# Documentation/Calc Functions/T.INV

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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:

## ODF standard:

None

## Equivalent Excel functions:

T.INV