[Libreoffice-bugs] [Bug 117318] Wrong SIGMA SLOPE value calculated with LINEST function

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Pablo Wagner <pablofabian.wagnerboian at gmail.com> ---
(In reply to Regina Henschel from comment #5)
> Find the definition of the function LINEST at
> http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.
> html#LINEST.

Everything seems OK there. But still, fSigmaSlope = fRMSE / sqrt(fSumX2) is
wrong, since it's not giving the right value. 

According to the specs in the link provided, sigma_slope should be S_m as in:
http://pages.mtu.edu/~fmorriso/cm3215/UncertaintySlopeInterceptOfLeastSquaresFit.pdf
page 5 (quick Google search).

-- 
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/20180428/cff7c50e/attachment.html>