Using EXCEL to create an X-Bar and R control chart
Жүктеу.....
Пікірлер: 278
@alexfranklin54583 жыл бұрын
Jim if you see this 8 years later, you are the man. This was beyond helpful
@masonbaxter243
3 жыл бұрын
nice. made me happy made me smile
@HearsH96
Жыл бұрын
Same here, I hope he is well and doing well
@no_one_handle_this_channel
Жыл бұрын
It's true
@dhanrajshetty43278 ай бұрын
Hey Jim, you are awesome. Even after 11 years your videos are still helpful.
@InvaderNax9 жыл бұрын
THANKYOU SO MUCH!! I had absolutely no idea what the hell I was doing and I still don't and yet I have two complete and complicated looking graphs that fit the description so I won't look like a total idiot to my lecturer. Thanks man!
@pottedplantworkshop2 жыл бұрын
I've been near tears trying to figure this out with no guidance in my textbook. This has saved me. Thank you very much!
@StraightBelizian10 жыл бұрын
Mr. Grayson is amazing he helped me complete my X Bar / R Bar Assignment and it looks professional and organized. He also showed me how to make models for both of them using line graphs. This made my assignment 100% easier and more precise because I did not manually complete my calculations, excel did them for me.
@user-cy4fz2mc4w Жыл бұрын
Jim, I was stuck on a question for my final, this helped me tremendously. Want to thank you and wish you all the best. Life saver.
@higgins7392 Жыл бұрын
This wraps up hours of reading and struggling in about 5 minutes that's easily understood. Thank you!
@bariskaahadi44618 жыл бұрын
this is absolutely great! I am a 4th year uni student, understood this more than I did from lecturer!!!
@toobsessed2111 жыл бұрын
Thank you so much for these videos, not only do they help me out with assignments, but they are a really good learning tool, you show the information well and I feel that I really learn a lot from them! Thanks!!
@brandonpoulin6 жыл бұрын
This video was extremely helpful. Thank you for taking the time to put it together and share.
@Im1HappyChick10 жыл бұрын
Thank you so much for the explanation on making an x-bar chart and R chart! This really helped me out! :D
@statguy5311 жыл бұрын
If something is greyed out it typically means there is an editing process happening with a cell. Make sure no cells are being edited. Then, highlight a range of cells for the chart and insert | chart | line and it should work.
@lhupadilha3 жыл бұрын
Thank you so much Jim. I am doing my Master in Project Management and your video has helped me a lot. All the best for you and take care, stay safe. God bless you :D
@enesberk93755 жыл бұрын
This is one of the best videos I've ever seen related to the topic. Thank you so much Mr. Jim. ! I admire you !
@statguy53
5 жыл бұрын
Thank you.
@R1Z3Clan2 жыл бұрын
Need more people like this on KZread just simple explanations. Thank you!
@goldenstatewarriors9418Ай бұрын
Thank you so much! This was very helpful and straightforward. Every other video I've found for this makes it super extra complicated for no reason.
@megangardon97683 жыл бұрын
Most direct way I've seen it explained. THANK YOU SO MUCH!
@coopysfamily41233 жыл бұрын
Thanks a lot, sir. Your teaching style is simple, effective, and super engaging.
@danielleciccoli719410 жыл бұрын
Most useful explanation on You Tube. Thank you very much.
@Ballers_updates Жыл бұрын
Can't explain how much you have helped me Mr. If a life, may you be added another year sir
@marcusgarvey87437 жыл бұрын
You mate are a diamond, it's currently half 6 in the morning and I've working all night, but you friend, have this day a bit brighter by not making a pointless 40 minute video. Cracking tie as well lad.
@carterbrock63583 жыл бұрын
Jim thank you you're killing it in 2021
@shannentormey10209 жыл бұрын
EXTREMELY helpful. Thank you so much!
@IsabelR33439 жыл бұрын
This is a very well explained example. Saves me a lot of time.
@christinagarcia13962 жыл бұрын
Super helpful! I just completed a final case study thanks to you!
@AbyShift3 жыл бұрын
Great and quick explanation. You saved my exam grades, thank you very much!
@statguy5311 жыл бұрын
To make a cell a fixed reference you can highlight the cell in a formula and then use the F4 key to put the $ sign in front of both the row and column reference, for example $C$4, and this would make the cell C4 a fixed reference.
@Flyyyy4538 жыл бұрын
You sir, were so very helpful! Thank you so much for this tutorial!
@pleasetredonme6 жыл бұрын
I just want to say you are a hero! Thank you so much! I was so lost when I was learning this in class... but you saved me! I wish my prof was as good as you at explaning....
@statguy53
6 жыл бұрын
Thanks.
@statguy536 жыл бұрын
We insert $ signs before a column and/or row reference to fix that reference so that when we copy a formula it always refers to that reference cell with the double dollar signs
@rubyarellano634610 жыл бұрын
Thank you for posting this video! I've had a hard time understanding during class and I had to do a search while doing my homework. This helped so much! Really appreciate it.
@sourabhmandol294211 жыл бұрын
Thank you you are a life saver! Got A+ in Industrial Engineering thanks to you!
@juventus120110 ай бұрын
Jim, thank you for this!! 11 years later and you're still bailing people out!
@mohsinrazvi60193 ай бұрын
thank you Jim, you helped a lot of people
@stevenkantrowitz60402 жыл бұрын
I just want you to know that this saved my stats grade nearly 1 decade later. Thank you Jim!
@sammiller391
2 жыл бұрын
+rep
@Ceusoj4 жыл бұрын
Thanks sir. Straight shooter getting straight to the point, nice!
@thepredictors8998 ай бұрын
Jim I was studying for my exam last minute and this video did wonders. Thank you so much. I hope everything is well with you.
@dutchbabyface7 жыл бұрын
Thank you! Wonderful step-by-step video, very helpful.
@RissaK831 Жыл бұрын
This video helped tremendously. Connected all the dots for me. Thank you!
@georgesirepisios92242 жыл бұрын
Jim, this was very helpful. Thank you very much!
@rockonwood196511 жыл бұрын
Thanks Jim. I wondered how that was done. I love your videos.
@xpiratebarbiex6 жыл бұрын
Thank you for this tutorial Sir, helped a bunch today!
@andrickmarceloesparza398123 күн бұрын
best video ive seen on this topic. Super concise and easy to understand.
@bggunny68957 жыл бұрын
AWESOME! Easy to understand for me! Thank you!
@marcelcomtois8111 жыл бұрын
Thank You for taking the time to answer............Have a good weekend!
@michellesimbajon44434 жыл бұрын
Thank you so much! This has been a lifesaver!!
@Infiltraitor2410 жыл бұрын
Great refresher! Thanks for explaining!
@OldSurvivor97 Жыл бұрын
In an online course and we barely covered this. Had no idea the formulas or anything. With in minutes this started making sense.
@micaberga7 ай бұрын
Thank you so much for your video! It helped me understand precisely the content and how to use Excel.
@jkb9866 жыл бұрын
My man, you are a life saver!
@reinia9167 Жыл бұрын
Very helpful, Jim. Thank you for this.
@blee19861009 жыл бұрын
Excellent video, thank you for sharing your knowledge.
@omar390z9 жыл бұрын
Thank you, sir. This tutorial was very good!
@longqian5033 жыл бұрын
Very helpful and clear explained. Thank you!
@carlaliranzo53296 жыл бұрын
Thank you! Very thorough explanation! THANK YOU, you helped me earn my Six Sigma!
@will0198610 жыл бұрын
Thanks a lot really helped me out and saved me a lot of time !
@naufal71472 жыл бұрын
i love the fax machine sound in background and also the smell of paper being shred
@charlescowart26285 ай бұрын
I know this is now 11 years later, but thank you!
@valueatspeed11 жыл бұрын
Brilliant explanation thank you you really helped me with my assignment.
@statguy5311 жыл бұрын
The plotted statistic is the mean (x -bar). The control limits, typically called 3 sigma control limits, are +/- 3 standard deviations of the statistic, or +/- 3 standard errors in this case from the center line. The limits can be set at any multiple of the "standard deviation" from the center line with the decision trade off of time to detect a shift versus the likelihood of a false alarm.
@partyofjonathan12 жыл бұрын
Thank you for helping me complete my XBar chart.
@shadowblack10482 жыл бұрын
Thank you very much Mr.Grayson🙏 Very helpful in my studies in 2022🙏Bless you.
@statguy5312 жыл бұрын
Thanks. Glad it was helpful.
@alvinnnac
3 жыл бұрын
it's still very helpful up in 2021:' thank you!
@GaryHutsonVBA10 жыл бұрын
Cheers Jim. Great tutorial!
@abdullahnabil20504 жыл бұрын
thank you sir, you clearly explain these 2 types of control charts
@alexiskuper913 Жыл бұрын
10 years later and you're still relevant Jim
@BlaxxShadow2 жыл бұрын
I wish you were my teacher. You walk through everything step by step. :) Ty for this.
@loretalesi77456 жыл бұрын
Thank you so much! This was really very helpful!
@tanisc.144810 жыл бұрын
Thank you, great way to explain!!
@aravindpl20904 жыл бұрын
Thanks for simplifying the concept, Excellent explanation @jim Grayson
@blarg53411 жыл бұрын
Thanks for explaining this so clearly!
@chocobo23610 жыл бұрын
Thank you for your help it help me solve a school assignment!
@statguy537 жыл бұрын
If you google "x bar r control chart constants" you can find a table. For example www.bessegato.com.br/UFJF/resources/table_of_control_chart_constants_old.pdf
@gauthambhavaraju
7 жыл бұрын
Thank you..!!
@thepikachu143
3 жыл бұрын
Please Pin this link.....Hard searching through 190+ comments
@ebrodg
3 жыл бұрын
Thanks
@GilThunder996 ай бұрын
MBA student of UCW, in canada. thank you for this video. it helped me in solving an assignment under operations management class.
@namakusi11 жыл бұрын
Awesome job.. thank you for keeping it simple.
@statguy5311 жыл бұрын
A2 comes from commonly available tables and is bases on the sample size (n) of the sub group.
@CapitanMarv3 ай бұрын
Jim you're the man! Thank you so much it was very helpful for my homework!
@Dreambulls9
3 ай бұрын
Aight no way bruhhhhhh🙉
@kirkD93497 ай бұрын
Very helpful for teaching my university class on Quality Assurance, thanks!
@1507Link6 жыл бұрын
Thank you so much sir! You just save my assignment
@anishabandhakavi8507 Жыл бұрын
Awesome video, thank you so much!
@jacoboestrada36296 жыл бұрын
Thank you so much!! Excellent video!!
@yosintacs7 жыл бұрын
Thank you so much. Very clear and helpful :)
@MrRanazeeshan093 жыл бұрын
v impressive and excellent example of understaning. much appreciated. pls share X-Bar- S chart also.
@tasha96504 ай бұрын
This was really well explained
@NangsandGangaz3 жыл бұрын
I am going to Pass my final because of you. I appreciate you
@saran96127 жыл бұрын
So, so helpful!! Thank you!!!
@soniq190774 жыл бұрын
Thanks for the video, it was very helpful. Now I have another question: how do we find the possibility of an example being between specification lines?
@elizabethfonseca71752 жыл бұрын
This video save me from failing! Thank you!
@yanning7413 жыл бұрын
thanks for posting! it really helped with my assignment :)
@TheSweatyYeti8 жыл бұрын
Very informative. Thank you!
@hvnsgrl95458 жыл бұрын
Thank you Thank you Thank you so very much for your guidance!!!!
@jasonwiesenthal28989 жыл бұрын
This is a great video. Thanks. Logged in to thumb this up and leave a comment. Rarely do that.
@statguy53
9 жыл бұрын
Thanks.
@medbobo38886 жыл бұрын
thank you for the amazing video
@ken12310310 жыл бұрын
You are the man! Thanks so much!
@rguiouisaadia334710 жыл бұрын
thank you Mr.Grayson your video helped me in my class of QHSE . thank you very much sir.
@isaiahveluz26017 жыл бұрын
Good day sir. Is there a minimum number of samples and observation in order to use the x-bar and r chart? Thank you.
@marcelcomtois8111 жыл бұрын
Thank You so much for taking the time to answer me so quickly........You're awesome! .....Then I would chart each time separately?........I'll have to look up "Individual moving Range charts" and how to set that up.......Are there constants involved with ImR charts?............
@statguy533 жыл бұрын
It is the number of observations (horizontal) for each row .. that will tell us the average of xbar and R (vertical)
@dimensifs4 жыл бұрын
thank you so much sir. your video was really really helpful!
Пікірлер: 278
Jim if you see this 8 years later, you are the man. This was beyond helpful
@masonbaxter243
3 жыл бұрын
nice. made me happy made me smile
@HearsH96
Жыл бұрын
Same here, I hope he is well and doing well
@no_one_handle_this_channel
Жыл бұрын
It's true
Hey Jim, you are awesome. Even after 11 years your videos are still helpful.
THANKYOU SO MUCH!! I had absolutely no idea what the hell I was doing and I still don't and yet I have two complete and complicated looking graphs that fit the description so I won't look like a total idiot to my lecturer. Thanks man!
I've been near tears trying to figure this out with no guidance in my textbook. This has saved me. Thank you very much!
Mr. Grayson is amazing he helped me complete my X Bar / R Bar Assignment and it looks professional and organized. He also showed me how to make models for both of them using line graphs. This made my assignment 100% easier and more precise because I did not manually complete my calculations, excel did them for me.
Jim, I was stuck on a question for my final, this helped me tremendously. Want to thank you and wish you all the best. Life saver.
This wraps up hours of reading and struggling in about 5 minutes that's easily understood. Thank you!
this is absolutely great! I am a 4th year uni student, understood this more than I did from lecturer!!!
Thank you so much for these videos, not only do they help me out with assignments, but they are a really good learning tool, you show the information well and I feel that I really learn a lot from them! Thanks!!
This video was extremely helpful. Thank you for taking the time to put it together and share.
Thank you so much for the explanation on making an x-bar chart and R chart! This really helped me out! :D
If something is greyed out it typically means there is an editing process happening with a cell. Make sure no cells are being edited. Then, highlight a range of cells for the chart and insert | chart | line and it should work.
Thank you so much Jim. I am doing my Master in Project Management and your video has helped me a lot. All the best for you and take care, stay safe. God bless you :D
This is one of the best videos I've ever seen related to the topic. Thank you so much Mr. Jim. ! I admire you !
@statguy53
5 жыл бұрын
Thank you.
Need more people like this on KZread just simple explanations. Thank you!
Thank you so much! This was very helpful and straightforward. Every other video I've found for this makes it super extra complicated for no reason.
Most direct way I've seen it explained. THANK YOU SO MUCH!
Thanks a lot, sir. Your teaching style is simple, effective, and super engaging.
Most useful explanation on You Tube. Thank you very much.
Can't explain how much you have helped me Mr. If a life, may you be added another year sir
You mate are a diamond, it's currently half 6 in the morning and I've working all night, but you friend, have this day a bit brighter by not making a pointless 40 minute video. Cracking tie as well lad.
Jim thank you you're killing it in 2021
EXTREMELY helpful. Thank you so much!
This is a very well explained example. Saves me a lot of time.
Super helpful! I just completed a final case study thanks to you!
Great and quick explanation. You saved my exam grades, thank you very much!
To make a cell a fixed reference you can highlight the cell in a formula and then use the F4 key to put the $ sign in front of both the row and column reference, for example $C$4, and this would make the cell C4 a fixed reference.
You sir, were so very helpful! Thank you so much for this tutorial!
I just want to say you are a hero! Thank you so much! I was so lost when I was learning this in class... but you saved me! I wish my prof was as good as you at explaning....
@statguy53
6 жыл бұрын
Thanks.
We insert $ signs before a column and/or row reference to fix that reference so that when we copy a formula it always refers to that reference cell with the double dollar signs
Thank you for posting this video! I've had a hard time understanding during class and I had to do a search while doing my homework. This helped so much! Really appreciate it.
Thank you you are a life saver! Got A+ in Industrial Engineering thanks to you!
Jim, thank you for this!! 11 years later and you're still bailing people out!
thank you Jim, you helped a lot of people
I just want you to know that this saved my stats grade nearly 1 decade later. Thank you Jim!
@sammiller391
2 жыл бұрын
+rep
Thanks sir. Straight shooter getting straight to the point, nice!
Jim I was studying for my exam last minute and this video did wonders. Thank you so much. I hope everything is well with you.
Thank you! Wonderful step-by-step video, very helpful.
This video helped tremendously. Connected all the dots for me. Thank you!
Jim, this was very helpful. Thank you very much!
Thanks Jim. I wondered how that was done. I love your videos.
Thank you for this tutorial Sir, helped a bunch today!
best video ive seen on this topic. Super concise and easy to understand.
AWESOME! Easy to understand for me! Thank you!
Thank You for taking the time to answer............Have a good weekend!
Thank you so much! This has been a lifesaver!!
Great refresher! Thanks for explaining!
In an online course and we barely covered this. Had no idea the formulas or anything. With in minutes this started making sense.
Thank you so much for your video! It helped me understand precisely the content and how to use Excel.
My man, you are a life saver!
Very helpful, Jim. Thank you for this.
Excellent video, thank you for sharing your knowledge.
Thank you, sir. This tutorial was very good!
Very helpful and clear explained. Thank you!
Thank you! Very thorough explanation! THANK YOU, you helped me earn my Six Sigma!
Thanks a lot really helped me out and saved me a lot of time !
i love the fax machine sound in background and also the smell of paper being shred
I know this is now 11 years later, but thank you!
Brilliant explanation thank you you really helped me with my assignment.
The plotted statistic is the mean (x -bar). The control limits, typically called 3 sigma control limits, are +/- 3 standard deviations of the statistic, or +/- 3 standard errors in this case from the center line. The limits can be set at any multiple of the "standard deviation" from the center line with the decision trade off of time to detect a shift versus the likelihood of a false alarm.
Thank you for helping me complete my XBar chart.
Thank you very much Mr.Grayson🙏 Very helpful in my studies in 2022🙏Bless you.
Thanks. Glad it was helpful.
@alvinnnac
3 жыл бұрын
it's still very helpful up in 2021:' thank you!
Cheers Jim. Great tutorial!
thank you sir, you clearly explain these 2 types of control charts
10 years later and you're still relevant Jim
I wish you were my teacher. You walk through everything step by step. :) Ty for this.
Thank you so much! This was really very helpful!
Thank you, great way to explain!!
Thanks for simplifying the concept, Excellent explanation @jim Grayson
Thanks for explaining this so clearly!
Thank you for your help it help me solve a school assignment!
If you google "x bar r control chart constants" you can find a table. For example www.bessegato.com.br/UFJF/resources/table_of_control_chart_constants_old.pdf
@gauthambhavaraju
7 жыл бұрын
Thank you..!!
@thepikachu143
3 жыл бұрын
Please Pin this link.....Hard searching through 190+ comments
@ebrodg
3 жыл бұрын
Thanks
MBA student of UCW, in canada. thank you for this video. it helped me in solving an assignment under operations management class.
Awesome job.. thank you for keeping it simple.
A2 comes from commonly available tables and is bases on the sample size (n) of the sub group.
Jim you're the man! Thank you so much it was very helpful for my homework!
@Dreambulls9
3 ай бұрын
Aight no way bruhhhhhh🙉
Very helpful for teaching my university class on Quality Assurance, thanks!
Thank you so much sir! You just save my assignment
Awesome video, thank you so much!
Thank you so much!! Excellent video!!
Thank you so much. Very clear and helpful :)
v impressive and excellent example of understaning. much appreciated. pls share X-Bar- S chart also.
This was really well explained
I am going to Pass my final because of you. I appreciate you
So, so helpful!! Thank you!!!
Thanks for the video, it was very helpful. Now I have another question: how do we find the possibility of an example being between specification lines?
This video save me from failing! Thank you!
thanks for posting! it really helped with my assignment :)
Very informative. Thank you!
Thank you Thank you Thank you so very much for your guidance!!!!
This is a great video. Thanks. Logged in to thumb this up and leave a comment. Rarely do that.
@statguy53
9 жыл бұрын
Thanks.
thank you for the amazing video
You are the man! Thanks so much!
thank you Mr.Grayson your video helped me in my class of QHSE . thank you very much sir.
Good day sir. Is there a minimum number of samples and observation in order to use the x-bar and r chart? Thank you.
Thank You so much for taking the time to answer me so quickly........You're awesome! .....Then I would chart each time separately?........I'll have to look up "Individual moving Range charts" and how to set that up.......Are there constants involved with ImR charts?............
It is the number of observations (horizontal) for each row .. that will tell us the average of xbar and R (vertical)
thank you so much sir. your video was really really helpful!
Great explanation !! Thanks alot