Apache OpenOffice (AOO) Bugzilla – Issue 110707
Sine regression trend line
Last modified: 2014-03-02 15:43:36 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.
Can you please tell me, where I find "sine fitting" in Excel?
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.
@IHA: One more issue for your "enhancement collection"
Confirmed with AOO410m14(Build:9760) - Rev. 1573062 2014-03-01_04:11:01 - Rev. 1573123 Debian