Question

In the portfolio optimization model, stock 2 is not in the optimal portfolio. Use SolverTable to see whether it ever enters the optimal portfolio as its correlations with stocks 1 and 3 vary. Specifically, use a two-way SolverTable with two inputs, the correlations between stock 2 and stocks 1 and 3, each allowed to vary from 0.1 to 0.9 in increments of 0.1. Capture as outputs the three changing cells. Discuss the results.



$1.99
Sales0
Views42
Comments0
  • CreatedApril 01, 2015
  • Files Included
Post your question
5000