The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these...

Transcribed Image Text:

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.) January February Month Cola Co. 0.90% 10.30% 1.22% - 5.00% 8.70% - 5.80% Gas Co. 11.80% - 3.40% 3.60% 3.50% -0.60% - 5.10% 2.50% -0.40% -2.80% March April May June July August 0.80% 2.20% September 3.40% October 0.50% November 12.50% 7.80% 5.40% 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.) January February Month Cola Co. 0.90% 10.30% 1.22% - 5.00% 8.70% - 5.80% Gas Co. 11.80% - 3.40% 3.60% 3.50% -0.60% - 5.10% 2.50% -0.40% -2.80% March April May June July August 0.80% 2.20% September 3.40% October 0.50% November 12.50% 7.80% 5.40%