Consider the following table:

		Stock Fund	Bond Fund
Scenario	Probability	Rate of Return	Rate of Return
Severe recession	0.10	32%	17%
Mild recession	0.15	22.0%	15%
Normal growth	0.35	14%	6%
Boom	0.40	35%	4%

a. Calculate the values of mean return and variance for the stock fund. (Do not round intermediate calculations. Round "Mean return" value to 1 decimal place and "Variance" to 4 decimal places.)

PLEASE USE EXCEL AND PROVIDE FORMULA VIEW

Consider the following table:

		Stock Fund	Bond Fund
Scenario	Probability	Rate of Return	Rate of Return
Severe recession	0.10	32%	17%
Mild recession	0.15	22.0%	15%
Normal growth	0.35	14%	6%
Boom	0.40	35%	4%

b. Calculate the value of the covariance between the stock and bond funds. (Negative value should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to 4 decimal places.)