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 550933 - LINEST gives wrong standard error
LINEST gives wrong standard error
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: 2008-09-05 02:55 UTC by Andreas J. Guelzow
Modified: 2009-07-01 22:29 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
screenshot showing the problem (65.43 KB, image/png)
2008-09-09 03:01 UTC, Andreas J. Guelzow 		Details

Description Andreas J. Guelzow 2008-09-05 02:55:39 UTC 
When the y-intercept is forced to zero, LINEST should not return a standard error for the intercept. The intercept is correctly returned as 0, but it is given a standard error (which is equal to the standard error of the "last" slope).
Comment 1 Andreas J. Guelzow 2008-09-09 03:01:55 UTC 
Created attachment 118344 [details]
screenshot showing the problem

The attached image shows the value (marked by an arrow) that should be 0 (or
for compatibility with XL, should be #N/A).
Comment 2 Andreas J. Guelzow 2009-07-01 22:29:01 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.