Macro to Enable LINSET Equations in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-890191%22%20slang%3D%22en-US%22%3EMacro%20to%20Enable%20LINSET%20Equations%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-890191%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20large%20sets%20of%20historicals%20prices%20for%20control%20vairables%20(x%20value)%20and%20share%20prices%20(Y%20value).%20I%20have%20seen%20LINSET%20and%20similar%20functions%20in%20excel%20can%20run%20regression%20and%20analysis%20to%20find%20and%20predict%20the%20impact%20of%20multiple%20X%20values%20on%20multiple%20Y%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20an%20example%20spreadsheet%20and%20aiming%20to%20find%20a%20formula%20or%20macro%20to%20use%20this%20function%20on%20large%20set%20of%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20kindly%20for%20any%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-890191%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent 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