[Libreoffice-bugs] [Bug 142643] LibreOffice Calc power regression coefficients error

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Jun 4 08:54:52 UTC 2021


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

--- Comment #3 from edwardsontan at protonmail.ch ---
Top menu bar: Data > Statistics > Regression. Clicking on the Help button
brings up the example tabular x and y data that I used. The help page also has
the correct coefficients for linear, logarithmic and power regression. 
Also I think the cell with the label "LN(X1)" is mislabeled. In the same help
page it states that: "Power regression: Find a power curve in the form of y =
a.x^b, where a is the coefficient, b is the power that best fits the data." So
there shouldn't be any logarithmic operation performed on X. And further, after
a power regression has been performed, the result for "LN(X1)" is in fact b or
the intercept. The result for "Intercept" on other hand is a mystery. I don't
know how it fits into the equation y = a.x^b

(In reply to m.a.riosv from comment #2)
> Please can you attach the example file?

-- 
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/20210604/06a11cac/attachment.htm>


More information about the Libreoffice-bugs mailing list