Cp, Cpk Formulas  Pp Ppk Formulas
See How Easily You Can Analyze Process Capability
Cp and Cpk
Process Capability Metrics
 Cp measures how well the data fits within the spec limits (USL, LSL)
 Cpk measures how centered the data is between the spec limits.
Use Cp Cpk when you have a sample, not the population, and are testing the potential capability of a process to meet customer needs.
Cp and Cpk use Sigma estimator.
Pp and Ppk
Process Performance Metrics

Pp measures how well the data fits within the spec limits (USL, LSL)

Ppk measures how centered the data is between the spec limits.
Use Pp Ppk when you have the total population and are testing the performance of a system to meet customer needs.
Pp, Ppk use standard deviation.
Cp, Cpk Formula & Calculations
(Cpk > 1.33 is desirable)
Pp, Ppk Formula & Calculations
(Ppk > 1.33 is desirable)
Sigma Estimator Formula & Calculations
d2 is a constant based on subgroup size
c4 is a constant based on subgroup size
Rbar = Average(Ri)
(Average of the Ranges in samples)
sbar = Σ(σi)/n
OneSided or Unilateral Specification Limits
Use CpU (USL) or CpL (LSL) for Cpk.
Mistakes to Avoid When Using Cp Cpk and Pp Ppk Formulas
You can calculate Cp, Cpk and Pp Ppk manually or you can use the QI Macros for Excel. Based on calls to our tech support line, most people who try to perform manual calculations or build their own Excel formulas end up with incorrect results.
For example, they use stdev instead of sigma estimator for Cp and Cpk. Or they get the constant wrong based on their sample size. If you're providing these results to your customers shouldn't you use a tool that's proven and affordable?
QI Macros Tools that Calculate Cp, Cpk and Pp, Ppk
 Histogram  calculates Cp, Cpk, Pp, Ppk and 20 other metrics using your data and spec limits.
 Capability Suite  creates six charts including histogram, control charts, probability plot, values plot and capability plot. Also calculates Cp, Cpk and Pp, Ppk.
 Cp Cpk Template  calculates Cp, Cpk and Pp, Ppk on multiple sets of data.