XBar-R Control Charts

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

Пікірлер: 278

  • @alexfranklin5458
    @alexfranklin54583 жыл бұрын

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

  • @masonbaxter243

    @masonbaxter243

    3 жыл бұрын

    nice. made me happy made me smile

  • @HearsH96

    @HearsH96

    Жыл бұрын

    Same here, I hope he is well and doing well

  • @no_one_handle_this_channel

    @no_one_handle_this_channel

    Жыл бұрын

    It's true

  • @dhanrajshetty4327
    @dhanrajshetty43278 ай бұрын

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

  • @InvaderNax
    @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!

  • @pottedplantworkshop
    @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!

  • @StraightBelizian
    @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
    @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
    @higgins7392 Жыл бұрын

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

  • @bariskaahadi4461
    @bariskaahadi44618 жыл бұрын

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

  • @toobsessed21
    @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!!

  • @brandonpoulin
    @brandonpoulin6 жыл бұрын

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

  • @Im1HappyChick
    @Im1HappyChick10 жыл бұрын

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

  • @statguy53
    @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.

  • @lhupadilha
    @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

  • @enesberk9375
    @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

    @statguy53

    5 жыл бұрын

    Thank you.

  • @R1Z3Clan
    @R1Z3Clan2 жыл бұрын

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

  • @goldenstatewarriors9418
    @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.

  • @megangardon9768
    @megangardon97683 жыл бұрын

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

  • @coopysfamily4123
    @coopysfamily41233 жыл бұрын

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

  • @danielleciccoli7194
    @danielleciccoli719410 жыл бұрын

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

  • @Ballers_updates
    @Ballers_updates Жыл бұрын

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

  • @marcusgarvey8743
    @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.

  • @carterbrock6358
    @carterbrock63583 жыл бұрын

    Jim thank you you're killing it in 2021

  • @shannentormey1020
    @shannentormey10209 жыл бұрын

    EXTREMELY helpful. Thank you so much!

  • @IsabelR3343
    @IsabelR33439 жыл бұрын

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

  • @christinagarcia1396
    @christinagarcia13962 жыл бұрын

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

  • @AbyShift
    @AbyShift3 жыл бұрын

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

  • @statguy53
    @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.

  • @Flyyyy453
    @Flyyyy4538 жыл бұрын

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

  • @pleasetredonme
    @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

    @statguy53

    6 жыл бұрын

    Thanks.

  • @statguy53
    @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

  • @rubyarellano6346
    @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.

  • @sourabhmandol2942
    @sourabhmandol294211 жыл бұрын

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

  • @juventus1201
    @juventus120110 ай бұрын

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

  • @mohsinrazvi6019
    @mohsinrazvi60193 ай бұрын

    thank you Jim, you helped a lot of people

  • @stevenkantrowitz6040
    @stevenkantrowitz60402 жыл бұрын

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

  • @sammiller391

    @sammiller391

    2 жыл бұрын

    +rep

  • @Ceusoj
    @Ceusoj4 жыл бұрын

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

  • @thepredictors899
    @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.

  • @dutchbabyface
    @dutchbabyface7 жыл бұрын

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

  • @RissaK831
    @RissaK831 Жыл бұрын

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

  • @georgesirepisios9224
    @georgesirepisios92242 жыл бұрын

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

  • @rockonwood1965
    @rockonwood196511 жыл бұрын

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

  • @xpiratebarbiex
    @xpiratebarbiex6 жыл бұрын

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

  • @andrickmarceloesparza3981
    @andrickmarceloesparza398123 күн бұрын

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

  • @bggunny6895
    @bggunny68957 жыл бұрын

    AWESOME! Easy to understand for me! Thank you!

  • @marcelcomtois81
    @marcelcomtois8111 жыл бұрын

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

  • @michellesimbajon4443
    @michellesimbajon44434 жыл бұрын

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

  • @Infiltraitor24
    @Infiltraitor2410 жыл бұрын

    Great refresher! Thanks for explaining!

  • @OldSurvivor97
    @OldSurvivor97 Жыл бұрын

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

  • @micaberga
    @micaberga7 ай бұрын

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

  • @jkb986
    @jkb9866 жыл бұрын

    My man, you are a life saver!

  • @reinia9167
    @reinia9167 Жыл бұрын

    Very helpful, Jim. Thank you for this.

  • @blee1986100
    @blee19861009 жыл бұрын

    Excellent video, thank you for sharing your knowledge.

  • @omar390z
    @omar390z9 жыл бұрын

    Thank you, sir. This tutorial was very good!

  • @longqian503
    @longqian5033 жыл бұрын

    Very helpful and clear explained. Thank you!

  • @carlaliranzo5329
    @carlaliranzo53296 жыл бұрын

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

  • @will01986
    @will0198610 жыл бұрын

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

  • @naufal7147
    @naufal71472 жыл бұрын

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

  • @charlescowart2628
    @charlescowart26285 ай бұрын

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

  • @valueatspeed
    @valueatspeed11 жыл бұрын

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

  • @statguy53
    @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.

  • @partyofjonathan
    @partyofjonathan12 жыл бұрын

    Thank you for helping me complete my XBar chart.

  • @shadowblack1048
    @shadowblack10482 жыл бұрын

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

  • @statguy53
    @statguy5312 жыл бұрын

    Thanks. Glad it was helpful.

  • @alvinnnac

    @alvinnnac

    3 жыл бұрын

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

  • @GaryHutsonVBA
    @GaryHutsonVBA10 жыл бұрын

    Cheers Jim. Great tutorial!

  • @abdullahnabil2050
    @abdullahnabil20504 жыл бұрын

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

  • @alexiskuper913
    @alexiskuper913 Жыл бұрын

    10 years later and you're still relevant Jim

  • @BlaxxShadow
    @BlaxxShadow2 жыл бұрын

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

  • @loretalesi7745
    @loretalesi77456 жыл бұрын

    Thank you so much! This was really very helpful!

  • @tanisc.1448
    @tanisc.144810 жыл бұрын

    Thank you, great way to explain!!

  • @aravindpl2090
    @aravindpl20904 жыл бұрын

    Thanks for simplifying the concept, Excellent explanation @jim Grayson

  • @blarg534
    @blarg53411 жыл бұрын

    Thanks for explaining this so clearly!

  • @chocobo236
    @chocobo23610 жыл бұрын

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

  • @statguy53
    @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

    @gauthambhavaraju

    7 жыл бұрын

    Thank you..!!

  • @thepikachu143

    @thepikachu143

    3 жыл бұрын

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

  • @ebrodg

    @ebrodg

    3 жыл бұрын

    Thanks

  • @GilThunder99
    @GilThunder996 ай бұрын

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

  • @namakusi
    @namakusi11 жыл бұрын

    Awesome job.. thank you for keeping it simple.

  • @statguy53
    @statguy5311 жыл бұрын

    A2 comes from commonly available tables and is bases on the sample size (n) of the sub group.

  • @CapitanMarv
    @CapitanMarv3 ай бұрын

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

  • @Dreambulls9

    @Dreambulls9

    3 ай бұрын

    Aight no way bruhhhhhh🙉

  • @kirkD9349
    @kirkD93497 ай бұрын

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

  • @1507Link
    @1507Link6 жыл бұрын

    Thank you so much sir! You just save my assignment

  • @anishabandhakavi8507
    @anishabandhakavi8507 Жыл бұрын

    Awesome video, thank you so much!

  • @jacoboestrada3629
    @jacoboestrada36296 жыл бұрын

    Thank you so much!! Excellent video!!

  • @yosintacs
    @yosintacs7 жыл бұрын

    Thank you so much. Very clear and helpful :)

  • @MrRanazeeshan09
    @MrRanazeeshan093 жыл бұрын

    v impressive and excellent example of understaning. much appreciated. pls share X-Bar- S chart also.

  • @tasha9650
    @tasha96504 ай бұрын

    This was really well explained

  • @NangsandGangaz
    @NangsandGangaz3 жыл бұрын

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

  • @saran9612
    @saran96127 жыл бұрын

    So, so helpful!! Thank you!!!

  • @soniq19077
    @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?

  • @elizabethfonseca7175
    @elizabethfonseca71752 жыл бұрын

    This video save me from failing! Thank you!

  • @yanning741
    @yanning7413 жыл бұрын

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

  • @TheSweatyYeti
    @TheSweatyYeti8 жыл бұрын

    Very informative. Thank you!

  • @hvnsgrl9545
    @hvnsgrl95458 жыл бұрын

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

  • @jasonwiesenthal2898
    @jasonwiesenthal28989 жыл бұрын

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

  • @statguy53

    @statguy53

    9 жыл бұрын

    Thanks.

  • @medbobo3888
    @medbobo38886 жыл бұрын

    thank you for the amazing video

  • @ken123103
    @ken12310310 жыл бұрын

    You are the man! Thanks so much!

  • @rguiouisaadia3347
    @rguiouisaadia334710 жыл бұрын

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

  • @isaiahveluz2601
    @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.

  • @marcelcomtois81
    @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?............

  • @statguy53
    @statguy533 жыл бұрын

    It is the number of observations (horizontal) for each row .. that will tell us the average of xbar and R (vertical)

  • @dimensifs
    @dimensifs4 жыл бұрын

    thank you so much sir. your video was really really helpful!

  • @meghasingh7836
    @meghasingh78369 жыл бұрын

    Great explanation !! Thanks alot

Келесі