The Cp indicates if a process is capable to produce within the specification limits, if the process is centered between the specification limits. To get this quality (Cpk) the process needs to be tuned so that mean is moved to center of the tolerance borders. Therefore the Cp is always lower of equal compared to the Cpk value. This calculation assumes that the data is normally distributed this can be checked with the Anderson Darling normality test. If the cell with the Cp value is red the data set is not according the normal distribution.
The Cp value of a data-set is only calculated if the min and max tolerance are available.

Formula

With a higher Cp value the variation is smaller and it is possible to produce with a higher quality.

Cpk (Process capability)

Calculates the Process capability value of a data-set. The higher the Sigma level the higher the quality (see table). This calculation assumes that the data is normally distributed this can be checked with the Anderson Darling normality test. If the cell with the Cpk value is red the data set is not according the normal distribution.

Formula

With a higher Cpk value the data set is better within tolerance.

Calculates how much % of the data set is statistical out of tolerance. Below 0.1% the value is displayed in PPM (Parts Per Million). This calculation assumes that the data is normally distributed this can be checked with the Anderson Darling normality test. If the cell with the "% out of tolerance" value is red the data set is not according the normal distribution.

Formula

calculate the value out of the t distribution.
calculate the value out of the t distribution.

% out of tolerance

Legend

= Mean
s = STDEV
USL = Upper specification limit
LSL = Lower specification limit

Minimum sample size Cp and Cpk

The minimum sample size to estimate the Cp and Cpk is 30 samples.

What if the process is not approximately normally distributed

All the Cp, Cpk and % out of tolerance assume that the data is according a normal distribution. This can be checked with the Anderson Darling normality test. If the data set is not normally distributed see "What to do with not normally distributed data". A solution is to transform the data and tolerance limits with a Box-Cox transformation. If the result of this transformation is a normally distributed data-set the Cp, Cpk and % out of tolerance can be used.

Example

From data-set in column A the CP is 1.2, Cpk 1.05 and statistical is 0.11% out of tolerance, this is visible in the rows: Cp, Cpk and % out of tol of the result array. The values are calculated with the tolerance borders in Max Tol. and Min Tol.