How To... Perform a one-way ANOVA Test in Excel 2010

Learn how to use Excel to generate an ANOVA table to test if there is a significant difference (or not) between the means of three or more samples. This method uses Excel's "Analysis Toolpak" Add-In which needs to be added (how to do this is shown in the video).

[felissaarnold]

Mr. O'Loughlin I thank you so very much for doing this tutorial, you saved my grade in statistics, your instructions were very easy to follow and comprehend ! Thank you truly!

[thisisapen]

Thanks Eugene. I became ANOVA expert after watch this video.

[kylelangley]

Thanks a million! Absolutely clear and precise instruction as well as explanation. Thanks again sir!

[admarshall]

Thank you posting. I am beginner in the stats fields, but your videos are quite clear. Thanks again

[electrobalbuena]

Thank you for this video, i really learned a lot.... i hope to witness more videos with detailed explanations and procedures. More Power!

[efeosasere]

Thanks for the post. I was wondering, if the hypothesis was all the means are different, do you follow the same process?

[mufazilali]

Before applying ANOVA sir we should know data is normally distributed and homogeneity of variance can we assume both

[ruanpretorius]

Thanks, that was extremely to the point and straight forward and well prepared.

[DarkSokiX]

If you can reject the null hypothesis then hypothesis 1 is true. But how to find out if really all three sets of data's means are statistically significantly different? Thanks for the help!!

[EugeneOLoughlin]

Hi efeosaere,

Remember, the hypothesis is that the means are the same. The NULL is that at least two are different.

Dr E.

[JackalMcLemster]

What was the website where you got the F table from? I couldn't quite hear what you said, unfortunately.

[saras]

another dissertation saved by this video. thank you. 

[SukhwinderSingh-lurh]

Can you show how to proceed after anova table, means calculation of standard error and critical difference in excel? It will be very helpful.

[lauraroberts]

So much easier to understand. Thankyou

[AlokeAnand-d]

Thanks for a detail explanation. how to determine the significance level as 0.5?

[efeosasere]

Thanks Eoloughlin

I understand better now

[gazafelias]

what if the p value is more than 0.05, but Fstat is bigger than Fcritical?

[stevenheidtke]

Thank you, I'm using this in my Quality Management class.

[pinkymixology]

shhhh... just listen to the nice man's soothing voice.

[jakubii]

fantastic, very well explained. Really very helpful. Thanks