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.

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 Percent Style button

See also
T.INV.2T function
T.INV function
T.TEST function
List of all functions (by category)

Share your feedback about this topic

Rate this content: