The STANDARDIZE function returns a normalized value from a distribution characterized by a given mean and standard deviation. All arguments are number values.
STANDARDIZE(num, average, stdev)
num: The value to be evaluated.
average: The known average (arithmetic mean) rate at which events occur.
stdev: The standard deviation of the population. stdev must be greater than 0.
Example |
|---|
=STANDARDIZE(6, 15, 2.1) returns approximately -4.28571428571429. |