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?



  • Only $329 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