Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Sine regression trend line|
|Component:||chart||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P4||CC:||elish, issues, rb.henschel|
|Version:||3.3.0 or older (OOo)|
|Issue Type:||FEATURE||Latest Confirmation in:||4.1.0-dev|
Description scmathes 2010-04-08 19:34:01 UTC
Please add trigonometric (sine) regression trend line as there are no periodic data fitting models in Chart. Excel has sine fitting which is nice, and would be great as a starting point. What would be SUPER nice and would blow Excel out of the water for data fitting would be compound curve fitting, to be able to select 2 models at a time, as to model something like damped spring oscillations (exponential sine function) or monthly mean temperature data over decades (seasonal sine changes superimposed on linear warming trend). Composite models may be shooting for the stars,but as a start Sine modeling would still be very useful for everything from high school statistics to engineering or environmental scientists.
Comment 1 Regina Henschel 2010-04-08 20:06:03 UTC
Can you please tell me, where I find "sine fitting" in Excel?
Comment 2 scmathes 2010-04-09 00:54:08 UTC
Oops, you're right regina, it's not Excel that can do Sine regression, it's the TI-83 I also use for teaching types of regression curves. Regardless, it is a useful family to be able to model.
Comment 3 kla 2010-04-09 08:24:51 UTC
@IHA: One more issue for your "enhancement collection"
Comment 4 Edwin Sharp 2014-03-02 15:43:36 UTC
Confirmed with AOO410m14(Build:9760) - Rev. 1573062 2014-03-01_04:11:01 - Rev. 1573123 Debian