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
Europa MacDonaldChief slayer of dragonsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
d-glitchConnect With a Mentor Commented:
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.