Instructions

How to run MSA analysis in Quantum XL

Step Select 'Create MSA template' from the menu to create MSA template.
Use all default settings in the wizard.
1

Step Quantum XL will create a new worksheet 'MSA Template'.

- Enter measurements for each part
2 - Enter reference values
- Set specification limits

Step Select 'ANOVA' from the MSA menu and Quantum XL will run MSA ANOVA analysis.
All analysis are reported in a single worksheet. Top of the report contains links so you navigate ea
3
 MSA template.

te'.

will run MSA ANOVA analysis.

he report contains links so you navigate easily.
 MSA Template
Template for
Gage name: My gage Specification Limits:
Gage No.: USL 1 1. Enter specifica
2. Enter data (nu
Gage type: LSL 0 3. Enter referenc
4. Run Quantum
Part Name:
Part No.:
Characteristics:
Specifications:

Date: 11/7/2011
Performed by:

Operator 1 Operator 2 Operator 3

Part
Trial 1 Trial 2 Trial 3 Trial 1 Trial 2 Trial 3 Trial 1
1 0.5461568 0.150293 0.234896 0.705107 0.658138 0.273077 0.113131
2 0.1793377 0.382001 0.59869 0.636111 0.740702 0.744049 0.494313
3 0.1535457 0.177517 0.719797 0.475973 0.56889 0.575687 0.614689
4 0.834501 0.247042 0.157164 0.097667 0.639342 0.12535 0.860001
5 0.01674 0.920816 0.323379 0.477065 0.584847 0.966375 0.683129
6 0.9556784 0.153935 0.152269 0.764375 0.27474 0.846369 0.719878
7 0.3504723 0.235716 0.76021 0.271179 0.46699 0.311329 0.45953
8 0.2121718 0.578142 0.85441 0.541993 0.499237 0.883111 0.269247
9 0.9788506 0.175386 0.361437 0.400382 0.200958 0.437541 0.288736
10 0.685702 0.235901 0.991911 0.329087 0.44492 0.524633 0.390573
 Template for ANOVA, XbarR and Nested ANOVA analysis
1. Enter specification limits (optional) .
2. Enter data (numerical values) in the Trial columns for each operator (mandatory) .
3. Enter reference data (numerical values) in the Ref column (optional) .
4. Run Quantum XL > MSA > ANOVA, XbarR or Nested ANOVA.

Operator 3
Ref
Trial 2 Trial 3
0.322789 0.58374 0.183841
0.070446 0.250003 0.40752
0.518467 0.747391 0.978689
0.464618 0.036894 0.426266
0.538646 0.664531 0.533543
0.088732 0.174066 0.934716
0.500438 0.36518 0.207652
0.166359 0.006792 0.741173
0.188844 0.021528 0.835704
0.566454 0.849297 0.371965
 MSA ANOVA Results
MSA Data Source: Sheet 'MSA Template' Specification Limits: Part name:
Performed by
# of Operators: 3 Gage name: My gage USL: 1.0 Part No.:
# of Trials: 3 Gage No.: LSL: 0.0 Part Characteristics:
Date 11/7/2011
# of Parts: 10 Gage type: Part Specifications:

Stats Advisor Gage R&R Results Average Chart Range Chart GP Curve Gage Linearity And Bias

Stats Advisor
Total Gage R&R (GRR) Percent Tolerance Color
Color Code
Code Table
Table
→ The Total GR&R is 161.87%. A GR&R greater than 30% is an indication of an unacceptable measurement system. Reference AIAG MSA 4rd ed., p. 78 (3rd ed. p. 77).
Black
BlackText
Text --Complies
Complieswith
withrules
rulesof
ofthumb
thumb
Number of Distinct Categories (ndc) Blue
Blue Text
Text --Doesn't
Doesn'tviolate
violate rules
rulesof
ofthumb,
thumb,but
butcould
couldbe
beimproved
improved
→ Number of distinct categories (ndc) is 1. For the measurement system to be acceptable, ndc should be >= 5. Reference AIAG MSA 4 ed., p. 123 (3rd ed., p. 117). Red
RedText
Text --Does
Doesnot
notmeet
meetrules
rulesof
ofthumb
thumb
Xbar Chart
→ 0.00% of the plotted averages fall outside the control limits. If less than half fall outside the control limits, then either the measurement system lacks adequate effective
resolution or the sample does not represent the expected process variation. Reference AIAG MSA 4th ed., p 106 (3rd ed., p. 102).

Range Chart
→ All ranges are in control. Operators are doing the same job. Reference AIAG MSA 4th ed., p 108. (3rd ed., p. 104).
Bias
→ All operators have average bias that is statistically zero (p-Value >= 0.05). Reference AIAG MSA 4th ed., p 95. (3rd ed., p. 91).
Linearity
→ This system has higher risk since the 'bias = 0' line does not fall within the confidence bounds for some operators. A change in procedure may be required. Reference
AIAG MSA 4th ed., p. 95.

Gage R&R Results ANOVA Table

Source Standard 6 * StDev % Contribution % Tolerance Source Degrees of Sum of Mean square F-ratio p-Value
Deviation Freedom Squares
Total Variation (TV) 0.26978 1.6187 100.00% 161.87% Parts 9 0.45747 0.05083 0.70569 0.6967
Total Gage R&R (GRR) 0.26978 1.6187 100.00% 161.87% Operators 2 0.20188 0.10094 1.4014 0.27187
Repeatability (EV) 0.26797 1.6078 98.67% 160.78% Interaction (Operator by Part) 18 1.2965 0.072029 1.004 0.46857
Reproducibility (AV) 0.031162 0.18697 1.33% 18.70% Repeatability (Equipment) 60 4.3047 0.071745
Operator 0.031162 0.18697 1.33% 18.70% Total 89 6.2606
Operator * part NA NA NA NA
Part to part (PV) 0.0 0.0 0.00% 0.00% Alpha to remove interaction term = 0.25
Model is without interactions (additive) since interactions p-Value > interaction term.
Number of distinct categories: ndc = 1

Non-AIAG Statistics
P/Tol Ratio 1.6187
The Precision to Tolerance Ratio is defined by NIST (see http://www.itl.nist.gov/div898/handbook/glossary.htm)

Xbar chart Components of Variation

MSA
XBarChart 6AB14BF9DF616C4192C57BC58B7BCCD7 ComVarChart
MSA 6A B14BF9DF616C4192C57BC58B7BCCD7
11 1
180
Average

0.8 160
Percent

Operator 1
140
Operator 2
0.6 120
Operator 3
LCL=-0.010081 100 % Contribution
0.4 Center=0.4534 % Tolerance
80
2
UCL=0.91692 60
0.2
Column D 40

0 20
1 2 3 4 5 6 7 8 9 1 1 2 3 4 5 6 7 8 9 1 1 2 3 4 5 6 7 8 9 1 0
0 0 0 Gage R&R Repeat Reprod Part To Part
-0.2

Rule Of Thumb »
The current chart is locked to prevent modification of the X and Y Axis of the Xbar chart. To edit this chart, unprotect it at the Excel ribbon >
The current
Review chart sheet.
> Unprotect is locked to prevent modification of the X and Y Axis of the Xbar chart. To edit this chart, unprotect it at the Excel ribbon >
Review > Unprotect sheet.
Range chart Operator by Part
Measurement

MSA 1.4
RChart 6AB14BF9DF616C4192C57BC58B7BCCD7
11 MSA
OpByPartChart 6AB14BF9DF616C4192C57BC58B7BCCD7
11 1
1.2
0.8
Range

1
Operator 1
Operator 2 0.6
0.8
Operator 3 Operator
Center=0.4530 0.4 1
0.6 8 Operator
UCL=1.1662 0.2 2
0.4 Column D
0
0.2
-0.2
0 1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 1 1 2 3 4 5 6 7 8 9 1 1 2 3 4 5 6 7 8 9 1 Part number
0 0 0

Rule Of Thumb »

The current chart is locked to prevent modification of the X and Y Axis of the Range chart. To edit this chart, unprotect it at the Excel ribbon >
The current
Review chart sheet.
> Unprotect is locked to prevent modification of the X and Y Axis of the Range chart. To edit this chart, unprotect it at the Excel ribbon >
Review > Unprotect sheet.
Gage Performance Curve
Pr obabilit y of Acce ptance

MSA1 .2
ComVarChart 6AB14BF9DF616C4192C57BC58B7BCCD7
11
2 2

0 .8

0 .6

0 .4

0 .2

0
-12
4
10
6
12
814
16
18
.820
22
24
26
28
30
32
34
36
38
40
42
44
46
48
50
52
54
56
58
60
62
64
66
68
70
72
74
76
78
80
82
84
86
88
90
92
94
100
96
102
-104
98
106
108
110
112
114
116
118
120
122
124
1.3126
128
130
132
134
136
138
140
142
144
146
148
150
152
154
156
158
160
162
164
166
168
170
172
174
176
178
180
182
184
186
188
190
192
194
196
198
200
202
204
206
208
210
-0212
214
216
218
220
222
224
.8226
228
230
232
234
236
238
240
242
244
246
248
250
252
254
256
258
260
262
264
266
268
270
272
274
276
278
280
282
284
286
288
290
292
294
296
298
300
302
304
306
308
310
312
314
316
318
320
322
324
-0.3326
328
330
332
334
336
338
340
342
344
346
348
350
352
354
356
358
360
362
364
366
368
370
372
374
376
378
380
382
384
386
388
390
392
394
396
398
400
402
404
406
0408
410
412
414
416
418
420
422
.2424
426
428
430
432
434
436
438
440
442
444
446
448
450
452
454
456
458
460
462
464
466
468
470
472
474
476
478
480
482
484
486
488
490
492
494
496
498
500
502
504
506
0508
510
512
514
516
518
520
522
.7524
526
528
530
532
534
536
538
540
542
544
546
548
550
552
554
556
558
560
562
564
566
568
570
572
574
576
578
580
582
584
586
588
590
592
594
596
598
600
602
604
606
1608
610
612
614
616
618
620
622
624
.2626
628
630
632
634
636
638
640
642
644
646
648
650
652
654
656
658
660
662
664
666
668
670
672
674
676
678
680
682
684
686
688
690
692
694
696
698
700
702
704
706
1708
710
712
714
716
718
720
722
.7724
726
728
730
732
734
736
738
740
742
744
746
748
750
752
754
756
758
760
762
764
766
768
770
772
774
776
778
780
782
784
786
788
790
792
794
796
798
800
802
804
806
808
810
812
814
816
818
2.2820
822
824
826
828
830
832
834
836
838
840
842
844
846
848
850
852
854
856
858
860
862
864
866
868
870
872
874
876
878
880
882
884
886
888
890
892
894
896
898
900
902
904
906
908
910
912
914
916
918
2.7920
Reference Value (True Value) of Part

Tip »

The current chart is locked to prevent modification of the X and Y Axis of the Gage Performance Curve. To edit this chart, unprotect it at the
Theribbon
Excel current> Review
chart is >locked to prevent
Unprotect sheet.modification of the X and Y Axis of the Gage Performance Curve. To edit this chart, unprotect it at the
Excel ribbon > Review > Unprotect sheet.

Gage Linearity And Bias For Operator 1

This system has higher risk since the regression p-value(s) are < 0.05.

0.7 Regression formula:

LinearityChart
MSA
6AB14BF9DF61 6C4 192 C57BC58B7BCCD7 Bias = -0.98255 * Reference + 0.43433
Coefficient t-Statistic p-Value
0.5
Const 0.43433 3.351 0.0023169
Slope -0.98255 -4.7506 0.0000548
0.3

Statistics:
0.1 Data Standard error 0.31381
Bias

95% CI
Upper R2 44.63%
-0.1 Regressi Process Variation 1.6187
on
95% CI Linearity 1.5904
Lower %Linearity 98.25%
-0.3
Average
Bias
Bias = 0 Bias:
-0.5

Reference Bias t-Statistic p-Value

-0.7 Average -0.11797 -1.8256 0.082879
0.18384 0.12661 1.0519 0.40317
-0.9 0.20765 0.24115 1.5148 0.26903
0.18 0.28 0.38 0.48 0.58 0.68 0.78 0.88 0.98 0.37196 0.26587 1.211 0.34958
Reference Value of Measured Parts
0.40752 -0.020844 -0.17215 0.87916
0.42627 -0.013363 -0.062919 0.95555
0.53354 -0.11323 -0.42657 0.71122
0.74117 -0.19293 -1.0373 0.40857
0.8357 -0.33048 -1.361 0.30659
0.93472 -0.51409 -1.9216 0.1946
0.97869 -0.6284 -3.3989 0.076731

Gage Linearity And Bias For Operator 2

This system has higher risk since the regression p-value(s) are < 0.05.

Regression formula:
LinearityChart
MSA
6AB14BF9DF61 6C4 192 C57BC58B7BCCD7 Bias = -0.88461 * Reference + 0.45065
0.5
Coefficient t-Statistic p-Value
Const 0.45065 4.8989 0.0000366
0.3 Slope -0.88461 -6.0262 0.0000017

Statistics:
0.1 Data Standard error 0.22272
Bias

95% CI
Upper R2 56.46%
Regressi Process Variation 1.6187
-0.1 on
Linearity 1.4319
95% CI
Lower %Linearity 88.46%
Average
-0.3 Bias
Bias = 0 Bias:

-0.5
Reference Bias t-Statistic p-Value
Average -0.046599 -1.2785 0.21572
0.18384 0.3616 2.6422 0.11835
-0.7 0.20765 0.14218 2.381 0.14022
0.18 0.28 0.38 0.48 0.58 0.68 0.78 0.88 0.98 0.37196 0.060915 1.073 0.39555
Reference Value of Measured Parts
0.40752 0.29943 8.4503 0.013717
0.42627 -0.13881 -0.78814 0.51319
0.53354 0.14255 0.96036 0.43821
0.74117 -0.099726 -0.82105 0.49791
0.8357 -0.48941 -6.6627 0.021793
0.93472 -0.30622 -1.716 0.2283
0.97869 -0.43851 -13.633 0.0053374

Gage Linearity And Bias For Operator 3

This system has higher risk since the regression p-value(s) are < 0.05.

0.5 Regression formula:

LinearityChart
MSA 6AB14BF9DF61 6C4 192 C57BC58B7BCCD7 Bias = -1.0861 * Reference + 0.44904
Coefficient t-Statistic p-Value
0.3 Const 0.44904 4.2138 0.0002363
Slope -1.0861 -6.3871 0.0000007

0.1
Statistics:
Data Standard error 0.25801
Bias

95% CI
-0.1
Upper R2 59.30%
Regressi Process Variation 1.6187
on
Linearity 1.7581
-0.3 95% CI
Lower %Linearity 108.61%
Average
Bias
-0.5 Bias = 0 Bias:

Reference Bias t-Statistic p-Value

-0.7
Average -0.16149 -3.9516 0.0007879
0.18384 0.15605 1.1464 0.37029
-0.9 0.20765 0.23406 5.8445 0.02805
0.18 0.28 0.38 0.48 0.58 0.68 0.78 0.88 0.98 0.37196 0.23014 1.7224 0.22714
Reference Value of Measured Parts
0.40752 -0.13593 -1.1066 0.38374
0.42627 0.027572 0.11601 0.91824
0.53354 0.095226 2.0984 0.17074
0.74117 -0.59371 -7.776 0.016139
0.8357 -0.66933 -8.5866 0.013293
0.93472 -0.60716 -3.0711 0.091679
0.97869 -0.35184 -5.3017 0.033785