You are finally able to invest in the stock market. You know a bit about a well diversified portfolio and decide to invest in 6 stocks. Their monthly returns are presented below:
Proin loc s Points] a well divenifled panelin and decide to invest in stock You are finally able to win the work market. You know a web Sret Stock A Fill in the formation on each sterk below: Use the INDIRECT futou in all cell mod I bonus point is yours! Stock D 18/0% 02.08.2013 1.0996 3.49 Ep. Retur Staudinle 7.40% +36ES Akree -1.78% -1.556 17.5093 -1.0G B. Create the Var-Coy mattis of the stocks (Prescan your values to spes) I have called the range here varer Anuel Redur Stock Stock C Stock D 1.54% 17.535 1031, 2013 11419, 2013 0.809 O 0.81% .0L% Stock E Stock 11.1095 0331,2014 WAY 14 5.75% 1.339 10.55 -1.14% -1.9046 -3.19% Cleneb of the comes below, you will use Solver to assign tbe relevant weights Mi Verinner. Your objective is to find the cowb o a mimizes the portfolio sudard devintos (144). ronjective is m find the combination that mines the periode standard deviation but all welcher 113 2014 1.14% 20.9063 Max Return Your objective is to m e the expected on the portfolio 6.61% -2.9495 Market Portfoliol Your objective is to maximize the Shape ratio on the portfolio. How can we - 15 10 . -3.13. Esamlly | Miui Weighted SES Stock A Stock D 3758 -3.15% Sum of Weights 1.16% -1.1295 0229 2016 U3 2016 12.79 U719, 2016 08.31.2016 hom the landard deviations of the portfolio Produce a pile of the licent Frontier. Recall the officient from the X asis and her Experted Terres on the Yan 180/2010 Proin loc s Points] a well divenifled panelin and decide to invest in stock You are finally able to win the work market. You know a web Sret Stock A Fill in the formation on each sterk below: Use the INDIRECT futou in all cell mod I bonus point is yours! Stock D 18/0% 02.08.2013 1.0996 3.49 Ep. Retur Staudinle 7.40% +36ES Akree -1.78% -1.556 17.5093 -1.0G B. Create the Var-Coy mattis of the stocks (Prescan your values to spes) I have called the range here varer Anuel Redur Stock Stock C Stock D 1.54% 17.535 1031, 2013 11419, 2013 0.809 O 0.81% .0L% Stock E Stock 11.1095 0331,2014 WAY 14 5.75% 1.339 10.55 -1.14% -1.9046 -3.19% Cleneb of the comes below, you will use Solver to assign tbe relevant weights Mi Verinner. Your objective is to find the cowb o a mimizes the portfolio sudard devintos (144). ronjective is m find the combination that mines the periode standard deviation but all welcher 113 2014 1.14% 20.9063 Max Return Your objective is to m e the expected on the portfolio 6.61% -2.9495 Market Portfoliol Your objective is to maximize the Shape ratio on the portfolio. How can we - 15 10 . -3.13. Esamlly | Miui Weighted SES Stock A Stock D 3758 -3.15% Sum of Weights 1.16% -1.1295 0229 2016 U3 2016 12.79 U719, 2016 08.31.2016 hom the landard deviations of the portfolio Produce a pile of the licent Frontier. Recall the officient from the X asis and her Experted Terres on the Yan 180/2010
