Definition

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.

Sample Usage

Syntax

T.DIST.2T(x,deg_freedom)

The T.DIST.2T function syntax has the following arguments:

  • X     Required. The numeric value at which to evaluate the distribution.

  • Deg_freedom     Required. An integer indicating the number of degrees of freedom.

Remarks

  • If any argument is nonnumeric, T.DIST.2T returns the #VALUE! error value.

  • If deg_freedom < 1, T.DIST.2T returns the #NUM! error value.

  • If x < 0, then T.DIST.2T returns the #NUM! error value.

In order to use the T.DIST.2T formula, start with your edited Excellentable:


Then type in the T.DIST.2T formula in the area you would like to display the outcome:


By adding the values you would like to calculate the T.DIST.2T formula for, Excellentable will generate the outcome:



Error.

User does not have sufficient privileges to access this Content
Learn More