Forum Discussion
95% Confidence Interval to Bar Graph
I am trying to add 95% confidence intervals to my bar graph in excel. I have 5 categories, each with one number (that I was told are averages) and I was given an upper and lower confidence interval f...
I tried to input the numbers directly as shown in the image SergeiBaklan , but the error bars are way off. Am I doing something wrong?
Hi Julie1 ,
But it shows correctly. Let take Q1 bar:
value = 18.28
LCI =11.69, thus it shows 18.28-11.69=6.59
UCI=27.42, error bar shows 18.28+27.42=45.70