How do you populate the X variables in Regression analysis for mo.

T

tjp32

I can't seem to figure out how to type in the cell ranges for multiple
independant variables in Regression analysis. It won't let me separate each
range w/ a , or ; ? Any suggestions on how to set it up with more than one
variable?
 
M

Michael R Middleton

tjp32 -

The x variables must be in adjacent columns (with no intervening hidden
columns). The "Input X Range" must be a single rectangular range.

- Mike
www.mikemiddleton.com

I can't seem to figure out how to type in the cell ranges for multiple
independant variables in Regression analysis. It won't let me separate each
range w/ a , or ; ? Any suggestions on how to set it up with more than one
variable?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LINEST and Dynamic Regression 0
Multiple (as in many) regressions 3
Multiple Regression Analysis 2
Excel 2003 Regression using more than 1 independent variable 2
Regression - Standard Error X Variable 1 2
How do I put days of the week into a multiple regression model? 2
Simple Variable to someone 5
add a second independent variable, doing regression in excel? 1

Top