Apache OpenOffice (AOO) Bugzilla – Issue 5085
extrapolate regression lines (extend trendlines) (forward/backward forecast)
Last modified: 2013-09-25 20:42:04 UTC
There should be some way to not only display the equation for a trendline, but also to cast it backwards and forwards. Often when charting experimental data, it is useful to find the slope and x or y intercepts.
This issue is defintely a must. It should be implemented as soon as somebody has the time. I'm give my vote.
This is a dup of 5289
duplicate *** This issue has been marked as a duplicate of 5289 ***
closed
reopen this one because the duplicate is a much to huge container bug - this one can better be handled because it concentrates on a single feature.
->bm: Please take care of this issue.
*** Issue 4509 has been marked as a duplicate of this issue. ***
accepted as a feature task for implementing the extrapolation of trendlines (regression curves)
*** Issue 56578 has been marked as a duplicate of this issue. ***
added 'trendline' to summary for better searching
added '(forward/backward forecast)' to summary for easier finding this issue
Created attachment 36094 [details] xls
Created attachment 36095 [details] png
Created attachment 36096 [details] png
*** Issue 90692 has been marked as a duplicate of this issue. ***
change owner
reset to new
I voted for this issue, but resolving the problem that is brought up in the duplicate issue 90692 is far more important to me. Extending trend lines beyond the range of data plotted in a nice feature, but extending trend lines beyond the plotted data is statistically inappropriate in most cases. I would suggest that plotting the trend line so that it does not extend beyond the plotted values should be the default.