STANDARDIZE
Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist. |
Returns a normalized value from a distribution characterized by mean and standard_dev.
Syntax
STANDARDIZE ( x , mean , standard_dev )
X is the value you want to normalize.
Mean is the arithmetic mean of the distribution.
Standard_dev is the standard deviation of the distribution.
Remarks
If standard_dev 0, STANDARDIZE returns the #NUM! error value.
The equation for the normalized value is:
Example
X |
Mean |
StdDev |
Formula |
Description (Result) |
---|---|---|---|---|
42 |
40 |
1.5 |
=STANDARDIZE([X],[Mean],[StdDev]) |
Normalized value of 42 for the specified arguments (1.333333) |