STANDARDIZE Function Explained
The STANDARDIZE function in Microsoft Excel returns a normalized value (z-score) based on the mean and standard deviation of a supplied set of values. It takes three arguments: the value to be standardized, the mean of the supplied values, and the standard deviation of the supplied values.
STANDARDIZE Function Syntax
STANDARDIZE(x, mean, standard_dev)
- x: The value to be standardized.
- mean: The arithmetic mean of the distribution.
- standard_dev: The standard deviation of the distribution.