Automatic Regressions based on Field Values

E

eoin.bourke

Hi

Is there a way of writing a macro that can search through a set of values in excel and based on a particular value in a particular row set when running the macro, regress the next 90 values in two adjacent columns?

For example. search column A. If row 32 in column A = 'StockSplit', regress the value in Column B Row 32 against Column C in row 32, including the next 89 rows in column B and C in the regression.

I would then like to output the R squared, intercept, and some other values to a table.

I would be interested to hear if anybody has done something similar, or if this is even possible in excel.

Thanks
 

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

Top