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 
* 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 onetailed distribution is used. * If "tails" = 2, then the twotailed 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.microsoft.com 

1  This is the probability of a value equal to or greater than 1.96 with 10 degrees of freedom. 
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top