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