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.
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😢😢
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.
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.
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, 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 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!!
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
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 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, 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 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.
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.
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.
GOD BLESS YOU LOL. I'm in Operations Management for my Master's right now and this saved me lol, THANK YOU!
Dr.Eugene,It was a brilliant class in a lucid style.Thnx for the video.It is really really helpful.
Words cannot express how much your wonderful video helped me today! Thank you!!
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
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.
Thank you!!
I cannot express how much your video helped me today!
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.
Dear Eugene O'Loughlin,
Your explanation was wonderful! Thank you very 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.
Well explained, process easy to follow, thanks a lot Eugene!
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.
Super amazing, you have saved my life. Thanks million times
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😢😢
Thanks from Canada! Simple and helpful - much appreciate, Eugene!
Absolutely the BEST video to help explain how to do this! THANK YOU!!!!
Thank you for the simplified explanation , you Make the both the understanding of the concept and the representation really interesting.
These videos have been very helpful! Thank you very, very much!
Thanks Eugene, very well explained. Managed to do my temperature monitoring control chart first time I watched your video!!
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!
Thank you very much! The clearest explanations I found online.
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 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.
Thankyou very much - I was just brushing up on control charts prior to an interview. Great help!
Amazing and Amazingly simple. Really saved my rear end on the homework I have due tonight.
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.
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
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 video really helps me in my food processing and packaging class. Thank you very much!
Thanks a bunch Eugene. Very straight forward explanation.
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
thank you very much. ur the best guru in the world
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 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
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!
thank you you saved my operations management project, couldn't find this anywhere!
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. This made creating my chart of class so much easier. Great insturctions for a simple control chart.
This was very helpful, thank you so much! You explain it much better than my teacher did haha
Here to thank you for this helpful and easy to understand video :-)
Thank u very much ..Really u r a good teacher
thnx a lot man.. u're a life saver and i completed my project because of uhh! :)
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!!
Thank you so very much for this!Exactly what I needed, very clear and simple instructions.
easily understandable steps, good explanations
this video was so helpful and easy to follow. thank you!
Thank you so much! Excellent, to the point and easy to follow.
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.
Thanks again Eugene, great video keep them coming!
Great video. Pedagogy on point, sir!
Awesome, thanks for this simple and helpful information
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?
very helpful video.very clear and to the point
Very useful...thanks for sharing
Excellent! Just did a Control Chart using this.
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.
Thanks, this video helped me with a business ops class.
This was very useful, thanks for taking the time out to make it :)
This was great. Easy to follow and right to the point. How could someone dislike this? Idiot.
Great video explaining everything. Thank you so much!!
Excellent video very well explained. Thank You.
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!
Thank you very much. This video is a great help.
Nicely done. Happy Easter
awesome, useful...n very easy to understand.. thank you :)
It was indeed very useful. Thank you..
Just the job. Easy to understand and replicate afterwards
Great video.I totally understand it now:)
Awesome it really helps !!! Thanks a ton.
That was very helpful and useful. Thank you so much sir!
Eugene thanks so much you are a star
Thank you for this! This helps me a lot in my analytics
Thanks prof. it helped a lot mate ...
THANK YOU!!!!! WELL DONE!
Thank you! Incredibly helpful!
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.
That was useful to me. Thanks!
Thanks a lot!! Very useful!!
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.
found this very useful!! thank you!
Thank you! you helped me very much!!
Thanks Eugene. Very helpful indeed.
Thank you so much. Very useful. BTW This works fine in LibreOffice Calc as well (except for the auto copy)
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.
Thanks sir it's very useful ❤️❤️❤️
Very helpful, thanks!
This was a great tutorial, thank you.
That was really cool and simple, thank you so much
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.
you are just amaizing sir thank you
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