Calculating returns, variances, standard deviations for X and Y

Using the following returns, calculate the average returns, the variances, and the standard deviations for X and Y.

See attached spreadsheet for the data.

Prob #7
RETURNS
Year X Y
1 10% 26%
2 18 -4
3 -8 -10
4 12 42
5 6 21

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/accounting/calculating-returns-variances-standard-deviations-for-x-and-y-2us
Attachments

Solution Preview

...(RY) = (26 - 4 - 10 + 42 + 21) / 5
= 15%

Step 2
Find the variances and standard deviations.

n
2 =  (ki - k)2 / n where k = average return
i = 1 ...