CHIINV

[westfox09]

I have some questions on CHIINV() computation on Excel.

According to the help files:
If degrees_freedom is not an integer, it is truncated.
If degrees_freedom < 1 or degrees_freedom = 10^10, CHIINV returns the #NUM!
error value.

Why do I get #NUM! error when I compute values like CHIINV(0.1,5000) or
CHIINV(0.1,8^5). Isn't 10^10 the limit? Sorry for my shallow understanding of
this statistic formula and Excel...

 

[Mike Middleton]

westfox09 -

For some past discussions, browse to groups.google.com and search for "excel
chiinv function" (without the quotes).

The first thread returned from google groups has Dave Braden's workaround,

=GAMMAINV(1-x,deg_freedom/2,2),

and a link to Ian Smith's more-accurate VBA code, at

http://members.aol.com/iandjmsmith/Examples.xls

- Mike
http://www.mikemiddleton.com