Question

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

20132013.

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

Month	Cola Co.	Gas Co.
January	6.706.70​%	2.002.00​%
February	7.707.70​%	negative 4.00−4.00​%
March	negative 1.30−1.30​%	6.706.70​%
April	6.306.30​%	7.707.70​%
May	negative 1.90−1.90​%	negative 2.80−2.80​%
June	3.903.90​%	3.203.20​%
July	negative 1.00−1.00​%	negative 1.50−1.50​%
August	negative 2.50−2.50​%	3.703.70​%
September	negative 1.30−1.30​%	4.404.40​%
October	3.303.30​%	0.200.20​%
November	8.608.60​%	1.801.80​%
December	5.605.60​%	negative 2.10−2.10​%

The average monthly return for Cola Co. is

2.842.84​%.

​(Round to two decimal​ places.)The average monthly return for Gas Co. is

1.611.61​%.

​(Round to two decimal​ places.)The volatility for Cola Co. is

nothing​%.

​(Round to two decimal​ places.)

Answer 1