Difference between revisions of "Documentation/How Tos/Calc: STANDARDIZE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
| Line 17: | Line 17: | ||
: returns <tt>'''1'''</tt>. The original value <tt>'''14'''</tt> lies 1 standard deviation above the original mean <tt>'''10'''</tt>; the new value lies 1 standard deviation above the new mean <tt>'''0'''</tt>. | : returns <tt>'''1'''</tt>. The original value <tt>'''14'''</tt> lies 1 standard deviation above the original mean <tt>'''10'''</tt>; the new value lies 1 standard deviation above the new mean <tt>'''0'''</tt>. | ||
| − | + | {{Documentation/SeeAlso| | |
| − | [[Documentation/How_Tos/Calc: STDEV function| | + | * [[Documentation/How_Tos/Calc: STDEV function|STDEV]], |
| − | [[Documentation/How_Tos/Calc: NORMDIST function| | + | * [[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]], |
| − | [[Documentation/How_Tos/Calc: NORMSDIST function| | + | * [[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]], |
| − | [[Documentation/How_Tos/Calc: GAUSS function| | + | * [[Documentation/How_Tos/Calc: GAUSS function|GAUSS]] |
| − | [[Documentation/How_Tos/Calc: Statistical functions| | + | * [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]] |
| − | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
| − | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
Revision as of 14:19, 25 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.
