The T.DIST function returns the one-tailed Student’s T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.

Syntax

=T.DIST(x,deg_freedom,cumulative)

Arguments

Argument Description
x The value at which you want to evaluate the distribution
deg_freedom An integer indicating the number of degrees of freedom – must be ≥ 1
cumulative A logical value that determines the form of the function

  TRUE Returns the cumulative distribution function
  FALSE Returns the probability density function

Examples

  A B C
1 Formula Result Notes
2 =T.DIST(50,1,TRUE) 0.993655 Student’s left-tailed t-distribution for 50, returned as the cumulative distribution function, using 1 degree of freedom
3 =T.DIST(50,1,FALSE) 0.000127 Student’s left-tailed t-distribution for 50, returned as the probability density function, using 1 degrees of freedom

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are non-numeric
#NUM! Occurs if cumulative is TRUE and the supplied deg_freedom argument is < 1
#DIV/0! Occurs if cumulative is FALSE and the supplied deg_freedom argument is < 1