This function returns a normalized value from a distribution characterized by mean and standard deviation.
Syntax
STANDARDIZE(x,mean,stdev)
Arguments
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. |
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
STANDARDIZE(15.6,A4,B2)
STANDARDIZE(88,48,1.6) gives the result 25
Version Available
This function is available in product version 1.0 or later.
See Also
NORMDIST | NORMSDIST | Statistical Functions