Excel - STANDARDIZE Function
Description
The STANDARDIZE function returns a normalized value from a distribution characterized by mean and standard_dev.
Syntax
STANDARDIZE(x, mean, standard_dev)
Arguments
| Argument | Description | Required/Optional |
|---|---|---|
| X | The value you want to normalize. | Required |
| Mean | The arithmetic mean of the distribution. | Required |
| Standard_dev | The standard deviation of the distribution. | Required |
Notes
The equation for the normalized value is −
$$Z=\frac{X-\mu}{\sigma }$$
If standard_dev ≤ 0, STANDARDIZE returns the #NUM! error value.
If any of the supplied arguments are non-numeric, STANDARDIZE returns the #VALUE! error value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
Advertisements