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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #11 from Ming Hua <ming.v.hua at qq.com> ---
(In reply to Uwe Auer from comment #9)
> Just to make clear, how I calculate and understand the regression:
> 
>    f(x) = a * x^b
> -> ln (f(x)) = ln (a*x^b) = ln(a) + ln(x^b) = ln(a) + b*ln(x)
> 
> Now you use function() LINEST on natural logarithm of both axis an you get
> two coefficients:
> 
> [1] Slope - which is b
> [2] Intercept - which is ln(a)
> 
> Hence you need to exp(ln(a)) to get a.
Thanks for the explanation.

But all of these are not easily deductible from either the Data > Statistics >
Regression... dialog or the help page [1].  Some improvement on documentation
is probably in order.

1.
https://help.libreoffice.org/latest/en-US/text/scalc/01/statistics_regression.html

-- 
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/215a9008/attachment.htm>