To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=7998
------- Additional comments from [EMAIL PROTECTED] Sat Sep 29 14:16:44 +0000 2007 ------- I'm sorry you developers got flamed by people who profess to study statistics and who don't appear know how to substitute the slope and intercept into Y=mX+b in a text cell to one side of the graph. Hell, it can even be automated to a certain extent using the text, slope, and intercept functions already in Calc. Like so: ="Y=" & ROUND(SLOPE(A2:A22;B2:B22),2) & " X + " & ROUND(INTERCEPT(A2:A22;B2:B22),2). For R^2, use this: ="R-square ="&ROUND(INDEX(LINEST(A2:A22;B2:B22;1;1);3;1);2) For me, that equation box would be nice to have, but it's not a deal killer. Seems to me that there are a few scientists commenting here who need to broaden their horizons and learn to use the rest of their spreadsheet formulas. But, as others have said, I'd like to have the means to display more than one regression line on the graph. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
