T.DIST function

The T.DIST function in Excel calculates the Student’s t-distribution probability for a given value, which is useful in statistical analysis, particularly when conducting hypothesis tests or confidence intervals for small sample sizes.

The t-distribution is commonly used when the sample size is small and the population standard deviation is unknown. It is symmetric and bell-shaped, similar to the normal distribution, but has heavier tails. The T.DIST function calculates the cumulative probability or the probability density function (PDF) for a t-distribution.

Syntax

=T.DIST(x, degrees_freedom, cumulative)

Parameters

1. x (required): The numeric value for which you want to calculate the t-distribution.
2. degrees_freedom (required): The number of degrees of freedom, typically calculated as $n – 1$, where $n$ is the sample size.
3. cumulative (required):
   • TRUE: Returns the cumulative distribution function (CDF), which gives the probability that the t-statistic is less than or equal to x.
   • FALSE: Returns the probability density function (PDF), which gives the height of the t-distribution curve at the point x.

Key Points

• Cumulative Distribution (CDF): When cumulative is TRUE, T.DIST gives the probability that a t-distributed random variable is less than or equal to x. This is often used in hypothesis testing (e.g., calculating the p-value).
• Probability Density (PDF): When cumulative is FALSE, T.DIST returns the value of the probability density function at x, which indicates the likelihood of observing the value x under a t-distribution.
• The degrees of freedom refer to the number of independent values in the dataset, typically calculated as the sample size minus 1 (n – 1).

Examples

1. Cumulative Distribution (CDF) Example

Suppose you have a t-statistic value of 2.5, with 10 degrees of freedom, and you want to find the cumulative probability. To calculate the cumulative probability:

=T.DIST(2.5, 10, TRUE)

Result: 0.9873 (approx.)

• This result indicates that the probability of a t-distributed random variable being less than or equal to 2.5 is approximately 98.73%.

2. Probability Density (PDF) Example

Now, suppose you want to find the probability density at the t-statistic value of 2.5, with 10 degrees of freedom. To calculate the probability density:

=T.DIST(2.5, 10, FALSE)

Result: 0.0647 (approx.)

• This result shows the height of the t-distribution curve at the point x = 2.5 for 10 degrees of freedom. It gives the likelihood of observing exactly 2.5 as a t-statistic.

3. Hypothesis Testing (CDF)

If you’re conducting a two-tailed t-test with a t-statistic of 2.5 and 10 degrees of freedom, and you need to calculate the p-value, you would use the cumulative distribution function. To calculate the p-value:

=T.DIST(2.5, 10, TRUE)

Result: 0.9873 (approx.)

• Since this is a two-tailed test, the p-value would be calculated as $2 \times (1 – 0.9873) = 0.0254$, indicating a significance level of approximately 2.54%.

Notes

• T-Distribution: The t-distribution is used when the sample size is small, typically less than 30, or when the population standard deviation is unknown.
• Degrees of Freedom: For a one-sample t-test, the degrees of freedom are calculated as $n – 1$, where $n$ is the sample size.
• Tails of the Distribution: When calculating a two-tailed p-value, you may need to multiply the cumulative probability by 2, depending on the hypothesis test.

Related Functions

• T.DIST.2T: Calculates the two-tailed t-distribution, useful for hypothesis testing with two tails.
• T.INV: Returns the inverse of the Student’s t-distribution for a given probability and degrees of freedom (used to find critical values).
• T.INV.2T: Returns the inverse of the two-tailed t-distribution for a given probability and degrees of freedom.
• T.TEST: Performs a t-test to determine if there is a significant difference between two sample means.

The T.DIST function is useful for statistical analysis when working with small samples and conducting t-tests or calculating the probability under a t-distribution curve. It helps in hypothesis testing, confidence intervals, and understanding the spread of data with small sample sizes.