# how do I plot mean and standard deviation in excel

1. ## how do I plot mean and standard deviation in excel

I want to take a data series and plot the mean and standard deviation on a
bar graph. How do I do this in excel?  Register To Reply

2. ## Re: how do I plot mean and standard deviation in excel

Do you want something akin to an X bar Schart? Or do you want a graph that
shows X bar with maybe an Inner Quartile Range?

"amg" <amg@discussions.microsoft.com> wrote in message
news:4FA33F07-C472-4645-A4F8-E5E35986CAFA@microsoft.com...
> I want to take a data series and plot the mean and standard deviation on a
> bar graph. How do I do this in excel?  Register To Reply

3. ## RE: how do I plot mean and standard deviation in excel

This might describe one way to approach the creation of the chart:

Assuming your data starts in cell A1, as an example create a simple
clustered column chart based on the following data. The data range for this
example should span A1:E8.

Data Mean -1sd +1sd
A 55 44.71 34.62 54.81
B 34 44.71 34.62 54.81
C 31 44.71 34.62 54.81
D 48 44.71 34.62 54.81
E 58 44.71 34.62 54.81
F 46 44.71 34.62 54.81
G 41 44.71 34.62 54.81

The data in the column â€œDataâ€? is your original source.

The â€œMeanâ€? is calculated using the formula

=AVERAGE(\$B\$2:\$B\$8)

The â€œ-sdâ€? is calculated using the formula

=\$C2-STDEV(\$B\$2:\$B\$8)

The â€œ+sdâ€? is calculated using the formula

=\$C2+STDEV(\$B\$2:\$B\$8)

Put you curser in cell A1 and create a simple clustered column chart. After
the chart is created, you should have four columns for each Y-axis tick mark
label. Now, convert the â€œMeanâ€?, â€œ-1sdâ€?, and â€œ+1sdâ€? series to lines. To
convert each series to a line, click on one of the columns for the â€œMeanâ€?.
Right-click on your mouse -> Chart Type -> Line. Go through the same process
for the â€œ-1sdâ€? and â€œ+1sdâ€? series. Now all you have to do is format the chart

----
Regards,
John Mansfield
http://www.pdbook.com

"amg" wrote:

> I want to take a data series and plot the mean and standard deviation on a
> bar graph. How do I do this in excel?  Register To Reply

4. ## Re: how do I plot mean and standard deviation in excel

I've just posted a sample on my web site:

http://peltiertech.com/Excel/Charts/RunChtLines.html

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

amg wrote:

> I want to take a data series and plot the mean and standard deviation on a
> bar graph. How do I do this in excel?  Register To Reply