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. The average monthly return for Cola Co. is The average monthly return for Gas Co. is The volatility for Cola Co. is%. (Round to two decimal places.) %. (Round to two decimal places.) %. (Round to two decimal places.) January February March April May June July August September October November Month Cola Co. 2.40% 0.90% 1.60% - 1.60% 2.80% 4.60% 0.80% -0.80% - 0.80% -0.40% 5.90% Gas Co. 6.20% - 4.60% 4.60% - 5.90% 3.80% 6.00% -0.40% -2.00% - 3.60% 0.60% 1.80% 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. The average monthly return for Cola Co. is The average monthly return for Gas Co. is The volatility for Cola Co. is%. (Round to two decimal places.) %. (Round to two decimal places.) %. (Round to two decimal places.) January February March April May June July August September October November Month Cola Co. 2.40% 0.90% 1.60% - 1.60% 2.80% 4.60% 0.80% -0.80% - 0.80% -0.40% 5.90% Gas Co. 6.20% - 4.60% 4.60% - 5.90% 3.80% 6.00% -0.40% -2.00% - 3.60% 0.60% 1.80%

Answer rating: 100% (QA)

Solution To estimate the average monthly return and volatility for each stock we can use the following formulas Average Monthly Return Sum ofMonthly R... View the full answer