![cp and cpk calculations in excel cp and cpk calculations in excel](https://econoshift.com/wp-content/uploads/2017/01/Unilateral-Tolerances-Calculation-on-Excel-Worksheet.png)
→ In our business, the reduction of waste and provide quality products are paramount if we want to survive in the market and make a strong presence even if in cut-throat competition. → Both are very important tools for calculating the initial and ongoing processes & parts capability. → Both are used with variable or continuous data and it shows how our process is capable and either meets our specifications or not? ⇢ (2) Cpk - Actual_Capability during the production ➨ Various Indexes for Process_Capability Measurement → In Six Sigma Projects or any other quality improvement project, this tool is very useful for an estimate of the capability. Before we get into the detailed statistical caluculations, lets review the high-level steps: 1: Plot the Data: Record the measurement. → Our processes can be capable of manufacturing an acceptable product on a consistent basis if we maintain the capability. So with the help of a suitable measuring instrument, we can get a more reliable output. Not every cup of tea is exactly the same but if we control the measurements then it could be approximately the same. The variation can occur in the amount of tea or water quantity during the operation and the performance of the tea maker. Our operation step includes turning on the tea maker, measure and adds the tea and water and our output is a cup of tea.
![cp and cpk calculations in excel cp and cpk calculations in excel](https://i.ytimg.com/vi/ZmNxmrUWFnc/maxresdefault.jpg)
→ For Example, if we want to make a cup of tea, then our inputs are tea and water. → We can monitor it, measure it, reduce and control it. → All processes have a certain amount of variation and this variation cannot be eliminated. → Each step adds value to achieve the desired output. → In simple language, the process is a sequence of interdependent steps that consume resources and convert the inputs into outputs. → Let we understand this concept with the help of a simple example → It is a statistical tool to measure the variability of the_process and it is a part of Statistical_Process Control. → Process Capability is a statistical measurement of a process’s ability to manufacture parts within the specification consistently. This measurement is determined by dividing the specification limit (voice of the customer) by the process spread (voice of the process).