This function returns a normalized value from a distribution characterized by mean and standard deviation.
STANDARDIZE(x,mean,stdev)
This function has these arguments:
Argument | Description |
---|---|
x | Value to normalize |
mean | Arithmetic mean of the distribution |
stdev | Standard deviation of the distribution Must be greater than zero. |
Accepts numeric data for all arguments. Returns numeric data.
STANDARDIZE(15.6,A4,B2)
STANDARDIZE(88,48,1.6) gives the result 25