Documentation/Calc Functions/TINV

Function name:
TINV

Category:
Statistical Analysis

Summary:
Calculates the two-tailed inverse of the Student's t-distribution. It finds the value of a random variable for which the two-tailed test value for the Student's t-distribution would be equal to a particular probability.

Syntax:
TINV(Number; DegreesFreedom)

Returns:
Returns a positive real number which is the inverse of the specified two-tailed test value for the given Student’s t-distribution.

Arguments:
Number is a real number between 0(exclusive) to 1(excusive) or a reference to a cell containing that number which is the two-tailed test value for which the inverse is to be calculated.

DegreesFreedom is a positive integer value or a reference to a cell containing that value which is the number of degrees of freedom for the Student's t-distribution.


 * If Number is less than or equal to 0 or greater than or equal to 1 then the function returns an error value.
 * If DegreesFreedom is less than 1 then the function returns an error value.
 * If DegreesFreedom is a non-integer value then the function uses its floor value, i.e. it is truncated to an integer.

Additional details:

 * It is such that if TDIST(x;df;2) = p or T.DIST.2T(x;df) = p then TINV(p;df) = x.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/T.DIST.2T T.DIST.2T]

[[Special:MyLanguage/Documentation/Calc_Functions/T.DIST.RT T.DIST.RT]

[[Special:MyLanguage/Documentation/Calc_Functions/T.DIST T.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/T.INV.2T T.INV.2T]

[[Special:MyLanguage/Documentation/Calc_Functions/T.TEST T.TEST]

[[Special:MyLanguage/Documentation/Calc_Functions/TDIST TDIST]

[[Special:MyLanguage/Documentation/Calc_Functions/T.INV T.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/TTEST TTEST]

ODF standard:
Section 6.18.78, part 2

Equivalent Excel functions:
TINV