Home › Functions › Statistical › =T.DIST.2T()
Statistical Excel 2010 ◉ 25 views

=T.DIST.2T()

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.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=T.DIST.2T(x,deg_freedom)
Hover argument names in the table for details.
Output typeNumber
Popularity8 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =T.DIST.2T() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
Download T.DIST.2T.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
x Number Required The numeric value at which to evaluate the distribution.
deg_freedom Number Required An integer indicating the number of degrees of freedom.

▣ Examples

▦ Data
CellValueDescription
A2 1.959999998 Value at which to evaluate the distribution
A3 60 Degrees of freedom
A4 1.959999998 Value at which to evaluate the distribution
A5 60 Degrees of freedom
Two-tailed distribution (0.054645, or 5.46 percent) =T.DIST.2T(A2,A3)
Result: 5.46%

§ 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.

⚠ Common Errors

#VALUE! If any argument is nonnumeric, T.DIST.2T returns the #VALUE! error value.
Fix: بررسی کنید X و Deg_freedom مقدار عددی باشند و متن یا سلول خالی وارد نکرده باشید.
#NUM! If deg_freedom < 1, T.DIST.2T returns the #NUM! error value. If x < 0, then T.DIST.2T returns the #NUM! error value.
Fix: Use ABS for a negative statistic

⇄ Related Functions

=ABS() Returns the absolute value of a number. The absolute value of a number is the number without its sign. =T.DIST.RT() Returns the right-tailed Student's t-distribution. The 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. =T.INV.2T() Returns the two-tailed inverse of the Student's t-distribution. =T.TEST() Returns the probability associated with a Student's t-Test. Use T.TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. Results from the test shows if the difference is statistically significant or from chance.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.