# Documentation/Calc Functions/T.INV

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.

• 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

None

T.INV