Returns the normalized value from a distribution characterized by the specified arguments.
Syntax
 Copy Code
|
|---|
STANDARDIZE( Number n, Number mean, Number sigma ) → Number |
Parameters
- n
- Required. The value to normalize.
- mean
- Required. The arithmetic mean of the distribution.
- sigma
- Required. The standard deviation of the distribution. Must be a non-negative value.
Remarks
The equation of the normalized value is (n - mean) / sigma. If sigma is negative, the function returns the #NUM! error value.
Example
| Formula
Copy Code
|
|---|
=STANDARDIZE(42,40,1.5) |
See Also
Function Reference