Excel functions / Statistics
T.DIST function
Student's t-distribution: the chance of a t of x or less, or the height of the curve at x.
Syntax
=T.DIST(x, deg_freedom, cumulative)
Arguments
x: The value to work the distribution out at.deg_freedom: The degrees of freedom. Decimals are cut off.cumulative: TRUE for the chance of x or less; FALSE for the height of the curve at x.
When to use it
T.DIST gives the chance of a t-value of x or less (with TRUE), or the height of the curve, in Student's t-distribution. The t-distribution replaces the normal one for small samples.
Examples
Below t = 60 with 1 degree of freedom
A B C D 1 t df 2 60 1 0.99470 In D2:
=T.DIST(A2, B2, TRUE)→ 0.99470
Common mistakes
- Tails. For the p-value of a test, use T.DIST.2T or T.DIST.RT.
T.DIST 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
- Danish: T.FORDELING
- Dutch: T.DIST
- Finnish: T.JAKAUMA
- French: LOI.STUDENT.N
- German: T.VERT
- Hungarian: T.ELOSZL
- Italian: DISTRIB.T.N
- Norwegian: T.FORDELING
- Polish: ROZKŁ.T
- Portuguese (Brazil): DIST.T
- Portuguese (Portugal): DIST.T
- Russian: СТЬЮДЕНТ.РАСП
- Spanish: DISTR.T.N
- Swedish: T.FÖRD
- Turkish: T.DAĞ
Related functions
- T.DIST.2T: The two-tailed t-distribution: the chance of a t further from 0 than x, on either side. This is the p-value of a two-sided t-test.
- T.DIST.RT: The right tail of the t-distribution: the chance of a t greater than x.
- T.INV: The t-value below which a given share of the t-distribution falls.
- T.TEST: Student's t-test: the chance that two samples would differ this much if they came from populations with the same mean.