How To Perform A One-Way ANOVA Test In Excel

✉️ Join my newsletter

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

HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Software (Microsoft Word 365 ProPlus)

FOLLOW US

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.

[deborahnaybor]

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!

[danielskinner]

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

[nickfilippos]

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!

[sillysocks]

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

[YanaLfiana]

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

[g_wartooth_]

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!

[keertikamahnot]

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

[dyosugh]

YOU SAVED OUR THESIS OMG THANK YOU THANK YOU THANK YOU

[Tomhudnall]

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

[najwa_rusmadi]

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.

[angiepridgen]

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

[wyattnataros]

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

[engineeragm]

In fact, I love using EXCEL when it comes to Data Analysis compared to SPSS. I love your simple explanation

[honeybunchesofoatsalmond]

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

[nahravky]

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

[fefoilmagno]

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

[morgandorsey]

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

[SN-oftu]

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!

[jericfoliente]

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

[lourdesaguilar]

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