Documentation/Calc Functions/STANDARDIZE

From The Document Foundation Wiki
Jump to navigation Jump to search


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:
Standardize.png

where X is the Number, μ is the Mean and σ is the StDev.

  • For more details on the z-score, visit Wikipedia.

Examples:

Formula Description Returns
=STANDARDIZE(11;10;1) The function calculates a normalized value for the random variable 11 with mean 10 and standard deviation 1. 1
=STANDARDIZE(11;10;-1) The function returns an error value since the standard deviation is less than 0. Err:502
=STANDARDIZE(11;10;0) The function returns an error value since the standard deviation is 0. #DIV/0!

Related LibreOffice functions:

GAUSS

ODF standard:

Section 6.18.71, part 2

Equivalent Excel functions:

STANDARDIZE