Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 5th 05, 06:37 AM
amg
 
Posts: n/a
Default 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?

  #2   Report Post  
Old January 5th 05, 02:38 PM
Barb Reinhardt
 
Posts: n/a
Default

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" wrote in message
...
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?



  #3   Report Post  
Old January 5th 05, 03:51 PM
John Mansfield
 
Posts: n/a
Default

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
to your liking.

----
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?

  #4   Report Post  
Old January 6th 05, 04:53 AM
Jon Peltier
 
Posts: n/a
Default

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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:39 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017