Documentation/How Tos/Calc: STANDARDIZE function

STANDARDIZE

Returns the normalized value of a random variable.

Syntax:

STANDARDIZE(n; μ; σ)

n is a number in a normal distribution with mean μ and standard deviation σ.

STANDARDIZE converts n to a corresponding value in a (standard) normal distribution with mean 0 and standard deviation 1.

The result is calculated as (n - μ)/ σ.

Example:

STANDARDIZE(14; 10; 4)

returns 1. The original value 14 lies 1 standard deviation above the original mean 10; the new value lies 1 standard deviation above the new mean 0.

See also:

STDEV, NORMDIST, NORMSDIST, GAUSS

Statistical functions