Functions
STANDARDIZE
Standardize a value
Try it
When to use it
When should I use STANDARDIZE?
Use STANDARDIZE to convert a raw value to a z-score by subtracting the mean and dividing by the standard deviation, making values from different distributions directly comparable.
Used in
Syntax
STANDARDIZE(x,mean,stdev)Examples
=STANDARDIZE(96,80,6.7) // => 2.388059701492537
=STANDARDIZE(80,80,6.7) // => 0
=STANDARDIZE(70,80,6.7) // => -1.4925373134328357