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. cp-cpk-template-menu

  3. Next click on the worksheet tab labeled: Pass-Fail Cp Cpk Calculator.
  4. 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...

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



  • Only $299 USD - less with quantity discounts
  • No annual fees
  • Free Technical Support

easy to use

Easy to Use

  • Works Right in Excel
  • Calculates Cp Cpk Pp Ppk
  • Accurate Results Without Worry

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free