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.

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.

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.



