WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Inverse Correlation

Inverse Correlation

By Rishab NigamRishab Nigam | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is Inverse Correlation?

Inverse correlation is defined as the mathematical relationship between two variables wherein their positions are opposite to each other. It signifies that if one variable displays an increase in its position, then the other variables would display a decrease. A negative correlation coefficient signifies inverse correlation, and the value presented by the correlation coefficient signifies the strength of a linear or non-linear relationship between two variables.

How to Find Inverse Correlation?

The correlation coefficient helps in determining the relationship between two variables using statistical and mathematical relationships as an inverse correlation (when the coefficient is negative).

For two variables X and Y, the correlation coefficient can be expressed as displayed below: –

r = n (∑xy) – ∑x ∑y / √ [n* (∑x2 – (∑x)2)] * [n* (∑y2 – (∑y)2)]

Here the number of variables for determining the correlation coefficient is represented as n.

Popular Course in this category
Sale
Financial Modeling Course (with 15+ Projects)
4.9 (927 ratings)
16 Courses | 15+ Projects | 90+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • If both variables (X and Y) share the same number of data sets employed to determine correlation, it would be termed as homogenous. If both variables share a different number of data sets employed, then it would be termed as heterogeneous.
  • The calculation of correlation for the homogenous dataset is easier and less complex as compared with heterogeneous datasets.

Inverse Correlation

Inverse Correlation Numerical Example

Suppose an investor holds two assets X and Y have the following returns: –

  1. X: 22, 20, 110
  2. Y: 70,80,30

To calculate the correlation coefficient of X and Y, perform the following steps: –

  • ∑X = 22 + 20 + 110 = 152
  • ∑Y = 70 + 80 + 30 = 180
  • ∑(X2)=(22)2+(20)2+(110)2= 12,984
  • ∑(X×Y) = (22×70) + (20×80) + (30×110) = 6,440
  • ∑(X)2 = (152)2 = 23,104
  • ∑(Y)2 = (180)2 = 32,400

Inverse Correlation Solution 1

Inverse Correlation Solution 1-1

Solution 1-2

Solution 1-3

r = – 0.99

Therefore, the Investor holds a diversified portfolio of two assets. The portfolio provides an inverse correlation of -0.99.

Inverse Correlation in Portfolio Diversification

Diversification is a process that reduces concentration risk and helps in the allocation of investment capital in more than one asset. A portfolio of assets is formulated to achieve diversification of risk inherent in holding such assets and ensure stable returns. A portfolio of assets signifies a collection of financial assets: such financial assets maybe bonds, stocks, or commodities.

The diversification achieved for a portfolio of assets is an example of an inverse correlation. When the correlation coefficient is at -1, it is said that the diversification is at maximum, and there is a minimum risk involved in the portfolio of assets formulated.

Inverse Correlation – Gold and Dollar Example

Gold is a commodity that is a very popular instrument which can be used both for hedging purpose as well as for investment. The gold as an asset shares an inverse correlation-based relationship with the United States dollars.

The gold can be used to curb the rising levels of inflations and hence curb any potential loss in the value of US dollars. Whenever a dollar collapses in front of rising inflation, gold can be utilized as an alternative investment tool to curb inflation, stop the loss of value, and reduce the potential impacts of a dollar collapse.

Advantages

  1. It offers diversification to the portfolio of financial assets.
  2. Diversifiable risk is defined as the risk that is specific to the firm.
  3. A portfolio holds assets that are not specific to one firm or industry but caters to multiple firms or industries.
  4. It is not necessary that each industry perform similarly and hence results in an inverse correlation.
  5. An inverse correlation between the two assets can help in the hedging positions.

Limitations

  1. The analysis of the inverse correlation does not account for potential outliers.
  2. Additionally, the analysis does not consider the odd behavior of a few data points taken up in the data set chosen for analysis.
  3. There can be various factors and variables that might not be a part of the determination and analysis of inverse correlation.
  4. Extrapolating the results of reference data onto the new data can give rise to errors and high levels of risk.
  5. An inverse correlation between two variables does not mean a cause-and-effect relationship between the two variables.

Important Points

  1. This analysis is not a static analysis but a dynamic analysis that modifies itself with time.
  2. The two variables taken up for analysis can display a positive correlation for a specific period of time and inverse correlation in the next period of time.
  3. It does not describe the cause and effect relationship between the two variables.
  4. If the correlation is not calculated correctly, it can present skewed results.

Conclusion

The correlation analysis tells us how two variables taken up for analysis behave with each other. In this, if one variable displays appreciation in its characteristics, the other variable would display deterioration in its value. The best way to determine the inverse correlation between two variables is to employ regression analysis and plot the results using a scatter plot.

The portfolio of assets that offers an inverse correlation is said to be diversified. A diversified portfolio reduces the measure of unsystematic risk.

Recommended Articles

This article has been a guide to what is Inverse Correlation and its Definition. Here we discuss formula to calculate the inverse correlation along with examples, advantages, and disadvantages. You can learn more about from the following articles –

  • Excel Inverse Matrix
  • Negative Correlation Matters
  • Pearson Correlation Coefficient Formula
  • Correlation Matrix in Excel
7 Shares
Share
Tweet
Share
Financial Modeling Course (with 15+ Projects)
  • 16 Courses
  • 15+ Projects
  • 90+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More