optimal portfolio weights

In sheet “Many risky”, complete by using Solver to figure out the optimal portfolio weights among 5 assets. The main objective is to minimize portfolio variance.


Set up solver, main objective 0.5 pt
Set up solver, changing cells 0.5 pt
Set up solver, 2 more constraints 1 pt
Total 2 pts