- Cpk Equation Excel
- Cpk Calculation Excel Format
- Using Excel To Calculate Cpk
- Free Cpk Excel Download
- Cpk Formula
- How To Compute Cpk In Excel
- Cpk In Excel Formula
OEE Calculation is the simple calculation which is multiplied by availability, Performance and Quality. It is a methodology to measure the productivity of Process industries. If you manufacturing process OEE indicating 100%, It means your are Producing as fast as possible with low or no down times. Cpk = Zu = Zl = Pu = Pl = X axis Y axis min max delta 1.5 x Ymax Only change the cells in YELLOW It is not password protected. Other cells will be calculated and chart will be generated automatically.
Cp stands for process capability and Cpk stands for process capability index. Both are used for the measure of a potential capability of a process in short term. The higher the sigma level, the better the process is performing. You can learn how to calculate Cp and Cpk values using this tutorial. Learn to calculate the Process Capability (Cp) and Process Capability Index (Cpk) values using the steps and few examples given here.
Learn to Calculate Process Capability Index - Tutorial, Definition and Example
Process Capability (Cp) Definition:
Process capability is a technique to find out the measurable property of a process to a specification. Generally, the final solution of the process capability is specified either in the form of calculations or histograms
Process Capability Index (Cpk) Definition:
Process capability index (cpk) is the measure of process capability. It shows how closely a process is able to produce the output to its overall specifications.
Formula :
Where,
USL = Upper Specification Limit, LSL = Lower Specification Limit.
Example :
Food served at a restaurant should be between 38°C and 49°C when it is delivered to the customer. The process used to keep the food at the correct temperature has a process standard deviation of 2°C and the mean value for these temperature is 40. What is the process capability of the process?
Given,
USL (Upper Specification Limit) =49°C LSL (Lower Specification Limit) =39°C Standard Deviation =2°C Mean = 40
To Find,
Process Capability & Process Capability Index
Solution:
| Process Capability : | |
|---|---|
| Process Capability | = (49 - 39) / (6 * 2) |
| = 10 / 12 | |
| = 0.833 | |
| Process Capability Index : | |
| Solution 1 | |
| (USL-mean/ 3*std.Dev) | = (49 - 40) / (3 * 2) |
| = 1.5 | |
| Solution 2 | |
| (mean-LSL/3*std.Dev) | = (40 - 39) / (3 * 2) |
| = 0.166 | |
| Now, find the minimum value. | |
| Process Capability Index | = min (Solution 1, Solution 2) |
| = min (1.5 , 0.166) | |
| = 0.166 | |
Cp and Cpk are used in Six Sigma Quality Methods for analyzing the performance of the process carried out to deliver any product.
Related Tutorials:
Top Calculators
Popular Calculators
Top Categories
What is Ppk?
Our first two blogs in this process capability series answered two questions: What is process capability? – and - What is Cpk? This blog answers the next question: What is Ppk?
The answer is quite simple. Just to refresh your memory, Cpk is expressed as the following:
Cpk = Minimum (Cpu, Cpl)
Cpu=(USL-X)/3σ
Cpl=(X-LSL)/3σ
where Cpu is the capability based on the upper specification limit (USL), Cpl is the capability based on the lower specification limit (LSL), X is the overall average, and σ is the estimated standard deviation from a range control chart. Cpk is the minimum of Cpu and Cpl.
Ppk is expressed as the following:
Ppk = Minimum (Ppu, Ppl)
Ppu=(USL-X)/3s
Ppl=(X-LSL)/3s
where Ppu is the capability based on the upper specification limit (USL), Ppl is the capability based on the lower specification limit (LSL), and s is the calculated standard deviation from all the data. Ppk is the minimum of Ppu and Ppl.
Look at the equations for Cpu and Ppu. What differences do you see? Now look at equations for Cpl and Ppl. What differences do you see?
Cpk Equation Excel
The only difference is that Cpu and Cpl both use σ - the estimated standard deviation from a range control chart, while Ppu and Ppl both use s - the calculated standard deviation from all the data.
What does the difference mean? The easiest way to see this is through an example using an individuals control chart (X-mR). With an individuals control chart, the individual (X) value is plotted on the X chart. The range between consecutive points is plotted on the moving range (mR) chart. The average moving range is used to calculate the value of σ. And this value is used in the Cpk calculations.
Suppose the data are being collected hourly. Each moving range represents the “short-term” variation – the variation between consecutive hours. Cpk is sometimes referred to as the short-term capability – it represents what the process is capable of doing in the short-term – from hour to hour in this example.
| Hour | X | Hour | X |
|---|---|---|---|
| 1 | 106 | 11 | 102 |
| 2 | 104 | 12 | 100 |
| 3 | 104 | 13 | 92 |
| 4 | 106 | 14 | 99 |
| 5 | 99 | 15 | 115 |
| 6 | 92 | 16 | 105 |
| 7 | 99 | 17 | 100 |
| 8 | 93 | 18 | 98 |
| 9 | 109 | 19 | 105 |
| 10 | 105 | 20 | 99 |
The figure below represents the moving range for the data given. The first X value is 106; the second X value is 104. So, the moving range between these two results is 2.
Cpk Calculation Excel Format
The average moving range for these data is 6.2. For a moving range between consecutive points, σ is calculated as the following:
σ = R/1.128 = 6.2/1.128= 5.50
This is the value that would be used in calculating Cpk.
Using Excel To Calculate Cpk
For Ppk, the standard deviation of all the X values is calculated. Note that all the values are used at one time to determine the standard deviation. These values represent 20 hours (since there are 20 data points). This is a much longer time-frame than the between consecutive hours in the moving range chart. Because of this, Ppk is sometimes referred to as the long-term capability. In Excel, you can use the function STDEV to calculate the standard deviation. The result is:
s = 5.7
Free Cpk Excel Download
This is the value that would be used in calculating Ppk
Cpk Formula
The difference between Cpk and Ppk is simply in how you calculated the standard deviation. So, which is better to use: the short-term Cpk capability or the long-term Ppk capability? This will be the topic of our next blog.
How To Compute Cpk In Excel
Our SPC Knowledge Base has multiple publications on process capability if you would like more details.
Cpk In Excel Formula
The control chart above was made using SPC for Excel, a simple but powerful software for statistical analysis in the Excel environment.