Macro to Enable LINSET Equations in Excel

Iron Contributor

Hi,

 

I have large sets of historicals prices for control vairables (x value) and share prices (Y value). I have seen LINSET and similar functions in excel can run regression and analysis to find and predict the impact of multiple X values on multiple Y values.

 

I have attached an example spreadsheet and aiming to find a formula or macro to use this function on large set of data.

 

Thank you kindly for any assistance.

0 Replies