One-way ANOVA & Post-Hoc Analysis in Excel
Вставка
- Опубліковано 23 лип 2024
- 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.
This lecture is part of a free video series covering introductory statistics in the context of kinesiology. More stats concepts and Excel, SPSS, and JASP tutorials here: bit.ly/2GOtjVf
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.
amzn.to/3i5zyCT
#statistics #ANOVA #DrGoodin
-
Whether you are a student or practitioner of human movement, sport scientist, or just need to brush up on your stats-thanks for checking out this video! It’s part of a playlist that covers introductory statistical concepts: from central tendency to ANOVA, all in the context of kinesiology and sport science. You can find that here: bit.ly/2GOtjVf
Additionally, check out my Praxis of Strength Training and Conditioning playlist where I cover major topics related to becoming a Certified Strength and Conditioning Specialist (CSCS): bit.ly/2GLzZn4
Or stop by my channel for complete teaching series on anatomy, kinesiology concepts, and sport science: bit.ly/2Rlg5kQ
Have a great day and remember to move well, live well, and lead well.
-
MY OTHER PLAYLISTS:
Praxis of Strength Training and Conditioning - bit.ly/3tOJp5s
Statistics in Kinesiology - bit.ly/2OCyAU7
Kinesiology Concepts - bit.ly/3mgKy1K
Biomechanics Concepts - bit.ly/3iJzGHv
Structural Kinesiology - bit.ly/38MuIHg
At-Home Exercise Library - bit.ly/2DWbvGQ
At-Home Follow-Along Workouts - bit.ly/3k8OQqc
-
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:
PLNU Undergraduate Kinesiology Program: bit.ly/33jA1KA
PLNU Graduate Sports Performance Program: bit.ly/3hs8Pyi
-
GEAR I USE FOR FILMING LECTURES
My Main Camera - amzn.to/38B4Vlq
Back-up Camera - amzn.to/38BtaA0
Action Camera - amzn.to/2KeV7V6
Cheap Lighting Setup - amzn.to/38COzZG
Gigantic LED Key Light - amzn.to/3srHxPx
Shotgun Mic - amzn.to/2LrGmib
Lav Mic - amzn.to/2XwiyMu
Zoom H1 Recorder - amzn.to/3i5DELf
Audio Extension Cable - amzn.to/3nEAEXo
High Speed SD Card - amzn.to/35v9ADJ
Dummy-Proof Drone - amzn.to/2LLpyCs
iPad Pro (for recording slides) - amzn.to/2Xzoi8f
MY FAVORITE SPORT SCIENCE TOOLS
Velocity-Based Training Tool (GymAware) - bit.ly/35pvyZ6
The Force Platforms I Use (Hawkin Dynamics) - bit.ly/3lqqAkz
Timing Gate Solution (FreeLap) - bit.ly/35nXKeQ
Drone - amzn.to/2LLpyCs
THE PROTEIN I RECOMMEND
MyProtein - bit.ly/3iqlCCP (code Jacob-R4U9 for 45% off order of $30 or more)
THE TEXTBOOKS I TEACH FROM
Applied Biomechanics: Concepts and Connections - amzn.to/38EF0tc
Essentials of Strength Training and Conditioning - amzn.to/3oGhS2W
Statistics in Kinesiology - amzn.to/3i5zyCT
Manual of Structural Kinesiology - amzn.to/3i6z0MZ
The Sports Gene - amzn.to/2XzBqu6
Scientific Principles of Strength Training - amzn.to/38DfGUn
Every Good Endeavor - amzn.to/3bCJQZR
-
MUSIC CREDIT
Music for these videos provided by Epidemic Sound - bit.ly/3gCNO4l
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.
Love how in depth all of these videos are, thank you!
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!
I appreciate how straightforward this video was about how to use Excel for post hoc analyses.
thank you for showing us every step! I come back to these videos a lot for help during assignments!!
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 sooooo much, dude! I owe you big!!!!!
Excel has so many features and abilities that I had no idea about. Thanks for sharing these videos!
always helpful videos! love being able to walk step by step with you in the videos
These videos are always helpful, and I defiantly come back to these videos sometimes for labs and worksheets!
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!
Seeing ANOVA in excel made it even more simple. Thank you!
Thank you for walking us through this. It was extremely helpful and you made it easy to understand. Amazing job!
This video was super helpful, followed along step by step while working through the worksheet for this week!
THANK YOU SO MUCH DR. JACOB! THIS IS SUCH A SAVIOR!!!
This was really helpful for the second problem in the group worksheet this week, thank you!
These videos are great to come back to and work with while conducting the process in excel.
Thank you so much Mr. Goodin! I learned a lot. God bless!
Dr. Goodin,
Thank you for this awesome tutorial. best professor ever!
This was so much easier than the by hand way! so thankful for these programs!
Thank you for this video! This helps me a lot with the worksheets.
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.
Dr. Goodin, this will definitely will help me in my class this week thanks for the help !
Thank you for using excell as a way to help us out. I dont use google sheets that often so this really does help out a lot.
Thank you for a great video! Really helped with the homework this week
I feel so much more confident using excel thanks to your videos!
Thank you for making ANOVA in excel very easy to understand!
This video gives me a great source to go back and utilize for the future, great tool!
-Alex
Thank you for this video! They are really helpful to follow along with when doing the assignments.
Wonderful explanation and visuals!
Thanks Dr. You are truly helpful
Thank you for this, I am finding it much easier to do my work in excel !
thank you for Dr. Goodin for helping me solve my summative test using Anova
Thank you for the helpful video, excel is easier for me so this was perfect but it is always great to see the differences compared to SPSS.
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.
It was interesting seeing the difference between SPSS and Excel. I liked how this was all on the same page but I also liked the SPSS version where it had everything together.
Congratulations from Brazil!! Very very good!
Excel is a life saver, makes everything so much easier.
Even though I have used SPSS a couple of times, I am more comfortable with excel so this video really helped.
So helpful; thank you!
This really helped me complete the homework for this week!
I left a comment on a video a couple before this asking about Excel. Thank you for demonstrating this on Excel too, as I don't have SPSS.
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
Thank you for the helpful video, excel is easier for me so this was perfect
Thanks , you earned a new sub.
Thank you! It wasn't as scary as I thought it would be.
Thanks!
Shane, thank you so much for your support!
This video showed me how to do ANOVA in excel.
Can you please do the rest of these lectures? like repeated measures ANOVA
Great video thanks!! Do you know what 'none detected' means when reporting results in research papers? For example a figure legend under a result stating: "ANOVA and Tukey post hoc test; nd, none detected".
Gracias por colocar la traducción!!
Thank you very helpful except could not understand the last formula
I seem not to be able to find the link to the excel sheet. I wanted to follow along
I am unable to locate XLS in description as mentioned at the start of video
1. I dig the beard 2. this video is going to help me with my group worksheet!!
Hi, what is the conclusion here? Can we know which group generates more force?
Really struggled to figure out the ANOVA on excel before this video
cant find the file
Is post hoc analysis only done on ANOVA results with "significance difference" ?. Because here what I have is that all my ANOVA results are "no significance"
yes, can only do post-hoc analysis when there is a significant difference
What? How? Can someone please share how he filtered the sports column and numbers to a new worksheet on Excel?
What Excel formula did he use to create the new columns?
* Struggling student here
How you are telling that p value is incredibly small. What is E in p value
The "E" denotes that it is scientific notation. This wikipedia article gives a good overview on how to read it: en.wikipedia.org/wiki/Scientific_notation
Doc great work I sent you a five spot - Have a cold one on me!
Shane! Wow thank you 🙏🏽. I think I will do just that.
Now it doesn't look as bad on excel compared to the lecture video lol