The Excel Standardize function returns a normalized value of a distribution that is characterized by a supplied mean and standard deviation.
The syntax of the function is:
Where the function arguments are:
| x | - | The value to be normalized. |
| mean | - | The arithmetic mean of the distribution. |
| standard_dev | - | The standard deviation of the distribution. |
The spreadsheet below shows examples of the Excel Standardize function, used to normalize three different values.
|
Formulas:
|
Results:
|
For further details and examples of the Excel Standardize function, see the Microsoft Office website.
If you get an error from the Excel Standardize Function, this is likely to be one of the following:
| #NUM! | - | Occurs if the supplied standard_dev argument is < 0. |
| #VALUE! | - | Occurs if any of the supplied arguments are non-numeric. |