Practice free

T.DIST function

T.DIST converts a t statistic into a left-tailed Student t probability or density, which suits small samples. It is the basis for many t-tests, and negative values are allowed.

Example

Read it as a sentence: find the cumulative probability that a t value is 1.96 or less with 60 degrees of freedom, which gives 0.972677535.

Practice this in the app

Syntax

T.DIST(x, deg_freedom, cumulative)

x (required)
The t value.
deg_freedom (required)
Degrees of freedom, a positive integer.
cumulative (required)
TRUE for the cumulative left-tail probability, FALSE for density.

Returns: The left-tailed Student t probability or density.

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.DIST(1.96,60,TRUE) 0.972677535 Working example
=T.DIST(1.96,60,FALSE) 0.059847906 Other cumulative flag
=T.DIST(1.96,60,0) 0.059847906 Cumulative as 0
=T.DIST("1.96",60,TRUE) 0.972677535 Text-number in first arg
=T.DIST({1.96,1.96},60,TRUE) 0.972677535 Array in first arg (lifts, spills)
=T.DIST(-1.96,60,TRUE) 0.027322465 Negative x
=T.DIST("abc",60,TRUE) #VALUE! Non-numeric text in first arg
=T.DIST(NA(),60,TRUE) #N/A Error in first arg

Watch out for

  • Negative x is allowed here but not in T.DIST.2T.
  • Degrees of freedom is truncated to an integer.

Where it works

Excel
T.DIST arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, but behaves differently. Sheets has TDIST (right/two-tail) and T.DIST; check cumulative handling.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .