STANDARDIZE Function

Basic Description

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

Syntax: 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

 

Standardize Function Examples

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:
A
1 =STANDARDIZE( 5.5, 5, 2 )
2 =STANDARDIZE( 12, 15, 1.5 )
3 =STANDARDIZE( -2, 0, 5 )
 Results:
A
1 0.25
2 -2.0
3 -0.4

 

Standardize Function Error

If you get an error from the Excel Standardize Function, this is likely to be the #NUM! error:

#NUM! Occurs if the supplied standard_dev argument is < 0.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment