How To Perform A One-Way ANOVA Test In Excel

In this video tutorial, I’m going to show you how to perform a one-way analysis of variance, or one-way ANOVA, test by using Microsoft Excel. I will show you how to perform the test and how to interpret the results.
VIDEO CHAPTERS
00:00 Intro
00:30 My example data
01:05 Install Data Analysis ToolPak
01:40 Performing One-Way ANOVA
03:12 Interpreting the results
THE ONLINE GUIDE
toptipbio.com/one-way-anova-e...
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor techsmith.z6rjha.net/c/198849...
KZbin SEO www.tubebuddy.com/SHTeach
Software (Microsoft Word 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

[@StevenBradburn]

THE ONLINE GUIDE toptipbio.com/one-way-anova-excel/

[@vlhoward6431]

I so appreciate the simplicity of your video. It took the anxiety away that I was experiencing with second guessing my results.

[@g_wartooth_5904]

This was incredibly helpful, thank you so much for providing such an effectively fast video on how to do a One-Way ANOVA test! I am currently looking at song variation in American Robins, so this was very critical to my results!

[@najwa_rusmadi4219]

OMG thank you for the video sir. you clearly explain the test in a simple way and I totally need this tutorial to complete my degree since I lost all my notes related to the ANOVA test. Again thank you so much.

[@SN-of5tu]

Amazing! It makes so much more sense now. never thought I'd get the hang of ANOVA, but here we are. Thank you for this awesome vid!

[@Tomhudnall2003]

Oh man. Thank you!!! I didn't understand the last three weeks of school work, you saved me.

[@deborahnaybor2233]

I am stuck teaching ANOVA when I haven't done it in years, and never done it Excel. This is going to make me look like a genius. Thank you!

[@kristacloud3270]

Best video out there! Absolutely love how you've simplified each part so I can understand it

[@angiepridgen1100]

THANK YOU SO MUCH!!! I only survived Statistics because of your videos. You make it so clear and easy to follow.

[@keertikamahnot]

I was struggling so bad before I saw your video! Thank you so so so much! Explained everything so well :)

[@nickfilippos3340]

I am currently working on my thesis and I found this video very helpful, because I can't run SPSS on my computer. Thanks for sharing!

[@kkrwazie]

Thanks for this! I'm going to use this tomorrow for my 3rd year science degree essay. Well explained and easy to follow. You sir, are my hero 😁

[@subahanan5093]

This video is so informative!! I learned an entire chapter of my STAT class form this video:)

[@wyattnataros1313]

You saved my business analytics final project. Can’t thank you enough 🤞🏼

[@danielskinner6514]

My g, Sick video. You saved my degree, good sir. Love You xxx

[@kieraarodgers3075]

Thank you very much! I'm dyslexic and in uni. We have been thought this stuff over and over again but I could never properly understand it. Now thanks to you it makes sense to me

[@StevenBradburn]

You're very welcome!

[@YanaLfiana]

I've been struggling for 3 weeks to understand this information and this video just saved my life...

[@morgandorsey6795]

My teacher doesnt actually teach his class so this video helped me learn the concept. Thanks a lot my man.

[@fefoilmagno]

Thank you so much, our professor is completely unable to teach us the Anova theory, but now I got it finally

[@lordsiomai]

Thank you for the very clear explanation, especially including on how to interpret it based on the null and alternative hypotheses

[@sillysocks2421]

Thank you so so much!! This is so clear! It’s explained better than my lectures!!

[@cgriff8756]

Thank you so much! I wasn’t sure how to do this for my data while making a lab report but thanks to this tutorial I was able to do it 😊

[@statisticallysignificant]

kzbin.info/www/bejne/faazkIluh8p0kNE

[@lourdesaguilar3274]

I could not find anything that would help me and I found this video, I am grateful to you ❤❤

[@josephcastaneda3457]

Very well explained! Everyone here appreciates your videos!

[@honeybunchesofoatsalmond]

the fact that you taught me WAY more than my college professors says alot about the american college system. thank you so much

[@sksksksk6453]

YOU SAVED OUR THESIS OMG THANK YOU THANK YOU THANK YOU

[@hopeokuo4204]

This video was really helpful currently doing my final year project and this video was amazing

[@anurag1691]

Thank you for this video Steve, it helped me a lot with my Research Thesis.

[@jericfoliente]

Thank you. I didn't skip ads. It is the least I can do for your channel.

[@StevenBradburn]

Thanks for the support Jeric! Appreciate it

[@user-ss8bd2sv3g]

Really clearly explained - thanks so much. Must look out for others by you.

[@recordvaliant7615]

love the content bro, very precise and concise hope your doing well, thanks for this videos

[@violaonyinye9853]

Thank you so much for this video. You made it simple and understandable.

[@Sagarikamothe]

thank you for this. helped me to get through ANOVA very easily.

[@juleslopez3342]

Thanks! This really helped me with online classes!

[@DrDianeDAddie]

Fantastic, clear and helpful explanation! Thank you very much.

[@alenah2382]

Brilliant tutorial and sum up, thank you!!!!

[@egidialylys5183]

This is a great lesson. You have saved me a lot

[@jaysontaguba]

