https://bugs.freedesktop.org/show_bug.cgi?id=75538
Priority: medium
Bug ID: 75538
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Other: R^2 of trend line is calculated wrong when
forced through a defined y-value.
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: e325...@rtrtr.com
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.1.1 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 94778
--> https://bugs.freedesktop.org/attachment.cgi?id=94778&action=edit
example-picture of wrong calculated R^2 with trend lines of an x/y-plot.
Problem description:
Steps to reproduce:
1. take numbers (x, y) and plot them.
2. plot the trend line ans let libreoffice show the correlation coefficient
(correct)
3. let the trend line go through zero or another value and get strange R^2's.
Current behavior:
R^2 can be bigger than 1, if the correlation gets worse.
Expected behavior:
R^2 is defined as a value between 0 and 1. If the correlation gets worse, the
vlaue should become smaller.
Operating System: Fedora
Version: 4.2.1.1 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
