The Elsmar Cove Business Standards Discussion Forums More Free Files Forum Discussion Thread Post Attachments Listing Elsmar Cove Discussion Forums Main Page
Welcome to what was The Original Cayman Cove Forums!
This thread is carried over and continued in the Current Elsmar Cove Forums

Search the Elsmar Cove!

Wooden Line
This is a "Frozen" Legacy Forum.
Most links on this page do NOT work.
Discussions since 2001 are HERE

Owl Line
The New Elsmar Cove Forums   The New Elsmar Cove Forums
  Statistical Techniques and 6 Sigma
  DPMO to Sigm

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   DPMO to Sigm
Jimdad
Lurker (<10 Posts)

Posts: 5
From:Phila,PA,USA
Registered: Jan 2001

posted 23 January 2001 01:06 PM     Click Here to See the Profile for Jimdad   Click Here to Email Jimdad     Edit/Delete Message   Reply w/Quote
How does one accomplish this conversion?

Formual?

IP: Logged

rivet guy
unregistered
posted 24 January 2001 05:26 AM           Edit/Delete Message   Reply w/Quote
JimDad

Motorola has a book with tables.

sigmas DPMO(npmo) non-conformities or ppm
1 317,400
2 45,400
3 2,700
4 63
5 0.57
6 0.002
7 0.000003

This data above doesn't include a 1.5 sigma shift on either side of the median.

The book title is The Nature of 6 Sigma Quality from the Motorola University Press.

IP: Logged

stefanson
Forum Contributor

Posts: 24
From:La Mesa, CA, USA
Registered: May 99

posted 24 January 2001 12:37 PM     Click Here to See the Profile for stefanson   Click Here to Email stefanson     Edit/Delete Message   Reply w/Quote
Try the following site for a simple converter: http://www.pyzdek.com/Sigma-PPM-Percent%20Converter.htm

IP: Logged

Jimdad
Lurker (<10 Posts)

Posts: 5
From:Phila,PA,USA
Registered: Jan 2001

posted 25 January 2001 10:13 AM     Click Here to See the Profile for Jimdad   Click Here to Email Jimdad     Edit/Delete Message   Reply w/Quote
Thanks for the feedback folks, I really need to find the formula. Unfortunately, the table does not produce a sigma for a specific DPMO and I do not have the entire 2000 office suite to utilize Pyzdek's converte page.

Still seeking directions,,
Jim

IP: Logged

Ken K.
unregistered
posted 26 January 2001 12:11 PM           Edit/Delete Message   Reply w/Quote
Here is a formula (ready?)

Sigma =SQRT(LN(1/(1-EXP(-B24/1000000))^2))-(2.55155+0.802853*SQRT(LN(1/(1-EXP(-B24/1000000))^2))+0.010328*SQRT(LN(1/(1-EXP(-B24/1000000))^2))^2)/(1+1.432788*SQRT(LN(1/(1-EXP(-B24/1000000 ))^2))+0.189269*SQRT(LN(1/(1-EXP(-B24/1000000))^2))^2+0.001308*SQRT(LN(1/(1-EXP(-B24/1000000))^2))^3)+1.5

where B24 is DPMO

This formula is accurate to two decimal places between Sigma = 3.2 - 9.0, and one decimal between 2.5 & 3.2, and shouldn't be used for Sigma < 2.5

If you're using Excel you can use:
Sigma =NORMINV(1-B24/1000000,1.5,1)

The Excel function is accurate to 2 decimal places between Sigma = 1.4 - 5.7, and to 1 decimal place for Sigma = 5.7 - 6.1

IP: Logged

Jimdad
Lurker (<10 Posts)

Posts: 5
From:Phila,PA,USA
Registered: Jan 2001

posted 26 January 2001 05:15 PM     Click Here to See the Profile for Jimdad   Click Here to Email Jimdad     Edit/Delete Message   Reply w/Quote
Thank you.

IP: Logged

All times are Eastern Standard Time (USA)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply Hop to:

Contact Us | The Elsmar Cove Home Page

Your Input Into These Forums Is Appreciated! Thanks!


Main Site Search
Y'All Come Back Now, Ya Hear?
Powered by FreeBSD!Made With A Mac!Powered by Apache!