Using Excel to make a bar graph with standard error bars

[McDreamyn_mdphd]

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!

[feriydecalskan]

your presentation is helpfull. thank you. I couldn't succeed it before... Exiting.

[matthewdonnelly]

This was really helpful thank you so much!

[napukim]

Thank you very helpful, I would've died without this

[cranjusmcballer]

The chart elements page no longer has an Error Bars customization option, any suggestions?

[priyankarajput]

Thanks so much, it’s too helpful for me