Hi Paul,
To whom it may concern, I recently installed Debian on an old box I had, learned everything to date I know about Linux, and promptly typed out an advanced chemistry lab report in Calc, created graphs to prove that flipping coins had a 50% reaction rate when turning heads to tails, created best fit lines, and ground to a screeching halt when I went to add the regression statistics to the graphs. By regression statistics I mean the following: In Microsoft Excel one can add the equation and accuracy (r^2) value of a given regression type (linear, power, etc.) to a graph. This is highly useful for determining the best regression for a given graph. While it is currently possible to use linest or another function to evaluate the accuracy of a regression, it is not convenient nor visually appealing, nor on the graph itself.So. I have experience in Java and figured that since open office is open source, there probably was something I could do about this. I have a few preliminary questions about this endeavor: #1 I've done some internet searching and haven't found how to add regressions to graphs except possibly by macro. I'm assuming this is in fact something that cannot be currently done... if someone with some programming insight or a lot more experience with open office than myself could let me know if I've simply missed how to do this it would be great. In other words: is this in fact a feature yet to be implemented or did I miss it?
Insert Statistics or the tab Statistics of the properties of a data series is the place to create regression curves.
Note, that there is an Issue [1] in OOo 2.2, that only linear regression lines are painted, the other types are missing. It is fixed but not yet available as a patch. It will get into OOo 2.2.1.
Showing formulas and the r^2 value is on the list [2] but not implemented yet.
Regards, -Bjoern [1] http://www.openoffice.org/issues/show_bug.cgi?id=75991 [2] http://www.openoffice.org/issues/show_bug.cgi?id=7998 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
