Cp Cpk Template for Excel

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2009

It's easy to calculate Cp Cpk and analyze process capability using our Cp Cpk template.

Just enter your target value, tolerances and measurements in the yellow shaded areas. The worksheet will automatically calculate Cp, Cpk, Pp, and Ppk. It has space for up to eight characteristics and 100 measurements:

One Sided Spec Limits
If you need to perform a one tailed capability analysis, just delete the formula in either the USL or LSL field.

Cp and Cpk Calculations
While most people try to calculate Cp as the upper spec limit minus the lower spec limit divided by six times the standard deviation:

Cp = (USL-LSL)/6*Stdev

this is actually the formula for process performance (Pp).

The template uses the correct formula which estimates the standard deviation from the average of the ranges divided by a constant (Rbar/d2).

Cp = (USL-LSL)/6*Rbar/d2

The same is true for Cpk. To see the formulas used for Cp, Cpk click here.

To open the template from the QI Macros pull down menu, select Fill in the Blank Templates, SPC Charts, Cp Cpk Worksheet.

Other Resources

Cp Cpk Dashboard which automatically creates control charts , histograms and probability plots from your data.

Histograms in Excel with Cp, Cpk and Pp, Ppk

The Cp, Cpk template is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
FREE
30-Day Trial



Or Buy It Now
for only $139!
Unconditional
90-Day
Money-Back
Guarantee