## [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.

I did some work on this already but the answers are not correct, can you look at it please.

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 X

1

2

3

4

5

Total

Average return

Variance

Standard Deviation Y

1

2

3

4

5

Total

Average return Actual

Return

17

22

8

-15

10

42

8

0.00% Actual

Return

23.0

34.0

11.0

(32.0)

21.0

57.0

11.4 Variance 0.851469 Standard Deviation 92.28% Average

Return

8.40

8.40

8.40

8.40

8.40 Deviation

8.60

13.60

-0.40

-23.40

1.60 Average

Return

11.40

11.40

11.40

11.40

11.40 Deviation

11.60

22.60

(0.40)

(43.40)

9.60 Squared

Deviation

2.93

3.69

Err:502

Err:502

1.26 Squared

Deviation

3.41 3.40588

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001006002.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