STANDARDIZE function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
STANDARDIZE
Converts a value in a normal distribution to its equivalent in a standard normal distribution.
Syntax:
STANDARDIZE(n; μ; σ)
- n is a number in a normal distribution with known mean μ and known standard deviation σ.
- STANDARDIZE converts n to a corresponding value in a standard normal distribution, which has mean 0 and standard deviation 1.
- STANDARDIZE calculates and returns (n - μ)/ σ.
Example:
STANDARDIZE(14; 10; 4)
- returns 1. The original value 14 lies 1 standard deviation above the original mean 10; the new value lies 1 standard deviation above the new mean 0.
See Also
