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.
If you want to calculate your capabiltiy figures immediately online, check the website sixsigmablackbelt.io
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).