The formula for Cpk (process capability index) is: where μ is the mean or average of the process. Cp, CpkCalculator Difference between Cp and Cpk The main difference between Cp and Cpk is that Cp only considers the spread of the process data relative to the specification limits, while Cpk...
Click on the QI Macros menu on Excel's tool-bar and select Calculators. Then click on theDPMO | Yield | Cp/PPM | OEE. The template has several tabs, select the tab labeled Cp-Cpk-PPM calculator. Input areas are shaded in yellow. ...
Plus, you don't need to create the code for this calculation. You can refer to our Cp/Cpk calculator at the following link. Enter the values for mean, standard deviation, LSL and USL and you will get Cp and Cpk https://www.benchmarksixsigma.com/calculators/process-capability-calculator/...