TDIST

Owned by Charles Bishop (Deactivated)
Jan 30, 2018

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/BooleanLogical argument which defines the type of distribution to be calculated
TrueUses the cumulative distribution function
FalseUses the probability density function

Examples

TDIST(#input!Value;#input!DF;cumulative value)

Value
DF
Cumulative valueTDIST returns
110false0.2303
110false0.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