1. Find the average return and return variance of each asset and get formulas for asset 2.

2. Find the covariance of the two return series and get formula.

3. Find the correlation coefficient of the two return series and get formula.

4. Suppose we form portfolios with asset 1 and asset 2. Find the portfolio standard deviation and portfolio mean return given different weights and get formulas.

5. Make a smooth marked scatter plot of portfolio standard deviation vs portfolio mean return, with the portfolio mean return being the y-axis, portfolio standard deviation being the x-axis and title it as "Portfolio Risk vs Expected Return".

show the excel formula you use!

Asset 1 12.56% 13.50% 14.23% 15.23% 14.23% 12.23% 10.23% 5.26% 4.25% 2.23% Asset 2 21 31-1204 3 31-12H-05 41 31-12-06 5 31-12-07 6 31-12-08 7 31-12H-09 8 31-12-10 91 31-12-11 8.56% 4.56% 2.12% 1.23% 0.26% 3.25% 4.89% 5.56% 6.45% | 31-12-12 11 31-12H-13 12 13 Average return 14 Return variance 15 Covariance 16 Correlation Coef 10 get formula 17 18 weight of asset 1 0 Portfolio Standarod de Portfolio Expected Return get formula Variance Portfolio 19 get formula viation get formula 21 23 0.3 0.4 0.5 0.6 0.7 0.8 0.9 25 26 27 29 30