Apache OpenOffice (AOO) Bugzilla – Issue 97439
linear regression passing through a point
Last modified: 2017-05-20 09:52:56 UTC
hi,I report a lack of calc. it is not possible choose the intercept when i do a linear regression.
please attach an example.
For charts it is the bug 34093 for linear regressions, and bug 77932 for other regressions. For the spreadsheet itself you can use a workaround: Translate your data points so that the desired point moves into the origin. Then calculate the regression line in the variant with "force through origin". And then translate the result back.
Duplicate per comment 2 *** This issue has been marked as a duplicate of issue 34093 ***