TDIST(x, degrees_freedom, tails)

Returns the percentage points probability for the t distribution.

xThe number from the distribution.
degrees_freedomThe number of degrees of freedom.
tailsThe number of distribution tails to return:
1 = one tailed distribution
2 = two tailed distribution

Remarks

* T.DIST was added in Excel 2010 to include a 'cumulative' argument.
* T.DIST.RT was added in Excel 2010 to replace this function when "tails" = 1.
* T.DIST.2T was added in Excel 2010 to replace this function when "tails" = 2.
* The t distribution is a continuous distribution.
* If "x" is not numeric, then #VALUE! is returned.
* If "degrees_freedom" is not an integer, it is truncated.
* If "degrees_freedom" < 1, then #NUM! is returned.
* If "degrees_freedom" is not numeric, then #VALUE! is returned.
* If "tails" is not an integer, it is truncated.
* If "tails" = 1, then the one-tailed distribution is used.
* If "tails" = 2, then the two-tailed distribution is used.
* If "tails" is any value other than 1 or 2, then #NUM! is returned.
* If "tails" is not numeric, then #VALUE! is returned.
* In Excel 2010 the accuracy of this function was improved.
* For the Microsoft documentation refer to support.office.com

 A
1=TDIST(0.1,1,1) = 0.468
2=TDIST(0.1,1,2) = 0.937
3=2*TDIST(0.1,1,1) = 0.937
4=TDIST(0.5,1,1) = 0.352
5=TDIST(1,1,1) = 0.250
6=TDIST(1,1,2) = 0.500
7=TDIST(1.5,1,1) = 0.187
8=TDIST(2,1,1) = 0.148
9=TDIST(2.5,1,1) = 0.121
10=TDIST(5,1,1) = 0.063

1 - This is the probability of a value equal to or greater than 1.96 with 10 degrees of freedom.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top