Earn your certification as a Financial Modeling & Valuation Analyst (FMVA)®. Register today!

Correlation

A statistical measure of the relationship between two variables

What is a Correlation?

A correlation is a statistical measure of the relationship between two variables. The measure is best used in variables that demonstrate a linear relationship between each other. The fit of the data can be visually represented in a scatterplot. Using a scatterplot, we can generally assess the relationship between the variables and determine whether they are correlated or not.

 

Correlation

 

The correlation coefficient is a value that indicates the strength of the relationship. The coefficient can take any values from -1 to 1. The interpretations of the values are:

  • -1: Perfect negative correlation. The variables tend to move in opposite directions (i.e., when one variable increases, the other variable decreases).
  • 0: No correlation. The variables do not have a relationship between each other.
  • 1: Perfect positive correlation. The variables tend to move in the same direction (i.e., when one variable increases, the other variable also increases).

 

One of the primary applications of the concept in finance is portfolio management. A thorough understanding of the statistical concept among various securities is essential to a successful portfolio optimization.

 

Correlation and Causation

Correlation must not be confused with causality. The famous expression “correlation does not mean causation” is crucial to the understanding of the two statistical concepts.

If two variables are correlated, it does not imply that one variable causes the changes in another variable. Correlation only assesses relationships between variables, and there may be different factors that can lead to the relationships. Causation may be a reason for the correlation, but it is not the only one.

 

CFI’s Math for Corporate Finance Course explores the financial mathematics concepts required for financial modeling.

 

How to Find the Correlation?

The correlation coefficient that indicates the strength of the relationship between two variables can be found using the following formula:

 

Correlation - Formula

 

Where:

  • rxy – the correlation coefficient of the linear relationship between the variables x and y
  • x– the values of the x-variable in a sample
  • – the mean of the values of the x-variable
  • yi – the values of the y-variable in a sample
  • ȳ – the mean of the values of the y-variable

 

In order to calculate the correlation coefficient using the formula above, you must undertake the following steps:

  1. Obtain data sample with the values of x-variable and y-variable.
  2. Calculate the means (averages) x̅ for the x-variable and ȳ for the y-variable.
  3. For the x-variable, subtract the mean from each value of the x-variable (let’s call this new variable “a”). Do the same for the y-variable (let’s call this variable “b”).
  4. Multiply each a-value by the corresponding b-value and find the sum of these multiplications (the final value is the numerator in the formula).
  5. Square each a-value and calculate the sum of the resulted values. Do the same for the b-values.
  6. Multiply the sums from the previous step.
  7. Find the square root of the value obtained in the previous step (this is the denominator in the formula).
  8. Divide the value obtained in step 4 by the value obtained in step 7.

 

You can see that the manual calculation of the coefficient is an extremely tedious process, especially if the data sample is large. However, there are many software tools that can help you to save time when calculating the coefficient. The CORREL function in Excel is one of the easiest ways to quickly calculate the correlation between two variables for a large data set.

 

Example of Correlation

John is an investor. His portfolio primarily tracks the performance of the S&P 500 and John wants to add the stock of Apple Inc. Before adding Apple to his portfolio, he wants to assess the correlation between the stock and S&P 500 to ensure that in the case of a market decline, the stock will not also go down. To find the coefficient, John gathers the following prices for the last five years (Step 1):

 

Correlation Example - Table 1

 

Using the formula above, John can determine the correlation between the prices of S&P 500 and Apple Inc.

Firstly, John calculates the average prices of each security for the given periods (Step 2):

 

Correlation Example - Table 2

 

After the calculation of the average prices, we can find the other values. A summary of the calculations is given in the table below:

 

Correlation Example - Table 3

 

Using the obtained numbers, John can calculate the coefficient:

 

Correlation - Sample Calculation

 

The coefficient indicates that the prices of S&P 500 and Apple Inc. are highly positively correlated. It means that the prices of the securities tend to move in the same direction.

 

Related Readings

CFI is the official provider of the Financial Modeling and Valuation Analyst (FMVA)™ certification program, designed to transform anyone into a world-class financial analyst.

To keep learning and developing your knowledge of financial analysis, we highly recommend the additional resources below:

  • Anchoring Bias
  • Dynamic Financial Analysis
  • Hypothesis Testing
  • Poisson Distribution

Financial Analyst Training

Get world-class financial training with CFI’s online certified financial analyst training program!

Gain the confidence you need to move up the ladder in a high powered corporate finance career path.

 

Learn financial modeling and valuation in Excel the easy way, with step-by-step training.