How to Calculate ANOVA with Excel (Analysis of Variance)

Visual explanation of how to calculate ANOVA using Microsoft Excel. Tutorial provides step by step instructions on how to conduct an ANOVA Test using Excel. Like MyBookSucks on Facebook!…
Video Tutorial Rating: 4 / 5

Don’t forget to check out our other video tutorials or share this video with a friend.

0 votes

Loading... 4,451 views

19 responses to “How to Calculate ANOVA with Excel (Analysis of Variance)”

1. Hossein Ali Narouei Khandan says:

   21/03/2015 at 7:19 am

   Hi, I am lefty too, just the way that you explained ANOVA shows the process
   of your thoughts, I believe lefties explain thing in a very systematic way
   that is distinct from the rest.

   Reply
2. Amethyst Magee says:

   21/03/2015 at 8:12 am

   Your plea at the end: Please like me I don’t have any friends!! Haha!!!
   It’s already done! You saved my ass from a horrible skype professor. THANK
   YOU!

   Reply
3. Eduardo Ardales says:

   21/03/2015 at 8:13 am

   Thanks a lot! Very helpful indeed.

   Reply
4. Hossein Ali Narouei Khandan says:

   21/03/2015 at 8:14 am

   Thanks, Cant be explained better than this, you might be a left-handed
   though ;)

   Reply
5. Rockbobby says:

   21/03/2015 at 8:59 am

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

   Reply
6. Funmilade Akinleye says:

   21/03/2015 at 9:05 am

   I used this for a data and got a negative value for the denominator

   Reply
7. elizabeth ford says:

   21/03/2015 at 9:22 am

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

   Reply
8. Emma Stevenson says:

   21/03/2015 at 9:37 am

   ok now why are you doing each thing you need to explain why each part is
   being done for what purpose

   Reply
9. shankar shrestha says:

   21/03/2015 at 9:54 am

   so what does 22.6 says about the significant difference of the groups?
   Are they less significant or more significant?

   Reply
10. sasspagan says:

    21/03/2015 at 10:11 am

    And what, pray tell, is an F score? Totally devoid of context or
    explanation, this is meaningless.

    Reply
11. Hazwan Subli says:

    21/03/2015 at 11:00 am

    I came here to understand how people get the value, for example: (p>0.005)
    or something like that by stating they did a one-way ANOVA, instead I get
    how to calculate the F value? LMAO

    Example in a sentence like this:

    “Statistical analysis of the flexural strength data using one-way ANOVA
    revealed significant (p<0.05) differences between the test groups."

    Got this from here:
    http://europepmc.org/abstract/MED/11931138

    PLS REPLY anyone, I really NEED to understand and know HOW to really get
    this

    Reply
12. David Gonzalez says:

    21/03/2015 at 11:40 am

    Was this a One Way ANOVA or Two?

    Reply
13. Yasmin Amico says:

    21/03/2015 at 12:04 pm

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

    Reply
14. SINGH RAJESH says:

    21/03/2015 at 12:13 pm

    GREAT VIDEO

    Reply
15. francisco tuballa says:

    21/03/2015 at 12:43 pm

    Thanks a lot!

    Reply
16. KaysTealRibbon says:

    21/03/2015 at 1:21 pm

    Great video! Very helpful & understandable!

    Reply
17. pushilem says:

    21/03/2015 at 1:25 pm

    isnt the sum of the (x-mean)^2 the variance? so, can you calculate it with
    the excel function =VAR instead of going through the steps x-mean and
    (x-mean)^2 first?

    Reply
18. Channel Me says:

    21/03/2015 at 2:10 pm

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

    Reply
19. NMM2107 says:

    21/03/2015 at 2:58 pm

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

    Reply