A gauge repeatability and reproducibility study at NEW Gauge, Inc., collected the data for three operators, two

Question:

A gauge repeatability and reproducibility study at NEW Gauge, Inc., collected the data for three operators, two trials, and eight parts, as found in the worksheet Prob04-08 in the Excel file Ch04Data.xlsx on the Student Companion Site for this chapter. Analyze these data. The part specification is 1.5 ± 0.1 inches.

























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 operators3
Upper specification limit1.6

Average range
0.028










Number of trials2
Lower specification limit1.4

Range of operator averages0.013










Number of parts8






Range of part averages0.028 <---Note: This formula was modified to account for only 8 parts being measured.
























DataOperator 1



Operator 2



Operator 3












Trial



Trial



Trial




Part





Part #123AverageRange123AverageRange123AverageRange
Average





11.5111.518
1.5150.0071.5221.491
1.5070.0311.4731.502
1.4880.029
1.503





21.5011.480
1.4910.0211.5101.495
1.5030.0151.4881.500
1.4940.012
1.496





31.4991.480
1.4900.0191.4731.543
1.5080.0701.5131.453
1.4830.060
1.494





41.5101.491
1.5010.0191.5251.489
1.5070.0361.4791.505
1.4920.026
1.500





51.4961.487
1.4920.0091.5311.459
1.4950.0721.4491.521
1.4850.072
1.491





61.4751.493
1.4840.0181.4951.492
1.4940.0031.4941.475
1.4850.019
1.487





71.5081.486
1.4970.0221.4751.474
1.4750.0011.4841.455
1.4700.029
1.480





81.4861.519
1.5030.0331.5261.508
1.5170.0181.4941.516
1.5050.022
1.508





9


#DIV/0!



#DIV/0!



#DIV/0!

#DIV/0!





10


#DIV/0!



#DIV/0!



#DIV/0!

#DIV/0!





Average


1.4960.019


1.5010.031


1.4880.034





































% of Total Variation% of ToleranceVariance Ratios











Repeatability (Equipment Variation) - EV
0.126
EV92.76%EV62.98%EV86.04%











Reproducibility (Appraiser Variation) - AV
0.015
AV11.13%AV7.56%AV1.24%











Repeatability and Reproducibility - R&R
0.127
R&R93.42%R&R63.44%R&R87.28%











Part Variation - PV


0.048
PV35.66%PV24.22%PV12.72%











Total Variation - TV


0.136
























Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: