CHIINV

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

westfox09 - 10 Jan 2007 07:01 GMT

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...

Reply to this Message

Mike Middleton - 10 Jan 2007 20:40 GMT

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

>I have some questions on CHIINV() computation on Excel.
>
[quoted text clipped - 8 lines]
> of
> this statistic formula and Excel...

Reply to this Message

Rate this thread: