Gauge R&R Analysis in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Gauge R&R Analysis capabilities.
For further information visit UNISTAT User's Guide section 9.3.8. Gauge R&R Analysis.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Gauge R&R Analysis
ANOVA
Data: Measurement
| Due To | Sum of Squares | DoF | Mean Square | F-Stat | Prob |
|---|---|---|---|---|---|
| Part | 88.362 | 9 | 9.818 | 492.291 | 0.0000 |
| Operator | 3.167 | 2 | 1.584 | 79.406 | 0.0000 |
| Part x Operator | 0.359 | 18 | 0.020 | 0.434 | 0.9741 |
| Repeatability | 2.759 | 60 | 0.046 | ||
| Total | 94.647 | 89 | 1.063 |
Gauge R&R
Data: Measurement
Part: Part
Operator: Appraiser
Method: ANOVA
Control Range: 6 x Sigma
| Variation | Lower 95% | Upper 95% | |
|---|---|---|---|
| Gauge R&R | 1.8793 | 1.4524 | 8.7575 |
| Repeatability EV | 1.2866 | 1.0920 | 1.5664 |
| Reproducibility AV | 1.3698 | 0.7001 | 8.6622 |
| Part x Operator IV | 0.0000 | 0.0000 | 0.5619 |
| Part PV | 6.2604 | 4.3014 | 11.4370 |
| Total TV | 6.5364 | 4.6887 | 12.6478 |
Number of distinct categories: 4
Gauge R&R Analysis
Gauge R&R
Data: Measurement
Part: Part
Operator: Appraiser
Method: Average and Range
Control Range: 6 x Sigma
| Standard Deviation | % Standard Deviation | Variation | % Variation | |
|---|---|---|---|---|
| Gauge R&R | 0.3058 | 26.68 | 1.8347 | 26.68 |
| Repeatability EV | 0.2019 | 17.61 | 1.2112 | 17.61 |
| Reproducibility AV | 0.2297 | 20.04 | 1.3781 | 20.04 |
| Part PV | 1.1045 | 96.37 | 6.6267 | 96.37 |
| Total TV | 1.1460 | 100.00 | 6.8760 | 100.00 |
Number of distinct categories: 5
