Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > TDIST

 

TDIST(x, degrees_freedom, tails)

 
 Returns the percentage points probability for the Student t-distribution.

 xThe numeric value at which to evaluate the distribution.
 degrees_freedomThe number indicating the number of degrees of freedom.
 tailsThe number of distribution tails to return.

 REMARKS
 
  • The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution.
     
  • If any of the arguments are 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 "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.
     
  • Example 1 - This is the probability of a value equal to or greater than 1.96 with 10 degrees of freedom.

     EXAMPLES
     
     A
    1=TDIST(1.96,10,1) = 0.039
    2=TDIST(1.96,60,2) = 0.055
    3=TDIST(2,1,1) = 0.148
     

     Functions - T | Index - T | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top