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 usingAVERAGE
or its related functions andstandard_deviation
can be calculated usingSTDEV
or its related functions.
See Also
STDEV
: The STDEV function calculates the standard deviation based on a sample.
AVERAGE
: The AVERAGE function returns the numerical average value in a dataset, ignoring text.