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 operators | 3 | Upper specification limit | 1.6 | Average range | 0.028 | ||||||||||||||||||
Number of trials | 2 | Lower specification limit | 1.4 | Range of operator averages | 0.013 | ||||||||||||||||||
Number of parts | 8 | Range 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 | |||||||
1 | 1.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 | ||||||||||
2 | 1.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 | ||||||||||
3 | 1.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 | ||||||||||
4 | 1.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 | ||||||||||
5 | 1.496 | 1.487 | 1.492 | 0.009 | 1.531 | 1.459 | 1.495 | 0.072 | 1.449 | 1.521 | 1.485 | 0.072 | 1.491 | ||||||||||
6 | 1.475 | 1.493 | 1.484 | 0.018 | 1.495 | 1.492 | 1.494 | 0.003 | 1.494 | 1.475 | 1.485 | 0.019 | 1.487 | ||||||||||
7 | 1.508 | 1.486 | 1.497 | 0.022 | 1.475 | 1.474 | 1.475 | 0.001 | 1.484 | 1.455 | 1.470 | 0.029 | 1.480 | ||||||||||
8 | 1.486 | 1.519 | 1.503 | 0.033 | 1.526 | 1.508 | 1.517 | 0.018 | 1.494 | 1.516 | 1.505 | 0.022 | 1.508 | ||||||||||
9 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||||||||||||||||
10 | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | |||||||||||||||||||
Average | 1.496 | 0.019 | 1.501 | 0.031 | 1.488 | 0.034 | |||||||||||||||||
% 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% | ||||||||||||||||
Total Variation - TV | 0.136 | ||||||||||||||||||||||
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
An Introduction To Six Sigma And Process ImprovementISBN: 9781133604587 2nd Edition Authors: James R. Evans, William M. Lindsay
Question Posted:
|