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.

1. Select the cell K1 and type the label Z-Scores.
2. Below Z-Scores, enter the formula = STANDARDIZE(J2,$H$2,$H$4).

Note: Remember to include the $ symbol.

3. Select the cell with the z-score calculated, K2.
4. 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.
5. Adjust the z-scores values to two (2) decimal places