XBar-R Control Charts

Using EXCEL to create an X-Bar and R control chart

[@alexfranklin5458]

Jim if you see this 8 years later, you are the man. This was beyond helpful

[@masonbaxter243]

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

[@dhanrajshetty4327]

Hey Jim, you are awesome. Even after 11 years your videos are still helpful.

[@StraightBelizian]

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.

[@InvaderNax]

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!

[@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.

[@pottedplantworkshop]

I've been near tears trying to figure this out with no guidance in my textbook. This has saved me. Thank you very much!

[@higgins7392]

This wraps up hours of reading and struggling in about 5 minutes that's easily understood. Thank you!

[@bariskaahadi4461]

this is absolutely great! I am a 4th year uni student, understood this more than I did from lecturer!!!

[@toobsessed21]

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!!

[@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.

[@Im1HappyChick]

Thank you so much for the explanation on making an x-bar chart and R chart! This really helped me out! :D

[@brandonpoulin]

This video was extremely helpful. Thank you for taking the time to put it together and share.

[@R1Z3Clan]

Need more people like this on KZbin just simple explanations. Thank you!

[@enesberk9375]

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]

Thank you.

[@danielleciccoli7194]

Most useful explanation on You Tube. Thank you very much.

[@coopysfamily4123]

Thanks a lot, sir. Your teaching style is simple, effective, and super engaging.

[@statguy53]

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.

[@lhupadilha]

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

[@statguy53]

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.

[@megangardon9768]

Most direct way I've seen it explained. THANK YOU SO MUCH!

[@carterbrock6358]

Jim thank you you're killing it in 2021

[@Ballers_updates]

Can't explain how much you have helped me Mr. If a life, may you be added another year sir

[@juventus1201]

Jim, thank you for this!! 11 years later and you're still bailing people out!

[@marcusgarvey8743]

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.

[@andrickmarceloesparza3981]

best video ive seen on this topic. Super concise and easy to understand.

[@charlescowart2628]

I know this is now 11 years later, but thank you!

[@IsabelR3343]

This is a very well explained example. Saves me a lot of time.

[@AbyShift]

Great and quick explanation. You saved my exam grades, thank you very much!

[@christinagarcia1396]

Super helpful! I just completed a final case study thanks to you!

[@mohsinrazvi6019]

thank you Jim, you helped a lot of people

[@OldSurvivor97]

In an online course and we barely covered this. Had no idea the formulas or anything. With in minutes this started making sense.

[@pleasetredonme]

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]

Thanks.

[@shannentormey1020]

EXTREMELY helpful. Thank you so much!

[@rubyarellano6346]

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.

[@Ceusoj]

Thanks sir. Straight shooter getting straight to the point, nice!

[@naufal7147]

i love the fax machine sound in background and also the smell of paper being shred

[@rockonwood1965]

Thanks Jim. I wondered how that was done. I love your videos.

[@stevenkantrowitz6040]

I just want you to know that this saved my stats grade nearly 1 decade later. Thank you Jim!

[@sammiller391]

+rep

[@sourabhmandol2942]

Thank you you are a life saver! Got A+ in Industrial Engineering thanks to you!

[@statguy53]

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]

Thank you..!!

[@thepikachu143]

Please Pin this link.....Hard searching through 190+ comments

[@ebrodg]

Thanks

[@Flyyyy453]

You sir, were so very helpful! Thank you so much for this tutorial!

[@RissaK831]

This video helped tremendously. Connected all the dots for me. Thank you!

[@statguy53]

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

[@thepredictors899]

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.

[@marcelcomtois81]

Thank You for taking the time to answer............Have a good weekend!

[@GilThunder99]

MBA student of UCW, in canada. thank you for this video. it helped me in solving an assignment under operations management class.

[@GaryHutsonVBA]

Cheers Jim. Great tutorial!

[@Infiltraitor24]

Great refresher! Thanks for explaining!

[@dutchbabyface]

Thank you! Wonderful step-by-step video, very helpful.

[@alexiskuper913]

10 years later and you're still relevant Jim

[@georgesirepisios9224]

Jim, this was very helpful. Thank you very much!

