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:
A
|
B
|
|
|---|---|---|
1
|
||
2
|
||
3
|
