Multiple Regression Analysis

[arte]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Please can someone give me brief step-by-step guidance to setting up a multiple regression analysis on excel 2008.

The aim is to verify the impact of several independent (x) variables on one dependent (y) variable.

Thanks,
Ron

 

[Mike Middleton]

Ron -

Browse to "Description of the LINEST function in Excel 2003 and in later
versions of Excel" at
http://support.microsoft.com/kb/828533

For other descriptions, browse to www.google.com, and search for "excel
linest function."

Mac Excel 2008 does not have the Regression tool of the Analysis ToolPak
(provided in previous versions of Excel), so I don't think it's possible to
provide "brief step-by-step guidance" in a newsgroup message. The guidance
would not be brief.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Carl Witthoft]

There are some other useful articles in various discussion boards
online. One of the nice things to learn is that, since all powers of x
are orthogonal, you can fit a polynomial by doing
LINEST(y,x^{1,2,3},...)

So, Google around a bit any you'll see how to do that as well as the
straightforward LINEST(y,x1,x2,x3,...) multivariable fit.