<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - LibreOffice Calc power regression coefficients error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142643#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - LibreOffice Calc power regression coefficients error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142643">bug 142643</a>
from <span class="vcard"><a class="email" href="mailto:edwardsontan@protonmail.ch" title="edwardsontan@protonmail.ch">edwardsontan@protonmail.ch</a>
</span></b>
<pre>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 <a href="show_bug.cgi?id=142643#c2">comment #2</a>)
<span class="quote">> Please can you attach the example file?</span ></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>