Difference between revisions of "Documentation/How Tos/Calc: TINV 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 20: | Line 20: | ||
{{Documentation/SeeAlso| | {{Documentation/SeeAlso| | ||
− | * [[Documentation/How_Tos/Calc: TDIST function|TDIST]] | + | * [[Documentation/How_Tos/Calc: TDIST function|TDIST]] |
* [[Documentation/How_Tos/Calc: TTEST function|TTEST]] | * [[Documentation/How_Tos/Calc: TTEST function|TTEST]] | ||
Revision as of 14:43, 26 February 2009
TINV
Calculates the inverse of the two-tailed TDIST function.
Syntax:
TINV(p; r)
- returns the value x, such that TDIST(x; r; 2) is p.
- r (degrees of freedom) is an integer >=1.
- p (probability) must be >=0 and <=1.
- To calculate the inverse of the one-tailed TDIST function, use TINV(p*2; r), which returns the value x, such that TDIST(x; r; 1) is p.
Example:
TINV(0.666; 2)
- returns approximately 0.50.