## [answered] Calculating Returns and Variability [ LO1] Using the follow

 Calculating Returns and Variability [ LO1] Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Ro the standard deviation, use the Excel function SQRT.See the file. You must use the SQRT Function to answer the question as requested

7. Calculating Returns and Variability [ LO1] Using the following returns, calculate the

arithmetic average returns, the variances, and the standard deviations for X and Y. Ro

the standard deviation, use the Excel function SQRT. Returns

Year

1

2

3

4

5 X

17%

22

8

-15

10 Y

23%

34

11

-32

21 Actual

Return X

1

2

3

4

5

Total

Average return

Variance

Standard Deviation 0

0

0.00% Actual

Return Y

1

2

3

4

5

Total

Average return

Variance

Standard Deviation 0.00% Average

Return Deviation Squared

Deviation Average

Return Deviation Squared

Deviation -

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001006003.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 18, 2020

EXPERT

Tutor