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.
The T.DIST.RT function syntax has the following arguments:
- X (required argument) – This is the numeric value at which we wish to evaluate the right-tailed student’s T Distribution.
- 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:
- #NUM! error – Occurs when the deg_freedom argument provided is <1.
- #VALUE! error – Occurs when the given arguments are non-numeric.
- The deg_freedom and tails arguments are truncated to integers.
- We can use the T.DIST.RT function in place of a table of critical values for the T distribution.