[Previous entry: "6 Sigma and Software CMM"] [Next entry: "Process Capability for Non-Normal Data Cp, Cpk"]

07/27/2007: "Converting DPMO & Sigma Level"

How do you covert DPMO to sigma level and sigma level to DPMO?

Al F.

Generally, you would use a table, such as provided in my Six Sigma Demystified book, or you can calculate it directly in Excel using the formula =(NORMSINV(1-$D2))+1.5, where the data in cell D2 is entered as a decimal (for example, 30% error rate = 300,000 DPMO = 0.3 which calculates as 2.02 Sigma Level).

pak