Home » Histograms & Capability Analysis » Cp Cpk for Attribute Data

Need to Calculate Cp Cpk for Attribute Data?

QI Macros has an attribute Cp Cpk Calculator in Excel!

Calculating Cp Cpk for for attribute data can seem tricky.

That is why we created the Pass / Fail Cp Cpk Calculator template for Excel.

---

How to use the Attribute Cp Cpk calculator:

1. QI Macros installs on Excel's menu. To open the template, click on QI Macros > Capability Templates > Cp Cpk Templates.
   



2. Next click on the worksheet tab labeled: Pass-Fail Cp Cpk Calculator.
3. Enter the parts that failed the go/no-go test in Cells B2:B3 and Total Parts in cell B4.
   These will be converted to Z scores which are then converted to Cp and Cpk:
   
   
4. That's it! That's how easy it is to use QI Macros.

Learn More...

• Cp Cpk to PPM Converter
• Rolled Throughput Yield
• Other Lean Six Sigma Templates in QI Macros

QI Macros Draws These Charts Too!