# T.DIST.2T function

Returns the two-tailed Student's t-distribution. The Student's 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.

## Syntax

T.DIST.2T(x,deg_freedom)

Argument

Description

Remarks

x

The numeric value at which to evaluate the distribution.

• If this argument is less than zero, this function returns the #NUM! error value.

• If this argument is nonnumeric, this function returns the #VALUE! error value.

deg_freedom

An integer that indicates the number of degrees of freedom.

• If this argument is less than 1, this function returns the #NUM! error value.

• If this argument is nonnumeric, this function returns the #VALUE! error value.

## Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

 1 2 3
 A B Data Description 1.959999998 Value at which you want to evaluate the distribution 60 Degrees of freedom Formula Description (Result) =T.DIST.2T(A2,A3) Two-tailed distribution (0.054645, or 5.46 percent)
 Note  To view the number as a percentage, select the cell, and then on the Home tab, in the Number group, click Percent Style .
 Rate this content: