DPMO Six Sigma Calculator in Excel
Excel Template Calculates DPMO and Six Sigma
Just input opportunites and defects into the yellow input area and the Excel template will calculate DPMO, % defects, % yield, Sigma, and Z. Area to the right compares DPMO to the Six Sigma values.
Example of the QI Macros DPMO Six Sigma Calculator Template
To Calculate DPMO and Sigma You Need to Know:
- How many opportunities are there to create a defect in a given step in the process?
- How many defects were produced in a given run?
- Input these two values in the yellow fields on the QI Macros DPMO Calculator.
To calculate DPMO and Rolled Throughput Yield on more than one step, use the Rolled Throughput Yield template.
Watch Video on the DPMO, Six Sigma and RTY Calculators