91187
2008-06-29 05:37:57 +0000
Power Regression isn't useful in current form
2013-02-24 21:20:30 +0000
1
1
3
Code
General
chart
3.3.0 or older (OOo)
Unknown
All
CLOSED
DUPLICATE
20819
P3
Trivial
---
0
nino
thomas.klarhoefer
issues
issues
DEFECT
---
---
0
oldest_to_newest
1067004
0
nino
2008-06-29 05:37:57 +0000
Hi gang,
I realize that trendline plotting and display is currently being worked on and
I'm hoping that one of the developers notes my comments.
In its current form, plotting a trendline using the "power" option (versus
logarithm, linear, etc) isn't terribly useful. In general the user should be
able to decide the order of the polynomial being used (e.g. 2nd order, 3rd, 4th,
5th, etc). Having Calc/Chart _only_ using a 2nd order polynomial is pretty
useless. Generally speaking, a best-fit analysis is performed on the order of
polynomial chosen to be used and then the curve is plotted and the equation
revealed.
In MANY cases that I've encountered, a higher order polynomial is required.
The logic for determining the 2nd order polynomial equation that best fits
should be able to be ported to an nth-order polynomial so the work shouldn't be
too difficult.
I'd recommend a greyed-out user input field on the GUI used when determining the
type of curve fit - if polynomial is chosen, then the greyed-out box becomes
active and the user can input the order of polynomial chosen and then OO goes
off and does its thing. This is similar to how Excel works and, in general,
other curve-fitting packages.
I wouldn't call this an enhancement as the current form isn't really useful
until it can do higher order polynomials.
TIA,
enmane
1067005
1
thomas.klarhoefer
2008-07-03 12:43:33 +0000
duplicate
*** This issue has been marked as a duplicate of 20819 ***
1067006
2
thomas.klarhoefer
2008-07-04 15:43:16 +0000
closed, double