Returns the Student's 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.
Syntax
T.DIST(x,deg_freedom, cumulative)
The T.DIST function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
- 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.
