Standard deviation
 

I need to chart standard deviation in my worksheet. There needs to be 3
times the standard deviation (positive and negative) Is the average added to
these two values
to be correct thanks in advance.

Standard deviation
 

This show how to add the lines
http://peltiertech.com/Excel/Charts/...orzSeries.html

You need three lines
=Average(rng)+3*stdev(rng)
=Average(rng)
=Average(rng)-3*stdev(rng)

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"patiencescientist" wrote in
message ...
I need to chart standard deviation in my worksheet. There needs to be 3
times the standard deviation (positive and negative) Is the average added
to
these two values
to be correct thanks in advance.

Standard deviation
 

What is correct depends on what you are trying to show.
--
David Biddulph

"patiencescientist" wrote in
message ...
I need to chart standard deviation in my worksheet. There needs to be 3
times the standard deviation (positive and negative) Is the average added
to
these two values
to be correct thanks in advance.