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 |
|
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:
STANDARDIZE(42,40,1.5) results in 1.333333333
end example]