46 0 375KB
Gage R&R Study - Data Entry
More on GR&R:
Part #/Name: Feature Name: Feature Tolerance:
Sample Part Special Dimension 72.000
p-Value for Interaction:
0.25
www.dmaictools.com/measure/grr
Prototype Gage A John Smith 7/5/2012
Gage #/Name: Completed by: Study Date:
(default is 0.25)
Notes: (1) all calculations in this workbook have been validated using AIAG standards with ten parts, three appraisers, and three trials. (2) all measurement data (ten parts, three appraisers, three measurements each) must be entered to obtain valid results.
Part Appraiser
Trial #
Appraiser A
1 2 3
Appraiser B
Appraiser C
©2012 DMAIC Tools
1
2
3
4
5
6
7
8
9
Average
10
56 56 54
44 45 49
-11 -9 -9
0 0 0
0 0 0
30 36 36
18 15 16
25 26 24
22 22 24
18 15 16
20.2 20.6 21
Average
55.333
46.000
-9.667
0.000
0.000
34.000
16.333
25.000
22.667
16.333
20.600
Range
2.000
5.000
2.000
0.000
0.000
6.000
3.000
2.000
2.000
3.000
2.5
51 53 58
47 48 46
-10 -19 -12
-4 -3 -4
0 -3 0
36 38 30
10 15 14
28 17 20
36 24 25
20 13 15
21.4 18.3 19.2
Average
54.000
47.000
-13.667
-3.667
-1.000
34.667
13.000
21.667
28.333
16.000
19.633
Range
7.000
2.000
9.000
1.000
3.000
8.000
5.000
11.000
12.000
7.000
6.5
50 49 50
43 43 45
-10 -8 -12
-2 -4 -4
0 0 0
32 32 35
16 12 10
21 15 17
20 19 21
15 14 16
18.5 17.2 17.8
Average
49.667
43.667
-10.000
-3.333
0.000
33.000
12.667
17.667
20.000
15.000
17.833
Range
1.000
2.000
4.000
2.000
0.000
3.000
6.000
6.000
2.000
2.000
2.8
Part Average
53.000
45.556
-11.111
-2.333
-0.333
33.889
14.000
21.444
23.667
15.778
19.356
1 2 3
1 2 3
Gage R&R Results - ANOVA Method Part #/ Name: Feature Name: Feature Tolerance:
www.dmaictools.com/measure/grr
Sample Part Special Dimension 72
Gage Name: Completed by: Study Date:
Summary Results Total Gage R&R Repeatability Reproducibility Part-to-Part
% Study Variation 15% 13% 9% 99%
Prototype Gage A John Smith 5-Jul-12
100% % Tolerance 27% 22% 15% 173%
80% 60% 40%
% Study Variation
20%
% Tolerance
0% Total Gage R&R
Repeatability
Part-to-Part Reproducibility
Two-Way ANOVA Table With Interaction DF
SS
MS
F
P Value
Part
9
34922.8444
3880.31605
304.353
0.000
Appraiser
2
118.2889
59.14444
4.639
0.024
Appraiser-Part Interaction
18
229.4889
12.74938
1.796
0.047
Equipment
60
426.0000
7.10000
Total
89
35696.6222
Interaction will be included if p value is less than 0.25 (reference "p-Value for Interaction" input on Data Entry page)
Two-Way ANOVA Table Without Interaction DF
SS
MS
F
P Value
Part
9
34922.8444
3880.31605
461.739
0.000
Appraiser
2
118.2889
59.14444
7.038
*
Equipment
78
655.4889
8.40370
-
-
Total
89
35696.622
Gage R&R Source Total Gage R&R Repeatability Reproducibility Appraiser Appraiser-Part Part-to-Part Total Varation Number of Distinct Categories
Source Total Gage R&R Repeatability Reproducibility Appraiser Appraiser-Part Part-to-Part Total Varation ©2012 DMAIC Tools
Variance Component
% Contribution
10.52963 7.10000 3.42963 1.54650 1.88313 429.72963 440.25926
2% 2% 1% 0% 0% 98% 100%
Pie Chart - Variance Components 2% 1%
Repeatability Reproducibility 98%
9
Standard Deviation
Study Variation (6s)
% Study Variation
% Tolerance
3.24494 2.66458 1.85193 1.24358 1.37227 20.7299 20.9824
19.46963 15.98750 11.11156 7.46151 8.23363 124.37953 125.89414
15% 13% 9% 6% 7% 99% 100%
27% 22% 15% 10% 11% 173% 175%
Part-to-Part
Gage R&R Results - ANOVA Method
www.dmaictools.com/measure/grr
Calculations per AIAG MSA Manual, Third and Fourth Editions
Study Information Part #/ Name: Feature Name: Feature Tolerance:
Sample Part Special Dimension 0.02
Gage Name: Completed by: Study Date:
Prototype Gage A John Smith 5-Jul-12
Range Control Chart
Measurements by Appraiser
12.00
60.000
10.00
50.000
8.00
40.000
Values
Sample Range
14.00
6.00 4.00 2.00
30.000 20.000 10.000 0.000
0.00 1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10
Appraiser A
-10.000
1 2 3 4 5 6 7 8 9 10
Appraiser B
Appraiser C
-20.000
Appraiser A
Appraiser B
Appraiser
Appraiser C
Interaction Plot 60.000
70 60 50 40 30 20 10 0 -10 -20 -30
50.000 40.000
Average
Values
Measurements by Part
30.000 20.000 10.000 0.000 -10.000
1
2
3
4
5
6
7
8
-20.000 1
2
3
4
5
Part ©2012 DMAIC Tools
6
7
8
9
Part
10 Appraiser A
Appraiser B
Appraiser C
9
10