The following table contains the excess monthly returns for three companies and the market index.

Required:

Using the monthly excess returns above, calculate the stocks' covariance with the market and their

betas. $($Note: the covariance of the market with the market is just its variance.$)$

$($Use cells A$5$ to E$40$ from the given information to complete this question.$)$