TDIST

Formulas / TDIST
Compute the probability for the student t-distribution.
`TDIST(x,deg_freedom,tails)`
• x - required, numeric value to evaluate the distribution on
• degrees_freedom - required, integer
• tails - required, 1 or 2, truncated to an integer

Examples

• `=TDIST(A2,A3,2)`

The TDIST function is used to calculate the probability of obtaining a given value from the t-distribution. In the example above, it returns the two-tailed distribution of values in cell A2, cell A3, and column 2 of the worksheet. The two-tailed distribution is the probability of a given value occurring in either tail of the t-distribution.

• `=TDIST(A2,A3,1)`

This example returns the one-tailed distribution of the difference between A2 and A3. The one-tailed distribution is the probability of a given value occurring in one tail of the t-distribution.

• `=TDIST(A2,A3,2, TRUE)`

The TDIST function can also be used to calculate the probability of obtaining a given value in the t-distribution. This returns the probability of the difference between A2 and A3 occurring in the two-tailed t-distribution.

• `=TDIST(A2,A3,3,TRUE)`

Finally, the TDIST function can be used to calculate the probability of obtaining a given value from the t-distribution. The example returns the three-tailed distribution of values in cell A2, cell A3, and column 3 of the worksheet. The three-tailed distribution is the probability of a given value occurring in any of the three tails of the t-distribution.

Summary

The TDIST function is used to calculate the probability of a student t-distribution in small sample data sets. It is available for backward compatibility and is improved by the T.DIST.2T and T.DIST.RT functions.

• The TDIST function returns the probability for the student t-distribution, and is used for small sample data sets.
• The new T.DIST.2T and T.DIST.RT functions provide improved accuracy.