A question about Standard Deviation

[bombayterror]

I hope I am posting in the right section

I have a column of numbers and I need to find 1 standard deviation
above and 1 standard deviation below

I know how to find the normal standard deviation in excel
[STDEV(A1:A100)] but how do I go about finding the 1 above and 1 below?
Is there a forumla for this in excel?

thanks a lot guys

 

[Guest]

I know how to find the normal standard deviation in excel
[STDEV(A1:A100)] but how do I go about finding the 1 above
and 1 below? Is there a forumla for this in excel?

"Statistics is a dangerous weapon in the hands of the
unknowledgable."

1 std dev above is the arithmetic mean plus the std dev.
1 std dev below is the arithmetic mean minus the std dev.
The arithmetic mean is computed using AVERAGE().

 

[bombayterror]

got it. thanks a lot for the hel