The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these data, estimate the av
Posted: Thu May 05, 2022 7:50 am
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.
Month
Cola Co.
Gas Co.
January
2.80%
5.90%
February
3.00%
−1.50%
March
−1.80%
−1.30%
April
4.70%
2.50%
May
−0.60%
−1.70%
June
11.10%
14.40%
July
1.60%
9.30%
August
−0.50%
−2.80%
September
−5.00%
−1.20%
October
−1.40%
0.00%
November
1.50%
12.00%
December
−0.70%
3.00%
and Gas Co. for
2013.
Using these data, estimate the average monthly return and
the volatility for each stock.
Month
Cola Co.
Gas Co.
January
2.80%
5.90%
February
3.00%
−1.50%
March
−1.80%
−1.30%
April
4.70%
2.50%
May
−0.60%
−1.70%
June
11.10%
14.40%
July
1.60%
9.30%
August
−0.50%
−2.80%
September
−5.00%
−1.20%
October
−1.40%
0.00%
November
1.50%
12.00%
December
−0.70%
3.00%