77932
2007-05-30 12:30:55 +0000
Regression Curves - force through zero
2013-09-25 20:41:29 +0000
1
1
3
Code
General
chart
3.3.0 or older (OOo)
PC
Windows XP
CONFIRMED
ms_interoperability, oooqa
P3
Trivial
---
15522
1
vabijou
issues
issues
rb.henschel
stefan.weigel
tony.galmiche.ooo
ENHANCEMENT
---
---
4
oldest_to_newest
1798628
0
vabijou
2007-05-30 12:30:55 +0000
When adding a regression curve to data in a chart, there does not appear to be
any way to force the curves to run through the origin. Sometimes you want your
your curve to be a true best fit, but sometimes you want the curve to intersect
the origin, especially when performing a regression on a set of data from a
physical system that theoretically should pass through the origin.
1798629
1
rb.henschel
2007-05-30 13:49:07 +0000
For linear regression it is in issue 34093. Do you think of other types beyond
linear?
1798630
2
vabijou
2007-05-30 20:59:00 +0000
Yes, forcing the y-axis intercept to zero is applicable exponential curves as
well as the polynomial regression I proposed in Issue 77930.
1798631
3
rb.henschel
2007-05-30 21:16:01 +0000
Forcing to zero makes no sense for me for exponential curves. But if we get
polynomial regressions, it might be a useful feature.
1798632
4
rb.henschel
2007-05-30 21:17:53 +0000
Hope, it goes to chart now.
1798633
5
vabijou
2007-05-30 23:53:59 +0000
I am sorry. You are correct about forcing to zero not making sense for
exponential curves. However, Excel allows the user to force exponential curves
through values greater than zero, so including that option in Chart would be
appropriate.
1798634
6
thomas.klarhoefer
2007-05-31 15:16:21 +0000
@Iha: maybe a good idea.
1798635
7
paul8paul
2008-07-03 13:18:13 +0000
I agree. This is very important function for me as a science student. I can't
stop using Microsoft Office until I can do this in Open Office - at least for
linear regression. In fact in the interest of flexibility I think you should be
able to choose exactly where it intersects either axis.
I know there are scientific arguments for and against this function but what
difference does it make who is scientifically right or wrong. If this is a
function that users want to use then Open Office should be able to do it as
simply and quickly as possible.
1798636
8
paul8paul
2008-07-03 13:25:42 +0000
Its also necessary to be able to extrapolate the line as much as desired in
either direction.