$42$ Required:

$43$

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

$44$

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

$46$

Graded Worksheet