The following spreadsheet contains monthly returns for Coca Cola 9KO) and EXXON Mobile (XOM) for 1980. Using the data in MS Excel, estimate the:

a) Average monthly return and volatility

b) Covariance between the stocks

c) Correlation between thestocks

Transcribed Image Text:

KO 0.404 0.045 YOM 0.099 0.098 -0.045 0.011 0.076 0.045 0.005 -0.004 0.077 0.223 0.013 0.034 Month anuary February Mar April une Jul August September October November December -0.023 0.099 -0.124 0.003 0.012 0.012 0.103 0.098 0.877