STANDARDIZE
Name
Standardize
Description
Returns a normalized value from a distribution characterized by mean and standard deviation.
Syntax
STANDARDIZE(x,mean,stdev)
Remarks
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 Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
STANDARDIZE(15.6,A4,B2)
STANDARDIZE(B4,C5,D5)
STANDARDIZE(88,48,1.6)=25