Excel 2003 Regression using more than 1 independent variable
 

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

Excel 2003 Regression using more than 1 independent variable
 

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

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

Dave
--
Brevity is the soul of wit.


"Alex" wrote:

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

Excel 2003 Regression using more than 1 independent variable
 

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

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