Displaying different ways to calculate Z-scores is very helpful to see the comparison of the athletes' performance. It makes it easier to identify how far above or below an average athlete's performance is. Thank you!
Dr. Goodin, I am learning so much from your videos on how to use excel, and it is much easier to understand when you explain every step to calculate z scores.
This is certainly applicable to those within the sports science/strength and conditioning world. Being able to present this data to an audience will be a necessity, this is awesome!
I am always intrigued by how much i did not know about how helpful excel can be when going through data of this nature. Makes results so much easier to see faster.
Dr. Goodin, I love these how to videos. It really makes online class make sense. You're the best. I share your videos with my friends at my old community college that are in a very similar course for psychology and other majors.
I really appreciated how the video was so well organized, it was super easy to follow. I also liked how you showed us the "easy" version and how it may not be necessarily super easy or a shortcut to use!
I always find it so helpful to see you do the work in excel so I can mirror what is happening because excel is so hard for me but these videos are super helpful and I often come back to them for help with assignments
Great video! This walkthrough really helped with putting together my table on excel. I also really enjoy how you use actually sport-science based data and help us understand what the scores could possible mean. Thanks!
The conditional formatting with color scales is such a cool function that makes the dat so much easier to read. As a whole this video made calculating Z-scores in excel very easy to understand!
I didn’t know that you could lock in values or formulas on Excel. That’s great to know for this class and any other time I need to use excel. Thank you for all the helpful videos!
This video really simplified something that can be extremely complicated thank you for your explanation. It was also really helpful to learn that you can lock a value.
My love for excel has been growing because of this class. There is so many numbers that can be calculated with ease on there! Thank you for showing how to calculate different Z scores and giving examples, as this will help me in the future for this class.
Cole Lewis- My group and I used Google Sheets to complete the lab. A Iot of the same features on Excel do apply on Sheets, but this video did help, thank you!
Thanks for the video! I found it interesting that you can use these types of Z scores to differentiate between different scores of different movements.
I love the way you showed us the two different ways to find out the z scores. It was nice to have those different options and seeing which one worked best for me. But I always enjoy the excel steps since sometimes it can get confusing.
I think it is amazing how you can analyze the Z-scores to understand how each athlete's performance compares to the reference group. For example, athletes with higher positive Z-scores have above-average jump heights, while those with negative Z-scores have below-average jump heights compared to the reference group. -Alex
I really appreciate your video. Very clear and straightforward. However, I have some doubts at 12:01 when you pointed out that athlete 6 had a decent sprint time because the time was about 1 standard deviation above the mean. In fact, the function is showing a green box because there is a high number above the mean, although, a high sprint time is not something you would pretend. Care must be taken when analyzing these data as a higher time can be interpreted as a positive outcome when is not.
For sprint time, should we consider that a lower score is better? So in terms of a z-score we would want to multiply our calculation by negative one, so that our lower scores are seen as better scores?
Just be careful with interpreting Z scores in terms of speed as highest negative value which is highlighted red is actually the opposite with that person probably being one of the fastest out of the sample
the more I watch these videos the more comfortable I get with Excel, Thank you!
Displaying different ways to calculate Z-scores is very helpful to see the comparison of the athletes' performance. It makes it easier to identify how far above or below an average athlete's performance is. Thank you!
Dr. Goodin, I am learning so much from your videos on how to use excel, and it is much easier to understand when you explain every step to calculate z scores.
Knowing how to calculate Z scores in Excel will save plenty of time and will prove to be valuable in the future! Thank you for teaching us!
This is certainly applicable to those within the sports science/strength and conditioning world. Being able to present this data to an audience will be a necessity, this is awesome!
I am always intrigued by how much i did not know about how helpful excel can be when going through data of this nature. Makes results so much easier to see faster.
Dr. Goodin,
I love these how to videos. It really makes online class make sense. You're the best. I share your videos with my friends at my old community college that are in a very similar course for psychology and other majors.
I really appreciate these excel tutorials. If it weren't for these, I would probably end up scrolling through hundreds of unhelpful videos on youtube.
Having a visual example of how to calculate these problems are very helpful. These videos are so easy to follow. Thank you so much!
I really appreciated how the video was so well organized, it was super easy to follow. I also liked how you showed us the "easy" version and how it may not be necessarily super easy or a shortcut to use!
I always find it so helpful to see you do the work in excel so I can mirror what is happening because excel is so hard for me but these videos are super helpful and I often come back to them for help with assignments
Excel is an extremely useful tool when taking and or using statistics. Now knowing how to use it and excel and Z-scores is so helpful!
These videos are always a lifesaver when it comes to excel. I'm still pretty new to the program but these videos help me make sense of excel.
Great video! This walkthrough really helped with putting together my table on excel. I also really enjoy how you use actually sport-science based data and help us understand what the scores could possible mean. Thanks!
The conditional formatting with color scales is such a cool function that makes the dat so much easier to read. As a whole this video made calculating Z-scores in excel very easy to understand!
These step by step excel videos are so helpful thank you!
Thank you for making it easier to use Xcel with the help of these videos!
These videos are so incredibly helpful with applying the material in Excel!
I think ive learned more about how to use excel from this class and these videos than I have in my whole life.
that makes me happy
This video really helped me grasp a full understanding of how to calculate Z-scores.
I didn’t know that you could lock in values or formulas on Excel. That’s great to know for this class and any other time I need to use excel. Thank you for all the helpful videos!
Thank you for showing us more about Excel. These videos have been so helpful!
excel really does the trick... good to know all this information to have stored in my back pocket for life and for this class! woohoo!
This video really simplified something that can be extremely complicated thank you for your explanation. It was also really helpful to learn that you can lock a value.
Dr. Goodin, the more I watch your videos the more I appreciate excel. Thank you for explaining two ways to find Z-scores.
My love for excel has been growing because of this class. There is so many numbers that can be calculated with ease on there! Thank you for showing how to calculate different Z scores and giving examples, as this will help me in the future for this class.
we love excel!! who knew how time saving it could be!?
Thx Dr Goodin. The video tutorials are very helpful when trying to guide through excel. Hopefully I can get this down with z scores
Cole Lewis- My group and I used Google Sheets to complete the lab. A Iot of the same features on Excel do apply on Sheets, but this video did help, thank you!
Very helpful video, I have enjoyed these excel videos and find them easy to follow along with.
Oh wow there are a lot of steps, but man is excel the way to go, it truly can do so many things.
This was very helpful! Ties the other video in nicely
Thanks for the video! I found it interesting that you can use these types of Z scores to differentiate between different scores of different movements.
I love the way you showed us the two different ways to find out the z scores. It was nice to have those different options and seeing which one worked best for me. But I always enjoy the excel steps since sometimes it can get confusing.
Awesome video! Its great to be able to follow along so easily. Thank you
Wow! There are a lot of steps to compare scores. Crazy!
Wow there is so much data, luckily we have excel to help us! I feel like excel has endless features.
Another great excel video, these are always very helpful
I have to comeback and rewatch these when I have assignments because they can be very helpful
It's nice to have excel as an option for calculating such large volumes of Z scores.
This video gave me a lot of options on how to calculate the Z score
these videos are so helpful and I've learned more about excel than ever!!
I think it is amazing how you can analyze the Z-scores to understand how each athlete's performance compares to the reference group. For example, athletes with higher positive Z-scores have above-average jump heights, while those with negative Z-scores have below-average jump heights compared to the reference group.
-Alex
Another super helpful video thank you!
I've been intimated by Excel since I first needed to use it and these tutorials have been making it easier to use!
You're legit a master on that excel
That's why they pay me the big bucks 😂
I liked how you included different ways to calculate z scores as well as how to interpret them.
Excel is always so confusing to me so it is really nice to have a very organized video explaining how to find z scores in the program.
It was interesting to hear how this can be applicable to sports medicine, like the example of making a well rounded athlete.
I really appreciate your video. Very clear and straightforward. However, I have some doubts at 12:01 when you pointed out that athlete 6 had a decent sprint time because the time was about 1 standard deviation above the mean. In fact, the function is showing a green box because there is a high number above the mean, although, a high sprint time is not something you would pretend. Care must be taken when analyzing these data as a higher time can be interpreted as a positive outcome when is not.
Super helpful! I think I replayed this 4 different times haha.
For sprint time, should we consider that a lower score is better? So in terms of a z-score we would want to multiply our calculation by negative one, so that our lower scores are seen as better scores?
In this video I learned two methods to find z score in excel.
Just be careful with interpreting Z scores in terms of speed as highest negative value which is highlighted red is actually the opposite with that person probably being one of the fastest out of the sample
How to fix this? I have the same problem to make a spider graph. The fastest player in the Z Score is the worst.