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 Cp Cpk Calculator and Cp Cpk Template in Excel. These templates are part of the proven and affordable QI Macros SPC Software for Excel.

Instructions for Using the Cp Cpk Calculator with Attribute Data

  1. Click on the QI Macros menu on Excel's toolbar and select Calculators. Then click on the DPMO | Yield | Cp/PPM | OEE:
  2. dpmo-calculator

  3. In the template, click on the tab labeled Cp-Cpk-PPM calculator. Input areas are shaded yellow:
  4. Cp Cpk Calculator Excel - QI Macros

  5. Enter PPM above/below the Go/NoGo in cells B2 and B3 to calculate Cp Cpk
    • if you are using a pass/fail or go/nogo gage, some parts are too large, some are too small. This is like a specification limit. Calculate Parts Per Million (PPM) using:
      - PPM Above = (Parts too large*1000000)/Total Parts
      - PPM Below = (Parts too small*1000000)/Total Parts
    • Put these values in the Cp/Cpk calculator to determine Cp and Cpk.

Instructions for Using the Cp Cpk Template with Attribute Data

In September, 2016, we added this calculation to the Cp Cpk Template:

  1. Click on 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/nogo 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:
  5. Attribute capability Cp Cpk Template Excel/></li>
                <h3>Learn More...<br />
                  <li><a href=

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