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

Using the following returns, calculate the arithmetic average returns, the variances,

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. X 15% 26% Year 1 2. 3 4 5 Y 21% 36% 13% -26% 15% 7% UN -13% 11% Complete the following analysis. Do not hard code values in your calculations. Make sure to use the "sample" Excel formulas in your calculations. You must use the built-in Excel functions to answer this question. X Arithmetic 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:

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 following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Using the following returns, calculate the arithmetic average returns,...

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:

You bought one of Great White Shark Repellant Company's 8 percent coupon bonds one year ago for $790. These bonds make annual payments and mature 7 years from now. Suppose you decide to sell your...

Q:

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Returns Year X Y 1 8 % 18 % 2 26 39 3 15 -12 4 -16 -26 5 17 47...

Q:

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year Y 1 15% 21% 2345 26% 36% 3 7% 13% -13% -26% 11% 15% Complete the...

Q:

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Returns Year 1 NMO 26 15 -16 17 25 % 46 -8 -22 54 Calculate the...

Q:

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 % 25 % 2 27 46 3 16 -7 4 -17 -21 5 18 54...

Q:

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 % 18 % 2 27 39 3 16 -7 4 -17 -21 5 18 47 calculate...

Q:

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y Returns 6% 24 % 13 15 Year 2 24 3 4 -1423 5 45 -9 53 Calculate the...

Q:

Consider the setup shown in Fig. Determine the minimum amount of current required to keep the magnetic plate at a distance of 2.5 mm from the pole faces of an electromagnet having 1500 turns when the...

Q:

A researcher claims that more than 30% of U.S. smartphone owners use their phone (shopping, social networking and so on) while watching television. In a random sample of 150 adults, 38% say they use...

Q:

Suppose you own 7 0 , 0 0 0 shares of common stock in a firm with 3 million total shares outstanding. The firm announces a plan to sell an additional 1 . 5 million shares through a rights offering....

Q:

xi) As part of its investing activities, the management of Classique Household Furnishings & Appliances is in the process of completing a major addition to the business property which is estimated to...