Purchase Solution

Average return, volatility, covariance, correlation

Not what you're looking for?

Ask Custom Question

Using the data in the following table, estimate (a) the average return and volatility for each stock, (b) the covariance between the stocks, and (c) the correlation between these two stocks.

Realized Returns
Year Stock A Stock B
1998 -10% 21%
1999 20% 30%
2000 5% 7%
2001 -5% -3%
2002 2% -8%
2003 9% 25%

Purchase this Solution

Solution Summary

Average return and volatility of return of two stocks have been computed. Also, covariance and correlation between the two stock returns has been calculated.

Solution Preview

The calculations are in the excel file attached:
Using the data in the following table, estimate (a) the average return and volatility for each stock, (b) the covariance between the stocks, and (c) the correlation between these two stocks.

Realized Returns
Year Stock A Stock B
1998 -10% 21%
1999 20% 30%
2000 5% 7%
2001 -5% -3%
2002 2% -8%
2003 9% 25%

Please Note: The % have been written in decimal form (0.21 for 21% and so on

Stock A Stock B
X Y X^2 Y^2 (X-Xmean) (Y-Ymean) (X-Xmean) x ...

Purchase this Solution


Free BrainMass Quizzes
Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.