After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 607008 - TDIST: unnecessary Excel incompatibility
TDIST: unnecessary Excel incompatibility
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
git master
Other All
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2010-01-14 20:09 UTC by Andreas J. Guelzow
Modified: 2010-01-20 20:15 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Andreas J. Guelzow 2010-01-14 20:09:41 UTC 
In Excel 2007 (and OOo), if x is negative TDIST(x,df,tails) returns an error,w hile we returning a value. 

For example
TDIST(-1,10,1) is an error in Excel and OOo but 0.82955 in Gnumeric.
Similarly
TDIST(-1,10,2) is an error in Excel and OOo but 0.34089 in Gnumeric.

This example also shows that our brahviour is a touch strange for negative x: we are returning the _right_ tail for tails=1 and both tails for tails=2, so the right tail for very negative x is larger than the two tails version.

Since we have the properly behaved r-calling convention functions I would suggest to change this function to match Excel 2007.
Comment 1 Morten Welinder 2010-01-20 01:58:21 UTC 
I see no good reason to keep our behaviour (which is probably a coincidence
of implementation).
Comment 2 Morten Welinder 2010-01-20 20:15:44 UTC 
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.