https://bugs.freedesktop.org/show_bug.cgi?id=87790
Bug ID: 87790
Summary: Unexpected values in evaluating R2 using regr.lin
(linear fit)
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
When fitting a series of (x,y) data with a function a * x + b, everything
(slope, intercept, correlation) seems ok (check done by comparison with excel
and by evaluaton using the standatd formulas in any book). Changing axis so
that the first (x,y) is in the origin and fitting with a * x' the slope is ok,
but the correlation is wrong, It is neither the Pearson correlation nor the
explained variance vs the total variance. The result is in disagreement with
what found in excel or by evlautaion with standard formula
I do not understand if there is a bug in the function or if the meaning of r2
is nn clearly eplaine in the on line manual
--
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
