Least Squares Analysis

[TNMAN]

Is there a way to compute a least squares analysis for a series of data in
excel 2003. Thanks in advance for any help.

 

[John Mansfield]

TNMAN,

Take a look at Excel's LINEST and TREND worksheet functions.

This Microsoft site explains how to perform a regression analysis:

http://office.microsoft.com/en-us/assistance/HA011119631033.aspx

 

[Bernard Liengme]

For situations that LINEST cannot handle you can use Solver to do a
least-squares fit.
Do you wish to tell us more about the problem?
best wishes