Formualizer Docs

TDIST

Returns the right-tailed or two-tailed Student's t probability (legacy name).

TDIST(x, deg_freedom, 1) is P(T > x) (T.DIST.RT) and TDIST(x, deg_freedom, 2) is P(|T| > x) (T.DIST.2T).

The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.

Syntax

=TDIST(x, deg_freedom, tails)

Arguments

ArgumentTypeRequiredDefault
xnumberRequired—
deg_freedomnumberRequired—
tailsnumberRequired—

How it works

A tails argument of 1 maps to T.DIST.RT(x, degrees_freedom). A value of 2 maps to T.DIST.2T(x, degrees_freedom). The legacy argument x must be nonnegative and degrees of freedom positive.

Remarks

  • deg_freedom and tails are truncated to integers.

Error cases

  • Returns #NUM! when x < 0, deg_freedom < 1, or tails is not 1 or 2.

Examples

Evaluate one upper tail of the Student t distribution.

Formula =TDIST(2,10,1)

Expected result 0.0366940173853702

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Evaluate both tails at the same statistic.

Formula =TDIST(2,10,2)

Expected result 0.0733880347707404

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

At the distribution center the two tails cover the full probability.

Formula =TDIST(0,10,2)

Expected result 1

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

The number of tails must be one or two.

Formula =TDIST(2,10,3)

Expected result #NUM!

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Two-tailed probability

Formula =TDIST(1.959999998,60,2)

Expected result 0.0546449299759204

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Implementation

Engine source

On this page