Buzz
This article introduces you to the function T.DIST.RT - one of the commonly used statistical functions in Excel.
Description: Returns the right-tailed Student's t-distribution. Used for testing hypotheses of small datasets. Supported from Excel version 2010 onwards.
Syntax: T.DIST.RT(x,deg_freedom)
In which:
- x: Value used for evaluating distribution, is a mandatory parameter.
- deg_freedom: Degree of freedom of the distribution, is a mandatory parameter.
Note:
- Any non-numeric argument -> function returns an error value #VALUE!
- If deg_freedom < 1 -> function returns an error value #NUM!
- The minimum value of deg_freedom must be 1.
Example:
Calculate the right-tailed Student's t-distribution of the values in the data table below:
- Enter the formula: =T.DIST.RT(D6,D7) into the cell to be calculated
- Press Enter -> the right-tailed Student's t-distribution is:
- In case the value for distribution evaluation is less than 0 -> the function still returns correct result:
- When the degrees of freedom are less than 1 -> the function returns an error value #NUM!
Above is the guide and some specific examples when using the function T.DIST.RT in Excel.
Wishing you success!
