Topic 10 - 09. Process Capability Calculation in Excel
This video is part of a lecture series available at / operationsmanagement101 . Excel files used in this series are available at drive.google.com/drive/folder...
Based on the textbook "Matching Supply with Demand: An Introduction to Operations Management" by Gerard Cachon and Christian Terwiesch, 3rd edition, 2011
Пікірлер: 22
Explained better in 5mins than some people who spend an hour. Thanks
I wish I would have found this video first in my research. Very thorough explanation with visual example that made this digestible for my brain. THANK YOU.
Really helpful - thank you very much. I’ve been looking online for hours and this explained it better than anything.
That was extremely helpful, simple and right to the point , thanks a lot
Many Thanks!!!! Great demonstration!
Very useful video, thanks!
Hi, can you show how do you plot UCL and LCL on a histogram with bell curve. What type of calculation do you do to get them appear on the graph?
Thanks!!
The major difference between Pp, Cp, Cpk and Ppk is the way we calculate standard deviation that is sigma where Cpk uses rbar/d2, a constant. And the the one you are calculating is Ppk not Cpk.
How did you calculate the USL and LSL?
Well explained
Can you make graph for this data plz
Thank you !
Now take your data and plug it into minitab and you will notice this is PPK not CPK.
Thanks, but why you didn't use R/D2 formula to calculate the Cpk, from your video, you use std so, it is PPK, not Cpk
@RJ_Schrodinger
6 ай бұрын
Exactly!
@FernandoGarcia-dl7kh
3 ай бұрын
How then with same process, could be calculated? Appreciated your support
Thanksss..
What if the USL-mu and mu-LSL answers are the same?
@gl4c.4
3 ай бұрын
I believe in that case you can select either of them to calculate CPK. And I think it will also mean the process is perfectly in the middle of the spec limits. Here you'd probably have CPK = 2 (6 sigma level)
To calculate cp value. Why we need to divide with 6? What is 6 stand for?
@TheMaruta731
Жыл бұрын
The 6 represents the +/-3 Sigma that the Capability Analysis is evaluating. Note Cp is only based on StDev and not on the mean at all. It is really showing you how capable your process COULD BE if the data set was perfectly centered in between the spec limits. This is why CpK (always the lower of CpU & CpL is important to understand too). If your CpK is low but your Cp is acceptable you just need to shift or scoot the process target more towards the middle. If the Cp is low you need to "squeeze" the data (reduce variation) as well because you already know that just scooting the data towards the middle of the spec alone won't be enough to get the CpK that you want for your process (1.0, 1.3, 2.0, etc). Hope that helps!