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.
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.
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 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!
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.
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!!
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
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.
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
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 for explaining in details on how to creating an spc chart using an excel spread sheet. Is there a way to create a histogram with excel using the giving data? Thank you for your time.
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
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.
Thank you for creating this video! Is it appropriate to calculate the UCL using the data from your sample? I thought there were formulas that one needed to use to calculate UCL? Thank You!
Hi Eugene - Great video. Very helpful. I am having a problem though. My LCL is negative, but none of my data is negative. I'm not sure how this can happen. I have checked and rechecked my formulas and I don't see anything wrong. This of course seriously messes up my chart. Any suggestions?
+Steve Marusic Hi Steve, I can't tell what the problem is with your data. Note that the calculation for Standard Deviation can be different depending on the situation you are measuring (see comments by Robin Francis in the comments thread below). Best to check this for your data. Dr E.
+Steve Marusic If LCL calculation comes out negative LCL = 0. Because there isn't a ["machine"/ something you're measuring] that produces negative parts.
Mr. O'Loughlin, you rock! Very no-nonsense, easy-to-understand instructions. Others over-complicate the calculations. Nice work!
GOD BLESS YOU LOL. I'm in Operations Management for my Master's right now and this saved me lol, THANK YOU!
Searched the web for ages to find a simple and clear explanation. Many thanks Eugene, this is brilliant.
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.
Words cannot express how much your wonderful video helped me today! Thank you!!
i am watching this video in 2019 and i cannot tell how much helpful this data is thank you so much so grateful
Dr.Eugene,It was a brilliant class in a lucid style.Thnx for the video.It is really really helpful.
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.
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.
Thank you Belle33, glad to be of service.
Thank you!!
I cannot express how much your video helped me today!
Albeit an older program, this is an excellent review of UCL/LCL type graphs and a masterful "how-to" explanation.
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.
Well explained, process easy to follow, thanks a lot Eugene!
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!!!!
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.
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 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 Eugene, this was most helpful. My professor and text didn't do a very good job telling us how to create a control chart.
Thankyou very much - I was just brushing up on control charts prior to an interview. Great help!
These videos have been very helpful! Thank you very, very much!
Thanks from Canada! Simple and helpful - much appreciate, Eugene!
Thanks Eugene, very well explained. Managed to do my temperature monitoring control chart first time I watched your video!!
Super amazing, you have saved my life. Thanks million times
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
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 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!
Amazing and Amazingly simple. Really saved my rear end on the homework I have due tonight.
Thanks a bunch Eugene. Very straight forward explanation.
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. This made creating my chart of class so much easier. Great insturctions for a simple control chart.
this has been immensely helpful, thanks so much Mr O' Loughlin
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.
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 so much! Excellent, to the point and easy to follow.
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
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 so very much for this!Exactly what I needed, very clear and simple instructions.
Very useful the way you have explained. Good job. We need more of these for complex usage of excel and QI macro
I never post but this was extremely helpful and I wanted to thank you very much!!
thnx a lot man.. u're a life saver and i completed my project because of uhh! :)
this video was so helpful and easy to follow. thank you!
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
Thank you sir for a simple and valuable tutorial.
This was very helpful, thank you so much! You explain it much better than my teacher did haha
Your videos are awesome. Thank you for this , i was trying to learn control charts , this video helped a lot ...
Thanks again.
you are very good teacher,god bless you,
it helped me a lot ,good work keep it up
once again thank you
Thanks Eugene.Your video is very useful, I can use it in my profession.Thanks.God bless!
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.
Thanks again Eugene, great video keep them coming!
easily understandable steps, good explanations
Excellent! Just did a Control Chart using this.
thank you very much. ur the best guru in the world
Great video explaining everything. Thank you so much!!
Very useful...thanks for sharing
very helpful video.very clear and to the point
Here to thank you for this helpful and easy to understand video :-)
This was very useful, thanks for taking the time out to make it :)
Great video. Pedagogy on point, sir!
Thank u very much ..Really u r a good teacher
Awesome, thanks for this simple and helpful information
Thank you for this! This helps me a lot in my analytics
Thank you very much. This video is a great help.
Thanks, this video helped me with a business ops class.
Thank you for explaining in details on how to creating an spc chart using an excel spread sheet. Is there a way to create a histogram with excel using the giving data? Thank you for your time.
Thank you! Incredibly helpful!
Awesome it really helps !!! Thanks a ton.
That was very helpful and useful. Thank you so much sir!
This was great. Easy to follow and right to the point. How could someone dislike this? Idiot.
Just the job. Easy to understand and replicate afterwards
Great video.I totally understand it now:)
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
Eugene thanks so much you are a star
Thanks Eugene. Very helpful indeed.
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.
Excellent video very well explained. Thank You.
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.
Thank you so much for the tutorial... Do you know if there is a way to pragmatically identify the 7 run rule in excel when building a control chart?
That was really cool and simple, thank you so much
This was a great tutorial, thank you.
That was useful to me. Thanks!
Thanks prof. it helped a lot mate ...
It was indeed very useful. Thank you..
Nicely done. Happy Easter
Thank you so much. Very useful. BTW This works fine in LibreOffice Calc as well (except for the auto copy)
awesome, useful...n very easy to understand.. thank you :)
Thank you! you helped me very much!!
Thank you for creating this video! Is it appropriate to calculate the UCL using the data from your sample? I thought there were formulas that one needed to use to calculate UCL? Thank You!
Hi Eugene - Great video. Very helpful. I am having a problem though. My LCL is negative, but none of my data is negative. I'm not sure how this can happen. I have checked and rechecked my formulas and I don't see anything wrong. This of course seriously messes up my chart. Any suggestions?
+Steve Marusic
Hi Steve,
I can't tell what the problem is with your data. Note that the calculation for Standard Deviation can be different depending on the situation you are measuring (see comments by Robin Francis in the comments thread below). Best to check this for your data.
Dr E.
+Steve Marusic If LCL calculation comes out negative LCL = 0. Because there isn't a ["machine"/ something you're measuring] that produces negative parts.
THANK YOU!!!!! WELL DONE!
Thanks for this very useful video
Thanks a lot!! Very useful!!
found this very useful!! thank you!
simple and effective one thank you .
you are just amaizing sir thank you