Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.
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.
- For a given dataset,
meancan be calculated using
AVERAGEor its related functions and
standard_deviationcan be calculated using
STDEVor its related functions.
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.