The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these data, estimate the average monthly return and the volatility for each stock. (Click on the following icon in order to copy its contents into a spreadsheet.) The average monthly return for Cola Co. is%. (Round to two decimal places.) January February March April May June July August September October November Month Cola Co. -2.10% 0.00% -2.00% 0.90% -3.10% -8.40% - 11.90% -1.60% 5.50% -1.10% -3.80% Gas Co. 2.80% -0.50% - 1.80% 2.80% 8.40% -4.60% 8.20% 4.60% 3.00% 1.40% 2.90%

The foligwing spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013 . Using these data, estimate the average monthly retum and the volatilify for each stock. fClick on the following icon 8 in order to copy its contents into a spreadsheet) The average monthly retum for Cola Co. is 4. (Round to two decimal places.) a. Using the formula: Var(R1)w12SD(R1)2+w22SO(R2)2+2w1w2Cor(R1R2)SD(R1)SO(R2) b. Calculating the monthly returns of the portolio and computing its volasily directly. c. How do your results compare? Data table a. Using the formula: Var(Rp)=w12SD(R1)2+w22SD(R2)2+2w1w2Con(R1,R2)SO(R1)SD(R2) (Click on the lolowing icen 8 in order lo copy ts contents into a spreadrheot)