T.DIST (t-distribution)

<< Click to Display Table of Contents >>

T.DIST (t-distribution)

Syntax:

T.DIST(X, DegreesFreedom, Cumulative)

Description:

Returns the probability of the Student's t-distribution.

X is the value to be evaluated. Must be ≥ 0.

DegreesFreedom is the number of degrees of freedom. Must be ≥ 1. Integer numbers are expected. Digits to the right of the decimal point are ignored.

Cumulative determines the type of function as a switch: If you enter the value TRUE, the cumulative distribution function of the left-tailed Student's t-distribution is calculated. By entering the value FALSE, the probability density function of the Student's t-distribution is calculated.

Note:

The T.DIST function supplements together with T.DIST.2T and T.DIST.RT the previous TDIST function, whereby T.DIST has the additional argument Cumulative.

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.

See also:

T.DIST.2T/T.DIST.RT/TDIST, T.INV/T.INV.2T/TINV, T.TEST/TTEST