I'm looking to show how many standard deviations a datapoint is above or below the mean

[mapm]

This is probably a no-brainer for most of you, but I've been working on it all day!

Lets say I have a data set in column A. In column B, I would like to show exactly how many SDs above or below the mean each datapoint is.

Example (Made up numbers, not checking accuracy of Sample SDs)

Column A (Data)___________Column B (Variance from Mean)
234____________________________ 0.32
34____________________________ -1.43
456 ____________________________ .49
255____________________________ .38
3356___________________________ 1.942
33_____________________________ -1.3
6______________________________ -2.1
3445____________________________ 2.4

 

[ravishankar]

Hi
Try B2=(A2-AVERAGE($A$2:$A$10))/STDEV(A$2:$A$10)
Drag the formula down
Ravi