T.DIST.2T Function

Basic Description

The Excel T.DIST.2T function calculates the two-tailed Student’s T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets. The T.DIST.2T function is new to Excel 2010. However, this function (along with the new T.DIST.RT function) simply replaces the TDIST function, that is available in earlier versions of Excel.

Syntax: T.DIST.2T( x, degrees_freedom )

where the function arguments are:

x The value at which you want to evaluate the two-tailed Student’s T-Distribution
degrees_freedom The number of degrees of freedom (must be ≥ 1)

 

Note that the Excel T.Dist.2t Function doesn’t allow the argument x to be < 0. Therefore, if you want to calculate the two-tailed Student’s T Distribution for values of x that are < 0, you should use the relationship :

T.DIST.2T( -x, df ) = T.DIST.2T( x, df )

 

T.Dist.2t Function Example

Plot of 2-Tailed Student's T Distribution with 10 Degrees of Freedom

2-Tailed Student’s T-Distribution with 10 Degrees of Freedom

The chart on the right shows the two-tailed Student’s T Distribution with 10 degrees of freedom.

If you want to calculate the value of this function at x = 1, this can be done using the Excel T.Dist.2t function, as follows:

=T.DIST.2T( 1, 10 )

This gives the result 0.340893132, or 34.09%.

If you want to calculate the value of the function, at x = -1, this must be done using the relationship T.DIST.2T( -x, df ) = T.DIST.2T( x, df ). Therefore, the formula to calculate the function at x = -1 is simply :

=T.DIST.2T( 1, 10 )

which, as shown above, gives the result 0.340893132, or 34.09%.

 

T.Dist.2t Function Errors

If you get an error from your Excel T.Dist.2t function this is likely to be one of the following:

#NUM! Occurs if either:

the supplied x argument is < 0
or
the supplied degrees_freedom argument is < 1
#VALUE! Occurs if either of the supplied arguments are non-numeric

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment