Question

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

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

  

Returns
Year X Y
1 11 %     18 %    
2 29         39        
3 18         -12        
4 -19         -26        
5 20         47        

   

Requirement 1:
(a) Calculate the arithmetic average return for X.
(Click to select)  14.75%  14.40%  11.80%  13.33%  9.56%

   

(b) Calculate the arithmetic average return for Y.
(Click to select)  14.92%  10.69%  16.10%  16.50%  13.20%

  

Requirement 2:
(a) Calculate the variance for X. (Do not round intermediate calculations.)
(Click to select)  0.042213  0.041997  0.033770  0.027354  0.033597

   

(b) Calculate the variance for Y. (Do not round intermediate calculations.)
(Click to select)  0.088292  0.081057  0.125088  0.110364  0.100070

  

Requirement 3:
(a)

Calculate the standard deviation for X. (Do not round intermediate calculations.)

(Click to select)  18.23%  14.89%  22.97%  20.49%  18.38%

   

(b)

Calculate the standard deviation for Y. (Do not round intermediate calculations.)

(Click to select)  33.22%  29.71%  25.62%  39.54%  31.63%
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text aCopy в 1 프· ー· 鱼, Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard BV13 BT Alignment Number Cells BW RETURNS BU BV BX св CA REQUIREMENT 1 BZ CD CF CG CH YEAR ARITHMETIC AVERAGE RETURN FOR X FOR Y 11.80 13.20 EXCEL FUNCTION FORMULA-AVERAGE(BW3:BW7) FORMULA-AVERAGE(BX3:BX7) 29 18 19 39 12 26 47 4 REQUIREMENT 2 6 VARIANCE FOR X FOR Y 337.70 1000.70 FORMULA-VAR.S(BW3:BW7) FORMULA-VAR.S(BX3:BX7) 9 REQUIREMENT 3 10 STANDARD DEVIATION FOR X FOR Y 12 13 14 15 16 17 18 19 18.38 31.63 FORMULA-STDEV.S(BW3:BW7) FORMULA-STDEV.S(BX3:BX7) DEAR Sheet2 COV : TIME SERIES Corr REGRESSION CAMERAEXP RETURN MATRIXINTERVAL, NORMAL HY 福 130% 04-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy ▼ в 1 프· ー· 鱼, Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Alignment Number Cells BV BW BX BY BZ CA CD CE CF CG CH CI CJ 60 61 62 63 YEAR X 64 65 RETURNS REQUIREMENT 1 ARITHMETIC AVERAGE RETURN FOR X FOR Y 12.77 14.28 1 14.7514.92 14.4 10.69 16.1 16.5 13.2 11.8 13.33 9.56 67 68 69 70 71 72 73 74 75 76 4 78 4 PV FV DIVIDEND EMV MEAN STDV DEAR ! Sheet2 | COV TIME SERIES corr REGRESSION CAMERAEXP RETURN MATRIXINTERVAL, NORMAL HY 福 130% 04-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum Wrap Text ta copy. в 1 프· ー· 鱼, Δ. : rーー 遑锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard CF85 BU Alignment Number Cells Edting BV BW BX BZ CA св CD CE CG CH 76 RETURNS REQUIREMENT 3 78 79 80 81 82 83 84 85 86 87 YEAR STANDARD DEVIATION FOR X FOR Y 18.23 14.89 22.97 20.49 18.38 33.22 29.71 25.62 39.54 31.63 2.9937 5.1091 4 89 90 91 92 93 94 4 PV FV DIVIDEND EMV MEAN STDV DEAR (Sheet2 | COV TIME SERIES ( corr REGRESSION CAMERAEXP RETURN MATRIXINTERVAL, NORMAL HY 福 130% 03:11 04-01-2019

Add a comment
Know the answer?
Add Answer to:
Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...

    Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Returns Year X Y 1 10 % 21 % 2 28 42 3 17 -9 4 -18 -23 5 19 50 Requirement 1: (a) Calculate the arithmetic average return for X 14%, 9.07%, 13.66%, 11.20%, 12.66% b) Calculate the arithmetic average return for Y. 19.76%, 16.20%, 18.31%, 20.25%, 13.12% Requirement 2: (a) Calculate the variance for X. (Do not round intermediate...

  • Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...

    Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Returns Y 14 % UNMto 19 % 40 -9 Requirement 1: (a)Calculate the arithmetic average return for X. Full-screen Snip (Click to select) (b)Calculate the arithmetic average return for Y. (Click to select) Requirement 2: (a) Calculate the variance for X. (Do not round intermediate calculations.) (Click to select) (b)Calculate the variance for Y. (Do not round intermediate calculations.) (Click to...

  • Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...

    Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Returns Year Х 10 % 19 % 28 40 17 -12 -18 19 48 Requirement 1: (a) Calculate the arithmetic average return for X. (Click to select) (b) Calculate the arithmetic average return for Y. (Click to select) A Requirement 2: (a) Calculate the variance for X. (Do not round intermediate calculations.) (Click to select) (b) Calculate the variance for Y....

  • Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...

    Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y Returns Year 2 3 4 14% 32 21 24% 45 -22 -25 23 53 Requirement 1 (a) Calculate the arithmetic average return for X. (Click to select) (b) Calculate the arithmetic average return for Y (Click to select) Requirement 2: (a) Calculate the variance for X. (Do not round intermediate calculations.) (Click to select) (b) Calculate the variance for Y. (Do...

  • Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...

    Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.    Returns Year X Y 1 10 %     24 %     2 28         45         3 17         -10         4 -18         -24         5 19         53             Requirement 1: (a) Calculate the arithmetic average return for X. (Click to select)  13.66%  9.07%  11.20%  12.66%  14.00%     (b) Calculate the arithmetic average return for Y. (Click to select)  14.26%  22.00%  21.47%  17.60%  19.89%    Requirement 2:...

  • Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for...

    Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y.    Returns Year X Y 1 9 %     23 %     2 27         44         3 16         -14         4 -17         -28         5 18         52             Requirement 1: (a) Calculate the arithmetic average return for X. (Click to select)  8.59%  10.60%  13.25%  12.93%  11.98%     (b) Calculate the arithmetic average return for Y. (Click to select)  17.40%  18.79%  12.47%  19.25%  15.40%    Requirement 2:...

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

    Using the following returns, calculate the average returns, the variances, and the standard deviations for X and Y. (Note that the book covers both the "arithmetic" and the "geometric" averages. Here, calculate the regular "arithmetic" average returns. These are the average returns covered in the course lecture. Year 1 2 3 4 5 Returns X Y 10% 20% 28 41 17 -11 -18 -25 1949 Requirement 1: (a)Calculate the average return for X. (Click to select) (b)Calculate the average return...

  • P12-7 Calculating Returns and Variability [LO1] Using the following returns, calculate the arithmetic average returns, the...

    P12-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. Returns Year 11 % NMto 24 % 2945 18 -10 -24 53 Requirement 1: (a)Calculate the arithmetic average return for X. (Click to select) (b)Calculate the arithmetic average return for Y. (Click to select) Requirement 2: (a)Calculate the variance for X. (Do not round intermediate calculations.) (Click to select) (b)Calculate the variance for Y. (Do...

  • Using the returns shown below, calculate the arithmetic average returns, the variances, and the standard deviations...

    Using the returns shown below, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. ( Do not round intermediate calculations. Enter your average return and standard deviation as a percent rounded to 2 decimal places, and round the variance to 5 decimal places).                                                    RETURNS Year X Y 1 19% 15% 2 22 34 3 8 14 4 -15 -20 5 10 24                                                                                                           X                                                Y Average Returns            _________      %              ____________      % Variances                      _________                        ____________ Standard...

  • The table below shows annual returns for stocks of companies X and Y. Calculate the arithmetic average returns. In...

    The table below shows annual returns for stocks of companies X and Y. Calculate the arithmetic average returns. In addition, calculate their variances, as well as their standard deviations. Returns Year Y 13% 23% 44 3 20 22 Requirement 1: (a) The arithmetic average return of company X's stock is: Click to select (b)The arithmetic average return of company Y's stock is: Click to select) ) Requirement 2: The variance of company X's stock returns is: (Do not round Intermediate...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT