"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!!

Hi

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

http://www.analyse-it.com/multiple-l...gression_y.htm


Regards N10