Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .