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'.

"Mike Middleton" wrote:

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


"sstexas" wrote in message
...
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!!