Link to home
Start Free TrialLog in
Avatar of Europa MacDonald
Europa MacDonaldFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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
Avatar of d-glitch
d-glitch
Flag of United States of America image

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
ASKER CERTIFIED SOLUTION
Avatar of d-glitch
d-glitch
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial