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:

T.DIST Function - How to use T.DIST Function in Excel

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

 

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

T.DIST Function in Excel 1 - How to use T.DIST Function in Excel

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.

 

 

 

 

 

 

 

READ:  How to use RANK.AVG Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *