View original (French)

Include confidence interval in a chart (Excel 2010)

cococmoi Posted messages 181 Status Member -  
cococmoi Posted messages 181 Status Member -
Hello,
I calculated the mean and the confidence interval of a variable, and I would like to represent it on a histogram.
In "chart tools" I go to "layout" and then "error bars," but it generates automatic confidence intervals for me.

How can I represent my own confidence intervals?
Thank you for your help.

2 answers

Answer 1 / 2
tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
 
Hello,
You can choose "Custom" error bars. When this option is checked, simply enter the calculated fields in the + and - areas.
10