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

Similar Threads

Need Help with a VBA subroutine 0
Copy cells to different sheet if value found 1
Working outlook via vba code with xlsx - error 0
Macro for comparing columns and highlighting matching/differences 13
Counting unique values in multiple columns 4
checking for positive or negative numbers 1
Help to Highlight Excel Row based on Weekly Date Range 2
Data Validation, Hlookup saving data issues 0

Top