Gauge Repeatability and Reproducibility
This spreadsheet is designed for up to three operators, three trials, and ten parts. Enter data ONLY in yellow shaded cells.
Number of operators
3Upper specification limit 1Average range 0.029
Number of trials 2Lower specification limit 0.5
Range of operator averages
0.056
Number of parts
10 Range of part averages 0.525
Data
Part
Part # 1 2 3 Average Range 1 2 3 Average
Range
1 2 3 Average
Range
Average
10.630 0.590 0.610 0.040 0.560 0.560 0.560 0.000 0.510 0.540 0.525 0.030 0.565
21.000 1.000 1.000 0.000 1.040 0.960 1.000 0.080 1.050 1.010 1.030 0.040 1.010
30.830 0.770 0.800 0.060 0.800 0.760 0.780 0.040 0.810 0.810 0.810 0.000 0.797
40.860 0.940 0.900 0.080 0.820 0.780 0.800 0.040 0.810 0.810 0.810 0.000 0.837
% of Total Variation
% of Tolerance
Repeatability (Equipment Variation) – EV
0.134 EV 15.32% EV 26.75% EV 2.35%
Reproducibility (Appraiser Variation) – AV
0.147 AV 16.81% AV 29.37% AV 2.83%
Repeatability and Reproducibility – R&R
Upper control limit for individual ranges
0.199 R&R 22.74% R&R 39.73% R&R 5.17%
Do not modify these tables
Trials/Operators D4 K1 K2
2 3.27 4.56 3.65
Parts K3
2 3.65
3 2.7
Variance Ratios
Trial
Trial
Operator 1
Operator 2
Operator 3