Accurate Parts, Inc.
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 1.8 Average range 0.014
Data Operator 1 Operator 2 Operator 3
Trial Trial Trial Part
Part # 1 2 3
Average
Range 1 2 3 Average
Range
1 2 3
Average
Range Average
11.558 1.560 1.554 1.557 0.006 1.519 1.523 1.522 1.521 0.004 1.568 1.586 1.588 1.581 0.020 1.553
21.627 1.627 1.646 1.633 0.020 1.646 1.648 1.656 1.650 0.010 1.646 1.676 1.651 1.658 0.029 1.647
31.646 1.646 1.648 1.647 0.002 1.375 1.392 1.333 1.366 0.059 1.343 1.330 1.323 1.332 0.020 1.448
% of Total Variation
% of Tolerance Variance Ratios
Repeatability (Equipment Variation) – EV
0.042 EV 9.78% EV 8.49% EV 0.96%
Reproducibility (Appraiser Variation) – AV
0.119 AV 27.31% AV 23.72% AV 7.46%
Do not modify these tables
Trials/Operators D4 K1 K2
2 3.27 4.56 3.65
Parts K3
2 3.65