Related Function:

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.

Syntax

=T.DIST.RT(x,deg_freedom)

Arguments

Argument Description
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

Examples

  A B C D
1 Data Description    
2 1.856954 Value at which to evaluate the distribution    
3 40 Degrees of freedom    
4        
5 Formula Result Notes
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