[@xpiratebarbiex]

Thank you for this tutorial Sir, helped a bunch today!

[@BlaxxShadow]

I wish you were my teacher. You walk through everything step by step. :) Ty for this.

[@bggunny6895]

AWESOME! Easy to understand for me! Thank you!

[@reinia9167]

Very helpful, Jim. Thank you for this.

[@jkb986]

My man, you are a life saver!

[@michellesimbajon4443]

Thank you so much! This has been a lifesaver!!

[@partyofjonathan]

Thank you for helping me complete my XBar chart.

[@micaberga]

Thank you so much for your video! It helped me understand precisely the content and how to use Excel.

[@shadowblack1048]

Thank you very much Mr.Grayson🙏 Very helpful in my studies in 2022🙏Bless you.

[@blee1986100]

Excellent video, thank you for sharing your knowledge.

[@statguy53]

Thanks. Glad it was helpful.

[@alvinnnac]

it's still very helpful up in 2021:' thank you!

[@longqian503]

Very helpful and clear explained. Thank you!

[@omar390z]

Thank you, sir. This tutorial was very good!

[@will01986]

Thanks a lot really helped me out and saved me a lot of time !

[@kirkD9349]

Very helpful for teaching my university class on Quality Assurance, thanks!

[@CapitanMarv]

Jim you're the man! Thank you so much it was very helpful for my homework!

[@Dreambulls9]

Aight no way bruhhhhhh🙉

[@carlaliranzo5329]

Thank you! Very thorough explanation! THANK YOU, you helped me earn my Six Sigma!

[@abdullahnabil2050]

thank you sir, you clearly explain these 2 types of control charts

[@isaiahveluz2601]

Good day sir. Is there a minimum number of samples and observation in order to use the x-bar and r chart? Thank you.

[@blarg534]

Thanks for explaining this so clearly!

[@valueatspeed]

Brilliant explanation thank you you really helped me with my assignment.

[@tanisc.1448]

Thank you, great way to explain!!

[@marialavoie3111]

Hi Jim when you make a formula for CL is =x-dblbar but just want to know you said UCF14 were can i get that?

[@namakusi]

Awesome job.. thank you for keeping it simple.

[@elizabethfonseca7175]

This video save me from failing! Thank you!

[@loretalesi7745]

Thank you so much! This was really very helpful!

[@tasha9650]

This was really well explained

[@aravindpl2090]

Thanks for simplifying the concept, Excellent explanation @jim Grayson

[@anishabandhakavi8507]

Awesome video, thank you so much!

[@chocobo236]

Thank you for your help it help me solve a school assignment!

[@soniq19077]

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?

[@marialavoie3111]

how can you get the CL i saw =X-DblBar then $20 I heard UCF 14? I cant't get the right formula? Please help me thanks

[@saran9612]

So, so helpful!! Thank you!!!

[@1507Link]

Thank you so much sir! You just save my assignment

[@mohammadhurairahhamkaazmi5779]

Sorry but if i may ask why times with 0.577 ? is that a reference no means like a reference no in which we never change it ?

[@TheSweatyYeti]

Very informative. Thank you!

[@jasonwiesenthal2898]

This is a great video. Thanks. Logged in to thumb this up and leave a comment. Rarely do that.

[@statguy53]

Thanks.

[@statguy53]

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.

[@yanning741]

thanks for posting! it really helped with my assignment :)

[@jacoboestrada3629]

Thank you so much!! Excellent video!!

[@hvnsgrl9545]

Thank you Thank you Thank you so very much for your guidance!!!!

[@NangsandGangaz]

I am going to Pass my final because of you. I appreciate you

[@yosintacs]

Thank you so much. Very clear and helpful :)

[@survivalistboards]

Great video, thank you

[@ken123103]

You are the man! Thanks so much!

[@medbobo3888]

thank you for the amazing video

[@genesiscastellanos9932]

how I obtain X- Dbbl Bar manually form in this case?

[@rguiouisaadia3347]

thank you Mr.Grayson your video helped me in my class of QHSE . thank you very much sir.

[@nicksantangelo730]

Mr. Grayson, is there any way that you can post that excel file as a tool for reference?