[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