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. X (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:

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

Result:

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.