Well explained Sir I will not forget how to build a control chart.Thanks you so much 😊 After seeing my own comment from 2 years ago I think I forgot that and again taking help from him😢😢
You are really a fantastic teacher. Just when I was about to give up on statistics projects I came across your channel and hope is restored. Keep doing the good work. I'm really grateful.
At 3:20, rather than using absolute references (for those who don't understand them) you can click in D3 and enter =C3. Then drag that formula all the way down. So D3 will =C3, E3 will =D3, etc. etc.
Thank you. This video was very helpful in understanding how to create the chart in Excel, as well as getting a better understanding of the chart in general and how to use it.
This is awesome! I was having issues with doing this for a process design class and now I can do it without expensive macros. This is easy to digest even for a novice in both statistics and excel.
Eugene, I checked the calculations in the appendix of the book by David Howard and it is correct. He is not using sample standard deviation to calculate control limits. In fact 3/1.128=2.66 which is same as formula I have given below.
Thank you sooo much for saving me from a headache! These video was incredibly helpful for the graphs. Wish I would have found the video to help create the charts. THANK YOU!!
Thank you for all your videos. It is immensely informative as well as your method of explanation is lucid and to the point. I appreciate your help...thanks!
Hi Robin, My example is based on Prof Nigel Slack's book "Operations Management" (5th ed) who suggests (p557) that control limits can be added at +- 3 std devs "away from the mean of sample averages". He states "this shows that the probability of the final point on the chart being influenced by an assignable cause is very high". Slack does point out that we "cannot be absolutely certain that the process is out of control" using this evidence and there may be a risk of a Type I error. Dr E.
Thank you Sir, your session was simple and very straight forward. Look forward for more such concepts discussed to shed light to all. Good work! Thanks again.
Hi Robin, Many thanks for your response - I'll be sure to check this out. Essentially I also took a shortcut by using Excel's STDEV function to do the calculations for me. Eugene
Hi Eugene - Many thanks , with profound appreciations for this excellent video presentation! its very helpful. Now I can easily prepare/present my Clinical laboratory internal quality control and statistical process control...Once again thank youFrom Musa
This was so helpful! Thank you, thank you! I don't know who needs to hear this, but this is the video to watch for constructing a Levey Jennings graph. #2020onlinelearning
Control limits are conventionally placed at +/ -3 standard deviations Dr. Shewhart originally proposed it. There is no problem with that. The problem is with the formula you are using to calculate standard deviation. What we need is an estimate of the standard deviation using average range, not the sample standard deviation. Please refer to Wheeler and Chambers book Understanding SPC (3rd edition) page 59. Other wise the control limits will be inflated, in this case by 455%.
I'm learning this, and noticed he did it different. Is it the difference between calculating the UCL and LCL using the +/- 3* stand deviation method, versus making moving range data and taking the 3* the MR mean then dividing by the d2 constant?
Hi Terry, My 30 sample measures are not means. If each sample measure was a mean value, then you would have to consider the average range within each mean before calculating the Standard Deviation. If your data points are mean values, then you need to consider the average range as Robin Francis points out below. If you need more information on this, search for "A User’s Guide to SPC" By David Howard - the calculations are outlined in the Appendix. Dr E.
Hi Robin, Many thanks for the suggested article by Wheeler - indeed he does point out that using three Std Devs is "wrong" and that it is "nothing more than another way to lie with statistics". I see also in the article's comments that there is some debate about this. I simply used Excel to show what other authors (cited above) have done. Allow me to check with my Mathematics colleagues before updating or removing this video as I am not expert in this area. Eugene
Mr. O'Loughlin, you rock! Very no-nonsense, easy-to-understand instructions. Others over-complicate the calculations. Nice work!
Searched the web for ages to find a simple and clear explanation. Many thanks Eugene, this is brilliant.
Words cannot express how much your wonderful video helped me today! Thank you!!
GOD BLESS YOU LOL. I'm in Operations Management for my Master's right now and this saved me lol, THANK YOU!
Well explained Sir I will not forget how to build a control chart.Thanks you so much 😊
After seeing my own comment from 2 years ago I think I forgot that and again taking help from him😢😢
Eugene, I have used this video in class for three years during a discussion about quality. thank you.
Thank you Stewart - I'm glad you found it useful. E.
i am watching this video in 2019 and i cannot tell how much helpful this data is thank you so much so grateful
You saved me tonight. I made a fictious chart with billing error as the error in the health care field for an assignment. This helped me so much.
You are really a fantastic teacher. Just when I was about to give up on statistics projects I came across your channel and hope is restored. Keep doing the good work. I'm really grateful.
Thank you Belle33, glad to be of service.
Albeit an older program, this is an excellent review of UCL/LCL type graphs and a masterful "how-to" explanation.
Thank you!!
I cannot express how much your video helped me today!
At 3:20, rather than using absolute references (for those who don't understand them) you can click in D3 and enter =C3. Then drag that formula all the way down. So D3 will =C3, E3 will =D3, etc. etc.
Dr.Eugene,It was a brilliant class in a lucid style.Thnx for the video.It is really really helpful.
Well explained, process easy to follow, thanks a lot Eugene!
That was great! I'm not going to read the comments, why would anyone mark a thumbs down? Maybe those that want to charge for this! Thank you so much!
your video means tutorial to me while the rest on google looks like people are trying to show off they are smarter than me.
Thank you
Super amazing, you have saved my life. Thanks million times
Thank you. This video was very helpful in understanding how to create the chart in Excel, as well as getting a better understanding of the chart in general and how to use it.
Your videos are great. Thank you for making them and putting them on you tube. I learned more from you then my professor. Thanks again.
Dear Eugene O'Loughlin,
Your explanation was wonderful! Thank you very much!
Absolutely the BEST video to help explain how to do this! THANK YOU!!!!
This is awesome! I was having issues with doing this for a process design class and now I can do it without expensive macros. This is easy to digest even for a novice in both statistics and excel.
Thank you very much! The clearest explanations I found online.
Thank you for the simplified explanation , you Make the both the understanding of the concept and the representation really interesting.
Thanks from Canada! Simple and helpful - much appreciate, Eugene!
Eugene, I checked the calculations in the appendix of the book by David Howard and it is correct. He is not using sample standard deviation to calculate control limits. In fact 3/1.128=2.66 which is same as formula I have given below.
Amazing and Amazingly simple. Really saved my rear end on the homework I have due tonight.
Thanks Eugene, very well explained. Managed to do my temperature monitoring control chart first time I watched your video!!
Thankyou very much - I was just brushing up on control charts prior to an interview. Great help!
Thanks Eugene, this was most helpful. My professor and text didn't do a very good job telling us how to create a control chart.
thank you you saved my operations management project, couldn't find this anywhere!
This video really helps me in my food processing and packaging class. Thank you very much!
Thank you sooo much for saving me from a headache! These video was incredibly helpful for the graphs. Wish I would have found the video to help create the charts.
THANK YOU!!
Thank you for all your videos. It is immensely informative as well as your method of explanation is lucid and to the point. I appreciate your help...thanks!
Thanks a bunch Eugene. Very straight forward explanation.
thank you very much. ur the best guru in the world
Hi Robin,
My example is based on Prof Nigel Slack's book "Operations Management" (5th ed) who suggests (p557) that control limits can be added at +- 3 std devs "away from the mean of sample averages". He states "this shows that the probability of the final point on the chart being influenced by an assignable cause is very high".
Slack does point out that we "cannot be absolutely certain that the process is out of control" using this evidence and there may be a risk of a Type I error.
Dr E.
Thank you Sir, your session was simple and very straight forward. Look forward for more such concepts discussed to shed light to all. Good work! Thanks again.
this has been immensely helpful, thanks so much Mr O' Loughlin
Hi Robin,
Many thanks for your response - I'll be sure to check this out. Essentially I also took a shortcut by using Excel's STDEV function to do the calculations for me.
Eugene
Hi Eugene - Many thanks , with profound appreciations for this excellent video presentation! its very helpful. Now I can easily prepare/present my Clinical laboratory internal quality control and statistical process control...Once again thank youFrom Musa
Thank you sir for a simple and valuable tutorial.
This was so helpful! Thank you, thank you! I don't know who needs to hear this, but this is the video to watch for constructing a Levey Jennings graph. #2020onlinelearning
Thank you. This made creating my chart of class so much easier. Great insturctions for a simple control chart.
These videos have been very helpful! Thank you very, very much!
This was very helpful, thank you so much! You explain it much better than my teacher did haha
Very useful...thanks for sharing
Excellent! Just did a Control Chart using this.
This was great. Easy to follow and right to the point. How could someone dislike this? Idiot.
thnx a lot man.. u're a life saver and i completed my project because of uhh! :)
Here to thank you for this helpful and easy to understand video :-)
Thank u very much ..Really u r a good teacher
easily understandable steps, good explanations
very helpful video.very clear and to the point
Thanks Eugene.Your video is very useful, I can use it in my profession.Thanks.God bless!
Very useful the way you have explained. Good job. We need more of these for complex usage of excel and QI macro
this video was so helpful and easy to follow. thank you!
Thank you so much! Excellent, to the point and easy to follow.
Just the job. Easy to understand and replicate afterwards
You can hit F4 when selecting a cell to absolute it, that way you wont have to go back to edit it and insert the $ sign.
Awesome, thanks for this simple and helpful information
I never post but this was extremely helpful and I wanted to thank you very much!!
Thank you very much. This video is a great help.
Thank you so very much for this!Exactly what I needed, very clear and simple instructions.
you are very good teacher,god bless you,
it helped me a lot ,good work keep it up
once again thank you
Great video.I totally understand it now:)
Eugene thanks so much you are a star
Your videos are awesome. Thank you for this , i was trying to learn control charts , this video helped a lot ...
Thanks again.
Thanks, this video helped me with a business ops class.
Awesome it really helps !!! Thanks a ton.
It was indeed very useful. Thank you..
Thanks again Eugene, great video keep them coming!
THANK YOU!!!!! WELL DONE!
Great video explaining everything. Thank you so much!!
Nicely done. Happy Easter
That was useful to me. Thanks!
awesome, useful...n very easy to understand.. thank you :)
Great video. Pedagogy on point, sir!
Thanks prof. it helped a lot mate ...
Thanks a lot!! Very useful!!
Very helpful, thanks!
Control limits are conventionally placed at +/ -3 standard deviations Dr. Shewhart originally proposed it. There is no problem with that. The problem is with the formula you are using to calculate standard deviation. What we need is an estimate of the standard deviation using average range, not the sample standard deviation. Please refer to Wheeler and Chambers book Understanding SPC (3rd edition) page 59. Other wise the control limits will be inflated, in this case by 455%.
I'm learning this, and noticed he did it different. Is it the difference between calculating the UCL and LCL using the +/- 3* stand deviation method, versus making moving range data and taking the 3* the MR mean then dividing by the d2 constant?
Thank you, great video.
Hi Terry,
My 30 sample measures are not means. If each sample measure was a mean value, then you would have to consider the average range within each mean before calculating the Standard Deviation.
If your data points are mean values, then you need to consider the average range as Robin Francis points out below. If you need more information on this, search for "A User’s Guide to SPC" By David Howard - the calculations are outlined in the Appendix.
Dr E.
Hi Robin,
Many thanks for the suggested article by Wheeler - indeed he does point out that using three Std Devs is "wrong" and that it is "nothing more than another way to lie with statistics". I see also in the article's comments that there is some debate about this.
I simply used Excel to show what other authors (cited above) have done. Allow me to check with my Mathematics colleagues before updating or removing this video as I am not expert in this area.
Eugene
Thanks for this very useful video
Very good and way to understand
This was very useful, thanks for taking the time out to make it :)
That was very helpful and useful. Thank you so much sir!
Thanks sir it's very useful ❤️❤️❤️
you are just amaizing sir thank you
Thank you for this! This helps me a lot in my analytics
Excellent video very well explained. Thank You.
Thanks for you useful tips
Thank you! Incredibly helpful!
Thank you so much. Very useful. BTW This works fine in LibreOffice Calc as well (except for the auto copy)
Thanks Eugene. Very helpful indeed.
Thank you! you helped me very much!!
Loved it!
This was a great tutorial, thank you.