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

Attribute Cp Cpk Calculator in Excel

Calculating Cp Cpk for Go/No-Go and Pass/Fail Gages

Calculating Process Capability for attribute data can seem tricky. That is why we created the Pass / Fail Cp Cpk Calculator template for Excel. This template is part of QI Macros SPC Software for Excel.

To open and use this template:

1. Click on QI Macros menu, then 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:
   
   

Learn More...

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

---

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