How to use T.DIST Function in Excel

Returns the Student’s left-tailed t-distribution. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution.

Syntax:= T.DIST(x,deg_freedom, cumulative)

The T.DIST function syntax has the following arguments:

• X     Required. The numeric value at which to evaluate the distribution
• Deg_freedom     Required. An integer indicating the number of degrees of freedom.

• Cumulative     Required. A logical value that determines the form of the function. If cumulative is TRUE, T.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

Example: Let’s look at some Excel T.DIST function examples and explore how to use the T.DIST function as a worksheet function in Microsoft Excel:

Syntax: =T.DIST(B1,B2,TRUE)
Result: 0.829553434

 

Syntax: =T.DIST(C1,C2,FALSE)
Result: 0.000736907

Note:

1. #NUM! error – Occurs when:
   1. The given cumulative is TRUE and deg_freedom < 1.
   2. The given cumulative is FALSE and deg_freedom < 0.
2. VALUE! error – Occurs when the given arguments are non-numeric.
3. The deg_freedom and tails arguments are truncated to integers.
4. #DIV/0 error – Occurs when the given cumulative is FALSE and deg_freedom is equal to 0.