From the data table in cells A16:C37:

a. What are the mean return and sigma of the least risky portfolio?

b. What are the proportions invested in Apple and Google for this portfolio?

205 Portfolio ModelsIntroduction A B C D E F G H | J CALCULATING THE MEAN AND STANDARD DEVIATION OF A PORTFOLIO a Asset returns AAPL GOOG Mean return 2.61% 0.24% n Variance 0.0125 0.0102 a Standard deviation 11.17% 10.09% a Covariance 0.0020 ? 8 Proportion of AAPL 0.5 9 10 Portfolio mean return 1.18% 1:- =BB'B3+(1BB)*CS 11 Portfolio return variance 0.006? 0, this i 3. Chapter 32 gives an introduction to matrices sufcient to deal with all the problems encoun- tered in this book. The Excel matrix functions MMult and MInverse used in portfolio problems are discussed in this chapter