Process capability

The process capability is a measurable property of a process to the specification, expressed as a process capability index (e.g., Cpk or Cpm). The output of this measurement is usually illustrated by a chronological control sample, histogram and calculations that predict how many parts will be produced out of specification (OOS).

How to calculate cpk in excel

Here you get this

 to calculate all process capability figures you need. If you want to have a template without branding, you can get it here.

If you want that i make some adjustments for you contact me. Maybe, if you want to get a template with your company logo or other things. The cpk formula in excel is inside the sheet.

The base for the cpk formula is described here.

cpk formula excel
cpk formula excel

process capability excel template 20150102.png
process capabality excel template

cpk calculation excel template
cpk calculation excel template

If you want to calculate your capabiltiy figures immediately online, check the website sixsigmablackbelt.io

cpk online calculation
cpk online calculation

If you want to to have a more scientific look on process control you can check this discussion in the minitab blog. Another way is to look on the homepage of ASQ.

Please feel free to contact me, if you have some suggestions to improve this page (roland.schnurr@sixsigmablackbelt.de).