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

CHIDIST(x, degrees_freedom)

 
 Returns the one tailed probability of the chi-squared distribution.

 xThe value at which you want to evaluate the distribution.
 degrees_freedomThe number of degrees of freedom.

 REMARKS
 
  		• If "x" < 0, then #NUM! is returned.
     
  		• If "x" or "degrees_freedom" 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" = 10^10, then #NUM! is returned.
     
  		• This function uses the following formula P(X>x), where X is a ?2 random variable ???

     EXAMPLES
     
     A
    1=CHIDIST(18.307,10) = 0.050
    2=CHIDIST(2,2) = 0.37
    3=CHIDIST(-1,2) = #NUM!
    4=CHIDIST(15,"some text") = #VALUE!
    5=CHIDIST("some text",2) = #VALUE!
    		 
     Functions - C | Index - C | Office Online 

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