Fundamentals of Statistics
HW#4: Fundamentals of Statistics
1.Given the data below for readings by 3 appraisers on 6 parts with 2 trials, determine if the measurement system is acceptable (how much variation is attributed to part, Gage R&R, equipment, and operator, respectively) and where should improvement efforts should be focused on. The readings were randomized. Use Excel calculation to finish this question.
|
|
1 |
2 |
3 |
4 |
5 |
6 |
|
Appraiser A |
|
|
|
|
|
|
|
Trial 1 |
.65 |
1.00 |
.85 |
.85 |
.55 |
1.00 |
|
Trial 2 |
.60 |
1.00 |
.80 |
.95 |
.45 |
1.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Appraiser B |
|
|
|
|
|
|
|
Trial 1 |
.55 |
1.05 |
.80 |
.80 |
.40 |
1.00 |
|
Trial 2 |
.55 |
.95 |
.75 |
.75 |
.40 |
1.05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Appraiser C |
|
|
|
|
|
|
|
Trial 1 |
.50 |
1.05 |
.80 |
0.80 |
.45 |
1.00 |
|
Trial 2 |
.55 |
1.00 |
.80 |
0.80 |
.50 |
1.05 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2.Given the data below for readings by 2 appraisers on 4 parts with 3 trail trials, determine if the measurement system is acceptable (how much variation is attributed to part, Gage R&R, equipment, and operator, respectively) and where should improvement efforts should be focused on. The readings were randomized. Use Excel calculation to finish this question
|
|
1 |
2 |
3 |
4 |
|
Appraiser A |
|
|
|
|
|
Trial 1 |
.55 |
.45 |
.60 |
.20 |
|
Trial 2 |
.55 |
.40 |
.60 |
.30 |
|
Trail 3 |
.50 |
.35 |
.55 |
.25 |
|
Appraiser B |
|
|
|
|
|
Trial 1 |
.55 |
.35 |
.60 |
.15 |
|
Trial 2 |
.50 |
.30 |
.55 |
.20 |
|
Trial 3 |
.45 |
.25 |
.50 |
.15 |
Special Notes:
The best approach to accomplish this homework is to manually compute GageR&R in first question and to use Microsoft Excel in the second question. You may use Excel in both questions, but be sure you understand the process.