T.DIST.2T (t-distribution two-tailed)

<< Click to Display Table of Contents >>

T.DIST.2T (t-distribution two-tailed)

Syntax:

T.DIST.2T(X, DegreesFreedom)

Description:

This returns the probability of the two-tailed 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.

Note:

The T.DIST.2T function, T.DIST.RT and T.DIST functions supplement the previous TDIST function, whereby T.DIST.2T returns the same result as TDIST with the argument Tails=2.

Compatibility notes:

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

See also:

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