#1   Report Post  
Amy Bass
 
Posts: n/a
Default CHIINV error

Hi - According to the Excel Help info, the CHIINV function should work with
degrees of freedom up to 10^10, but I get a #NUM error whenever the value is
greater than 1037. Example: CHIINV(0.95,1038) gives a #NUM error, as does
any other degrees of freedom value of 1038 or more. Can anyone help me with
this? (Am I doing something wrong?, or Is there a way to work around this
problem?) Thank you - Amy
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

I presume that for df10^10 Excel's code has a branch that explictly
returns an error. As you have discovered, even though the algorithm
tries to work, it overflows for much smaller df. Actually, there are
alternative formulas that improve as df increases, and achieve machine
accuracy long before df=10^10; see harlan's post and
http://www.library.adelaide.edu.au/d...fisher/281.pdf
for details.

Jerry

Amy Bass wrote:

Hi - According to the Excel Help info, the CHIINV function should work with
degrees of freedom up to 10^10, but I get a #NUM error whenever the value is
greater than 1037. Example: CHIINV(0.95,1038) gives a #NUM error, as does
any other degrees of freedom value of 1038 or more. Can anyone help me with
this? (Am I doing something wrong?, or Is there a way to work around this
problem?) Thank you - Amy


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Findlink Error D Moniz via OfficeKB.com Links and Linking in Excel 0 January 20th 05 05:53 PM
Error when entering and exiting excel Randy Excel Discussion (Misc queries) 1 January 11th 05 04:17 PM
Downloading Templates for Excel error with a windows error. Lanie Moore Excel Discussion (Misc queries) 0 December 21st 04 12:39 AM
#REF error Christen Excel Worksheet Functions 5 November 3rd 04 08:29 PM
CHIINV error Amy Excel Worksheet Functions 1 November 2nd 04 08:09 PM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"