T.DIST

The T.DIST function in Google Sheets returns the right-tailed Student's t-distribution for a given value, which is widely used in hypothesis testing when working with small sample sizes. Dive into our comprehensive guide to learn how it works.

Parameters

• x: The value at which to evaluate the distribution.
• degrees_freedom: The number of degrees of freedom.
• cumulative: A logical value — TRUE to return the cumulative distribution function, FALSE to return the probability density function.

Step-by-Step Tutorial

1. Calculating the cumulative t-distribution:

   • Example: =T.DIST(1.5, 10, TRUE)
   • Result: approximately 0.9178

2. Calculating the probability density:

   • Example: =T.DIST(1.5, 10, FALSE)
   • Result: approximately 0.1336

Use Cases and Scenarios

1. Hypothesis Testing: Determine p-values for t-tests when sample sizes are small and the population standard deviation is unknown.
2. Confidence Interval Estimation: Build confidence intervals for sample means using the t-distribution.
3. Academic Research: Perform statistical analysis in fields that rely on small-sample inference.

Related Functions

• T.DIST.RT: Returns the right-tailed Student's t-distribution.
• T.DIST.2T: Returns the two-tailed Student's t-distribution.
• T.INV: Returns the left-tailed inverse of the Student's t-distribution.

Related Articles

• Understanding Statistical Functions in Google Sheets