Related Topics:
	Spreadsheet Mathematical Functions Function Wizard Functions

STANDARDIZE

Description: Returns a normalized value.

Syntax: STANDARDIZE(x, Mean, Standard_dev)

• x is the value you want to normalize.

• Mean is the arithmetic mean of the distribution.

• Standard_dev is the standard deviation of the distribution.

Remarks:

• Standard_dev must be > 0.

• The equation for the normalized value is:

Example:

• STANDARDIZE(42,40,1.5) = 1.333333

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.