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