how do i calculate least-square regression analysis?
 

Guys,

please help me. thx.

Cheers,
Mie Mie

how do i calculate least-square regression analysis?
 

We need more details: are you fitting to a linear function? what info do you
want?
Please tell us more so we can hep.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Mie Mie" <Mie wrote in message
...
Guys,

please help me. thx.

Cheers,
Mie Mie

how do i calculate least-square regression analysis?
 

On Mon, 8 Oct 2007 03:13:00 -0700, Mie Mie <Mie
wrote:

Guys,

please help me. thx.

Cheers,
Mie Mie


Look at the LINEST function.

LINEST calculates the statistics for a line by using the "least squares" method
to calculate a straight line that best fits your data, and then returns an
array that describes the line.

It will return the values for the line, as well as, optionally, additional
regression statistices.
--ron