Documentation/Calc Functions/STANDARDIZE

Function name:
STANDARDIZE

Category:
Statistical Analysis

Summary:
Calculates a normalized value that represents the number of standard deviations by which the value of a random variable is above or below the mean of the distribution. This measure is often known as a standard score or z-score.

Syntax:
STANDARDIZE(Number; Mean; StDev)

Returns:
Returns a real number which is the standardized value of the specified random variable for the given distribution mean and standard deviation.

Arguments:
Number is a real number or a reference to the cell containing that number which is the random variable value to be standardized.

Mean is a real number or a reference to the cell containing that number which is the arithmetic mean of the distribution.

StDev is a real positive number or a reference to the cell containing that number which is the standard deviation of the distribution.


 * If StDev is less than or equal to 0, then the function returns an error value.

Additional details:

 * The formula for STANDARDIZE is:

where X is the Number, μ is the Mean and σ is the StDev.
 * For more details on the z-score, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/GAUSS GAUSS]

ODF standard:
Section 6.18.71, part 2

Equivalent Excel functions:
STANDARDIZE