software

Is it possible to calculate a figure for two standard deviations for a
series of numbers? I have the output for 1 SD, but need 2 SDs.Michael -

If cell A1 has the standard deviation, e.g., =STDEV(data_range), then in
some other cell enter =2*A1.

- Mike
www.mikemiddleton.com

quot;Michaelquot; gt; wrote in message oups.com...
gt; Is it possible to calculate a figure for two standard deviations for a
gt; series of numbers? I have the output for 1 SD, but need 2 SDs.
quot;Michaelquot; wrote:
gt; Is it possible to calculate a figure for two standard
gt; deviations for a series of numbers? I have the
gt; output for 1 SD, but need 2 SDs.

=2*sd

where quot;sdquot; is the std dev constant, STDEV(range),
or reference to a cell containing quot;sdquot;.

Perhaps what you need is the data value associated
with 2sd. That would be:

=avg 2*sd
=avg - 2*sd

where quot;avgquot; is the average constant, AVERAGE(range),
or reference to a cell that containing quot;avgquot;.