Documentation/Calc Functions/STANDARDIZE

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

STANDARDIZE

Category:

Statistical Analysis

Summary:

Converts a random variable to a normalized value.

Syntax:

STANDARDIZE(Number; Mean; StDev)

Returns:

Arguments:

Number is the value to be standardized.

Mean is the arithmetic mean of the distribution.

StDev is the standard deviation of the distribution.

Additional details:

Examples:

=STANDARDIZE(11;10;1) returns 1. The value 11 in a normal distribution with a mean of 10 and a standard deviation of 1 is as much above the mean of 10, as the value 1 is above the mean of the standard normal distribution.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: