Using a macro in VBA to run regressions

**NoCover** · 06-15-2013, 10:59 PM

I searched this forum and found this code to run many simple regressions at once (3600 of them) and send the output for all of them to a single worksheet. It runs a regression for the data in column 3 against the data column 65, then column 3 against column 66, etc., then column 4 against column 65, then column 4 against 66, etc., and so on. It works beautifully, but what I would like to do is run a regression for the data in column 3 against the data in column 65, then 4 against 66, then 5 against 67, and so on for a total of 60 regressions.

Unfortunately, I can't seem to correctly modify the code in order to make that happen. Can anyone help me? Thanks in advance!

Please Login or Register  to view this content.

**kalak** · 06-16-2013, 04:52 AM

try with the indicated changes, primarily omit the j loop but put j always=i+62

Please Login or Register  to view this content.

**abousetta** · 06-16-2013, 05:21 AM

Just as a warning, this code assumes you have no missing data (ie, no blank cells), if you do, then the ranges need to be modified.

**NoCover** · 06-16-2013, 08:11 AM

kalak, you are a life saver. After seeing what you did, I was able to modify it even further to perform many multiple regressions as well. Thanks again!

**kalak** · 06-16-2013, 08:15 AM

Originally Posted by NoCover

kalak, you are a life saver. After seeing what you did, I was able to modify it even further to perform many multiple regressions as well. Thanks again!

NoCover,

You're very welcome.

**kalak** · 06-16-2013, 08:27 AM

this post not entered as intended. disregard ...

**csmith-han** · 06-19-2016, 01:53 AM

Dear Forum Guru, I stumbled this post three years later and am interested in the comment you posted here. Your reply to this post was "Just as a warning, this code assumes you have no missing data (ie, no blank cells), if you do, then the ranges need to be modified."

I have a situation here where my regression is on columns of data that contain blank cells. How do you change the VBA code written by kalak to deal with blank cells in a column when running regressions?

Thanking you in anticipation if you're still an blogger to EXCEL Forum.