Difference between revisions of "Documentation/How Tos/Calc: STANDARDIZE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 18: | Line 18: | ||
{{Documentation/SeeAlso| | {{Documentation/SeeAlso| | ||
− | * [[Documentation/How_Tos/Calc: STDEV function|STDEV]] | + | * [[Documentation/How_Tos/Calc: STDEV function|STDEV]] |
− | * [[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]] | + | * [[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]] |
− | * [[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]] | + | * [[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]] |
* [[Documentation/How_Tos/Calc: GAUSS function|GAUSS]] | * [[Documentation/How_Tos/Calc: GAUSS function|GAUSS]] | ||
Revision as of 14:39, 26 February 2009
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.