TDIST

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
* This function is only available for backwards compatibility and should not be used.
* 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.
* You can use the T.DIST function to
* You can use the T.INV function to
* You can use the T.INV.2T function to
* You can use the T.TEST function to
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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.

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