To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102859 Issue #|102859 Summary|Trend Lines in scatter plot is wrong Component|Spreadsheet Version|OOO310m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|taesuk
------- Additional comments from tae...@openoffice.org Wed Jun 17 07:29:00 +0000 2009 ------- I drew a x-y scatter plot and added trend line with linear option and showed equation. It should be y = 10.21x + 83.416 but open office gives 5.5x + 165.32. Also R^2 is different. Excel gives 0.385 but open office gives 0.33. I think it is a bug that should be fixed ASAP because linear trend estimation is very popular and common tool. Please check the problem with following data. y x 115.22 3.69 135.98 4.39 119.34 4.75 114.96 6.03 187.05 12.47 243.92 12.98 267.43 14.2 238.71 14.76 295.94 15.32 317.78 16.39 216 17.35 240.35 17.77 386.57 17.93 261.53 18.43 249.34 18.55 309.87 18.8 345.89 18.81 165.54 19.04 196.98 19.22 395.26 19.93 406.34 20.13 171.92 20.33 303.23 20.37 377.04 20.43 194.35 21.45 213.48 22.52 293.87 22.55 259.61 22.86 323.71 24.2 275.02 24.39 109.71 24.42 359.19 25.2 201.51 25.5 460.36 26.61 447.76 26.7 482.55 27.14 438.29 27.16 587.66 28.62 257.95 29.4 375.73 33.4 --------------------------------------------------------------------- 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...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org