December - Cola Co. : -1.80% Gas Co : 2.90%

Calculate the average monthly return for Gas Co

Calculate the average monthly return for Cola Co.:

Calculate the variance for Cola Co.:

Calculate the variance for Gas Co.:

Calculate the volatility for Cola Co.:

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.)