The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page

Go Back   The Elsmar Cove Forum > ISO (International Organization for Standardization) Standards > ISO 17025 - General Metrology, Measurement Device, Calibration and Test Laboratories > Gage R&R (GR&R) and MSA (Measurement Systems Analysis)
Forum Username


Elsmar Cove Forum Sidebar
Custom Search
Monitor the Elsmar Forum
Monitor New Forum Posts
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Sponsor Links







Donate and $ Contributor Forum Access
Sponsored Links
Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:


Howard's
International Quality Services

Atul's
Symphony Technologies

Marcelo Antunes'
SQR Consulting

Bob Doering's
Correct SPC - Precision Machining


NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest Portal

IEST - Institute of Environmental Sciences and Technology

ASQ - American Society for Quality

Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 3rd September 2003, 05:46 PM
jsamson jsamson is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Sep 2003
Location: Ontario, Canada
 
Posts: 2
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 40
Karma: 10
jsamson has less than 100 Karma points so far.
Question 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.

Sponsored Links
  #2  
Old 12th October 2003, 02:03 PM
Atul Khandekar's Avatar
Atul Khandekar Atul Khandekar is offline
Forum Administrator

 
Registration Date: Mar 2000
Location: Pune, India
Age: 50
 
Posts: 1,321
Thanks Given to Others: 155
Thanked 204 Times in 141 Posts
Karma Power: 400
Atul Khandekar has disabled his/her Karma.
Send a message via Skype™ to Atul Khandekar
Quote:
In Reply to Parent Post by jsamson

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 .
__________________
You are never given a wish without also being given the power to make it true. You may have to work for it, however. ~Richard Bach
Sponsored Links

  #3  
Old 8th September 2005, 10:26 AM
Alex Kobzar's Avatar
Alex Kobzar Alex Kobzar is offline
Registered Visitor

 
Registration Date: Sep 2004
Location: Detroit, USA
 
Posts: 56
Thanks Given to Others: 4
Thanked 19 Times in 15 Posts
Karma Power: 41
Karma: 180
Alex Kobzar is appreciated, and has over 100 Karma points.Alex Kobzar is appreciated, and has over 100 Karma points.
Question

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 by Alex Kobzar; 8th September 2005 at 11:36 AM.
  #4  
Old 9th September 2005, 03:13 AM
Barbara B's Avatar
Barbara B Barbara B is offline
Number Cruncher

 
Registration Date: May 2005
Location: Germany
 
Posts: 390
Thanks Given to Others: 95
Thanked 270 Times in 173 Posts
Karma Power: 79
Karma: 3799
Barbara B is appreciated, and has over 1700 Karma points.
Barbara B is appreciated, and has over 1700 Karma points.Barbara B is appreciated, and has over 1700 Karma points.Barbara B is appreciated, and has over 1700 Karma points.Barbara B is appreciated, and has over 1700 Karma points.Barbara B is appreciated, and has over 1700 Karma points.Barbara B is appreciated, and has over 1700 Karma points.Barbara B is appreciated, and has over 1700 Karma points.
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
  #5  
Old 9th September 2005, 07:05 AM
bleoj69's Avatar
bleoj69 bleoj69 is offline
Inactive Registered Visitor

 
Registration Date: Sep 2005
Location: Philippines
 
Posts: 3
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 32
Karma: 20
bleoj69 has less than 100 Karma points so far.
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 (n): 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.

  #6  
Old 9th September 2005, 12:27 PM
Alex Kobzar's Avatar
Alex Kobzar Alex Kobzar is offline
Registered Visitor

 
Registration Date: Sep 2004
Location: Detroit, USA
 
Posts: 56
Thanks Given to Others: 4
Thanked 19 Times in 15 Posts
Karma Power: 41
Karma: 180
Alex Kobzar is appreciated, and has over 100 Karma points.Alex Kobzar is appreciated, and has over 100 Karma points.
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(?).
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xls MSA.xls (13.5 KB, 829 views)

Last edited by Alex Kobzar; 9th September 2005 at 02:33 PM.
Thanks to Alex Kobzar for your informative Post and/or Attachment!
  #7  
Old 9th September 2005, 01:41 PM
roland_lu roland_lu is offline
Involved - Posts

 
Registration Date: Jul 2005
Location: Canada
 
Posts: 95
Thanks Given to Others: 2
Thanked 1 Time in 1 Post
Karma Power: 42
Karma: 135
roland_lu is appreciated, and has over 100 Karma points.roland_lu is appreciated, and has over 100 Karma points.
Alpha =0.05, not 0.1
  #8  
Old 11th September 2005, 09:10 PM
bleoj69's Avatar
bleoj69 bleoj69 is offline
Inactive Registered Visitor

 
Registration Date: Sep 2005
Location: Philippines
 
Posts: 3
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 32
Karma: 20
bleoj69 has less than 100 Karma points so far.
Alex,

Please revisit your UCI formula. You should get the same results.

Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > ISO (International Organization for Standardization) Standards > ISO 17025 - General Metrology, Measurement Device, Calibration and Test Laboratories > Gage R&R (GR&R) and MSA (Measurement Systems Analysis)

Do you find this discussion thread helpful and informational?


Bookmarks


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
Is my MSA Study Spreadsheet okay to AIAG MSA Manual 4th Edition? Hirstyuk Using Minitab Software 11 16th April 2012 03:56 PM
Is alpha in UCI LCI formula constant or depend on sample size? (MSA Manual) nurcan Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8 29th June 2010 01:50 PM
Problems calculating the observed CP - Page 19, AIAG MSA manual 3rd edition Oskar_S Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2 7th December 2009 04:08 AM
AIAG Attribute MSA - Analytical Method - Page 135 of MSA manual 3rd edition cbeatty Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19 28th January 2008 12:06 PM
Differences between the AIAG's MSA Manual 2nd & 3rd Edition? rmundroff Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5 8th March 2004 08:51 AM



The time now is 03:49 PM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, Olde West Chester, Ohio 45069-1929
513 341-6272