# Documentation/Calc Functions/TINV

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.

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

## Examples:

Formula Description Returns
=TINV(0.8;8) The function calculates the two-tailed inverse of the Student's t-distribution. Here we can see that TDIST(0.261921096748832;2) gives 0.8. 0.261921096748832
=TINV(0.1;8) The function calculates the two-tailed inverse of the Student's t-distribution. Here we can see that TDIST(1.8595480375309;8;2) gives 0.1. 1.8595480375309
=TINV(1;8) The function calculates the two-tailed inverse of the Student's t-distribution. Here we can see that TDIST(0;8;2) gives 1. 0
=TINV(0;8) The function returns an error value when Number is either less than equal to 0 or greater than 1. Err:502

T.DIST.2T

T.DIST.RT

T.DIST

T.INV.2T

T.TEST

TDIST

T.INV

TTEST

## ODF standard:

Section 6.18.78, part 2

TINV