Hi, this is very helpful, as I am always trying to remember how to add them in excel. However, I am a PhD in biostatistics, and if I could recommend one tweak to your approach. If you want to truly calculate the 95 C.I. around the mean, you should calculate the lower and upper bounds and then use those cells. You can calculate the bounds by the mean+ 1.96(SE) for the upper and then mean-1.96(SE) for the lower bound. The 1.96 actually corresponds to the standardized value for a 95% CI. If you want to calculate the 90% or conversely, the 99%, then you'll need to look at a standardized reference table (z) for the appropriate confidence level. Again, I don't mean at all to nit pick your excellent work, but I just want to make sure that everyone is on the same page who sees this video!
Hi, this is very helpful, as I am always trying to remember how to add them in excel. However, I am a PhD in biostatistics, and if I could recommend one tweak to your approach. If you want to truly calculate the 95 C.I. around the mean, you should calculate the lower and upper bounds and then use those cells. You can calculate the bounds by the mean+ 1.96(SE) for the upper and then mean-1.96(SE) for the lower bound. The 1.96 actually corresponds to the standardized value for a 95% CI. If you want to calculate the 90% or conversely, the 99%, then you'll need to look at a standardized reference table (z) for the appropriate confidence level. Again, I don't mean at all to nit pick your excellent work, but I just want to make sure that everyone is on the same page who sees this video!
This was really helpful thank you so much!
Thank you very helpful, I would've died without this
Thanks so much, it’s too helpful for me
Very Helpful. Thanks a lot
your presentation is helpfull. thank you. I couldn't succeed it before... Exiting.
THANK you!!!!!!!
The chart elements page no longer has an Error Bars customization option, any suggestions?
Look for the custom option
Does this work using Office 365