TINV function
TINV returns the two-tailed critical t value, the cut-off for a confidence interval, such as 0.05 for 95 percent. It is a compatibility function, so use T.INV.2T in new workbooks.
Example
Read it as a sentence: find the two-tailed t value for a 50 percent probability with 1 degree of freedom, which gives 1.
A
B
C
D
1
1
2
3
Syntax
TINV(probability, deg_freedom)
-
probability(required) - Two-tailed probability.
-
deg_freedom(required) - Degrees of freedom.
Returns: The two-tailed critical t value.
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 |
|---|---|---|
=TINV(0.5,1) | 1 | Working example |
=TINV("0.5",1) | 1 | Text-number in first arg |
=TINV({0.5,0.5},1) | 1 | Array in first arg (lifts, spills) |
=TINV(1,1) | 0 | Probability 1 |
=TINV("abc",1) | #VALUE! | Non-numeric text in first arg |
=TINV(NA(),1) | #N/A | Error in first arg |
=TINV(0,1) | #DIV/0! | Probability 0 |
=TINV(Data!D1,1) | #DIV/0! | Blank cell as first arg |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Superseded by T.INV.2T; use that in new workbooks.
- Two-tailed: for a one-tailed test double the probability.
Where it works
- Excel
- TINV is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .