Practice free

T.DIST.RT function

T.DIST.RT returns the right-tailed Student t probability, the chance of seeing a t value this large or larger. It is used for one-sided tests with n-1 degrees of freedom.

Example

Read it as a sentence: find the right-tail probability for the t value in D1 with 60 degrees of freedom, which gives 0.5.

Practice this in the app

Syntax

T.DIST.RT(x, deg_freedom)

x (required)
The t value.
deg_freedom (required)
Degrees of freedom, a positive integer.

Returns: The right-tailed Student t 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.DIST.RT(1.96,60) 0.027322465 Working example
=T.DIST.RT("1.96",60) 0.027322465 Text-number in first arg
=T.DIST.RT({1.96,1.96},60) 0.027322465 Array in first arg (lifts, spills)
=T.DIST.RT(-1,10) 0.829553434 Negative x
=T.DIST.RT(Data!D1,60) 0.5 Blank cell as first arg
=T.DIST.RT("abc",60) #VALUE! Non-numeric text in first arg
=T.DIST.RT(NA(),60) #N/A Error in first arg
=T.DIST.RT(1.96,0) #NUM! Df 0

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • It equals 1 minus the cumulative T.DIST.
  • Fix degrees of freedom as n-1 for a one-sample test.

Where it works

Excel
T.DIST.RT arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, but behaves differently. Sheets has T.DIST.RT.

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