Excel 2003 Regression using more than 1 independent variable

[Alex]

How do you run a regression with more than one independent variable through
the menu Tools, Data Analysis, Regression?
On the help section it says you can run regressions with up to 16 variables.
After selecting my range for Y, I try to select more than 1 column for my X
variable and it always gives me an error message. Thanks

 

[Dave F]

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

Many more links:
http://www.google.com/search?hl=en&q=excel+multiple+linear+regression

Dave

 

[Mike Middleton]

Alex -

One important restriction is that the X variables must be in adjacent
columns with no hidden columns. Its always worked fine for me.

- Mike
http://www.mikemiddleton.com