T.INV FunctionWayne Becker
The T.INV function returns the left-tailed inverse of the Student’s T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.
- This function was introduced in Excel 2010 and so is not available in earlier versions.
- The T.INV function should not be confused with the TINV function, available in earlier versions of Excel. The TINV function calculated the two-tailed inverse Student’s T-Distribution and is replaced by the T.INV.2T function in Excel 2010.
||The probability, between 0 and 1, associated with the Student’s t-distribution
||An integer indicating the number of degrees of freedom – must be ≥ 1
||The left-tailed inverse of the Student’s t-distribution with a probability of 75% and 2 degrees of freedom
||The left-tailed inverse of the Student’s t-distribution with a probability of 75% and 5 degrees of freedom
Common Function Error(s)
||What went wrong
||Occurs if either of the supplied arguments are non-numeric
||Occurs if either:
||the supplied probability argument is ≤ 0 or > 1
||the supplied deg_freedom argument is < 1