Excel functions / Statistics
T.DIST.RT function
The right tail of the t-distribution: the chance of a t greater than x.
Syntax
=T.DIST.RT(x, deg_freedom)
Arguments
x: The value to work the distribution out at.deg_freedom: The degrees of freedom. Decimals are cut off.
When to use it
T.DIST.RT gives the chance of a t-value greater than x: the p-value of a one-sided t-test.
Examples
p-value for t = 1.96 with 60 degrees of freedom, one side
A B C D 1 t df 2 1.96 60 0.0273 In D2:
=T.DIST.RT(A2, B2)→ 0.0273
Common mistakes
- One or two sides. Two-sided tests use T.DIST.2T, which is twice this.
T.DIST.RT in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: T.DIST.RT
- Danish: T.FORDELING.RT
- Dutch: T.VERD.RECHTS
- Finnish: T.JAKAUMA.OH
- French: LOI.STUDENT.DROITE
- German: T.VERT.RE
- Hungarian: T.ELOSZLÁS.JOBB
- Italian: DISTRIB.T.DS
- Norwegian: T.FORDELING.H
- Polish: ROZKŁ.T.PS
- Portuguese (Brazil): DIST.T.CD
- Portuguese (Portugal): DIST.T.DIR
- Russian: СТЬЮДЕНТ.РАСП.ПХ
- Spanish: DISTR.T.CD
- Swedish: T.FÖRD.RT
- Turkish: T.DAĞ.SAĞK
Try T.DIST.RT in the playground