View previous topic :: View next topic |
Author |
Message |
valterb The Anomaly (earlier version)

Joined: Sep 23, 2005 Posts: 463 Location: San Giuliano Terme, Pisa, Italy
|
Posted: Sat Nov 11, 2006 10:10 am Post subject: |
|
That's good reason to go slowly
Anyway, I have something to say more on drawing a regression line...
If you have more than one set of data you can put two or more regression lines , one for each set of data on the same diagram.
I edited the image because of some errors. Now is correct.
As you can see you can put two values typing just one command (LINEST) or , if you need just slope or intercept, type the function you want. Both methods need the same matrix (array).
Hope this help too.
Valter
Last edited by valterb on Sat Nov 11, 2006 3:04 pm; edited 1 time in total |
|
Back to top |
|
 |
jgd Agent Smith

Joined: Feb 27, 2005 Posts: 1531 Location: France
|
Posted: Sat Nov 11, 2006 11:29 am Post subject: |
|
Beautiful
I'll add a note in the Wiki to morrow. Slowly…
Thanks
Jacqueline |
|
Back to top |
|
 |
jgd Agent Smith

Joined: Feb 27, 2005 Posts: 1531 Location: France
|
Posted: Sun Nov 12, 2006 4:08 am Post subject: |
|
valterb,
Thanks. All added.
Note that the functions "SLOPE" (PENTE) and "INTERCEPT" (ORDONNEE.ORIGINE) are in Category Statistical while "LINEST" (DROITEREG) is in Category Array. A bit weird
Jacqueline |
|
Back to top |
|
 |
sardisson Town Crier


Joined: Feb 01, 2004 Posts: 4588
|
Posted: Sun Nov 12, 2006 12:20 pm Post subject: |
|
I added the screenshot to the wiki and used it as an illustration for the French article; I hope that's OK
Smokey _________________ "[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki |
|
Back to top |
|
 |
jgd Agent Smith

Joined: Feb 27, 2005 Posts: 1531 Location: France
|
Posted: Sun Nov 12, 2006 1:42 pm Post subject: |
|
Thanks. It's OK, very nice. I just added "Cliquez sur l'image pour l'agrandir", because the picture is a bit difficult to read.
Jacqueline |
|
Back to top |
|
 |
|