T.DIST (t-distribution)

<< Click to Display Table of Contents >>

T.DIST (t-distribution)

Syntax:

T.DIST(X, DegreesFreedom, Cumulative)

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.

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, T.DIST.2T and T.DIST.RT functions supplement 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. The function is unknown in older versions.

See also:

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