Assuming by "how many STDEV's above and below each number is", you mean how
many STDEV above/below the average, use
=(A1-AVERAGE($A$1:$A$20))/STDEV($A$1:$A$20)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


wrote in message
oups.com...
I have a list of numbers in A1:A20 that has a STDEV of 27.6. I need a
formula that I can copy down that will tell me how many STDEV's above
and below each number is. Thanks in advance PJ.


13
123
24
35
35
46
46
57
57
58
6
79
79
79
78
57
46
35
24
32