- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Statistical - T.DIST Function
Description
The T.DIST.2T function returns the two-tailed Student's t-distribution. The Student's tdistribution 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(x,deg_freedom, cumulative)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| X | The numeric value at which to evaluate the distribution. | Required |
| Deg_freedom | An integer indicating the number of degrees of freedom. | Required |
| Cumulative | A logical value that determines the form of the Function. If cumulative is TRUE, T.DIST returns the cumulative distribution Function. If cumulative is FALSE, T.DIST returns the probability density function. |
Required |
Notes
If cumulative is TRUE and degrees_freedom < 1, T.DIST returns #NUM! value.
If cumulative is FALSE and degrees_freedom < 0, T.DIST returns #NUM! value.
If cumulative is FALSE and degrees_freedom = 0, T.DIST returns #DIV/0! Value.
If any argument is nonnumeric, T.DIST returns the #VALUE! error value.
Applicability
Excel 2010, Excel 2013, Excel 2016
Example
