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

  • @paddyburke4148
    @paddyburke41483 жыл бұрын

    Explained better in 5mins than some people who spend an hour. Thanks

  • @beckyhorton759
    @beckyhorton7592 жыл бұрын

    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.

  • @Alexander-cn5sc
    @Alexander-cn5sc2 жыл бұрын

    Really helpful - thank you very much. I’ve been looking online for hours and this explained it better than anything.

  • @elfassimariam250
    @elfassimariam2503 жыл бұрын

    That was extremely helpful, simple and right to the point , thanks a lot

  • @KenKaercher
    @KenKaercher3 жыл бұрын

    Many Thanks!!!! Great demonstration!

  • @lilianadarrigo3876
    @lilianadarrigo3876Ай бұрын

    Very useful video, thanks!

  • @vassiaanguelova5770
    @vassiaanguelova577010 күн бұрын

    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?

  • @tathianaarones380
    @tathianaarones380Ай бұрын

    Thanks!!

  • @SD-un3ii
    @SD-un3ii26 күн бұрын

    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.

  • @darladue
    @darladue12 күн бұрын

    How did you calculate the USL and LSL?

  • @vinaysharrma7967
    @vinaysharrma7967 Жыл бұрын

    Well explained

  • @creativethings1557
    @creativethings15573 жыл бұрын

    Can you make graph for this data plz

  • @usuitakumi4210
    @usuitakumi42102 ай бұрын

    Thank you !

  • @nicholaslubinski7019
    @nicholaslubinski7019 Жыл бұрын

    Now take your data and plug it into minitab and you will notice this is PPK not CPK.

  • @FunnyVideo-qm9sq
    @FunnyVideo-qm9sq Жыл бұрын

    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

    @RJ_Schrodinger

    6 ай бұрын

    Exactly!

  • @FernandoGarcia-dl7kh

    @FernandoGarcia-dl7kh

    3 ай бұрын

    How then with same process, could be calculated? Appreciated your support

  • @ayahnadanida
    @ayahnadanida6 ай бұрын

    Thanksss..

  • @EC23331
    @EC23331 Жыл бұрын

    What if the USL-mu and mu-LSL answers are the same?

  • @gl4c.4

    @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)

  • @nazifnazli7839
    @nazifnazli78392 жыл бұрын

    To calculate cp value. Why we need to divide with 6? What is 6 stand for?

  • @TheMaruta731

    @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!