Skip to main content



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



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.


  • 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:


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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.