Тёмный

Making a Control Chart in Excel (with dynamic control lines!) 

David McLachlan
Подписаться 128 тыс.
Просмотров 72 тыс.
50% 1

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

 

1 окт 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 38   
@TheEngineeringToolboxChannel
@TheEngineeringToolboxChannel 2 года назад
Thank you for the video, but I wanted to point out that this is NOT the correct way to calculate control limits for control charts. In control charting the sigma symbol is not the same as typical standard deviation. It is calculated using different methods (depending on the type of the chart) that takes into consideration the relative shift of the process over time. This is by design and it is very critical that sigma is calculated correctly for a control chart to be useful. In your case, sigma should be calculated as [sigma = MR/d2] .....where MR is the moving range of each successive data point and d2=1.128 (the scalar constant for control charts where sample size is n=1). I encourage people to compare both ways with real data and you will see how much different the values are. Using global standard deviation (as you have) will severely inflate the control limits and can give you the false impression that a process is in control when it is likely not. The reason 3*SD seems too far away is because it’s not the right calculation. Calculating the sigma value correctly will show many of the data points are out of control even with 3*sigma. Apologies for the rant but i see this error too often. Too many MBAs who took a stat class thinking this is what statistical process control is.
@davidmclachlanproject
@davidmclachlanproject 2 года назад
Great information, thank you! 👍🙂
@AkshayKumar-vd5wn
@AkshayKumar-vd5wn Месяц назад
I believe for an overview this technique is alright. To see if anything went beyond the 3 standard deviations. But we would love it if you could make a video on calculating it the right way.
@campbellwalker6378
@campbellwalker6378 Год назад
Mate, you may very well have saved my assessment from going into the fire, Thank you for your hard work at making such a easy to follow video, it is a mark of a true teacher to make the seemingly complex, simple to follow, Thank you again.
@SpiderPy
@SpiderPy 20 дней назад
Thanks, it was very useful for my school homework! Very well explained sir!
@cornicheebrewer4174
@cornicheebrewer4174 8 месяцев назад
Literally followed his directions had to pause multiple times but I did it!
@tapiwanalwimba6065
@tapiwanalwimba6065 2 месяца назад
Great content and always on the mark. I honestly love your videos so helpful and insightful🤧🤩
@lovetome6130
@lovetome6130 2 месяца назад
Thanks a lot. Keep doing such excellent knowledge sharing
@ahsanayaz8276
@ahsanayaz8276 Год назад
Can you please tell me how to make fishbone diagram in excel
@EC23331
@EC23331 Год назад
How are the USL and LSL added into the control chart?
@michaelfarrell9541
@michaelfarrell9541 6 месяцев назад
I'm struggling to get my head round one thing... why would you want your control limits to be dynamic? Imagine the scenario where you have a data point that should sit just outside your CL. But because the CL is dynamic, it shifts so the new data point is now within the CL. It's kind of a self fulfilling prophecy! Shouldn't you use historical data to establish fixed control limits, then see where new data points fall in relation to those limits? Thanks in advance 🙂
@supersport1572
@supersport1572 7 месяцев назад
Thank you for the video! Helped me so much. Can you get to the same result without the inputs in chart form? What if I have the dates and values across a horizontal row?
@paulanton5432
@paulanton5432 Месяц назад
Thank you so much. Really appreciated. Informative video.
@martinhodge394
@martinhodge394 7 месяцев назад
Thank you!
@timmcdaniel933
@timmcdaniel933 4 месяца назад
Good but too damn fast
@AnupHarne-h4n
@AnupHarne-h4n 4 месяца назад
Thanks..very useful
@chrisnedu9035
@chrisnedu9035 5 месяцев назад
Great resource, how can I contact you?
@reaganokongo
@reaganokongo 2 года назад
I love this you are doing a very excellent job, keep it up
@odwavelem5974
@odwavelem5974 2 года назад
Thank you very much david.
@TheVerM0nster
@TheVerM0nster 4 месяца назад
This is absolute fire
@hwylsoliloquy2959
@hwylsoliloquy2959 Год назад
THANK YOU VERY MUCHHHH
@patrickhunter3150
@patrickhunter3150 Год назад
Great vid
@markcerda2092
@markcerda2092 2 года назад
Thank you :)
@Xploremoments
@Xploremoments Год назад
I can not thank you enough for your precise and clear explanation. You really helped me to do my assignment correctly. Thanks
@markbassett335
@markbassett335 2 года назад
Nice job - thank you. I learned some new tricks!
@amjadalikk8589
@amjadalikk8589 8 месяцев назад
Ucl and lcl calculation are wrong... Ucl -average+3std dev
@davidmclachlanproject
@davidmclachlanproject 8 месяцев назад
You are right. In my experience, those values are too big for me (controls too wide). Good call for anyone who needs wider ones though!
@francescahamilton7997
@francescahamilton7997 2 года назад
Thank you very much. It is explained very clearly. Now I know how to impress my director :)
@TCCook326
@TCCook326 Год назад
moving too fast
@virgilitoabreu8757
@virgilitoabreu8757 Год назад
Excellent presentation
@jasonhunter7143
@jasonhunter7143 Год назад
You are the absolute GOAT!!! You never fail me brother
@ashrafta4188
@ashrafta4188 Год назад
Very simple, method thank you
@connie6616
@connie6616 2 года назад
Very useful and professional
@kimberlyannverano9962
@kimberlyannverano9962 2 года назад
This is very helpful 💙
@ivangohome
@ivangohome Год назад
Impressive!
@varvarapapadopoulou9875
@varvarapapadopoulou9875 2 года назад
I have 480 time measurements per day for 30 days, if I calculate the average per day and out of this mean, find the standard deviation it would be correct? Should I use x- chart and s-chart or r-chart?
@Stefanitons
@Stefanitons 2 года назад
If I understood correctly you UCL and LCL are 1 sigma away from the mean, correct?
@degracemuzik_band
@degracemuzik_band Год назад
This will help me close my audit non compliances.
Далее
How to Make a Risk Assessment Matrix in Excel
16:10
Просмотров 509 тыс.
ХОККЕЙНАЯ КЛЮШКА ИЗ БУДУЩЕГО?
00:29
OYUNCAK DİREKSİYON İLE ARABAYI SÜRDÜ 😱
00:16
Просмотров 2,7 млн
荧光棒的最佳玩法UP+#short #angel #clown
00:18
How to make Run Chart and Control Chart
6:47
Просмотров 53 тыс.
PMBOK 6. 8.2.5. Control Chart - PMP Exam
12:13
Просмотров 5 тыс.
ХОККЕЙНАЯ КЛЮШКА ИЗ БУДУЩЕГО?
00:29