# AIAG's MSA Manual 3rd Edition Attribute Gage Study - Calculating the UCI and LCI

J

#### jsamson

MSA 3rd Edition Attribute Gage study

I'm in the process of getting our Attribute Gage studies up to MSA 3rd Edition. I have managed to get my way through all of it, but am having a small issue with calculating the UCI and LCI. To calculate these I am using an equation from one of my Stats book for Confidence Interval for proportions. The issue is that I'm gettin different answers from what MSA has in their example. Can someone please help me, with finding the correct equations to use.

thanks.

#### Atul Khandekar

##### Quite Involved in Discussions
jsamson said:
I'm in the process of getting our Attribute Gage studies up to MSA 3rd Edition. I have managed to get my way through all of it, but am having a small issue with calculating the UCI and LCI. To calculate these I am using an equation from one of my Stats book for Confidence Interval for proportions. The issue is that I'm gettin different answers from what MSA has in their example. Can someone please help me, with finding the correct equations to use.

thanks.
First off, Welcome to the cove!

The MSA manual uses the exact confidence intervals for Bianomial distribution for LCI/UCI. You'll have to look up some good stats book on how to calculate the limits.

I remember, sometime back there was an excel sheet for attribute study someone had posted here as attachment - you can 'Search' for it .

#### Alex Kobzar

##### Registered Visitor
Can anybody suggest how to calculate the binomial UCI/LCI to get the results suggested in MSA?
...p+/-1.96*(p*q)^(0.5) for the sample on page 131 results in (94%; 74%), when MSA sais (93%, 71%)  Last edited:
B

#### Barbara B

There must be a mistake in one of the calculations: The CI is symmetric around p, leading to:
for the first CI p=1/2*(94+74)=84
for the second CI p=1/2*(93+71)=82

Barbara

B

#### bleoj69

The typical CI formula for Binomial distribution you see in Stats books is using the normal approximation approach. This will not work when p = 0 or p = 1.

The MSA manual is using the Clopper-Pearson interval for binomial distribution. See http://stat.wharton.upenn.edu/~tcai/paper/1sidedCI.pdf pp. 19-20.

