In this video, I discuss how to calculate a z-score and why it can be so valuable in sports science. I'll show you multiple different ways to calculate it, including a simple but invaluable trick in Microsoft Excel!
Thank you to today's sponsor Action Apps. Check out more information on their website: https://actionapps.co.uk/
CHAPTERS
00:00 Why is a z-score so useful?
01:14 Standard Normal Distribution
02:17 How to calculate a z-score
02:45 Excel method 1
04:05 Excel method 2
04:32 Excel method 3
08:29 Today's sponsor: Action Apps
08:53 Excel method 4
10:58 Using rolling averages over time
12:37 Using z-scores in data visualisation
Thanks for the video Jo - really helpful. Just wondering in the rolling average segment should we use STDEVP (or STDEV.P) as opposed to STDEV (or STDEV.S) as we have the full data for the individual for that timeframe? Thanks :)