STANDARDIZE
Definition
Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.
Sample Usage
STANDARDIZE(96,80,6.7)
STANDARDIZE(A2,A3,A4)
Syntax
STANDARDIZE(value, mean, standard_deviation)
value- The value of the random variable to normalize.mean- The mean of the distribution.standard_deviation- The standard deviation of the distribution.
Notes
- For a given dataset,
meancan be calculated usingAVERAGEor its related functions andstandard_deviationcan be calculated usingSTDEVor its related functions.
See Also
STDEV: Calculates the standard deviation based on a sample.
AVERAGE: Returns the numerical average value in a dataset, ignoring text.
In order to use the STANDARDIZE formula, start with your edited Excellentable
Then type in the STANDARDIZE Formula in area you would like to display the outcome:
Type in the complete STANDARDIZE formula for a cell as shown below:
Excellentable will generate the outcome when hitting enter.
