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


--
bombayterror
------------------------------------------------------------------------
bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855
View this thread: http://www.excelforum.com/showthread...hreadid=498197

"bombayterror" wrote:
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().

got it. thanks a lot for the help


--
bombayterror
------------------------------------------------------------------------
bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855
View this thread: http://www.excelforum.com/showthread...hreadid=498197