Macro to Enable LINSET Equations in Excel

Frequent Contributor



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