https://bugs.freedesktop.org/show_bug.cgi?id=73374
Priority: medium
Bug ID: 73374
Assignee: [email protected]
Summary: EDITING: R^2 calculation of trendline with forced
intercept is not correct
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.0.1 rc
Component: Chart
Product: LibreOffice
Created attachment 91622
--> https://bugs.freedesktop.org/attachment.cgi?id=91622&action=edit
Article with detail of calculation in case of forced intercept
Problem description:
Steps to reproduce:
1. Enter data: X=1, 2, 3 and Y=11, 12, 13
2. Select data and create XY chart
3. Insert a linear trend line with forced intercept and show R^2
Current behavior:
R^2=0 because it is calculated with the same formula as with free intercept and
gives a negative value, like Excel 2003 does.
Expected behavior:
R^2 should not be calculated with the same formula in case of forced intercept.
Attached article give the correct formula in case of forced intercept: (4')
instead of (4)
Operating System: All
Version: 4.2.0.1 rc
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
