Problem 8-15
Frankford Brake Systems
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.
NOTE: 0’s were filled into the template for the third operator and formulas for the part averages were modified.
Number of operators 2Upper specification limit 1.06 Average range 0.033
Number of trials 3Lower specification limit 0.94 Range of operator averages 0.006
Number of parts 10 Range of part averages 0.057
Data Operator 1 Operator 2 Operator 3
Trial Trial Trial Part <—- Formula adjusted to account for only two operators
Part # 1 2 3 Average Range 1 2 3 Average Range 1 2 3 Average Range Average
10.970 0.990 0.990 0.983 0.020 0.960 0.990 1.000 0.983 0.040 0.000 0.000 0.000 0.000 0.000 0.983
Average 0.991 0.028 0.997 0.038 0.000 0.000
% of Total Variation % of Tolerance Variance Ratios
Repeatability (Equipment Variation) – EV 0.101 EV 73.60% EV 83.88% EV 54.17%
Reproducibility (Appraiser Variation) – AV 0.012 AV 8.71% AV 9.93% AV 0.76%
Repeatability and Reproducibility – R&R 0.101 R&R 74.12% R&R 84.46% R&R 54.93%
Part Variation – PV 0.092 PV 67.13% PV 76.50% PV 45.07%
Total Variation – TV 0.137
Upper control limit for individual ranges 0.085
20.940 0.960 0.970 0.957 0.030 0.950 1.000 1.000 0.983 0.050 0.000 0.000 0.000 0.000 0.000 0.970
31.000 1.000 0.990 0.997 0.010 1.020 1.030 1.000 1.017 0.030 0.000 0.000 0.000 0.000 0.000 1.007
40.970 1.000 0.990 0.987 0.030 0.960 0.980 0.980 0.973 0.020 0.000 0.000 0.000 0.000 0.000 0.980
50.990 1.000 1.000 0.997 0.010 1.010 1.010 1.030 1.017 0.020 0.000 0.000 0.000 0.000 0.000 1.007
61.020 1.040 1.030 1.030 0.020 0.990 1.020 1.020 1.010 0.030 0.000 0.000 0.000 0.000 0.000 1.020
70.960 1.010 0.980 0.983 0.050 0.970 0.970 0.990 0.977 0.020 0.000 0.000 0.000 0.000 0.000 0.980
81.000 1.020 0.970 0.997 0.050 1.070 1.020 1.000 1.030 0.070 0.000 0.000 0.000 0.000 0.000 1.013
91.030 1.010 1.000 1.013 0.030 1.040 1.020 0.980 1.013 0.060 0.000 0.000 0.000 0.000 0.000 1.013