Topic 10 - 09. Process Capability Calculation in Excel

Подписаться 4 тыс.

Просмотров 61 тыс.

50% 1

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

Опубликовано:

27 июн 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 19

@paddyburke4148 3 года назад

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

@lilianadarrigo3876 18 часов назад

Very useful video, thanks!

@beckyhorton759 2 года назад

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 2 года назад

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

@tathianaarones380 2 дня назад

Thanks!!

@elfassimariam250 3 года назад

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

@KenKaercher 3 года назад

Many Thanks!!!! Great demonstration!

@nicholaslubinski7019 Год назад

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

@usuitakumi4210 Месяц назад

Thank you !

@vinaysharrma7967 Год назад

Well explained

@ayahnadanida 5 месяцев назад

Thanksss..

@creativethings1557 2 года назад

Can you make graph for this data plz

@FunnyVideo-qm9sq 11 месяцев назад

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 4 месяца назад

Exactly!

@FernandoGarcia-dl7kh 2 месяца назад

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

@EC23331 Год назад

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

@gl4c.4 2 месяца назад

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 2 года назад

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!