How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
statistics
How to Calculate Covariance.
statistics

How to Calculate Covariance.

Rosemary Njeri

Let us begin by defining covariance before we dive into discussing how to calculate it. Covariance measures the directional relationship between the return on two assets.

Types of Covariance.

The first one is the positive covariance. A positive covariance between two variables indicates that these variables tend to be higher or lower at the same time.

Negative Covariance. When the calculated covariance is less than negative, this indicates that the two variables have an inverse relationship.

Application of Covariance.

We can use covariance to evaluate the risk of particular stocks by comparing whether they move with or against each other.

The covariance formula has applications in finance, majorly in portfolio theory. Thus, the assets can be chosen that do not exhibit a high positive covariance with each other and partially eliminating the unsystematic risk.

Formula to Calculate Covariance.

How to Calculate Covariance.

x is the data value of x

y is the data value of y

μx is the mean of x

μy is the mean of y

N is the number of data values

Example:

Suppose an analyst observed the behavior of stock x and y. If the return of stock x is 2000 and the mean is 150, calculate the covariance if the return of stock y us 1500 and its mean is 120 when N is 5.

Since we already have the return in total, we do not need to do any summation, we will just plug our values in the formula.

How to Calculate Covariance.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How to Calculate Age in Excel.
In this case. we are going to learn how to …

How to Calculate Age in Excel.

How to Calculate Standard Error in Excel.
In this article, we will define and discuss how to …

How to Calculate Standard Error in Excel.

Popular Posts

    Categories

    learntocalculate.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

    How To Calculate

    Learn how to calculate anything

    Pages

    • About Us
    • Contact Us
    • Privacy Policy
    Copyright © 2025 How To Calculate

    Ad Blocker Detected

    Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

    Refresh