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

Copper Contributor

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