Documentation/Calc Functions/T.INV

Function name:
T.INV

Category:
Statistical Analysis

Summary:
Calculates values of the inverse of the cumulative distribution function for the given Student’s t-distribution.

Syntax:
T.INV(Number; DegreesFreedom)

Returns:
Returns a real number which is the inverse of the cumulative distribution function for the Student’s t-distribution for the given arguments.

Arguments:
Number is a real number between 0 to 1(both exclusive) or a reference to a cell containing that number which is the probability for which the inverse of the cumulative distribution function is to be calculated for the given Student’s t-distribution.

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 T.DIST(x;df;TRUE) = p then T.INV(p;df) = x.
 * For more details on Student's t-distribution, visit Wikipedia.

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/TINV TINV]

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

ODF standard:
None

Equivalent Excel functions:
T.INV