TDIST

TDIST(x, degrees_freedom, tails)

Returns the percentage points probability for the t distribution.

x	The number from the distribution.
degrees_freedom	The number of degrees of freedom.
tails	The 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.