|
This thread is carried over and continued in the Current Elsmar Cove Forums 
|
|
|
This thread is carried over and continued in the Current Elsmar Cove Forums
|
The New Elsmar Cove Forums
|
 The New Elsmar Cove Forums
 Statistical Techniques and 6 Sigma
 DPMO to Sigm
|
 UBBFriend: Email This Page to Someone! |
next newest topic | next oldest topic |
| Author | Topic: DPMO to Sigm |
|
Jimdad Lurker (<10 Posts) Posts: 5 |
posted 23 January 2001 01:06 PM
   
How does one accomplish this conversion? Formual? IP: Logged |
|
rivet guy unregistered |
posted 24 January 2001 05:26 AM
JimDad Motorola has a book with tables. sigmas DPMO(npmo) non-conformities or ppm 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 |
posted 24 January 2001 12:37 PM
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 |
posted 25 January 2001 10:13 AM
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,, IP: Logged |
|
Ken K. unregistered |
posted 26 January 2001 12:11 PM
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: 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 |
posted 26 January 2001 05:15 PM
Thank you. IP: Logged |
All times are Eastern Standard Time (USA) | next newest topic | next oldest topic |
  |
Hop to: |
Your Input Into These Forums Is Appreciated! Thanks!
Main Site Search 
