Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
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%
