https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #13 from edwardson...@protonmail.ch ---
(In reply to Ming Hua from comment #11)
> (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
Yes. Would be good to put more details in help page / documentation.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
