Determine correlation coefficient and covariance

Reference no: EM1346060

The annual returns of three stocks during the last eight years are presented.

STOCK A: 1%, 6%, 10%, 18%, 20%, 7%, -10%, -2%
STOCK B: 12%, 9%, 16%, 11%, -5%, -2%, -2%, 6%
STOCK C: 20%, -2%, 33%, 10%, -8%, -10%, 8%, 30%

1) Using Excel, Determine the average return, and the standard deviation of returns for each stock. Which stock has the highest expected return and which one has the highest risk?
2) Using Excel, Determine the correlation coefficient and the covariance between each pair of stocks.
3) Using Excel, Determine the expected return, and the standard deviation of returns of equally weighted portfolios consisting of two stocks (AB, BC, and AC) and three (ABC) stocks.
4) Create charts showing how the standard deviation of the two-stock (AB and AC) portfolios' returns changes as the weight of one stock (A) changes.
5) Use the Solver to determine the minimum variance portfolio composed of three stocks (ABC).

Reference no: EM1346060

Questions Cloud

Business communication - persuasive request : Business communication - persuasive request - Will you please make your contribution to the young people by addressing them on April 12?

Find the magnitude of the tension in the rope : When a certain spring is stretched by an amount x, it produces a restoring force of F(x) = ax=bx^2, where a and b are constants. How much work is done through an external force in stretching the spring by an amount D from its equilibrium length.

Business communication - direct and indirect orders : Describe when the direct order is appropriate in inquiries and when would you use the indirect order? Defend your remarks with examples.

Foreign exchange risk-interest rate and exchange rates : In international cash management, managers have choice between managing only foreign exchange risk or managing foreign exchange and interest rate risk together.

Determine correlation coefficient and covariance : The yearly returns of three (3) stocks during the last eight years are presented. Estimate the correlation coefficient and covariance between each pair of stocks.

Explaining use of encryption-virus and vpn : Write down the suitable example of best use of Encryption, Virus, VPN, Firewall securities, when and explain why?

Illustrate what are the interest rates : Consider a monopolist informal moneylender and competitive formal creditors who lend to farmers. illustrate what are the interest rates.

What wavelength of light in the visible region transmitted : A blacksmith heats a 1.9 kg iron horseshoe to 480 degree C, then plunges it into a bucket containing 10kg of water at 20 degree C. The specific heat of iron is 447 J/kgK. What is the final temperature.

Prepare effective project communications systems : Prepare effective project communications systems to keep stakeholders informed of project status.

User Account

All Pages