The T.DIS.RT function returns the right-tailed Student’s T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.
- This function was introduced in Excel 2010 and so is not available in earlier versions.
- The T.DIST.RT function, along with the T.DIST.2T function, replace the TDIST function included in earlier versions of Excel.
|x||The value at which you want to evaluate the distribution|
|deg_freedom||An integer indicating the number of degrees of freedom – must be ≥ 1|
|2||1.856954||Value at which to evaluate the distribution|
|3||40||Degrees of freedom|
|6||=T.DIST.RT(A2,A3)||3.53%||Right-tailed distribution (0.035346 or 3.53%)|
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if either of the supplied arguments are non-numeric|
|#NUM!||Occurs if the supplied deg_freedom argument is < 1|