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:

The x value is less than 0
The numerator or denominator is less than 1

#VALUE!

-

Occurs if the argument type isn't numeric

Browser not supported