Question: Please explain while using excel solver Individual Stocks_ Variance-covariance Matrix Equal weight --Weights-- Max g 6.5034% Mino 1.64% WEN AAPL 1.55% 0.65% 0.21% 0.02% 1.64%
Individual Stocks_ Variance-covariance Matrix Equal weight --Weights-- Max g 6.5034% Mino 1.64% WEN AAPL 1.55% 0.65% 0.21% 0.02% 1.64% 1.55% 8.81% 6.50% 8.95% 10.29% 9.33% 8.22% g/' Objective: 0.18 Constraint variable Value 0.10 0.02 0.00 LOW 0.18 KO 0.19 WEN AAPL Sum of weights Mean 02 mean/o LOW WEN AAPL 0.0078 0.0027 0.0046 0.0057 0.0048 0.0014 0.0027 0.0042 0.0035 0.0039 0.0025 0.0013 WEN 0.0046 0.0035 0.0080 0.0051 0.0035 0.0019 0.0057 0.0039 0.0051 0.0106 0.0047 0.0034 AAPL 0.0048 0.0025 0.0035 0.0047 0.0087 0.0032 0.0014 0.0013 0.0019 0.0034 0.0032
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
