To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102859
User taesuk changed the following: What |Old value |New value ================================================================================ Status|CLOSED |UNCONFIRMED -------------------------------------------------------------------------------- Resolution|WORKSFORME | -------------------------------------------------------------------------------- ------- Additional comments from tae...@openoffice.org Wed Jun 17 14:40:26 +0000 2009 ------- I input X and Y in the correct way. Do you think I exchange x and y? Of course, I changed X and Y location and drew xy plot. Previous x and y are my raw data. I correctly set X and Y in chart option and do regression in chart but it gives wrong coefficient and R^2. Did you try to plot and show linear trend and check the equation? Please try it with my data and comment!! OOs gives 5.5x+170.82 Excel gives 10.21x + 83.42 If chart gives Regression specific number of regression coefficient and r^2, i thought it is also a spreadsheet issue. It could be just a matter of chart, but many people including my students run the regression with chart not with SLOPE or INTERCEPT commend. By the way SLOPE and INTERCEPT commend give right answer : slope = 10.21 and intercept is 83.42. But Chart Linear Trend gives wrong equation and wrong R^2!! Please check the issue again. --------------------------------------------------------------------- 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: issues-unsubscr...@graphics.openoffice.org For additional commands, e-mail: issues-h...@graphics.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org