Definition

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