Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.

Sample Usage

STANDARDIZE(96,80,6.7)

STANDARDIZE(A2,A3,A4)

Syntax

STANDARDIZE(value, mean, standard_deviation)

value - The value of the random variable to normalize.

mean - The mean of the distribution.

standard_deviation - The standard deviation of the distribution.

Notes

For a given dataset, mean can be calculated using AVERAGE or its related functions and standard_deviation can be calculated using STDEV or its related functions.

See Also

STDEV: Calculates the standard deviation based on a sample.

AVERAGE: Returns the numerical average value in a dataset, ignoring text.

In order to use the STANDARDIZE formula, start with your edited Excellentable

Then type in the STANDARDIZE Formula in area you would like to display the outcome:

Type in the complete STANDARDIZE formula for a cell as shown below:

Excellentable will generate the outcome when hitting enter.

Error.

User does not have sufficient privileges to access this Content Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.