EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Correlation Formula
Secondary Sidebar
Finance Blog
  • Accounting Fundamentals Resources (720+)
  • Asset Management Tutorial (200+)
  • Banking (44+)
  • Corporate Finance Resources (374+)
  • Credit Research Fundamentals (6+)
  • Economics (104+)
  • Finance Formula (384+)
  • Financial Modeling in Excel (16+)
  • Investment Banking Resources (142+)
  • Investment Banking Careers (29+)
  • Trading for dummies (69+)
  • valuation basics (26+)
  • Insurance Resources (15+)
  • Top Finance Books (33+)
Finance Blog Courses
  • Investment Banking Course
  • Investment Banking Online Course
  • Financial Modeling Certification

Correlation Formula

By Madhuri ThakurMadhuri Thakur

Correlation Formula

Correlation Formula (Table of Contents)

  • Correlation Formula
  • Examples of Correlation Formula (With Excel Template)
  • Correlation Formula Calculator

Correlation Formula

Correlation is widely used in portfolio measurement and the measurement of risk. Correlation measures the relationship between two independent variables and can be defined as the degree of relationship between two stocks in the portfolio through correlation analysis. The correlation measure is known as the coefficient of correlation and is a primary measure of the risk. The correlation analysis gives us an idea about the degree & direction of the relationship between the two variables under study.

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

The formula for correlation is equal to Covariance of return of asset 1 and Covariance of asset 2 / Standard.

Deviation of asset 1 and a Standard Deviation of asset 2.

Correlation

  • ρxy = Correlation between two variables
  • Cov(rx, ry) = Covariance of return X and Covariance of return of Y
  • σx = Standard deviation of X
    • σy = Standard deviation of Y

Correlation is based on the cause of effect relationship, and there are three kinds of correlation in the study, which is widely used and practiced.

  • Positive Correlation – A positive correlation exists between two variables when they are said to move in the same direction. For example height and weight.
  • Negative Correlation – There is said to exist a negative correlation between two variables when the variable change in the opposite direction. For example, the law of demand, quantity, and supply.
  • No Correlation – There exists no correlation between two variables when there is no movement of a direct relationship between the two variables. That is, they do not have any relationship in the movement of each other.

Examples of Correlation Formula (With Excel Template)

Let’s take an example to understand the formula calculation better.

You can download this Correlation Template here – Correlation Template

Correlation Formula – Example #1

A fund manager wants to calculate the coefficient of correlation between two stocks in the debt real estate assets portfolio.

Correlation Formula Example 1-1

Solution:

Correlation is calculated using the formula given below

ρxy = Cov(rx, ry) / (σx * σy)

Result of Example 1

  • Correlation = 0.2 / (1.4 * 1.2)
  • Correlation = 0.12

Correlation Formula – Example #2

A student wants to calculate the coefficient of correlation between two stocks in the portfolio.

Correlation Formula Example 2-1

Solution:

Correlation is calculated using the formula given below

ρxy = Cov(rx, ry) / (σx * σy)

Result of Example 2

  • Correlation = -1 / (4 * 2)
  • Correlation = -0.13

Correlation Formula – Example #3

A VC fund is evaluating its portfolio, and it wants to calculate the coefficient of correlation between two stocks in the portfolio.

Correlation Formula Example 3-1

Solution:

Correlation is calculated using the formula given below

ρxy = Cov(rx, ry) / (σx * σy)

Result of Example 3

  • Correlation = 4 / (0.98 * 0.12)
  • Correlation = 34.01

Explanation

Correlation is used in the measure of the standard deviation.

  • A coefficient of 1 means a perfect positive relationship – as one variable increases, the other increases proportionally.
  • A coefficient of -1 means a perfect negative relationship – as one variable increases, the other decreases proportionally.
  • A coefficient of 0 means no relationship between two variables – the data points are scattered throughout the graph.

Relevance and Uses of Correlation

  • Correlation empowers the researcher to detect the unethically occurring variables to test experimentally.
  • Correlation is very important in Psychology and Education as a measure of the relationship between test scores and other performance measures.
  • It is an important formula that tells the user the strength and the direction of a linear relationship between variable x and y. The greater the absolute value, the stronger the relationship tends to be.
  • Researchers should avoid inferring causation from correlation, which is unsuited for analysis of the agreement. Correlational research has had and will continue to have an important role in quantitative research in exploring the nature of the relations among a collection of variables.

Correlation Formula Calculator

You can use the following Correlation Calculator

Con(rx,ry)
σx
σy
ρxy
 

ρxy =
Con(rx,ry)
(σx * σy)
0
= 0
(0 * 0)

Recommended Articles

This is a guide to Correlation Formula. Here we have discussed how to calculate Correlation along with practical examples. We also provide a Correlation calculator with a downloadable excel template. You may also look at the following articles to learn more –

  1. Guide Portfolio Variance Formula
  2. How To calculate PEG Ratio?
  3. Calculator For Debtor Days Formula
  4. Complete Guide to PEG Ratio
Popular Course in this category
Financial Analyst Masters Training Program
  250+ Online Courses |  1000+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course

Related Courses

Investment Banking Training4.9
Investment Banking Training4.8
Financial Modeling Training4.7
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

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

Download Correlation Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Correlation Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more