Apache OpenOffice (AOO) Bugzilla – Issue 28458
need way to access regression formula
Last modified: 2013-02-24 21:18:54 UTC
There is a very pretty set of regression fit tools to draw a best-fit line on XY graphs. But there seems to be no way to obtain the equation used for the line. Some sort of accessibility would be helpful. I can think of a range of possibilities, from a display option on the graph to a matching spreadsheet function that would return a suitable formula in a cell.
Hi, Spreadsheet is the wrong component. I changed it to Chart instead. Also it's probably a double and fixed in the upcomimng new chart module. Frank
Hello Frank: "Spreadsheet is the wrong component. I changed it to Chart instead" I can understand why you did that, but it presumes that the fix is to do it in the chart. I originally chose "spreadsheet" as offering a wider range of possibilities - like doing it in the sheet without having to draw a chart at all.
yep, is an duplicate. *** This issue has been marked as a duplicate of 366 ***
closed as duplicate
Please note this issue has been incorrectly identified as a duplicate os Issue 366, which is an RFE on defining custom ranges for error bars, and has nothing to do with regression analysis. This confusion is resulting in inappropriate comments being filed in Issue 366 by confused members, which is beginning to effectively cloud Issue 366. Thank you.