[Libreoffice-bugs] [Bug 114826] Different Results Calculating Logarithmic Regression with two methods of Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

Dennis Francis <dennisfrancis.in at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |ASSIGNED
     Ever confirmed|0                           |1

--- Comment #3 from Dennis Francis <dennisfrancis.in at gmail.com> ---
I can confirm the differences in results between LOGEST() and that via
statistics menu's regression option. I can confirm that the LOGEST function is
computing the right answers (compared with Excel online). The formulas
generated by the statistics regression tool for logarithmic regression seems to
have mixed up the roles of X and Y variables for computing slope, intercept and
standard error. I need to compare the results of statistics tool box of Excel
desktop (not the free online version as it does not seem to have toolboxes), to
decide on what the acceptable behaviour should be.

-- 
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/20180617/8c1d56dc/attachment.html>