View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default 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