NewGauge, 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.6 Average range 0.028
Number of parts 8Range of part averages 0.028 <—
Note: This formula was modified to account for only 8 parts being measured.
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.511 1.518 1.515 0.007 1.522 1.491 1.507 0.031 1.473 1.502 1.488 0.029 1.503
21.501 1.480 1.491 0.021 1.510 1.495 1.503 0.015 1.488 1.500 1.494 0.012 1.496
31.499 1.480 1.490 0.019 1.473 1.543 1.508 0.070 1.513 1.453 1.483 0.060 1.494
41.510 1.491 1.501 0.019 1.525 1.489 1.507 0.036 1.479 1.505 1.492 0.026 1.500
% of Total Variation
% of Tolerance Variance Ratios
Repeatability (Equipment Variation) – EV 0.126 EV 92.76% EV 62.98% EV 86.04%
Reproducibility (Appraiser Variation) – AV 0.015 AV 11.13% AV 7.56% AV 1.24%
Repeatability and Reproducibility – R&R 0.127 R&R 93.42% R&R 63.44% R&R 87.28%
Part Variation – PV 0.048 PV 35.66% PV 24.22% PV 12.72%
values and recompute statistics.
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