Paste your results to get the mean, spread, control limits and Cpk.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Cpk
—
Mean
—
Standard deviation
—
Upper control limit (mean + 3σ)
—
Lower control limit (mean − 3σ)
—
Results
—
Formula
Mean and sample standard deviation of the results; control limits = mean ± 3σ; Cpk from the nearer specification limit
=AVERAGE(B2:B31)Excel: results down column B; =STDEV.S(B2:B31) for the standard deviation
Use at least 25–30 results from a stable process for a reliable figure. A point outside the control limits is a signal to investigate.
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.