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 607562 - TRIMMEAN: unnecessary Excel incompatibility
TRIMMEAN: 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-20 16:15 UTC by Andreas J. Guelzow
Modified: 2010-01-20 19:48 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Andreas J. Guelzow 2010-01-20 16:15:34 UTC 
A1 to A5: 1,2,2,2,5
A7 =TRIMMEAN(A1:A5,1)

yields #NUM! in Excel 2007 (and OOo)
but yields 2 in Gnumeric. 

I see what is happening in that we exclude the bottom 50% (rounded down to 2 observations) and the top 50% (rounded down to 2 observations), so are left with the middle observation.

If we replace the 1 with a 0.99 both Gnumeric and Excel yield 2.
Comment 1 Morten Welinder 2010-01-20 19:35:55 UTC 
Hmm...

We probably need to first compute the total number of observations to
ignore, then split them between left and right.

This needs investigation.
Comment 2 Morten Welinder 2010-01-20 19:48:03 UTC 
No, it's simpler.  It's just the "1" case.

Error value was wrong too.

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.