From the course: Excel for Investment Professionals
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Finding covariances and correlations - Microsoft Excel Tutorial
From the course: Excel for Investment Professionals
Finding covariances and correlations
- [Instructor] A key part of building a portfolio is making sure that the assets that you have in that portfolio provide diversification. Diversification helps to reduce the risk in that overall portfolio but how do we know if two assets are complimentary to one another? How do we know if two assets will provide diversification when compared with one another? Well, Excel can help us with this and the calculation of what we call correlation and covariance. Let me show you what I'm talking about. I'm in the 0305 begin Excel file. Now what we've got here are return data for two different assets over a period of time throughout the year. We've gone through and calculated the arithmetic means for each. Now what we need to do is go through and determine the covariance of these two assets. The covariance tells us how much these assets move in sink with one another. A positive covariance means the two assets will tend to move up at the same time. An extreme example of this would be say…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Computing expected returns on a stock2m 55s
-
(Locked)
Using probability to calculate stock returns3m 35s
-
(Locked)
Computing arithmetic and geometric returns in a portfolio3m 19s
-
(Locked)
Computing standard deviation and variance of an asset4m 41s
-
(Locked)
Finding covariances and correlations5m 6s
-
(Locked)
Computing standard deviation and variance of a portfolio3m 12s
-
(Locked)
Computing beta of an asset4m 33s
-
(Locked)
Computing risk for a portfolio with many stocks3m 33s
-
-
-
-