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.

attribute cp cpk calculator 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. 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:

    Go No Go data

Learn More...

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

easy to use

Fast and Easy to Use

  • Works Right in Excel
  • Calculates Cp Cpk Pp Ppk
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

Proven and Trusted

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



  • Only $349 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support