Documentation/Calc Functions/T.INV

From The Document Foundation Wiki
Jump to: navigation, search

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.

Examples:

Formula Description Returns
=T.INV(0.8;8) The function calculates the cumulative distribution function of the Student’s t-distribution. Here we can see that T.DIST(0.88888951776702;8;TRUE()) gives 0.8. 0.88888951776702
=T.INV(0.1;8) The function calculates the cumulative distribution function of the Student’s t-distribution. Here we can see that T.DIST(-1.39681530974386;8;TRUE()) gives 0.1. -1.39681530974386
=T.INV(1;8) The function returns an error value when Number is either less than or equal to 0 or greater than equal to 1. Err:502

Related LibreOffice functions:

T.DIST.2T

T.DIST.RT

T.DIST

T.INV.2T

T.TEST

TDIST

TINV

TTEST

ODF standard:

None

Equivalent Excel functions:

T.INV