# Documentation/Calc Functions/TINV

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

## Function name:

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.

## Additional details:

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

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

TINV