https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #12 from [email protected] ---
(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.
Thank you Uwe for all your posts and answers! That really clarified the matter.
Though I wish libreoffice didn't have to let us do more computations which it
could've done for us. Maybe a note in the help page as to how to use the
results from the power reg would be helpful :-D
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
