In years 1-5, Stock A had returns of 5.6%, 7.9%, 4.2%, 1.8% and 4.5% respectively. During that same period of time the stock market had returns of 6.2%, 7.3%, 5.8%, 4.5% and 6.1% respectively. Use these data and Excel's COVARIANCE.P and VAR.P functions to calculate Stock A's beta over this five-year period.

Question

Quizplus · Accepted Answer

The Answer of In years 1-5, Stock A had returns of 5.6%, 7.9%, 4.2%, 1.8% and 4.5% respectively. During that same period of time the stock market had returns of 6.2%, 7.3%, 5.8%, 4.5% and 6.1% respectively. Use these data and Excel's COVARIANCE.P and VAR.P functions to calculate Stock A's beta over this five-year period.

In Years 1-5, Stock a Had Returns of 5