Chauncey Farrell -
How do I calculate the Z scores for a group of values. The Z score is a
plus or minus deviation by std. Dev form the mean. <
Assuming data in A1 through A30, in C1 enter =AVERAGE(A1:A30), in C2 enter
=STDEV(A1:A30). In B1 enter =(A1-$C$1)/$C$2, and copy from B1 down to B30
(e.g., by double-clicking the fill handle in B1).
Or, after calculating the mean and standard deviation, use Excel's
STANDARDIZE worksheet function (with relative reference to data and absolute
references to mean and standard deviation).
- Mike Middleton,
www.usfca.edu/~middleton