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:

This returns the probability of the Student's t-distribution.

X is the value whose probability is to be calculated. X must be ≥ 0.

DegreesFreedom is the number of degrees of freedom. This value must be ≥ 1. Integers are expected; if this is not the case, PlanMaker automatically truncates the decimal places.

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