Historical nominal returns for Coca-Cola have been 8% and -20%. The nominal returns for the market index S&P500 over the same periods were -15% and 28%. Calculate the beta for Coca-cola. Can you do...

Historical nominal returns for Coca-Cola have been 8% and -20%. The nominal returns for the market index S&P500 over the same periods were -15% and 28%. Calculate the beta for Coca-cola.

Can you do this with Excel and without Excel (using formulae please) corresponding to the formula attached.

The other image shows previous answer from an expert but I think the formula used for Beta seems wrong.

Extracted text:


Extracted text: