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).

[@kylelangley8818]

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

[@felissaarnold3712]

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!

[@thisisapen123456]

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

[@admarshall617]

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

[@AM-xu6sd]

Now you might be master in statistics

[@saras7635]

another dissertation saved by this video. thank you.

[@ruanpretorius2679]

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

[@electrobalbuena9788]

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

[@EugeneOLoughlin]

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

[@lauraroberts7432]

So much easier to understand. Thankyou

[@efeosasere]

Thanks Eoloughlin
I understand better now

[@jakubii1]

fantastic, very well explained. Really very helpful. Thanks

[@pinkymixology4965]

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

[@stevenheidtke2049]

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

[@Entedyn]

Thank you for the straight forward aid!

[@dcggil]

Great video! Thank you it was very helpful!

[@soonbong_tv]

Thank you so much, saved my bum big time...

[@rustleelepiten6331]

thank you very clear and understandable!!

[@santhoshugc]

thank you....very useful information
...

[@dheeraj12]

Thank You, Professor.

[@Ripperman88]

very very useful! thank u so much Prof!!! :)

[@HNazariK]

thank you very much! very helpful.

[@ninjachrish]

great vid, thx for the explanation.

[@himaniarora11]

Thanks a lot

[@SukhwinderSingh-lu5rh]

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

[@garkuls]

great video

[@JackalMcLemster]

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

[@efeosasere]

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

[@mufazilali9294]

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

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

[@AlokeAnand-d]

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

[@EugeneOLoughlin]

Aloke Anand THis depends on the experiment you conducting and the data you are analyzing. 0.05 means that there is a 5% chance that your result will be an (Type I) error, in other words your result is 95% accurate. 0.05 is a normal level of significance to go for. If you need more accurate results, go for 0.01.
Dr E.

[@n.h.m.rubelmozumder8680]

nice

[@gazafelias5104]

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

[@znb5873]

How come the values are in the order of millions?

[@EugeneOLoughlin]

statsoft dot com
Thanks you for watching the video!

[@deshawnjones3306]

Please redo the video...I can barely hear even you at 100%...this is a waste of time/video.

[@beed4-acausonkamillea.376]

he talks too fast

[@EugeneOLoughlin]

:-)