How do I graph confidence intervals?

G

Guest

I would like to graph my confidence intervals vertically in excel. Does
anyone know how to do this?
 
J

Jerry W. Lewis

In the absence of information from you, I will assume that you are
plotting a series of means and want to show the uncertainty in each.
Select the data series on the chart and then from the menu
Format|Selected Data Series|Y Error Bars. Click on the Display|Both
icon. Click on Custom and in the "+" and "-" fields point to a range
that contains the half widths of the confidence intervals; i.e. the
confidence interval is
xbar +/- w
so in the "+" and "-" fields point to the range that contains the w's/

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top