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

Transcribed Image Text:

The following spreadsheet contains monthly returns for Cola Co and Gas Co. for 2022: Using these data, estimate the average monthly return and the volatility for each stock. The average monthly return for Cola Co. is 1% (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Date - X Cola Co. Gas Co. Jan - 7.10% -8.10% Feb 2.10% 2.00% Mar - 3.80% 2.60% Apri - 4.10% 5.00% May 1.50% 4.70% June 1.20% 3.20% July -21.10% 6.70% Aug 14.50% 8.50% Sep - 28.80% 12.60% Oct 22.90% 16.50% Nov 13.40% 6.10% an example Dec - 1.80% 2.90% Clear all Check answer The following spreadsheet contains monthly returns for Cola Co and Gas Co. for 2022: Using these data, estimate the average monthly return and the volatility for each stock. The average monthly return for Cola Co. is 1% (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Date - X Cola Co. Gas Co. Jan - 7.10% -8.10% Feb 2.10% 2.00% Mar - 3.80% 2.60% Apri - 4.10% 5.00% May 1.50% 4.70% June 1.20% 3.20% July -21.10% 6.70% Aug 14.50% 8.50% Sep - 28.80% 12.60% Oct 22.90% 16.50% Nov 13.40% 6.10% an example Dec - 1.80% 2.90% Clear all Check answer