Question: (Excel: Calculating means, standard deviations, covariance, and correlation). Given the probability distributions of returns for stock X and stock Y, compute:

The expected return for each stock

Returns

Probability Stock X Stock Y

0.2 5% 12%

0.2 10 10

0.4 12 8

0.15 14 0

0.05 18 2