these excel demonstrations have been live savers not only for this course but also my other classes. Ive been able to use these excel guides in my labs and it has been super helpful!
these videos are literally so helpful with the assignments so I can come back and see the step by steps with excel. I can kind of say that excel isn't the most daunting thing in the world to me anymore and I can definitely thank you and this class for that!
Thank you for walking us through how to use excel step by step. It gives a better understanding how excel helps by analyzing data and visualize uncertainty.
I like how you went back into the graph and made the change to the y axis because sometimes graphs aren't very clear and they can be deceiving from what you're actually trying to get across.
Thank you for this video! It really helps with our assignments because you show step-by-step examples in Excel and explain the definition of everything.
These excel videos have been great to do the worksheets with as I go through the video, and I feel like I am learning how to get excel to do a lot of the hard work for me!
I always look forward to the excel video especially if we have homework pertaining to excel. Just because it really helps me with the steps because excel can get confusing at times.
Having a bit of background in knowing what the mean, means helps a lot. haha Thank you for explaining in great detail! Downloading and following along with you is so helpful!
It is quite interesting to look at how you calculate the SEM on a calculator and the difference in calculating it on an excel worksheet. At first, it looked kind of intimidating to look at such a big sample size and trying to calculate the SEM but you made it easier to understand and being able to calculate it.
Thank you for another helpful video about using excel! These have been so great for guidance with the worksheets. I feel like I'm getting better at using excel just from these videos
Dr. Goodin, It is so interesting to see you with a beard (haha). As always these videos come in handy and I am grestiful to have these how to videos as a resource.
hello, when I click on "more error bar options", the window "format error bars" doesn't appear ! Can you please tell me what to do in this case ? thank you
Hi Elizabeth. thanks for watching the video! Sorry that didn't work for you. You might try this tutorial which uses the PC version: www.teachucomp.com/format-error-bars-in-charts-in-excel-instructions/
1.96 is used because the 95% confidence interval has only 2.5% on each side. The probability for a z score below −1.96 is 2.5%, and is the same for a z score above +1.96. Adding 2.5% and 2.5% together is 5%. 1.64 would be correct for a 90% confidence interval, as the two sides (5% each instead of 2.5% and 2.5%) add up to 10%. Does that help Austin? Great job in class today BTW!
It’s surprising to me that the standard error of the mean can help you calculate a 95% confidence interval of the mean since this is a representation and not the whole population.
I really appreciated how detailed this was in explaining how to use excel because it is so confusing to try and figure it out without these videos.
these excel demonstrations have been live savers not only for this course but also my other classes. Ive been able to use these excel guides in my labs and it has been super helpful!
coming back to these videos makes it so much easier to complete our assignments!
Your intro never gets old!
these videos are literally so helpful with the assignments so I can come back and see the step by steps with excel. I can kind of say that excel isn't the most daunting thing in the world to me anymore and I can definitely thank you and this class for that!
These videos are always perfect for helping me become more proficient in Excel.
Excel keeps making my life easier. Thank you for demonstrating how to use these functions.
Thank you for walking us through how to use excel step by step. It gives a better understanding how excel helps by analyzing data and visualize uncertainty.
These Excel videos are lifesavers!
All of your videos have been very easy to understand. They make tough subjects look simple!
In my 6 weeks in this class i have gained so much knowledge about excel and how to utilize it to solve multiple problems.
I always love the breakdown of how to incorporate excel into our calculations.
-Alex
I like how you went back into the graph and made the change to the y axis because sometimes graphs aren't very clear and they can be deceiving from what you're actually trying to get across.
Thank you for connecting what we are reading to how to actually do it in Excel. These videos are so helpful.
I'm glad we have such an in depth video to help walk us through these problems on our worksheets! super helpful!
If it wasn't for your helpful videos excel would definitely my biggest enemy but you make it so much more easy. Thank you!
Thank you for this video! It really helps with our assignments because you show step-by-step examples in Excel and explain the definition of everything.
Dr. Goodin, these excel tutorials are always helpful and at a good pace to follow along when attempting to do it myself.
I'm learning so much about excel through these videos, thank you for making them!
These excel videos have been great to do the worksheets with as I go through the video, and I feel like I am learning how to get excel to do a lot of the hard work for me!
It is very helpful to know how to do all of these calculations in Excel as it could possibly save lots of time. Thank you!
These videos are so helpful! My Excel worksheets look so much cleaner now that I can use these videos for guidance.
Learning more and more shortcuts for excel will be super helpful
Great video, I like how you always go step by step on these excel videos.
These excel videos are the bomb! They seriously help so much
I always look forward to the excel video especially if we have homework pertaining to excel. Just because it really helps me with the steps because excel can get confusing at times.
Having a bit of background in knowing what the mean, means helps a lot. haha Thank you for explaining in great detail! Downloading and following along with you is so helpful!
These videos are so helpful! I'm learning so much about Excel and am so thankful for these walk-throughs of the software.
In this video, I learned how to find the standard error of the mean in excel.
Will definitely be looking back on this video when doing my assignment, thanks for the tutorial
I like how you show us step by step every week. It is extremely helpful!
I’ve said it before but it really is so much easier to use excel and the abilities of excel constantly surprise me
Thank you for showing us this. It truly helps when we do our problems !
It is quite interesting to look at how you calculate the SEM on a calculator and the difference in calculating it on an excel worksheet. At first, it looked kind of intimidating to look at such a big sample size and trying to calculate the SEM but you made it easier to understand and being able to calculate it.
These videos are so helpful in helping me learn Excel. Thank you!
Thank you for another helpful video about using excel! These have been so great for guidance with the worksheets. I feel like I'm getting better at using excel just from these videos
Thank you for helping me expand my knowledge on excel. These will come very handy for the lab in the future. Thank you for sharing!
These excel demonstrations are very helpful and I'm thankful that you make these for us!
Im finally able to understand how to calculate the standard error of the mean.
Thanks for making another great video! really helpful with this week's worksheet
Thanks for another very informative video on working with excel Doc!
these videos are always so helpful thank you!
This is awesome for S&C coaches when needing to calculate a large set of data. Having hundreds of athletes for years can certainly get confusing.
Your videos on excel are incredibly helpful and will continue to be helpful even outside of this class. Thank you!
This was very helpful! Thank you!
The standard error of the mean makes more sense now!
I feel like sample errors are very common in testing so very helpful to make sense of populations and how account for skewness.
When adjusting the axis, is there a general rule of thumb on how to adjust it?
Dr. Goodin,
It is so interesting to see you with a beard (haha). As always these videos come in handy and I am grestiful to have these how to videos as a resource.
hello,
when I click on "more error bar options", the window "format error bars" doesn't appear ! Can you please tell me what to do in this case ?
thank you
Hi Elizabeth. thanks for watching the video! Sorry that didn't work for you. You might try this tutorial which uses the PC version: www.teachucomp.com/format-error-bars-in-charts-in-excel-instructions/
How'd did you get 1.96 again?
1.96 is used because the 95% confidence interval has only 2.5% on each side. The probability for a z score below −1.96 is 2.5%, and is the same for a z score above +1.96. Adding 2.5% and 2.5% together is 5%. 1.64 would be correct for a 90% confidence interval, as the two sides (5% each instead of 2.5% and 2.5%) add up to 10%. Does that help Austin? Great job in class today BTW!
It’s surprising to me that the standard error of the mean can help you calculate a 95% confidence interval of the mean since this is a representation and not the whole population.