• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

stats - can I show standard deviation on an excel 2003 graph

I have a set of data which shows as a random distribution.

Can I also show graphically the standard deviation with my data in the graph ?

using excel 2003
0
Europa MacDonald
Asked:
Europa MacDonald
  • 2
1 Solution
 
d-glitchCommented:
You can combine chart types in Excel.

For example, you could have an XY Scatter Chart for your data.
And then add three Line Charts to show the AVG , AVG+STD, and AVG-STD.

More on this topic here:   http://peltiertech.com/Excel/Charts/ComboCharts.html
0
 
d-glitchCommented:
Here is an example with some random data.

The data are displayed as an XY scatter plot with points not lines.
The AVG and STD's are displayed as line with no points.

You could initially plot all of the data as points + lines.
Then select each data series on the plot to change the chart type.
In this case, all the series use XY types.
ExEx-Stat-Graph.png
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now