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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do you populate the X variables in Regression analysis for mo. (https://www.excelbanter.com/excel-worksheet-functions/20393-how-do-you-populate-x-variables-regression-analysis-mo.html)

tjp32

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

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?

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

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

All times are GMT +1. The time now is 07:34 PM.