|
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
 Miscellaneous Quality Topics
 DPMO vs SIGMA
|
 UBBFriend: Email This Page to Someone! |
next newest topic | next oldest topic |
| Author | Topic: DPMO vs SIGMA |
|
Jimdad Lurker (<10 Posts) Posts: 5 |
posted 26 January 2001 08:55 AM
   
Folks, I am deserately seeking a formula for converting DMPO to sigma... Anyone? IP: Logged |
|
stefanson Forum Contributor Posts: 24 |
posted 26 January 2001 12:55 PM
Check out: http://www.pyzdek.com/Sigma-PPM-Percent%20Converter.htm IP: Logged |
|
Jimdad Lurker (<10 Posts) Posts: 5 |
posted 26 January 2001 12:58 PM
Been there, I don't have the complete MS 2000 suite to utilize the converter.
IP: Logged |
|
GaryC Lurker (<10 Posts) Posts: 6 |
posted 25 February 2001 11:31 AM
DPMO to sigma is simple. Go to normal tables with your DPMO, get the z value and add 1.5. That is your sigma value. Use the paste function in Excel for the most accurate normal tables. GaryC IP: Logged |
|
GaryC Lurker (<10 Posts) Posts: 6 |
posted 25 February 2001 11:32 AM
DPMO to sigma is simple. Go to normal tables with your DPMO, get the z value and add 1.5. That is your sigma value. Use the paste function in Excel for the most accurate normal tables. GaryC IP: Logged |
|
D Edwards unregistered |
posted 02 March 2001 08:10 AM
In Excel try: DPMO-->sigma -NORMSINV((DPMO)/1000000) Sigma-->DPMO (1-NORMSDIST(Sigma))*1000000 Excel isn't accurate for DPMO's<.4 or sigma's over about 5.3. This is of course without the 1.5 gimmie. 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 
