T.INV.2T function
T.INV.2T returns the positive t value for a two-tailed probability. It is the multiplier for confidence intervals: give it 0.05 and your degrees of freedom for a 95 percent interval.
Example
Read it as a sentence: find the t value that leaves 5 percent split across both tails with 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.2T(probability, deg_freedom)
-
probability(required) - Two-tailed probability (significance level), e.g. 0.05.
-
deg_freedom(required) - Degrees of freedom, a positive integer.
Returns: The positive t value for the two-tailed 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.2T(0.05,10) | 2.228138852 | Working example |
=T.INV.2T("0.05",10) | 2.228138852 | Text-number in first arg |
=T.INV.2T({0.05,0.05},10) | 2.228138852 | Array in first arg (lifts, spills) |
=T.INV.2T(1.5,10) | -0.699812061 | Probability above 1 |
=T.INV.2T(1,10) | 0 | Probability 1 |
=T.INV.2T("abc",10) | #VALUE! | Non-numeric text in first arg |
=T.INV.2T(NA(),10) | #N/A | Error in first arg |
=T.INV.2T(0,10) | #NUM! | Probability 0 |
Watch out for
- Pass the total tail area (0.05), not 0.025.
- Always returns a positive number.
Where it works
- Excel
- T.INV.2T arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, but behaves differently. Sheets has T.INV.2T.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .