Question Details

[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
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001006002.zip (25.37 KB)

Buy this answer for only: $15

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)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now