In process improvement efforts, the process capability index or process capability ratio is a statistical measure of process capability: the ability of a process to produce output within specification limits. The concept of process capability only holds meaning for processes that are in a state of statistical control.
Process capability indices measure how much “natural variation” a process experiences relative to its specification limits and allows different processes to be compared to how well an organization controls them.
This template will significantly support you in calculating Cp/Cpk for any metrics or process parameters. You just input the measured values, the tolerances and the formulas will automatically calculate all the Cp/Cpk values.
- 2 different templates :
- calculation for a bilateral tolerance
- calculation for a unilateral tolerance
- Based on the measured values, the template automatically generates:
- Cp/Cpk values
- The mean
- UCL/LCL values
- Sample size
- 2 visual graphs
To download this tool, click on the following link :
- This tool is free
- It can be modified by the user
- Cannot be redistributed or sold
- PC Excel 2016: OK
- PC Excel 2013: OK
- PC Excel 2010: OK
- PC Excel 2007: OK
- MAC – Excel 2016: OK
- MAC – Excel 2011: not tested
- Language(s): English
- Revision 2
- 40122 Downloads
If you like this tool, you will love:
Gantt Chart Maker: Our most popular tool for project managers. It will help you make awesome project schedules and meet your deadlines. It has more than 10 years in service and 150,000+ downloads. Try the free version first.
Thank you so much
Best CpCpk template I found on the internet. Keep pushing!
Thanks for the Cp & CpK software
Thank you so much for this valuable example, great job.
This CPK template is user friendly and very comprehensive!
Thanks for sharing the Best Cp & Cpk Template and the Gantt Chart Maker!
Thanks and it is useful
Thank you so much. I appreciate this template, it is doing exactly what is expected and supports usage of statistical tools in my scope of work. Cheers from Malaysia
Thanks, nice tool