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. 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: https://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. https://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: https://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): https://bit.ly/2GLzZn4 Or stop by my channel for complete teaching series on anatomy, kinesiology concepts, and sport science: https://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 – https://bit.ly/3tOJp5s Statistics in Kinesiology – http://bit.ly/2OCyAU7 Kinesiology Concepts – https://bit.ly/3mgKy1K Biomechanics Concepts – https://bit.ly/3iJzGHv Structural Kinesiology – http://bit.ly/38MuIHg At-Home Exercise Library – https://bit.ly/2DWbvGQ At-Home Follow-Along Workouts – https://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: https://bit.ly/33jA1KA PLNU Graduate Sports Performance Program: https://bit.ly/3hs8Pyi — GEAR I USE FOR FILMING LECTURES My Main Camera – https://amzn.to/38B4Vlq Back-up Camera – https://amzn.to/38BtaA0 Action Camera – https://amzn.to/2KeV7V6 Cheap Lighting Setup – https://amzn.to/38COzZG Gigantic LED Key Light – https://amzn.to/3srHxPx Shotgun Mic – https://amzn.to/2LrGmib Lav Mic – https://amzn.to/2XwiyMu Zoom H1 Recorder – https://amzn.to/3i5DELf Audio Extension Cable – https://amzn.to/3nEAEXo High Speed SD Card – https://amzn.to/35v9ADJ Dummy-Proof Drone – https://amzn.to/2LLpyCs iPad Pro (for recording slides) – https://amzn.to/2Xzoi8f MY FAVORITE SPORT SCIENCE TOOLS Velocity-Based Training Tool (GymAware) – https://bit.ly/35pvyZ6 The Force Platforms I Use (Hawkin Dynamics) – https://bit.ly/3lqqAkz Timing Gate Solution (FreeLap) – https://bit.ly/35nXKeQ Drone – https://amzn.to/2LLpyCs THE PROTEIN I RECOMMEND MyProtein – https://bit.ly/3iqlCCP (code Jacob-R4U9 for 45% off order of $30 or more) THE TEXTBOOKS I TEACH FROM Applied Biomechanics: Concepts and Connections – https://amzn.to/38EF0tc Essentials of Strength Training and Conditioning – https://amzn.to/3oGhS2W Statistics in Kinesiology – https://amzn.to/3i5zyCT Manual of Structural Kinesiology – https://amzn.to/3i6z0MZ The Sports Gene – https://amzn.to/2XzBqu6 Scientific Principles of Strength Training – https://amzn.to/38DfGUn Every Good Endeavor – https://amzn.to/3bCJQZR — MUSIC CREDIT Music for these videos provided by Epidemic Sound - https://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.