Statistical - 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

Standardize Function
advanced_excel_statistical_functions.htm
Advertisements