[sc-issues] [Issue 113105] Calc: mayer chart (statis tique) wrong result
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113105 User regina changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from reg...@openoffice.org Tue Jul 13 11:53:41 + 2010 --- Closing. - 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
[sc-issues] [Issue 113105] Calc: mayer chart (statis tique) wrong result
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113105 User regina changed the following: What|Old value |New value CC|'cedricbosdo' |'cedricbosdo,regina' Status|NEW |RESOLVED Keywords| |oooqa Resolution| |WORKSFORME --- Additional comments from reg...@openoffice.org Tue Jul 13 11:50:53 + 2010 --- You are likely using the wrong chart type. You have to use the type "XY (Scatter)". See help for "Trend Lines" and there the paragraphs marked with a pin. - 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
[sc-issues] [Issue 113105] Calc: mayer chart (statis tique) wrong result
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113105 --- Additional comments from to...@openoffice.org Tue Jul 13 01:53:08 + 2010 --- I get the same results in Gnumeric that OpenOffice does. On Vista (Gnumeric 1.9.1) and Ubuntu 9.04 (Gnumeric 1.8.4) TomW - 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
[sc-issues] [Issue 113105] Calc: mayer chart (statis tique) wrong result
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113105 Issue #|113105 Summary|Calc: mayer chart (statistique) wrong result Component|Spreadsheet Version|OOo 3.2 Platform|Unknown URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|rene --- Additional comments from r...@openoffice.org Mon Jul 12 22:24:25 + 2010 --- [ I still see it in (vanilla) m84 ] >From http://bugs.debian.org/588471: --- snip -- I'm start to use statistic in my school, my teacher said me my result are wrong I show him My result and surprise he confirm OpenOffice Wrong Result for the +exercice ! Ms Office works well, and manual resolution confirme Ms office result. look the array below 0 1 2 4 6 10 76 67 59 46 35 20 Insert diagramme based on that data Choose the lines one - 0, 1, 2, 4 on the bottom chart's - 0 to 80 on the left right-click on the shape to choose 'Inserez une coube de valeur moyenne' (Yes +it's the french version) (i don't know the english sentense) and check-in : - Afficher l'équation - Aficher le coeficient de détermination (R2) You'll see : - f(x)= -11,1142[...]+89,4 - R2=0.989 _BUT_ - f(x) sould be -5.5[] + 71,80 - the shape does not cross the ordinate (Oy) at ~17,8 or 89,9 but +approximatively at 86 ! --- snip --- Cédric thankfully translated the french and added some comment. I can confirm this, too (use the first line): --- snip --- He meant, do the following steps: * Select all the data * Click "Insert > Chart" menu [...] * Select the "Line" chart type and keep the default options * Click "Next >>" [...] * Select "Data series in rows" [...] * Click "Insert trend line" in the context menu [...] * In the "Type" tab, check * "Show equation" * "Show correlation coefficient (R2)" [...] Oh, I have the trend line added and its equation and they fit what is in the bug report. However, I reproduced the very same procedure on Excel 2007 and I got the same results... I suspect that there is either something forgotten in the bug report or something done differently in Excel... --- snip --- - 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 --