How to compute: (Let's use the example in the manual p.131)

Total inspected : 50
# Matched (x): 42

UCI = BETAINV(1-alpha/2, x+1, n-x)
LCI = BETAINV(alpha/2, x, n-x+1)

Special case:
if x = n, UCI = 1 and use alpha instead of alpha/2 in the LCI formula.
if x = 0, LCI = 0 and use alpha instead of alpha/2 in the UCI formula.

Try it in Excel. You should now have the same result as that found in the manual. #### Alex Kobzar

##### Registered Visitor
Wow! so much!!!!!!
...with ALFA = 0.05 the calculation gives:
n = 50
x = 42
93.85% = UCI (MSA = 93%)

n = 50
x = 42
71% = LCI (MSA = 71%)

n = 50
x = 39
90.64% = UCI (MSA = 89%)

n = 50
x = 39
64% = LCI (MSA = 64%)

...MSA is not exact(?).

#### Attachments

• 13.5 KB Views: 1,037
Last edited:
B

#### bleoj69

Alex, #### Alex Kobzar

##### Registered Visitor
Right, the formula works.   #### Attachments

• 15 KB Views: 536
N

#### nurcan

alpha in UCI LCI formula

Hello all,

Alpha in UCI LCI formula is taken as 0,05 for the example in MSA manual. Does the value of alpha depend on sample size? Can I use this 0,05 for both 20 samples and 100 samples?

Thanks a lot,

Nurcan

Definition Equipment definition - What does "equipment" mean in the AIAG MSA Manual Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 1
H Is my MSA Study Spreadsheet okay to AIAG MSA Manual 4th Edition? Using Minitab Software 18
Q Using Traceable Standards - AIAG MSA Manual Chapter II, Section B, 1st bullet Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
Error in ANOVA table in the AIAG MSA manual? Table A4 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
P Is there an Errata sheet for AIAG's MSA Manual Fourth Edition Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
T When is GRR (Gage R&R) required? AIAG MSA Manual Version 4 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19
AIAG MSA (Measurement Systems Analysis) Manual 3rd ed. Chapter IV Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
O Problems calculating the observed CP - Page 19, AIAG MSA manual 3rd edition Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
B Operator*part interaction - AIAG MSA manual indicates ANOVA Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
P AIAG SPC Manual (ver.1) Interpretations related to Gage R&R (GR&R) and MSA IATF 16949 - Automotive Quality Systems Standard 8
C AIAG Attribute MSA - Analytical Method - Page 135 of MSA manual 3rd edition Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19
A Product or Process Tolerence - AIAG MSA Reference Manual 3rd edition page 3 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
T MSA using tolerances - Page 116 of the AIAG MSA manual Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 30
S Bias Study Confidence Intervals - Page 88 of the AIAG MSA manual Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 11
D What the AIAG manual says about the frequency of MSA - Measurement system analysis Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 11
P Has K1 for GR&R's changed in AIAG 3rd ed MSA Manual? Does it affect outcome of study? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
T TS 16949 - AIAG's MSA Manual - Thread Inspection Gage - Attribute Gage R&R Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
G Bias & Linearity Calculations and T Value Formula in the AIAG's MSA Manual Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
S Number of Distinct Data Categories - NDC - AIAG's MSA Manual 3rd edition Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
D Linearity Analysis - AIAG's MSA Manual 3rd Edition - Question Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10
D Linearity Analysis - Measurement System Analysis - AIAG MSA Manual 3rd Edition Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 14
M Attribute Gage R&R Form - Long Version - AIAG's MSA Manual Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 35
Chapter III- Section C of the AIAG MSA manual (3rd Edition) - Tired of analysis? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Differences between the AIAG's MSA Manual 2nd & 3rd Edition? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
I AIAG's MSA Manual 3rd Edition - A Look at K Values - Auditor Questions Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
M Anyone hear anything about the new AIAG MSA manual? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
M Third Edition of the AIAG's MSA Manual Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
B AIAG's MSA Reference Manual, page 95, "Gage R&R Confidence Intervals" Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
F Meeting the AIAG's MSA Manual Gage R&R Bias, Linearity, Stability requirements Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 18
The FILE recommended by AIAG MSA 4ed for LINEARITY Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
AIAG's IATF 16949 section 7.1.5.1.1 - Torque MSA Requirement Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10
ANOVA GR&R: Minitab vs AIAG MSA results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
C PPAP Rejection for "MSA-GR&R are not using the latest AIAG format" APQP and PPAP 9
V Latest revisions of Core Tools Manuals from the AIAG (APQP, PPAP, FMEA, SPC and MSA) IATF 16949 - Automotive Quality Systems Standard 3
S AIAG MSA 4th Edition Summary APQP and PPAP 4
AIAG MSA 4th Edition Workshop - August 19, 2010 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
J Where to buy AIAG MSA 3rd Edition Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
Where did "breakpoint" analysis come from? AIAG MSA book Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
S Are the AIAG document (FMEA, PPAP, SPC, MSA, APQP) guidelines or requirements FMEA and Control Plans 6
A Significance of X chart in AIAG MSA sheet for Gage R&R Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
AIAG SPC and MSA guidelines - Which are the latest revisions? Statistical Analysis Tools, Techniques and SPC 3
K Need a version of the AIAG's MSA (Measurement System Anaysis) 3rd Edition Checklist Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
Errata for the AIAG's MSA Third Edition; 1st and 2nd printings Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
Y AIAG's MSA (Measurement Systems Analysis) 3rd Edition - K1, K2, K3 constants Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
V AIAG's MSA III Edition - Forms and Formulas - Attribute Gage R&R Document Control Systems, Procedures, Forms and Templates 3
J AIAG MSA and Gage R&R - What does the Process Variation % R&R truly mean? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 11
Gage R&R Template AIAG 4th Edition IATF 16949 - Automotive Quality Systems Standard 3
Which OEM or customers are now requiring the new AIAG/VDA FMEA format? FMEA and Control Plans 0
AIAG/VDA FMEA - Is the new better? FMEA and Control Plans 0
PFMEA new AIAG FMEA and Control Plans 0