https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #15 from Uwe Auer ---
Created attachment 172638
--> https://bugs.documentfoundation.org/attachment.cgi?id=172638=edit
Power Regresssion Methods - Comparision of Coefficients
I'm not sure whether this is really a pure
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
Regina Henschel changed:
What|Removed |Added
CC||olivier.hallot@libreoffice.
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
> > ->
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #12 from edwardson...@protonmail.ch ---
(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) +
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #11 from Ming Hua ---
(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
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #10 from Uwe Auer ---
My conclusion - can't see any bug here.
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #9 from Uwe Auer ---
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
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #8 from Uwe Auer ---
(In reply to edwardsontan from comment #5)
> The following is the dataset that I was working on and which first alerted
> me to the problem.
>
> X Y
> --
> 240 57
> 280 48
> 320 40
>
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #7 from Uwe Auer ---
(In reply to Ming Hua from comment #4)
> (In reply to m.a.riosv from comment #2)
> > Please can you attach the example file?
> I don't think an example file is really needed, as this regression analysis
>
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #6 from Uwe Auer ---
EXP(1.57125263268399) = 4.81267293100676
And that's exactly what the trend line equation shows, when you insert a trend
line in a chart of your data.
--
You are receiving this mail because:
You are the
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #5 from edwardson...@protonmail.ch ---
The following is the dataset that I was working on and which first alerted me
to the problem.
X Y
--
240 57
280 48
320 40
360 35
400 30
500 25
600
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #4 from Ming Hua ---
(In reply to m.a.riosv from comment #2)
> Please can you attach the example file?
I don't think an example file is really needed, as this regression analysis
feature is based on UI, not formulas.
Steps
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #3 from edwardson...@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
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
m.a.riosv changed:
What|Removed |Added
CC||miguelangelrv@libreoffice.o
https://bugs.documentfoundation.org/show_bug.cgi?id=142643
Ming Hua changed:
What|Removed |Added
Blocks||111310
CC|
15 matches
Mail list logo