EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login
Home Finance Finance Resources Valuation Basics Correlation Example
Secondary Sidebar
Finance Blog
  • valuation basics
    • Unsystematic Risk
    • EV to EBITDA Multiple
    • Equity Value
    • What is Beta?
    • Correlation Example
    • Inherent Risk
    • Feasibility Study Examples
    • Business Valuation Methods
    • Free Cash Flow to Firm
    • Working Capital Projections
    • Terminal Value Methodologies
    • Methods To Calculate WACC
    • Cost Of Equity Through Risks
    • Steps To Calculate Beta
    • Estimate Market Risk Premium
    • Enterprise Value Calculation
    • CAPM Calculations
    • Book Value vs Market Value
    • Discounted Cash Flow Analysis
    • Equity Financing
    • Simple Interest vs Compound Interest
    • Present Value vs Future Value
    • Assessed Value vs Market Value
    • Equity vs Royalty
    • Average Cost vs Marginal Cost
    • Terminal Value DCF
  • Accounting fundamentals (700+)
  • Asset Management Tutorial (200+)
  • Banking (44+)
  • Corporate Finance Basics (373+)
  • Credit Research Fundamentals (6+)
  • Economics (88+)
  • Finance Formula (386+)
  • Financial Modeling in Excel (17+)
  • Investment Banking Basics (140+)
  • Investment Banking Careers (29+)
  • Trading for dummies (69+)
  • Insurance Resources (14+)
  • Top Finance Books (7+)
Finance Blog Courses
  • Equity Research Online Training
  • Business Valuation Course
  • Private Equity Training Course

Correlation Example

By Madhuri ThakurMadhuri Thakur

Correlation Example

Introduction to Correlation Example

The following Correlation examples outline the most common set of Correlation examples:

Example #1

The height and weight of 5 students in a class are mentioned below:

Student Name Height (in cm) Weight (in kgs)
Frank 160 53
Leo 165 61
Jerry 172 74
Celeste 150 51
Tracy 180 82

Based on this simple data of Height and Weight of students, we can observe a correlation pattern that is positive in nature. The data implies that with greater height, weight also increases, and inference drawn from the correlation implies that taller people are usually heavier in weight.

Start Your Free Investment Banking Course

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

All in One Financial Analyst Bundle(250+ Courses, 40+ Projects)
Financial ModelingInvestment BankingUS GAAPCFA-Level 1 & 2
Equity ResearchM & A ModelingPrivate Equity ModelingForex Trading
Price
View Courses
250+ Online Courses | 40+ Projects | 1000+ Hours | Verifiable Certificates | Lifetime Access
4.9 (86,580 ratings)

Similar types of examples can be observed in the correlation between Sales of Refrigerators and Increase in Temperature, which highlights a Positive Correlation.

Example #2

Provided below are the speed of different trains and the amount of time taken to reach the same destination.

Train Name Speed (in km/hr) Time Taken (in hrs)
A 40 5
B 50 4
C 80 2.5

Here we can easily observe the Negative Correlation that Speed and Time are taken has with greater the speed of Train, less the number of hours taken to reach the destination.

Example of Correlation (With Excel Template)

Let’s take an example to understand the calculation of the Correlation in a better manner.

You can download this Correlation Example Excel Template here – Correlation Example Excel Template

Correlation – Example #1

The following table exhibits the returns on ABC Limited’s two stocks in their Model Portfolio for the last 5 years. Based on the same, let us calculate and interpret the correlation between the two stocks.

Correlation Example - 1.1

Solution:

We will try to find the correlation between the two assets using the Pearson Correlation Coefficient, which is one of the most popular methods used for measuring the Linear Relationship between two variables which in our case is the two stocks, namely: Facebook and Amazon.

Correlation Example - 1.2

The average Mean for 5 years is calculated as

Correlation Example - 1.3

Standard Deviation is calculated as

Correlation Example - 1.4

The Sum of C*D is calculated as

Correlation Example - 1.5

Covariance is calculated as

Correlation Example - 1.6

Correlation is calculated using the given formula below

Pearson Correlation Coefficient = ρXY = covXY / σXσY

Pearson Correlation

The Correlation of Negative 0.7501 implies a low to high Negative Correlation between the two stocks.

The correlation discussed through the above example is basically the Pearson Correlation Coefficient method and is helpful in measuring the linear relationship between the two variables, which in our case was the two stocks in the model portfolio.

Correlation – Example #2

Let’s take another example and understand correlation measure using other popular approach known as Spearman Rank Correlation. It is an Ordinal Correlation measure, and correlation calculation is undertaken based on the relationship between the rank of the variables.

popular approach

Solution:

Correlation Example - 2.2

X is calculated as

X is calculated

The Sum of (di^2) is calculated as

Sum of (di^2)

The following table exhibits the returns on two stocks X and Y, for the last 5 months. Based on the same, let us compute and interpret the correlation between the two stocks using the Spearman Rank Correlation method.

Correlation is calculated using the formula given below

Spearman Correlation = ρ = 1 – [(6Σd2) / n(n2 – 1)]

Spearman Correlation

In order to calculate correlation using the Spearman Correlation method, we will first rank the returns of Stock X from lowest to highest in the second column, and similarly, the returns for Stock Y are listed in the third column for each respective month. The fourth and fifth columns list the return for Stock X and Y rank-wise. In the sixth column, the difference in rankings for each month is listed, and in the seventh column, the sum of squared differences in rankings is determined.

Correlation – Example #3

The following data is observed from the medical reports of 10 patients categorized on the basis of their Age and Blood Pressure Level. Based on the same, let us calculate the Correlation Coefficient.

medical reports

Solution:

 medical reports of 10 patients

The Sum of is calculated as

Example - 3.3

Correlation is calculated using the formula given below

r = NΣxy – (Σx)(Σy) / √ [NΣx2 – (Σx)2][NΣy2 – (Σy)2]

Example - 3.4

Conclusion

Correlation examples can be encountered in our day-to-day life and are useful in understanding the relationship between two things. Researchers often use it for predicting purposes as well as to validate any relationship between different variables. The correlation coefficient varies from -1 to 1 values where -1 indicates a strong Negative Correlation and 1 indicates a strong Positive Correlation between the variables, and a Correlation value of Zero indicates no relationship between the two variables. The above examples, both simple and Practical ones, are discussed to validate the Correlation concept and its relevance in statistical and other analytical studies.

Recommended Articles

This is a guide to Correlation Example. Here we discuss how to calculate the Correlation by using its different methods with different examples. You may also look at the following articles to learn more –

  1. Financial Analysis Example
  2. Demand Elasticity Example
  3. Break-Even Analysis Example
  4. Cost of Goods Sold Example
Popular Course in this category
Equity Research Training (17 Courses)
  17 Online Courses |  65+ Hours |  Verifiable Certificate of Completion |  Lifetime Access
4.9
Price

View Course

Related Courses

Business Valuation Training (16 Courses)4.9
Private Equity Training (19+ Courses with Case Studies)4.8
0 Shares
Share
Tweet
Share
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

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

EDUCBA
Free Financial Modeling Course

3 Statement Model Creation, Revenue Forecasting, Supporting Schedule Building, & others

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

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

EDUCBA Login

Forgot Password?

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

EDUCBA
Free Investment Banking Course

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

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

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

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

Let’s Get Started

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

EDUCBA

Download Correlation Example Excel 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