# Documentation/Calc Functions/STANDARDIZE

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

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

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

## ODF standard:

## Equivalent Excel functions:

STANDARDIZE