
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) nonconformities 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/SigmaPPMPercent%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/(1EXP(B24/1000000))^2))(2.55155+0.802853*SQRT(LN(1/(1EXP(B24/1000000))^2))+0.010328*SQRT(LN(1/(1EXP(B24/1000000))^2))^2)/(1+1.432788*SQRT(LN(1/(1EXP(B24/1000000 ))^2))+0.189269*SQRT(LN(1/(1EXP(B24/1000000))^2))^2+0.001308*SQRT(LN(1/(1EXP(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!