Question: Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year X Y 1 13% 27%

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

Year X Y
1 13% 27%
2 26% 36%
3 7% 11%
4 -5% -29%
5 11% 16%
(Use cells A6 to C11 from the given information to complete this question. You must use the built-in Excel function to answers this question. Make sure to use the sample Excel formulas.)
Output area:
Asset X:
Average return
Variance
Standard deviation
Asset Y:
Average return
Variance
Standard deviation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y Year -NM Returns X Y 7% 18 % 25 39 14 -15 27 16 47 -13 Requirement :...

Q:

2 3 4 Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Input area: 5 6 7 8 9 10 11 12 13 (Use cells A6 to C11 from the...

Q:

i. Calculating Returns Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $88. Compute the percentage of total...

Q:

PLEAZE HELP!! 3 . Using the following returns, calculate the arithmetic average returns the variances, and the standard deviations for X and Y. Returns X Y 15% 25 % 46 22 -13 -23 -27 24 54 Year 1 2 3...

Q:

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 Year 1 2 3 4 5 X 15% 26 7...

Q:

FINA6301 HWK Problems 13th Edition Chapters 10 - Session 8 7. Calculating Returns and Variability Using the following returns, calculate the arithmetic average returns, the variances, and the...

Q:

17. 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 1 2 3 4 5 X...

Q:

PLEASE ANSWER IN EXCEL FORM WITH EXACT CELL FORMULAS USED TO SOLVE EACH OF THE YELLOW BOXES. Using the following returns, calculate the arithmetic average returns, the variances, and the standard...

Q:

Please put the formula you used in getting your answer. Excel Assignment i Submitted 18.5 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 86 Calibri 11 AA % M 3 Paste BIU- A Alignment...

Q:

Its all one question but multiple parts Using the following returns, calculate the arithmetic average retums, the variances, and the standard deviations for X and Y. Returns by Year 1 2 3 4 5 (b) 12...

Q:

Using the information presented in Exhibit as a guide, prepare an effective goal for a call center customer-service worker who is responsible for resolving call-in problems about digital cameras.

Q:

In Problems 37-52, find the area bounded by the graphs of the indicated equations over the given intervals (when stated). Compute answers to three decimal places. y = x2 - 1; y = x - 2; - 2 x 1

Q:

Which of the following statements desorbing the dfferences between a bond and a common share iswe is correct? A bond issue provides for enhanced stablity of a corporation's operating income A larger...

Q:

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...