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 [email protected] 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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
