Difference between revisions of "Documentation/How Tos/Calc: TINV function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
(See also:)
Line 24: Line 24:
  
 
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
 
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
 +
 +
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
 +
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]

Revision as of 14:05, 13 September 2008


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.

See also:

TDIST, TTEST

Statistical functions

Functions listed alphabetically, Functions listed by category

Personal tools