Requirement 1: Calculate the average returns for X and Y. (Do not round intermed

Question

Requirement 1: Calculate the average returns for X and Y. (Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).)

Average returns

X % - Need

Y 14.96 % (Already Have)

Requirement 2: Calculate the variances for X and Y. (Do not round intermediate calculations. Round your answers to 6 decimal places (e.g., 32.161616).)

Variances

X - Need

Y .057077 (Have already)

Requirement 3: Calculate the standard deviations for X and Y. (Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).)

Standard deviations

X % Need

Y % Need

Explanation / Answer

Enter the returns of X and Y in an excel sheet

Stock X:

Average returns can be calculated as =AVERAGE(A1:A5) = 8.64%

Variance can be calculated as =VAR.S(A1:A5) = 0.027007

Standard Deviation can be calculated as =STDEV.S(A1:A5) = 16.43%

Note: Cells A1 to A5 has returns of Stock X

Stock Y:

Average returns can be calculated as =AVERAGE(B1:B5) = 14.96%

Variance can be calculated as =VAR.S(B1:B5) = 0.057077

Standard Deviation can be calculated as =STDEV.S(B1:B5) = 23.89%

Note: Cells B1 to B5 has returns of Stock Y

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.