Name

TDIST

Synopsis

Use TDIST to find the Student’s T-Distribution (cumulative) probability for the specified numeric value. This function is typically used when hypothesis testing small sample data sets where the population standard deviation is unknown.

To Calculate

=TDIST(X, Degrees_Freedom, Tails)

The arguments are all required for this function.

X

Indicates a numeric value.

Tails

Indicates an integer value of 1 or 2 that specifies the number of distribution tails to return. A value of 1 returns a one-tailed distribution. A value of 2 returns a two-tailed distribution.

Example

Figure 15-46 illustrates how to use TDIST to find the Student’s T-Distribution based upon 45 degrees of freedom and a two-tailed distribution. The example also shows how to take the probability distribution returned by TDIST and use TINV to find the inverse value.

Use TDIST and TINV with a Student’s T-Distribution

Figure 15-46. Use TDIST and TINV with a Student’s T-Distribution

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial