T.DIST

Definition

Returns the Student's left-tailed t-distribution. The t-distribution 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.

Sample Usage

Syntax

T.DIST(x,deg_freedom, cumulative)

The T.DIST function syntax has the following arguments:

• X     Required. The numeric value at which to evaluate the distribution

• Deg_freedom     Required. An integer indicating the number of degrees of freedom.

• Cumulative     Required. A logical value that determines the form of the function. If cumulative is TRUE, T.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

Remarks

• If any argument is nonnumeric, T.DIST returns the #VALUE! error value.

• If deg_freedom < 1, T.DIST returns an error value. Deg_freedom needs to be at least 1.

In order to use the T.DIST formula, start with your edited Excellentable:

Then type in the T.DIST formula in the area you would like to display the outcome:

By adding the values you would like to calculate the T.DIST formula for, Excellentable will generate the outcome: