Thread: how do i calculate least-square regression analysis?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default 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
Reply With QuoteReply With Quote