Home » Histograms & Capability Analysis » Cp Cpk to PPM Converter

Cp Cpk Calculator in Excel

Convert PPM to Cp Cpk or Convert Cp Cpk to PPM

Calculating Process Capability metrics or converting them to PPM can be tricky. That is why we created the Cp Cpk Calculator in Excel. This template is part of QI Macros SPC Software for Excel.

Instructions for Using the PPM to Cp Cpk Converter

1. Click on the QI Macros menu on Excel's tool-bar and select Calculators. Then click on the DPMO | Yield | Cp/PPM | OEE.
   
   
2. The template has several tabs, select the tab labeled Cp-Cpk-PPM calculator.
3. Input areas are shaded in yellow.
   • Enter parts per million above/below the USL/LSL in cells B2 and B3 to calculate Cp Cpk or
     
   • Enter Cp or Cpk in cells E2 and H2 to calculate PPM.

The Cp Cpk Calculations is one of many tools included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find any tool you need. If you can't locate a tool, use the find tools feature on the far right side of QI Macros menu.

Learn More...

• Attribute (Pass/Fail, Go/No-go) Cp Cpk Calculator
• Rolled Throughput Yield
• Other Lean Six Sigma Templates in QI Macros

---

Why Choose QI Macros to Perform Capability Analysis and Draw Histograms?