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
  Miscellaneous Quality Topics
  DPMO vs SIGMA

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 vs SIGMA
Jimdad
Lurker (<10 Posts)

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

posted 26 January 2001 08:55 AM     Click Here to See the Profile for Jimdad   Click Here to Email Jimdad     Edit/Delete Message   Reply w/Quote
Folks, I am deserately seeking a formula for converting DMPO to sigma...

Anyone?

IP: Logged

stefanson
Forum Contributor

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

posted 26 January 2001 12:55 PM     Click Here to See the Profile for stefanson   Click Here to Email stefanson     Edit/Delete Message   Reply w/Quote
Check out: 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 26 January 2001 12:58 PM     Click Here to See the Profile for Jimdad   Click Here to Email Jimdad     Edit/Delete Message   Reply w/Quote
Been there, I don't have the complete MS 2000 suite to utilize the converter.


Thanks for the feedback.


Jim

IP: Logged

GaryC
Lurker (<10 Posts)

Posts: 6
From:Homestead, FL, USA
Registered: Feb 2001

posted 25 February 2001 11:31 AM     Click Here to See the Profile for GaryC   Click Here to Email GaryC     Edit/Delete Message   Reply w/Quote
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
From:Homestead, FL, USA
Registered: Feb 2001

posted 25 February 2001 11:32 AM     Click Here to See the Profile for GaryC   Click Here to Email GaryC     Edit/Delete Message   Reply w/Quote
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           Edit/Delete Message   Reply w/Quote
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

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!