[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127517

Laurent BP <jumbo4444 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #7 from Laurent BP <jumbo4444 at yahoo.fr> ---
(In reply to Buovjaga from comment #6)
> Laurent: can you comment on this?
Excel chart is wrong ;-)
Scientific article Attachment 91622 of bug 73374 explain why Excel calculation
is wrong: it can give negative R²
In case of forced intercept, a different calculation must be used, as LINEST
function does (in LibO and Excel).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200830/5f2aefa7/attachment.htm>