Summary
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.