Question: Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Input area: Year X Y
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Input area: Year X Y 1 13% 27% 2 26% 36% 3 7% 11% 4 -5% -29% 5 11% 16% (Use cells A6 to C11 from the given information to complete this question. You must use the built-in Excel function to answers this question. Make sure to use the "sample" Excel formulas.) Output area: Asset X: Average return Variance Standard deviation Asset Y: Average return Variance Standard deviation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
