# Documentation/Calc Functions/STANDARDIZE

Jump to navigation Jump to search

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.

## 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!

STANDARDIZE