How to Calculate ANOVA with Excel (Analysis of Variance)

แชร์
ฝัง
  • เผยแพร่เมื่อ 17 ม.ค. 2025

ความคิดเห็น • 297

  • @Aleanor55
    @Aleanor55 12 ปีที่แล้ว

    I have watched dozens of videos and read the reading assignments but none have compared to the simple and accurate way you explain stats information. You truly have a gift for taking a complicated subject and making it understandable.

  • @jayrum7303
    @jayrum7303 ปีที่แล้ว +2

    Adding an extra minute to your video and showing how to obtain the Fcrit value from the table and comparing it to the calculated Fstat for hypotheses testing would have been the cherry on top of a stellar effort:)

  • @statisticsfun
    @statisticsfun  12 ปีที่แล้ว +14

    I use a lot of different tools including html5, photoshop, illustrator and string it all together in Final Cut Pro. As you can imagine it takes me a lot of time to create each video.

  • @statisticsfun
    @statisticsfun  12 ปีที่แล้ว +1

    Wow, thank you so much for the feedback. I really appreciate it! This has been my life's work. I hope you tell your friends and classmates to and help me ease their pain.

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    I like that - King of TH-cam! I do call myself the Professor of the Universe. Thanks for spreading the word and good luck in your statistics class. If you have any special requests of needs, then please let me know.

  • @timharpe6445
    @timharpe6445 11 ปีที่แล้ว

    You may have just become KING of TH-cam in my book!!! I just shared this in my Statistics class...YOU DA MAN!!!

  • @gautamhegde3763
    @gautamhegde3763 3 ปีที่แล้ว +2

    You did a better job in 15 minutes than what my stats professor did in 3 hours. Thank you!

  • @NMM2107
    @NMM2107 10 ปีที่แล้ว +2

    Words could not express how happy I am to finally be able to do ANOVA calculations on Excel! Thank you ! :)

  • @belalaszlo65
    @belalaszlo65 10 ปีที่แล้ว +2

    OMG, that could NOT be more clear. Wow you've got a real talent for explaining stuff. Thanks, man.

  • @ItsGeorgeHuh
    @ItsGeorgeHuh 11 ปีที่แล้ว

    BEST VIDEO I'VE WATCHED. completely saved me from having a meltdown over my coursework stats..... Legend, sir

  • @DianaRodriguez-vh1fd
    @DianaRodriguez-vh1fd 11 ปีที่แล้ว

    Your're Awesome!! I'm from the Dominican Republic and me and all my classmates LOVE you! Biostatistics is a lot easier with you helping us!

  • @mikhayla21
    @mikhayla21 7 ปีที่แล้ว

    a tide of relief washed over me as you explained this, and i was only having a break down about doing this with 20 groups last night! THANK YOU!!

  • @statisticsfun
    @statisticsfun  12 ปีที่แล้ว

    Wow that is great to hear -- not that your professor is sick but videos helped.
    Make sure that you like MyBookSucks on FaceBook (see link in video description). This will help other students with substitute teachers find the educational videos.

  • @toriennguyen6396
    @toriennguyen6396 4 ปีที่แล้ว +2

    One of the best presentations I've ever seen! Great visuals and effective speaking skills, I wish all my professors and TAs were just as good.

  • @statisticsfun
    @statisticsfun  12 ปีที่แล้ว

    Great to hear and thanks for the positive feedback.

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    Happy to help! Most statistics books seem complicate things and they are really expensive too.

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    You are very welcome! Good luck in your classes too.

  • @JacksonReynolds
    @JacksonReynolds 8 ปีที่แล้ว

    To call this tutorial video superb would be a severe understatement. Absolutely excellent in every way!

  • @xzyeee
    @xzyeee 9 ปีที่แล้ว +1

    To say that this is an astoundingly brilliant and clear presentation of an extremely complex statistical procedure is an unprecedented understatement. You Sir are exceptional!

    • @statisticsfun
      @statisticsfun  9 ปีที่แล้ว

      xzyeee Well, thank you so much for you kind comments. They are much appreciated. Hopefully you will like, share, subscribe, If you get a chance could you please like our FB page. www.FaceBook.Com/PartyMoreStudyLess
      It will help others find the videos.

    • @xzyeee
      @xzyeee 9 ปีที่แล้ว

      statisticsfun This video helped me clarify so much. So thank you again. However, I am having a problem with a Shapiro Wilk Test for Normality. What type of data should I use with this test? Should I use the raw data, convert the raw data to percentages or convert the raw data to averages? Any advice would be a great help.

  • @MrYamaboi
    @MrYamaboi 11 ปีที่แล้ว

    You are better than any instructors I have worked with. You make it so simple to understand, I watch your lessons all the time and I have learned so much from you. Do you do any tutoring? I would love to work with you.

  • @wdialloroyster
    @wdialloroyster 12 ปีที่แล้ว

    I have been trying to figure this out all week, thank you!!! You are an awesome instructor, please post more!

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    Yes, you are right for sure and thanks for pointing that out. I do it the long way because there are still professor who require students to ANOVA the long way by hand.

  • @cu99460
    @cu99460 8 ปีที่แล้ว

    You are the best teacher I have come across for teaching this statistics stuff. Keep up the great work!

  • @heathertolbert4573
    @heathertolbert4573 10 ปีที่แล้ว

    Your video was really easy to understand and walked me through all the steps. I could not have done it without you.

  • @gaylapontius9766
    @gaylapontius9766 11 ปีที่แล้ว

    David, thank you for your help! You and your videos are life savers! I wish I had seen them earlier this semester.

  • @nebiatsentayehu5303
    @nebiatsentayehu5303 5 ปีที่แล้ว +1

    I have seen both this one and the previous hand calculation its very perfect, clear and simplified to understand, thank you so much and keep up doing such kind of illustrations.

  • @statisticsfun
    @statisticsfun  12 ปีที่แล้ว

    Happy to hear.

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    You might be right about the spreadsheet usage. I am trying to make it as simple as possible, so students can follow it easily. I try not to use any short cuts or abbreviations either. If I was doing the spreadsheet for myself I would probably do it differently.

  • @MultiSydney01
    @MultiSydney01 12 ปีที่แล้ว

    Time well spent! Videos are great! Very professional and easy to follow.

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    You can do it! That is awesome that you did not let your youthful age deter you :). Btw, I have lots of economics videos incase you have the need.

  • @FrostyInvestor
    @FrostyInvestor 7 ปีที่แล้ว

    Please don't listen to the negative comments sir, you are "not a stack of gold bars that everyone will simply love"...old mexican saying. Instead of simply saying thank you, I read that they wanted the results interpreted. It was my understanding this was simply a tutorial on how to plug in the numbers, at least that what I was here for having never used excel for calculations. Again, thank you thank you!

  • @statisticsfun
    @statisticsfun  12 ปีที่แล้ว

    Answers
    1. F Score can never be less than one. This is because you should square the difference between the observation - mean. This gets rid of any negative sign.
    2. You could use a Cohen D to measure effect (would be one way).
    On my statistics fun channel I have a video on Cohen D, I would encourage to watch. Also, I have an entire playlist on ANOVA.

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    Gayla, It could be a rounding error. If you can go to MyBookSucks FaceBook page and post a message (and attach the excel spreadsheet) and if you take a photo of the book example -- I could look at it and see if I see anything. Make sure you like MyBookSucks too.

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    Wow! Thanks so much. Btw, I am in Kansas City, USA Make sure you like MyBookSucks on FB (see link in video description). This will help others find the educational videos. Good luck to you and all your classmates too.

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    Jocelyn, I don't have any R videos now, but the videos are in the works.

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    You are very welcome.

  • @statisticsfun
    @statisticsfun  12 ปีที่แล้ว

    Wow thanks so much. Good luck on your exams and in your class to. Do let me know if you have any special requests.

  • @MultiSydney01
    @MultiSydney01 12 ปีที่แล้ว

    Great job at effectively showing us how to do these calculations and what the calculations actually mean!

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    Good question. Yes, ANOVA works on 2 or more groups.

  • @mohammedahmedjalloh531
    @mohammedahmedjalloh531 4 ปีที่แล้ว

    Sir you are amazing I rarely comment in videos but you deserve more than a comment a subscriber and like thank you again

  • @glscott3535
    @glscott3535 3 ปีที่แล้ว

    Thanks for explaining that. It's easy to hit a button and let excel do all the work, but your lessons helped me understand the process.

  • @ALEC-gi2nt
    @ALEC-gi2nt 5 ปีที่แล้ว +1

    13:12 the division at the top is wrong if I'm not mistaken. 203.3 / 2 = 101.65 it doesn't equal 101.667

  • @fredddzzz2552
    @fredddzzz2552 3 ปีที่แล้ว

    Very useful ANOVA knowledge. Your presentations are excellent!

  • @xuser_Mmhghzi3210
    @xuser_Mmhghzi3210 9 ปีที่แล้ว +5

    you just saved my life ! I nearly dropped the course

    • @statisticsfun
      @statisticsfun  9 ปีที่แล้ว

      +Mariam Ghazi Happy to be a life saver. You can do it! Don't drop the course. If you get a chance, then like, share the videos. This will help others find the videos too. (www.FaceBook.Com/partymorestudyless)

  • @MrMPAROUARE
    @MrMPAROUARE 12 ปีที่แล้ว

    It's Just Great Sir, I wish You were my Econometrics Teacher. Things looks so easy and simple, God bless you. Your videos have been so useful for me. Many Thanks

  • @tobinwazzan
    @tobinwazzan 4 ปีที่แล้ว

    Your visual method really works for me. Thank you.

  • @pmarreddy9
    @pmarreddy9 8 ปีที่แล้ว

    I just loved the way how to do ANOVA calculations !! Thank you so much. Keep up the good work

  • @Zombiewithabowtie
    @Zombiewithabowtie 10 ปีที่แล้ว +1

    I owe you a great debt of gratitude.

  • @ddemoria
    @ddemoria 8 ปีที่แล้ว

    Thank you so very much for making these videos. You have made it so much easier for me to understand what I am doing in my Statistics course! Keep them coming :)

  • @bsky5718
    @bsky5718 12 ปีที่แล้ว

    thank you so much for such a useful video, I had a big problem with this topic and now is solved. thank you once again

  • @Djonin
    @Djonin 12 ปีที่แล้ว

    my professor was sick the day we learned how to do this, and his substitute hadn't taught Statistics in 10 years.
    Thank you, kind sir.

  • @elizabethford30
    @elizabethford30 10 ปีที่แล้ว +1

    I love the way you explained this. It made things so much easier to understand. Thank you!

  • @Rockbobby
    @Rockbobby 10 ปีที่แล้ว +9

    Man, if all my professors explained this clearly I'd be in heaven

    • @statisticsfun
      @statisticsfun  10 ปีที่แล้ว +2

      Rockbobby What a great thing to say. It is much appreciated.

  • @LyricGirl505
    @LyricGirl505 11 ปีที่แล้ว

    You sir, just helped me pass an important statistics activity in my AP Bio class. For this I am thankful. ~Sincerely, grateful stressed-out AP Bio student. P.S. YOU ARE AMAZING!

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    They are very similar tests and try to measure the same thing. The problem with t test is it can only be used on a max of two groups or samples while ANOVA can be used on two or more samples. Some people don't bother with t tests at all and only use ANOVA. Make sense?

  • @timharpe6445
    @timharpe6445 11 ปีที่แล้ว

    I guarantee I'll be USING you for the next 3 1/2 weeks, originally I was hoping to survive Bus Stats, I am now going for the A!!!

  • @gaylapontius9766
    @gaylapontius9766 11 ปีที่แล้ว

    I am SO thankful for your videos! They have been so helpful. I do have a question though about an ANOVA from my book that I plugged into the spreadsheet I built from your tutorial. My sum of squares within is not matching the book and I cannot figure out why. The book is showing that it is one less than what I am coming up with. Up until that point and my F-score everything is working out.

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    Manel, I am not positive but you could use ANOVA or a t test. If you want you can post a message on the MyBookSucks FB page (see link in this video description) and include an attachment and more detail.

  • @xWHOABAyBiEx
    @xWHOABAyBiEx 9 ปีที่แล้ว

    Life saver! Helped me pass this section on my exam! Thanks

    • @statisticsfun
      @statisticsfun  9 ปีที่แล้ว

      Jennifer Flores You are very welcome. Great to hear you passed your exam. Hopefully, you will like, share and subscribe. It will help others find the videos.

  • @kinankaghosh5196
    @kinankaghosh5196 8 ปีที่แล้ว +16

    How does one interpret the F value?
    How does one obtain the probability value?

  • @acissejelocin
    @acissejelocin 10 ปีที่แล้ว +5

    Thank you so much! This helps me with my research project tremendously.

  • @jenniferreyesseward6297
    @jenniferreyesseward6297 11 ปีที่แล้ว

    Thanks for the step by step process, really helped a lot!

  • @slsmithoh031
    @slsmithoh031 11 ปีที่แล้ว

    Thank you for making this simple and clear, my book complicates everything!

  • @YasminAmico
    @YasminAmico 10 ปีที่แล้ว

    Great step by step directions! Now, I get it. Thanks.

    • @statisticsfun
      @statisticsfun  10 ปีที่แล้ว

      Yasmin Amico You are very welcome. I am always happy to hear my videos are helping. Good luck in your studies too.

    • @YasminAmico
      @YasminAmico 10 ปีที่แล้ว

      Thank you.

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    Estefany, how many variables are you using for your mixed design? One factor or more than one factor?

  • @joshuamccormick3151
    @joshuamccormick3151 11 หลายเดือนก่อน

    I understand this a lot better than how my stats professor is teaching it. Thank you for breaking it down

  • @manmustbecrazy
    @manmustbecrazy 11 ปีที่แล้ว

    I appreciate your effort. Very informative and easy !!

  • @channelme473
    @channelme473 10 ปีที่แล้ว +1

    Brilliant :) , Thank you so much, needed to get my head around this in a hurry, perfect and brilliantly taught!!

  • @angelicabarrett3852
    @angelicabarrett3852 5 ปีที่แล้ว

    This was super helpful. Thank you for making this video!

  • @land9
    @land9 8 ปีที่แล้ว

    Brilliant video, thanks for explaining it so easily.

  • @nolanwilliams3515
    @nolanwilliams3515 10 ปีที่แล้ว

    Excellent tutorial. Thank you for taking the time to train.

  • @namirak1
    @namirak1 12 ปีที่แล้ว

    Really really clear and helpful!

  • @ruhamasidqy6005
    @ruhamasidqy6005 5 ปีที่แล้ว

    this video is much much better than my lecture explanation. thanks a lot

  • @vivekanandh7691
    @vivekanandh7691 10 ปีที่แล้ว

    Am a Fan of you man. Gr8 Teaching

  • @MrEj40
    @MrEj40 10 ปีที่แล้ว

    Man this video is awesome. Great job!

  • @NoahDrums75
    @NoahDrums75 11 ปีที่แล้ว

    You're my new hero.

  • @francescosilvestro1682
    @francescosilvestro1682 4 ปีที่แล้ว

    Thanks a billion, congratulation for the explanation!

  • @fentayewendm2357
    @fentayewendm2357 11 ปีที่แล้ว +38

    It is a great tutorial....but why did not you tell us how to interpret these results?

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    Happy to be of service. Make sure you like MyBookSucks on FaceBook (see link in video description). This will help others find the educational videos.

  • @gum_naam_kalam
    @gum_naam_kalam 9 ปีที่แล้ว

    Brilliantly explained.. Is their a video for T test as well ???????

  • @statisticsfun
    @statisticsfun  12 ปีที่แล้ว

    you are very very very welcome! I always appreciate feedback because it helps me understand if I am on the right track or not. Thanks again and make sure you like MyBookSucks on Facebook (you can see the link in the video description) -- this will help others find the videos.

  • @theenergyisoff
    @theenergyisoff 10 ปีที่แล้ว

    Great video! Very helpful & understandable!

  • @Fl00xX
    @Fl00xX 10 ปีที่แล้ว +1

    Thank you very much! Saved my life over here

  • @lamouramore
    @lamouramore 11 ปีที่แล้ว

    awesome!!! if you know where I can learn something about R (computational stats) that is explained just as well as you have, please let me know.

  • @lucianaguin
    @lucianaguin 12 ปีที่แล้ว

    Thank you! This video really helped me a lot!!!

  • @galinayork69
    @galinayork69 11 ปีที่แล้ว

    Like you? Love you! Thank you so much for the demonstration!

  • @elhamkhalesi9496
    @elhamkhalesi9496 11 ปีที่แล้ว

    That was awesome, I learned in by heart. Thanks a lot

  • @shemikas
    @shemikas 2 ปีที่แล้ว

    Thank you so much for this amazing video!

  • @chankhamtengbriacheu453
    @chankhamtengbriacheu453 9 ปีที่แล้ว

    you are the best. thank you for this valuable explanation.

    • @statisticsfun
      @statisticsfun  9 ปีที่แล้ว

      +chankham tengbriacheu Thanks for that! If you get a chance, then like, share the videos. This will help others find the videos too. (www.FaceBook.Com/partymorestudyless)

  • @ashrafsalih4262
    @ashrafsalih4262 10 ปีที่แล้ว

    Very easy ,, very clear and ... very useful,, Thanks

  • @sreeharsha1488
    @sreeharsha1488 9 ปีที่แล้ว +1

    the perfect explanation i got here thank you very much sir............

    • @statisticsfun
      @statisticsfun  9 ปีที่แล้ว

      Sreeharsha nyx Thanks for that!!! Thanks for sharing the videos too.

  • @tedtdu
    @tedtdu 12 ปีที่แล้ว

    Whole world should share the video

  • @chadspears8271
    @chadspears8271 11 ปีที่แล้ว

    this has helped me so much, thanks

  • @statisticsfun
    @statisticsfun  12 ปีที่แล้ว

    You are very welcome, indeed! Hopefully you will like MyBookSucks on FB (see link in the description of this video). This will help others find the free videos.

  • @marktabangay8060
    @marktabangay8060 7 ปีที่แล้ว

    Thank you so much. Such a great help!!!!

  • @arealphoenix9897
    @arealphoenix9897 6 ปีที่แล้ว

    Thanks for this, made the data analysis section of my manuscript much easier :D

  • @pablokiger3844
    @pablokiger3844 8 ปีที่แล้ว

    Top notch!!!!!
    Congrats!

  • @statisticsfun
    @statisticsfun  11 ปีที่แล้ว

    Sometimes it will not add up to 0 because of rounding error. Does it round to some really small number?

  • @janelleanncasuyon6805
    @janelleanncasuyon6805 5 ปีที่แล้ว

    Thank you so much. It helped me a lot.

  • @jerrardliu1324
    @jerrardliu1324 4 ปีที่แล้ว

    Thank you sir! You just save my project