Cp Cpk Template for Excel
You Don't Have to be a Statistician to Calculate Cp and Cpk
Just Drop Your Data Into QI Macros Fill in the Blank Template
Input 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 35 characteristics and 100 measurements:
Here is an Example of the QI Macros Cp Cpk Template
Four Worksheets in the Template
- Cp Cpk 8 Worksheet - 8 Characteristics and 100 measurements
- Cp Cpk 35 Worksheet - 35 Characteristics and 100 measurements
- Attribtue Cp Cpk Worksheet for Go/NoGo data - for when you don't have measurements, just pass/fail (binary) data.
- Cp Cpk True Position - when there are two aspects to your measurement (e.g. horizontal and vertical for the position of a hole.)
- MMC Cpk True Position - when you are measuring something like the inside and outside of a cylinder
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.
To open the template from the QI Macros menu, select Capability Templates, then Cp Cpk Templates.
To expand the template, follow these instructions (Click Here).
Learn More ...
- Process Capability Analysis Quick Reference Card (PDF, 172 KB)