Calculate Standard Error of the Mean, Custom Error Bars, and 95% Confidence Intervals in Excel

Channel	Publish Date	Thumbnail & View Count	Actions
	Publish Date not found	0 Views	View on YouTube Channel URL not found

Two important statistical calculations are standard error of the mean (SEM), and confidence intervals (CI) at various levels of confidence, such as 90%, 95%, or 99%. In this video I’ll show you how to calculate these in excel. 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:05 – Standard Deviation
02:03 – Standard Error of the Mean
03:35 – 95% Confidence Interval
05:10 – Graphing Data w/ Error Bar
07:39 – Where to Head Next

RESOURCES MENTIONED
Weir, J. P., & Vincent, W. J. (2020). Statistics in kinesiology. Human Kinetics Publishers.
https://amzn.to/3i5zyCT

#statistics #confidenceintervals #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.