Topic 10 - 09. Process Capability Calculation in Excel
HTML-код
- Опубликовано: 8 сен 2024
- This video is part of a lecture series available at / operationsmanagement101 . Excel files used in this series are available at drive.google.c...
Based on the textbook "Matching Supply with Demand: An Introduction to Operations Management" by Gerard Cachon and Christian Terwiesch, 3rd edition, 2011
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.
That was extremely helpful, simple and right to the point , thanks a lot
Really helpful - thank you very much. I’ve been looking online for hours and this explained it better than anything.
Very useful video, 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.
Many Thanks!!!! Great demonstration!
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?
Now take your data and plug it into minitab and you will notice this is PPK not CPK.
Thank you !
Thanks!!
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
Exactly!
How then with same process, could be calculated? Appreciated your support
How did you calculate the USL and LSL?
Well explained
Thanksss..
Can you make graph for this data plz
What if the USL-mu and mu-LSL answers are the same?
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?
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!