ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Regression - scenario won't run - can't determine why (https://www.excelbanter.com/excel-discussion-misc-queries/231976-regression-scenario-wont-run-cant-determine-why.html)

Harry

Regression - scenario won't run - can't determine why
 
Hi gang:

I am running a regression macro where I submit a X range of x variables, and
a Y range of Y data.

I make sure that my X range contains the same number of rows as my Y range.

However, when my x range (which is 15 variables) contains 15 rows, I get
this error:

Regression - the number of rows and columns in X range cannot be the same

Why is this? Is there a workaround?

thanks,
Harry





All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com