Macro to Enable LINSET Equations in Excel

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.