GNOME Bugzilla – Bug 68057
F test significance gives #VALUE
Last modified: 2004-12-22 21:47:04 UTC
In the regression analytics, I'm getting #VALUE immediately below "Significance of F". If this is the p-value of the F stat, R gives a real value for the same data. Also, would it be possible to add a checkbox "expand columns to fit"? For new sheets it would be cool if I didn't have to re-size columns right after making the regression test. cheers, adrian
adding an expand column to fit checkbox is probably a good idea for all analysis tools. Currently some autofit some don't. About #Value: Does this happen to you all the time? Could you attach a sample sheet that couses this problem? Which valuedoes R calculate for that data? Thanks
If it were possible, I would also reassign this bug to me.
1) new gnumeric 2) B4:b13 gets 1,2,3...10 3) C4:C13 gets 23,43,23,43,45,56,67,98,... 4) select a1 5) Tools->Data Analysis -> regression 6) xvar gets B's 7) yvar gets C's 8) ok --> in new sheet regression the #value appears. did jody change this needinfo->new because he got this also? cheers, adrian
I can repeat that (even if I don't quite know what the y values really are). The bug really in the calculation of finv since even the finv function has this problem: =finv(0.025,1,8) evaluates to #VALUE!
a diff implementing the enhancement of an `autofit columns' checkbox in all analysis tools has been submitted to Jody. finv(0.025, 1, 8) gives 7.570882 on Morten's Sparc system.
Initial debugging suggests that this is caused by "gcc 2.96" (red hat or mandrake) miscompiling function qbeta in mathfunc.c
Confirmed.
Just to set the record straight: this was not a gcc 2.96 problem it tuned out that most linux systems were not recognized as IEEE systems and as a consequence some slightly buggy code was used. THe configuration has been corrected so that w enow also look for ieee754,h header files as replacement to ieeefp.h. Moreover the requested autofit enhancement has been committed to cvs.