Skip to content
LeanSuite - Lean Manufacturing Software

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.

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.

How to calculate it

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.

Worked 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. 1Opportunities = 500 units × 10 = 5,000.
  2. 2DPU = 25 ÷ 500 = 0.05 defects per unit.
  3. 3DPMO = 25 ÷ 5,000 × 1,000,000 = 5,000.
  4. 4Yield = 1 − 5,000 ÷ 1,000,000 = 99.5%.
  5. 5Sigma 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>

How LeanSuite helps

LeanSuite's Quality Improvement tools log quality issues from the floor, trace each one to its root cause and follow the corrective action through to closure, with custom KPIs that show where defects happen.

See Quality Improvement

FAQ

DPMO and sigma level calculator: common questions

More free lean tools

All tools