Scenarios: Probabilities: Returns:
A 0.10 (0.10)
B 0.10 0.02
C 0.40 0.05
D 0.25 0.07
E 0.15 0.14
Problem 1: 5-Points: Calculate the expected return to the nearest basis point.
Problem 2: 5-Points: Calculate the standard deviation to the nearest basis point.
Please show work and calculation in Excel