The Excel STANDARDIZE Function

Home » Excel-Built-In-Functions » Excel-Statistical-Functions » Excel-Standardize-Function

Search this site:

Custom Search

Basic Description

The Excel STANDARDIZE function returns a normalized value of a distribution, for a distribution characterized by a given mean and standard deviation.

The format of the function is :

STANDARDIZE( X, Mean, Standard_Dev )

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 different values.

The format of the function is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

Formulas

Results

Further information and examples of the Excel Standardize function can be found on the Microsoft Office website.

If you get the #NUM! error from your Excel Standardize function this may result from the supplied Standard_dev argument having a value < 0.

Disclaimer