Cp/Cpk Capability

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 with respect to how well an organization controls them.

This template will significantly supports 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


This slideshow requires JavaScript.

Download link

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

Additional details

  • Language(s): English
  • Revision 2

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.


  1. Super!

Leave a Reply