STANDARDIZE
Syntax:
STANDARDIZE ( x , mean , standard-dev )
Description: Computes a normalized value from a distribution characterized by mean and standard-dev.
Mathematical Formula:
Arguments:
Name |
Type |
Description |
---|---|---|
x |
number |
The number whose value is to be normalized. |
mean |
number |
The the arithmetic mean of the distribution. |
standard-dev |
number |
The standard deviation of the distribution. |
Return Type and Value: number – A normalized value from a distribution.
However, if standard-dev ≤ 0, #NUM!
is returned.
example: