Oct 02 2019 05:28 PM
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.