In the model in Example 7.9, stock 2 is not in the optimal portfolio. Use SolverTable to

Question:

In the model in Example 7.9, 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 investment weights. Discuss the results.

Stocks
Stocks or shares are generally equity instruments that provide the largest source of raising funds in any public or private listed company's. The instruments are issued on a stock exchange from where a large number of general public who are willing... Portfolio
A portfolio is a grouping of financial assets such as stocks, bonds, commodities, currencies and cash equivalents, as well as their fund counterparts, including mutual, exchange-traded and closed funds. A portfolio can also consist of non-publicly...