One-way ANOVA & Post-Hoc Analysis in Excel

In this video I'll show you how to perform a one-way analysis of variance (ANOVA) in Excel plus a method for conducting a post hoc analysis while controlling for family-wise error rate.

TIME-STAMPS
00:00 - Intro
01:00 - Data in Excel
02:33 - One-Way ANOVA
06:12 - Pairwise Comparison
08:19 - Bonferroni Adjustment
09:19 - Where to Head Next

RESOURCES MENTIONED
Weir, J. P., & Vincent, W. J. (2020). Statistics in kinesiology. Human Kinetics Publishers.

#statistics #ANOVA #DrGoodin
—

Have a great day and remember to move well, live well, and lead well.

—

MY OTHER PLAYLISTS:

—

Dr. Jacob Goodin is a professor of kinesiology at Point Loma Nazarene University (PLNU), and holds a PhD in Sport Physiology and Performance from East Tennessee State University. He has over a decade of experience as a strength and conditioning coach and sport scientist from the high school to NCAA Division I levels. In addition to his role as a professor and research mentor, Dr. Goodin directs the Athlete Monitoring Initiative at PLNU, which provides testing and monitoring services to over 200 athletes yearly as well as research opportunities for kinesiology students.

APPLY TO STUDY UNDER DR. GOODIN:

—

GEAR I USE FOR FILMING LECTURES

MY FAVORITE SPORT SCIENCE TOOLS

THE PROTEIN I RECOMMEND

THE TEXTBOOKS I TEACH FROM

—

MUSIC CREDIT

DISCLOSURE 1: Some of the links above are affiliate links, meaning, at no additional cost to you, I will earn a (small) commission if you click through and make a purchase. This helps to directly support my teaching and research efforts.

DISCLOSURE 2: All aerial footage was previously captured under recreational circumstances in compliance with the Part 107 Exception for Recreational Flyers. FAA approval was granted through the Kittyhawk app in locations requiring it. In some instances, stock footage has been used.

[JulissanJuarez]

After watching this video and the ANOVA SPSS video, I will have to use Excel better because i feel more comfortable. Thank you for a great video as always!

[aribhalla]

I appreciate how straightforward this video was about how to use Excel for post hoc analyses.

[MrAntwaun_MBA]

I was struggling in my Business Analytics II course because of ANOVA post hoc, but you cleared all my confusion up in one video. Seriously, thank you much, dude! I owe you

[JacobCampman]

Seeing ANOVA in excel made it even more simple. Thank you!

[ClaireStone-jqwg]

This was so much easier than the by hand way! so thankful for these programs!

[BrianaReynoso]

I feel so much more confident using excel thanks to your videos!

[Chasebowen]

Excel will be my go to program and before this class i has little knowledge and now i have a ton of confidence in excel.

[willhopkins]

Excel has so many features and abilities that I had no idea about. Thanks for sharing these videos!

[jhamesalbertliwanag]

THANK YOU SO MUCH DR. JACOB! THIS IS SUCH A SAVIOR!!!

[madelinehernandez]

Excel is a life saver, makes everything so much easier.

[vanessaviramontesPLNU]

Dr. Goodin,
Thank you for this awesome tutorial. best professor ever!

[miadenava]

Thank you for this video. I appreciate how you show us how to perform an ANOVA in Excel as well as SPSS. This was really helpful!

[sarahcox]

always helpful videos! love being able to walk step by step with you in the videos

[evakoutelieris]

Love how in depth all of these videos are, thank you!

[alanaguinaldo]

Thank you for walking us through this. It was extremely helpful and you made it easy to understand. Amazing job!

[ryanharris]

Thank you for making ANOVA in excel very easy to understand!

[Alana_]

Thank you the step by step video on how to analysis ANOVA in Excel. As well as including a new method for family wise error rate.

[alannabergherm]

thank you for showing us every step! I come back to these videos a lot for help during assignments!!

[AlexBCarr]

This video gives me a great source to go back and utilize for the future, great tool!
-Alex

[rochellegore]

excel seems like a lot less user friendly but because of your videos, I find myself feeling more comfortable with it than the other software at times