Linear regression in spreadsheet

[valterb]

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

[jgd]

Beautiful
I'll add a note in the Wiki to morrow. Slowly…
Thanks

Jacqueline

[jgd]

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

[sardisson]

I added the screenshot to the wiki and used it as an illustration for the French article; I hope that's OK

Smokey

[jgd]

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