Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 compatibility | Excel Discussion (Misc queries) | |||
Cannot Open Webpage With Excel 2003 | Excel Discussion (Misc queries) | |||
Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
Excel 2003 Referencing multiple workbooks via single variable | Excel Worksheet Functions | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |