Bug#588471: openoffice.org-calc: mayer chart (statistique) wrong results
Hi Rene,
Here is what I could get out of the bug report.
On Fri, 2010-07-09 at 14:39 +0200, Rene Engelhard wrote:
> On Thu, Jul 08, 2010 at 09:18:07PM +0200, gbulot wrote:
> > look the array below
> > 0 1 2 4 6 10
> > 76 67 59 46 35 20
> >
> > Insert diagramme based on that data
>
> What diagram?
He meant, do the following steps:
* Select all the data
* Click "Insert > Chart" menu
> > Choose the lines one
>
> OK; I've choosen the line diagram.
> With what options?
* Select the "Line" chart type and keep the default options
* Click "Next >>"
> > - 0, 1, 2, 4 on the bottom chart's
> > - 0 to 80 on the left
>
> And where did you specify that? "Data series in rows" "First row as label"=
* Select "Data series in rows"
> > 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)
>
> Then look? Don't assume people either can understand that sentence or
> do even know what you are going to do?
>
> But done.
* Click "Insert trend line" in the context menu
> > and check-in :
> > - Afficher l'équation
> > - Aficher le coeficient de détermination (R2)
>
* In the "Type" tab, check
* "Show equation"
* "Show correlation coefficient (R2)"
> What? Where? I get a line drawn at 50. What am I supposed to do here?
>
> > You'll see :
>
> I see nothing.
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...
Regards,
--
Cedric
Reply to: