Multi-Parameter analytics via Solver/Data Analysis Pack or Formulas ?

%3CLINGO-SUB%20id%3D%22lingo-sub-2844849%22%20slang%3D%22en-US%22%3EMulti-Parameter%20analytics%20via%20Solver%2FData%20Analysis%20Pack%20or%20Formulas%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2844849%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20data%20consists%20of%205%20Parameters%20(%20each%20with%203%20-%205%20values).%3C%2FP%3E%3CP%3E500%20unique%20combinations%20of%20those%20parameters%20iterated%20over%20my%20target%20(%20250%20different%20stocks%20)%20produce%20different%20results%20(%20profit)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20evaluate%20%3A%3C%2FP%3E%3CP%3E1.)%26nbsp%3B%20each%20Parameters%20%22strenght%22%20of%20impact%20on%20Profit%3C%2FP%3E%3CP%3E2.)%26nbsp%3B%20Correlation%20between%20Parameter%20and%20Stocks%20MarketCap%2FVolume%20Ratio%26nbsp%3B%20for%20max%20Profit%3C%2FP%3E%3CP%3E3.)%20And%20Finally%20get%20a)%20universally%20best%20Parameter%20Configurations%20b)%20Individually%20best%20Parameter%20Configurations%20(%20dependant%20upon%20MarketCap%2FVolume)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBefore%20I%20start%20writing%20all%20kinds%20of%20formulas%20%2C%20maybe%20Solver%2FData%20Analysis%20AddIns%20have%20this%20kind%20of%20functionality%20%3F%20This%20kind%20of%20Data%20Analysis%20is%20fairly%20new%20to%20me%20%2C%20please%20point%20out%20whether%20Im%20looking%20in%20the%20right%20direction%20%2C%20thank%20you%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2844849%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2845884%22%20slang%3D%22en-US%22%3ERe%3A%20Multi-Parameter%20analytics%20via%20Solver%2FData%20Analysis%20Pack%20or%20Formulas%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2845884%22%20slang%3D%22en-US%22%3EThe%20Analysis%20toolpak%20should%20help%20with%20this%2C%20the%20regression%20should%20be%20able%20to%20handle%20multiple%20columns%20of%20x-values%3C%2FLINGO-BODY%3E
Visitor

Hello,  

My data consists of 5 Parameters ( each with 3 - 5 values).

500 unique combinations of those parameters iterated over my target ( 250 different stocks ) produce different results ( profit) 

 

I want to evaluate :

1.)  each Parameters "strenght" of impact on Profit

2.)  Correlation between Parameter and Stocks MarketCap/Volume Ratio  for max Profit

3.) And Finally get a) universally best Parameter Configurations b) Individually best Parameter Configurations ( dependant upon MarketCap/Volume)

 

Before I start writing all kinds of formulas , maybe Solver/Data Analysis AddIns have this kind of functionality ? This kind of Data Analysis is fairly new to me , please point out whether Im looking in the right direction , thank you .

 

1 Reply
The Analysis toolpak should help with this, the regression should be able to handle multiple columns of x-values