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.
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.
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: