https://bugs.documentfoundation.org/show_bug.cgi?id=129398
Bug ID: 129398
Summary: LibreOffice Calc 6.3.3.2(x64) Trend Calculated
Y-Intercept Incorrect
Product: LibreOffice
Version: 3.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
After making a graph with spreadsheet data, when you insert a TREND LINE and
have CALC calculate the linear equation for the data, the Y-INTERCEPT is
incorrect. It appears to reflect the y-intercept of the visualized graph and
not of the data. Eg if your graph has an x-axis starting at other than zero it
will give the y-intercept as if the first datapoint were x=0.
Steps to Reproduce:
1. Have graph data, eg one column of 11..20 (x) and another of 11..20 (y)
2. Insert a graph of that data
3. Insert a trend line and show the equation. It is f(x)=x+10 WRONG instead of
f(x)=x (CORRECT)
4. Actually, less-simple data gives a wrong slope (m) for the equation as well,
so the entire algorithm might be wonky. Email for detailed examples and graphs.
Actual Results:
see above
Expected Results:
see above
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
