Multiple Regression Analysis

[Guest]

Can multiple regression be done in Excel? I read a book last month that said
you had to use SPSS or SAS to do it. But a book I am reading today says that
it can be done in Excel (though it doesn't say how it is done).

The example in the book uses Sales (Y), Advertising (X1) and Price (X2) - so
it's pretty simple. Does anyone know if this can be done in Excel and, if
so, how it is done? This would be a great forecasting tool for me. Thanks!!

 

[N10]

Can multiple regression be done in Excel? I read a book last month that
said
you had to use SPSS or SAS to do it. But a book I am reading today says
that
it can be done in Excel (though it doesn't say how it is done).

The example in the book uses Sales (Y), Advertising (X1) and Price (X2) -
so
it's pretty simple. Does anyone know if this can be done in Excel and, if
so, how it is done? This would be a great forecasting tool for me.
Thanks!!

Hi

Here is a reference for you for an off the shelf solution

http://www.analyse-it.com/multiple-linear-regression_y.htm


Regards N10

 

[Mike Middleton]

sstexas -

The Regression tool of Excel's Analysis ToolPak (and the LINEST worksheet
function) can handle multiple regression with up to sixteen explanatory
variables. The Analysis ToolPak add-in is included on the installation disk
of all versions of Excel.

- Mike
http://www.MikeMiddleton.com

 

[Guest]

I know how to use the regression tool, but it only allows for an X and Y
variable. How can you get it to take 16 explanatory variables?

 

[Guest]

I figured out how to enter more than one X variable from a 9/24/05 posting...
thanks so much for the heads-up on multiple regression in Excel!

To specify multiple independent variables simply specify the larger
range. For example, if the values for the three indepdendent variables
are in A2:C23, specify that as the range for the 'Input X Range'.