T.INV function
T.INV returns the t value that has a given left-tail probability, such as 2.23 for 97.5 percent with 10 degrees of freedom. It finds one-sided critical values.
Example
Read it as a sentence: find the t value with 97.5 percent of the distribution to its left using 10 degrees of freedom, round it to 6 decimals, which gives 2.228139.
A
B
C
D
1
2.228139
2
3
Syntax
T.INV(probability, deg_freedom)
-
probability(required) - Left-tail probability, between 0 and 1.
-
deg_freedom(required) - Degrees of freedom, a positive integer.
Returns: The t value with that left-tail probability.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=T.INV(0.975,10) | 2.228138852 | Working example |
=T.INV("0.975",10) | 2.228138852 | Text-number in first arg |
=T.INV({0.975,0.975},10) | 2.228138852 | Array in first arg (lifts, spills) |
=T.INV("abc",10) | #VALUE! | Non-numeric text in first arg |
=T.INV(NA(),10) | #N/A | Error in first arg |
=T.INV(0,10) | #NUM! | Probability 0 |
=T.INV(1,10) | #NUM! | Probability 1 |
=T.INV(0.5,0) | #NUM! | Df 0 |
Watch out for
- For two-tailed 95 percent use T.INV.2T(0.05,...) or T.INV(0.975,...).
- Degrees of freedom is truncated to an integer.
Where it works
- Excel
- T.INV arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, but behaves differently. Sheets has T.INV.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .