TDIST
Syntax
TDIST( <number>, <number>; <boolean>)
Description
Returns student t-distribution at a given value x for a certain number of degrees of freedom.
or
Returns the student t density function or the cumulative distribution function for the t distribution. This function is frequently used used to measure the degree of diversity between two data sets.
The function arguments are:
- x: The value at which to evaluate the distribution (NUMERIC)
- df: The number of degrees of freedom (NUMERIC)
- Cumulative: Constant indicating the form of the function. If TRUE then the cumulative distribution function is used. If FALSE then the probability mass function is used. (BOOLEAN)
| Cumulative/Boolean | Logical argument which defines the type of distribution to be calculated |
|---|---|
| True | Uses the cumulative distribution function |
| False | Uses the probability density function |
Examples
TDIST(#input!Value;#input!DF;cumulative value)
Value | DF | Cumulative value | TDIST returns |
|---|---|---|---|
| 1 | 10 | false | 0.2303 |
| 1 | 10 | false | 0.8295 |
Common Errors
| #NUM! | - | Occurs if either:
|
| #VALUE! | - | Occurs if the argument type isn't numeric |