Skip to content
LeanSuite

Free tool

DPMO and sigma level calculator

DPMO, defects per million opportunities, is the number of defects a process would make in a million chances to make one. It is defects ÷ (units × opportunities per unit) × 1,000,000. The sigma level restates DPMO on the Six Sigma scale, where 6 sigma is 3.4 DPMO and 3 sigma is about 66,800.

DPMO formula and sigma level

DPUequalsDefects divided by Units

DPMOequalsDefects divided by Units × Opportunities per unit × 1,000,000

Sigma levelequalsz value of (1 − DPMO ÷ 1,000,000) + 1.5

The z value is the point on the standard normal curve with that share below it: NORM.S.INV in Excel. The + 1.5 is the conventional long-term shift used in Six Sigma tables.

Count every defect; one unit can have several

Units checked in the same period

Distinct ways a unit can fail that you check for

Pre-filled with the worked example. The sigma level includes the usual 1.5 sigma shift, the convention behind Six Sigma tables.

Sigma level

4.08

5,000 defects per million opportunities.

DPMO

5,000

Defects ÷ (units × opportunities) × 1,000,000

Yield

99.500%

Opportunities without a defect

Defects per unit (DPU)

0.05

Defects ÷ units

Sigma without the shift

2.58

Long-term z value of the yield

Email me my results

Optional. Get these inputs and results in your inbox, with a link back to this calculator.

We may follow up about LeanSuite. See our Privacy Notice.

Next step

Want to track this every week?

Bring this result to a 45-minute demo and we will show where it fits in LeanSuite's Quality Improvement.

How to calculate it

How to calculate DPMO: three counts from your inspection data

Defects are every nonconformity found, so a unit with two faults adds two. A defect check sheet is the simplest way to collect the count by type.

Units are the units inspected in the same period, good and bad.

Opportunities per unit are the distinct characteristics you check that could each be wrong. Keep the list short and fixed: padding it with features that never fail makes the sigma level look better than the process is.

Use DPMO and sigma level to compare processes or products of different complexity, and to track one process before and after a DMAIC project. For a single measured characteristic against its specification limits, Cp and Cpk say more, and for how many units get through each step without rework, use first pass yield.

DPMO calculation example

Illustrative numbers, not a benchmark

An inspection of 500 circuit boards, each checked for 10 kinds of defect, finds 25 defects in total.

  1. Step 1

    Opportunities = 500 units × 10 = 5,000.
  2. Step 2

    DPU = 25 ÷ 500 = 0.05 defects per unit.
  3. Step 3

    DPMO = 25 ÷ 5,000 × 1,000,000 = 5,000.
  4. Step 4

    Yield = 1 − 5,000 ÷ 1,000,000 = 99.5%.
  5. Step 5

    Sigma level = NORM.S.INV(0.995) + 1.5 = 2.576 + 1.5 = 4.08.
5,000 DPMO, a sigma level of 4.08. To reach 5 sigma (233 DPMO) the same inspection would have to find no more than one defect in about 4,300 opportunities.

Sigma level to DPMO table

Sigma levelDPMOYield
1691,46230.9%
2308,53869.1%
366,80793.3%
46,21099.38%
523399.977%
63.499.99966%

Worked out with the 1.5 sigma shift, the same convention the calculator uses. The shift goes back to Motorola, where Six Sigma started, and is a convention rather than a measured fact about your process; the Wikipedia article on Six Sigma covers the debate. Whichever you use, use it every time.

Embed this calculator

Teaching this, or writing about it? Paste this code into your site, course page or intranet and the calculator works right there. It is free, with no sign-up.

<iframe src="https://www.theleansuite.com/tools/dpmo-calculator/embed" title="DPMO and sigma level calculator by LeanSuite" width="100%" height="1130" style="border:0;max-width:1000px" loading="lazy" allow="clipboard-write"></iframe>
<p style="font:13px/1.4 sans-serif"><a href="https://www.theleansuite.com/tools/dpmo-calculator">DPMO and sigma level calculator</a> by LeanSuite</p>

FAQ

DPMO and sigma level calculator: common questions

  1. DPMO = defects ÷ (units × opportunities per unit) × 1,000,000. If you inspect 500 units, each with 10 opportunities for a defect, and find 25 defects, DPMO = 25 ÷ (500 × 10) × 1,000,000 = 5,000. Count defects, not defective units: one unit with three faults is three defects.

  2. Turn DPMO into a yield, find the z value of that yield on the standard normal curve, then add the 1.5 sigma shift. In Excel or Google Sheets: =NORM.S.INV(1 - DPMO/1000000) + 1.5. For 5,000 DPMO that is NORM.S.INV(0.995) + 1.5 = 2.58 + 1.5 = 4.08 sigma.

  3. An opportunity is one distinct way a unit can fail to meet a requirement that you actually check for, such as a solder joint, a dimension or a label. Agree the list once and keep it fixed. Counting more opportunities per unit lowers DPMO and raises the sigma level without the process getting any better, so only compare sigma levels that use the same definition.

  4. DPU is defects per unit: defects ÷ units. PPM, parts per million, counts defective units per million units, so a unit with three defects counts once. DPMO counts defects per million opportunities, which lets you compare products of different complexity. The same batch gives a different number on each scale, so say which one you mean.

  5. Six Sigma tables assume a process mean drifts by about 1.5 standard deviations over time. A process with six standard deviations between its mean and the nearest limit is then 4.5 standard deviations from it in the long run, and the share of a normal curve beyond 4.5 standard deviations is 3.4 per million. Without the shift, six sigma would mean about one defect per billion.

More free lean tools

All tools

Pass it on

We want LeanSuite to be the best place on the internet for lean help. If this was useful, send it to someone on your team or in your network who needs it.