Question: Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Input area: begin{tabular}{|ccc|} hlineYear & X

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Input area: \begin{tabular}{|ccc|} \hlineYear & X & Y \\ 1 & 13% & 27% \\ 2 & 26% & 36% \\ 3 & 7% & 11% \\ 4 & 5% & 29% \\ 5 & 11% & 16% \\ \hline \end{tabular} 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
