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
| Argument | Type | Required | Default |
|---|---|---|---|
x | number | Required | — |
deg_freedom | number | Required | — |
tails | number | Required | — |
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_freedomandtailsare truncated to integers.
Error cases
- Returns
#NUM!whenx < 0,deg_freedom < 1, ortailsis 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?.