This is very helpful for my thesis. Thank You.

[@nahravky3885]

Great video, currently doing my biology IA and this was amazingly helpful, great job!!

[@orlandodigregorio8149]

same!!!

[@dajunyuan513]

same lmao

[@richardsimon8270]

@@dajunyuan513 same lmao, but i got for p-value 2.84446E-11, anyone know what this means

[@elsachxn]

I'm doing my biology EE lol

[@belksbozagac5592]

it feels very good to know that I am not the only one struggling with ib nor be the last one :)

[@antygona-iq8ew]

Great video. Good step by step with clear explanation.

[@janitgjay3157]

this is amazing!! Love your work

[@RyanJumarPantoja]

I learned something from your simple and well detailed discussion video thanks....

[@katrinahetherington3425]

This video was so helpful. Thank you.

[@louiszhu4903]

you are a savior top tip online

[@devindiakmeemana2729]

Great video. thank you for sharing this kind of valuable tutorial with us.

[@rupeshs2812]

very easy to understand sir, thank you so much

[@susmitsen1588]

Easy to follow. Thanks for your post

[@clarapatata2692]

THIS IS SO HELPFUL OMG THANK YOU!!!

[@AP-qt7dp]

Great helpful video with a precise simple explanation! Thankyou :)

[@ellgene]

Thank you so much! This helped me a lot!

[@beawah]

I have watched all of your excel videos for an Msc Policy module on quant research methods - really well explained and very useful.

[@StevenBradburn]

Ah thanks so much. Means a lot. Glad they help

[@jacqueshollands5630]

Great explanation. Thank you very much.

[@grahamcameron2117]

Thanks! This somehow made me understand ANOVA better than both my Statistics units 😅

[@cynthiaumeh2105]

Thank you so much. You've been very helpful

[@BabesbyJanea]

This is going to cut my work into a fourth of the time. Thank you!!!

[@priyankachopra64]

Your videos are very helpful

[@ninacristelmarimon9465]

This def helped me with my stats classes

[@jazzverstorya2040]

Thank you so much, it help me on my assignment

[@user-sp1cm1vg2f]

its helps me ..tnx! a great review

[@anonymoussimp1507]

I REALLY HAVE FORGOTTEN THIS 😵‍💫 THANKS.

[@danatwork3648]

Great video with a great explanation...thanks.

[@vincesantiago1247]

Thank you sir. I get it now.

[@cesaraugustoruiz]

Thank you sir. Great video

[@jmmjvlogs]

Thank you for sharing😊

[@RICHARDBEDARD-eq1lf]

Thanks a lot now am going to analyze my Research data

[@tunahg]

This is the best video ever, thank you so much

[@StevenBradburn]

You're very welcome!

[@apuulilucky7970]

This was so educative

[@JohnOkelloh]

Fabulous. You just earned yourself another subscriber.

[@StevenBradburn]

Awesome! Welcome aboard John

[@hobobear188]

Well explained, ty

[@raniaa.m.35]

Really find it helpful videos for my work. Great thanks.

[@StevenBradburn]

Glad to help!

[@rudyvirgohilvano4983]

Thank you very much. Very helpful

[@carsongxd]

You saved me, kind sir.

[@emadahmad605]

Good Good it is wonderful... Thank you for all

[@gloriapenrod9327]

Great explanation!

[@williamsmith6148]

Thank you this was a great video

[@vinishp4878]

Great video, very well explained .....👏👏👏👏👏👏👏

[@carlakapp9656]

So helpful thankyou

[@manishsharma8497]

Nice explanation. Thank you

[@princessosifo9884]

A life saver!

[@jullianacassandrajoco8603]

Thank you for this very helpful video :-)))))))))))

[@Mael0rie]

Very much help thank you

[@debabratadutta6]

Hi Steven it was very useful. Thanks.

[@StevenBradburn]

Very welcome

[@kashishlotlikar9395]

thank this vdio helped me alot thank u for ur geniune help

[@mrtakobana188]

Thanks a lot sir!

[@mhemanth7462]

GREAT VIDEO

[@jamalabdullahi8155]

BEST VIDEO ON EARTH

[@cortezdavis3042]

Easy as heck!!

[@marcosmancilla7348]

Helpful. Thanks a lot!

[@StevenBradburn]

Glad it helped!

[@kennethjiedigal9331]

Thank you Great help 👍

[@corlahasper234]

PERFECT Thank you!!!

[@jaxonitaliano8224]

brilliant explanation

[@nasrollahrajaei4477]

I wonder how to thank you! You did uncountable for me! 🙏

[@StevenBradburn]

I like on this video? 🙏 😊

[@user-rn1xc6nk3t]

USEFUL!!

[@andreasilva6574]

Amazing video thanks

[@tjdgmlchl6305]

thank you a million!!!!!!!

[@abhishekshekhar8192]

Was helpful thanks

[@tahirhanif9669]

Excellent thank you

[@TeenaMalhotra]

Thank You, useful

[@loofuu4038]

Thank you! 🧡 I got A on my exam.😁

[@louiszhu4903]

bravo for doing this

[@originalvonster]

Thank you this was explained so much better than other videos I have seen. I have come across something called MS error do any of your videos cover this?