A sensor reads 72. The baseline mean is 60 and its standard deviation is 6. Express the gap on the baseline’s scale so a colleague can read its direction and size.

Enter the reading, mean and spread

Use A2 for 72, B2 for 60 and C2 for 6. Put this in D2:

=STANDARDIZE(A2,B2,C2)

The result is 2. The reading is 12 above the mean, and 12 ÷ 6 equals 2.

The reading of 72 is 12 above a mean of 60, with six units per standard deviation.

Illustrated calculation. Divide the distance from the mean by the baseline spread.

Check the direction with two nearby values

Replace the reading with 60 and expect zero. Try 54 and expect −1. Use a positive standard deviation from the same reference group as the mean. A zero spread cannot give a standardized distance.

A reading of 54 gives −1, while 60 gives zero.

Illustrated sign check. Keep the original readings next to the standardized output.

Label the output Standard deviations from baseline and keep the baseline period visible. A percentile would require information about the distribution beyond these three values.

Microsoft’s Excel function reference