View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] pkaraffa@gmail.com is offline
external usenet poster
 
Posts: 35
Default How many Standard Deviations above and below the mean each number is.

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