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.

Main Features

• 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

Screenshots

This slideshow requires JavaScript.

Download link

To download this tool, click on the following link :

License

• This tool is free
• It can be modified by the user
• Cannot be redistributed or sold

Compatibility

• 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

Additional details

• 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.