How to use T.DIST.RT Function in Excel

The T.DIST.RT function returns the right-tailed Student’s 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.RT(x,deg_freedom)

The T.DIST.RT function syntax has the following arguments:

  1. (required argument) – This is the numeric value at which we wish to evaluate the right-tailed student’s T Distribution.
  2. Deg_freedom (required argument) – This is an integer that indicates the number of degrees of freedom. It must be greater than or equal to 1.

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

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

Syntax:  =T.DIST.RT(B1,B2)

Result:

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

Note:

  1. #NUM! error – Occurs when the deg_freedom argument provided is <1.
  2. #VALUE! error – Occurs when the given arguments are non-numeric.
  3. The deg_freedom and tails arguments are truncated to integers.
  4. We can use the T.DIST.RT function in place of a table of critical values for the T distribution.

 

READ:  How to use LOGEST Function in Excel

Add a Comment

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