Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Problem 8-14
NEW Gauge, 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 trials 2Lower specification limit 1.4 Range of operator averages 0.013
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
% 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%
Do not modify these tables
Trials/Operators D4 K1 K2
2 3.27 4.56 3.65
3 2.58 3.05 2.7
