Forum Discussion
Multi-Parameter analytics via Solver/Data Analysis Pack or Formulas ?
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
