T TNMAN Feb 8, 2005 #1 Is there a way to compute a least squares analysis for a series of data in excel 2003. Thanks in advance for any help.
Is there a way to compute a least squares analysis for a series of data in excel 2003. Thanks in advance for any help.
G Guest Feb 8, 2005 #2 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
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
B Bernard Liengme Feb 8, 2005 #3 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
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
