TDIST (t-distribution)

<< Click to Display Table of Contents >>

TDIST (t-distribution)

Note: TDIST is supplemented by the new functions T.DIST.2T, T.DIST.RT and T.DIST with additional functionalities, which are available in newer versions of Microsoft Excel (2010 or later).

Syntax:

TDIST(X, DegreesFreedom, Tails)

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.

Tails is the number of distribution tails:

1: One-tailed distribution

2: Two-tailed distribution

See also:

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