Gage R&R Part Number
Average & Range Method 1 2 3 4 5 6 7 8 9 10 Sum
Appraiser 1 Trial 1 8.12 8.40 8.18 8.40 8.19 41.290
Enter your data here-> Trial2 8.12 8.40 8.35 8.40 8.19 41.460
Trial3 8.12 8.40 8.18 8.40 8.19 41.290
Trial4 Xbar1 Reference
Trial 5 8.269333 12.500 <-Insert Reference Value Here
Total 24.36 25.2 24.71 25.2 24.57 Bias
Average- 8.12 8.4 8.2367 8.4 8.19 Rbar1 -4.231
Range1 0 0 0.17 0 0 0.034
Appraiser 2 Trial 1 8.1200 8.4000 8.1800 8.4000 8.1900 41.290
Enter your data here-> Trial2 8.1200 8.4000 8.1800 8.1000 8.1900 40.990
Trial3 8.1200 8.4000 8.1800 8.4000 8.1900 41.290
Trial4 Xbar2 Reference
Trial 5 8.238 12.500
Total 24.36 25.2 24.54 24.9 24.57 Bias
Average- 8.12 8.4 8.18 8.3 8.19 Rbar2 -4.262
Range2 0 0 0 0.3 0 0.06
Appraiser Trial 1
Enter your data here-> Trial2
Trial3
Trial4 Xbar3 Reference
Trial 5 12.500
Total Bias
Average- Rbar3
Range3
K3 0.7071 0.5231 0.4467 0.403 0.3742 0.3534 0.3375 0.3249 0.3146
UCL 8.28572 8.2857 8.2857 8.2857 8.2857 8.2857 8.2857 8.2857 8.2857 8.2857
Part X Averag 8.120 8.400 8.208 8.350 8.190 0.280 Range Ave
XCL 8.2537 8.2537 8.2537 8.2537 8.2537 8.2537 8.2537 8.2537 8.2537 8.2537
LCL 8.22161 8.2216 8.2216 8.2216 8.2216 8.2216 8.2216 8.2216 8.2216 8.2216
UCL 0.081 0.081 0.081 0.081 0.081 0.081 0.081 0.081 0.081 0.081
Range 0.000 0.000 0.057 0.100 0.000
Rave 0.0313 0.0313 0.0313 0.0313 0.0313 0.0313 0.0313 0.0313 0.0313 0.0313
LCL 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Sum 48.720 50.400 49.250 50.100 49.140 ### Total
Range Average 0.0470 Constants
XDiff 0.0313 5 Trials 4 Trials 3 Trials 2 Trials # Trials 3
UCL 0.1213 2.11 2.28 2.58 3.27 D4 2.58 UCL represents the limit of the individual R's
LCL 0.0000 0 0 0 0 D3 0 Circle those beyond the limit.
Repeatability(EV) 0.0278 0.577 0.729 1.023 1.88 A2 1.023 Identify and correct causes
Reproducibility(AV) 0.0210 0.4299 0.4857 0.5908 0.8862 K1 0.5908 LCL = 0 D3=0 for up to 7 trials
Gage Capability(R&R) 0.0348 0.7071 0.5231 K2 0.7071
Spec Tolerance 0.012 2 Ops 3 Operators
Acceptability(%) 2.90 Gage system may be acceptable based on importance of application and cost
% Using % Using Gage may need maintenance, redesign, or better clamping
AIAG - Automotive Ind TV Tolerance
EV (Equipment Variati 0.0278 Equipment Variation (EV)
%EV 23.5% 1388% # Parts #Trials #Ops % of Total Variation (TV)
AV: (Appraiser Variati 0.02096 5 3 2 Appraiser Variation(AV)
%AV 17.8% 1048% % of Total Variation (TV)
R&R (Gage Capability 0.0348 Repeatability and Reproducibility (R&R)
%R&R 29.5% 1740% % of Total Variation (TV)
PV (Part Variation) 0.1128 Part Variation (PV)
%PV 95.6% 5642% % of Total Variation (TV)
TV (Total Variation) 0.1181 Total Variation (TV)
Calculate GageR&R using Anova With Interaction Without Interaction
Anova Source df SS MS F P F P
Appraiser 1 ### ### -4 Err:502 -23.999 Err:502
Parts 4 0.3280 0.082 0.00018 1.00000 0.00108 1.00000
Appraiser x Part 4 ### 454.1 114575 0.00000
Gage w AP Interaction 20 0.0793 0.0040
Gage w/o AP Interacti 24 ### 75.6864
Total 29 0.4271
Estimate %
of 5.15* % Study Contribut
Variance Std. Dev Stdev Variation ion
Repeatability 0.00396 0.06296 EV 0.3242 0% 0%
Appraiser 151.365 12.303 AV 63.361 63% 40%
AppraiserxPart 151.365 12.303 INT 63.361 63% 40%
R&R ### 17.3992 R&R 89.606 89% 80%
Part ### 8.69882 PV 44.799 45% 20%
TV 100.18
Part by Appraiser Plot (Stacked)
6
Average-Appraiser
Averagge
5 1
Average-Appraiser
2
4
0
1 2 3 4 5 6 7 8 9 10
Part
Part by Appraiser Plot
6
Averagge
5
Row 9
4
0
1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10
Appraiser 2
Appraiser 1 Appraiser 3
Range of Parts by Appraiser (Stacked)
0.35
0.3
0.25
0.2 Range
Range
1
Range
0.15 2
0.1
0.05
0
1 2 3 4 5 6 7 8 9 10
Parts
Range of Parts by Appraiser
0.35
0.3
0.25
0.2
Range
Row 10
0.15
0.1
0.05
0
1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10
Appraiser 2
Appraiser 1 Appraiser 3
Instructions 1. Select 10 DIFFERENT parts and at least two "appraisers" and one gage
(If you don't use enough parts, part variation will be small and magnify the appraiser/equipment variation)
2. RANDOMLY, have appraisers measure each part at least twice
3. Then enter the results of each measurement in Cells C3:L7, C11:L15, C19:L23
4. The template will automatically calculate all of the values based on your data
5. Evaluate your measurement system based on %R&R and make adjustments as required.
Gage Repeatability and Reproducibility
Measurement is one common cause of variation. Gage R&R helps improve measurement systems
If repeatability (EV - Can the same person using the same gauge measure the same thing consistently)
is larger than reproducibility, reasons include:
1. Gage instrument needs maintenance
2. Gage needs to be redesigned
3. Clamping or location needs to be improved
4. Excessive within-part variation
If reproducibility (AV-can two appraisers measure the same thing and get the same result)
is larger than repeatability, reasons include:
1. Operator needs to be better trained in how to use and read gage
2. Calibrations on gage are not clear
3. Fixture required to help operator use gage more consistently
Gage System Acceptability
%R&R<10% Gage System Okay (Most variation caused by parts, not people or equipment)
%R&R<30% May be acceptable based on importance of application and cost of gage or repair
%R&R>30% Gage system needs improvement (people and equipment cause over 1/3 of variation)
Verified using AIAG Measurement Systems Analysis 3rd Edition
Range Method
Range Method Insert Your Data Here
Part 1 2 3 4 5 Average g
Appraiser 1 1 1 ###
Appraiser 2 1.1 1.1 d2
Range 0.1 0 0 0 0 0.02 1.41
###
GR&R 0.0141844 ###
Insert Process
Standard
Deviation 0.0707107 ###
%GR&R 20% ###
Page 6
Bias
t-
Reference Average/ Stdev(r) Statistic/
Value Value Bias n Mean Stdev Stdev(b) critical d2*/d2 df
6.0 0 #DIV/0! #DIV/0! #N/A #N/A #N/A #N/A
Bias #DIV/0! #N/A #N/A #N/A
95% Confidence
Lower Upper
#N/A #N/A
#N/A
Reference: AIAG MSA Version 3 pgs 85-88
Page 7
Bias
g 2 3 4 5 6 7 8 9 10
d2* 1.41421 1.91155 2.23887 2.48124 2.67253 2.82981 2.96288 3.07794 3.17905
df 1 2 2.9 3.8 4.7 5.5 6.3 7 7.7
d2 1.12838 1.69257 2.05875 2.3593 2.53441 2.70436 2.8472 2.97003 3.07751
t crit 95% 4.303 3.182 2.776 2.571 2.447 2.365 2.306 2.262 2.228
Page 8
Bias
11 12 13 14 15 16 17 18 19 20
3.26909 3.35016 3.42378 3.49116 3.55333 3.61071 3.66422 3.71424 3.76118 3.80537
8.3 9 9.6 10.2 10.8 11.3 11.9 12.4 12.9 13.4
3.17287 3.25846 3.33598 3.40676 3.47193 3.53198 3.58788 3.64006 3.68896 3.735
2.201 2.179 2.16 2.145 2.131 2.12 2.11 2.101 2.093 2.086
Page 9
Linearity
Part
Trials 1 2 3 4 5
1 2.7 <- Insert Your Data Here
2
3 Linearity evaluates a gauge's ability
4 to measure accurately across a wide range
5 Imagine measuring a baseball bat:
6 1. at the grip
7 2. in the middle
8 3. and at the widest part
9
10
11
12
Average 2.70
Reference
Values 2.00 <- Insert Known Reference Values Here
Bias 0.70
Range 0.00 0.00 0.00 0.00 0.00
bias=
slope*ref+b
Slope= Err:502
b= Err:502
Goodness of
fit Err:502
Insert
Process
Variation
Linearity Err:502
%Linearity Err:502
Linearity Plot
0.80
0.70
0.60
0.50
Bias
0.40
0.30
0.20
0.10
0.00
1.50 2.00 2.50 3.00 3.50 4.00
Reference Value
Page 10
Linearity
a gauge's ability
ly across a wide range
a baseball bat:
Page 11
Appraiser A Appraiser B Appraiser C Reference Results A-B B-C
Part # Trial 1 Trial 2 Trial 3 Trial 1 Trial 2 Trial 3 Trial 1 Trial 2 Trial 3 ReferenceRef Value Code LSL USL %R&R Gray zone 1 2 3 1 2 3
1 1 X 0.00000
2 1 X 1. Enter Spec Limits Above
3 1 X 2. Have 3 appraisers accept/reject 10+
4 1 X 3. Enter pass/fail in columns B-J
5 1 X 4. Enter Reference value in column L
6 1 X 5. Evaluate effectiveness columns AJ
7 1 X
8 1 X
9 1 X
10 1 X
11 1 X
12 1 X
13 1 X
14 1 X
15 1 X
16 1 X
17 1 X
18 1 X
19 1 X
20 1 X
21 1 X
22 1 X
23 1 X
24 1 X
25 1 X
26 1 X
27 1 X
28 1 X
29 1 X
30 1 X
31 1 X
32 1 X
33 1 X
34 1 X
35 1 X
36 1 X
37 1 X
38 1 X
39 1 X
40 1 X
41 1 X
42 1 X
43 1 X
44 1 X
45 1 X
46 1 X
47 1 X
48 1 X
49 1 X
50 1 X
0 = Fail + = within spec limits
1 = Pass - = outside spec limits
x = gray area around spec limits
C-A A-REF B-REF C-REF
1 2 3 1 2 3 1 2 3 1 2 3
Crosstabulation Crosstabulation Miss
B Total REF Total Effectiveness Rate
A 0 1 A 0 1 A ### #DIV/0!
0 0 0 0 0 0 0 0 B ### #DIV/0!
1 0 0 0 1 0 0 0 C ### #DIV/0!
Tota 0 0 0 Tota 0 0 0 System ### #DIV/0!
#DIV/0!
C Total REF Total Effectiveness
B 0 1 B 0 1 Acceptable >= 90%
0 0 0 0 0 0 0 0 Marginal >=80%
1 0 0 0 1 0 0 0 Unacceptable <80%
Tota 0 0 0 Tota 0 0 0
A Total REF Total
C 0 1 C 0 1
0 0 0 0 0 0 0 0
1 0 0 0 1 0 0 0
Tota 0 0 0 Tota 0 0 0