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 680918 - INTERPOLATION (linear with averaging) problem
INTERPOLATION (linear with averaging) problem
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
git master
Other Linux
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2012-07-31 15:56 UTC by Andreas J. Guelzow
Modified: 2012-07-31 19:39 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
sample file (1.78 KB, application/gnumeric)
2012-07-31 15:56 UTC, Andreas J. Guelzow 		Details

Description Andreas J. Guelzow 2012-07-31 15:56:31 UTC 
Created attachment 219995 [details]
sample file

In the attached file, I don't think that F2 should be #NUM! (but perhaps 4.5?)

Much less importantly, I don't quite understand the added description:
"The values returned are the averages of the interpolation on each interval."
Do we mean:
"The values returned are the averages of the interpolated values for consecutive targets."?
Comment 1 Andreas J. Guelzow 2012-07-31 16:16:15 UTC 
Of course if "The values returned are the averages of the interpolated values for
consecutive targets." were right, why aren't we just using linear_interpolation and then average results afterwards (in linear_averaging)?
Comment 2 Jean Bréfort 2012-07-31 19:05:23 UTC 
no, it is actually the average of all possible values between two consecutive target. The integral is evaluated and divided by the interval length.

In the sample, F2 should be 4.5.
Comment 3 Jean Bréfort 2012-07-31 19:39:14 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.