Standard deviations in Excel

[Guest]

Can I show different standard deviations on each chart point. Seems pretty
worhless if I can't. WHose data ever has the same SD for each mean??

 

[Barb Reinhardt]

Are your chart points averages of individual points? If you want to
display the standard deviation of the data used to define the average on the
chart, you can use the XY Chart Labeler add in by Rob Bovey.

http://www.appspro.com/Utilities/ChartLabeler.htm

If it were me, I'd probably create an X bar S type chart.

 

[Jon Peltier]

Fred -

Suppose your X data are in column A and your Y data in column B. Put the
standard deviations behind each Y value into the corresponding cell in
column C. (You can also use the X standard deviations as well).

Make the chart. Double click the series, and on the Y Error Bars tab,
click in the Custom Plus box, then select the range of StDev values in
column C, and repeat for the Custom Minus box. You could even plot
different positive and negative error bar lengths.

More on error bars:

http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______