11.6 Converting to Z-Scores
We can use STANDARDIZE(value, mean, standard_dev)
to convert any value to a z-score when the mean and standard deviation are given.
- Select the cell K1 and type the label Z-Scores.
- Below Z-Scores, enter the formula
= STANDARDIZE(J2,$H$2,$H$4)
.
Note: Remember to include the $
symbol.
- Select the cell with the z-score calculated, K2.
- Place the mouse pointer in the lower right corner of the selected cell until it becomes a
+
sign, and click-drag downward across the range that covers all the values in column J. - Adjust the z-scores values to two (2) decimal places