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

 

CHIINV(probability, degrees_freedom)

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

 probabilityThe probability associated with the chi-squared distribution.
 degrees_freedomThe number of degrees of freedom.

 REMARKS
 
  • If any of the arguments are not numeric, then #VALUE! is returned.
     
  • If "probability" < 0, then #NUM! is returned.
     
  • If "probability" > 1, then #NUM! 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 an iterative technique for calculating the result.
     
  • This function iterates until the result is accurate to within ± 3x10^-7.
     
  • If the iterative process does not converge after 100 iterations, then #N/A is returned.
     
  • The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (828313).

     EXAMPLES
     
     A
    1=CHIINV(0.5,2) = 1.39
    2=CHIINV(0.05,10) = 18.307
    3=CHIINV(0.05,10^10) = 200000.000
    4=CHIINV(1.01,10) = #NUM!
    5=CHIINV("some text",10) = #VALUE!
    6=CHIINV(0.5,"some text") = #VALUE!
     

     Functions - C | Index - C | Office Online 

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