STANDARDIZE

Returns the normalized value from a distribution characterized by the specified arguments.

Syntax

STANDARDIZE( Number n, Number mean, Number sigma ) → Number

Parameters

n

Required. The value to normalize.

mean

Required. The arithmetic mean of the distribution.

sigma

Required. The standard deviation of the distribution. Must be a non-negative value.

Remarks

The equation of the normalized value is (n - mean) / sigma. If sigma is negative, the function returns the #NUM! error value.

Example

Formula

=STANDARDIZE(42,40,1.5)

See Also

Function Reference