Loading the player...

What is 'Correlation'

Correlation, in the finance and investment industries, is a statistic that measures the degree to which two securities move in relation to each other. Correlations are used in advanced portfolio management. Correlation is computed into what is known as the correlation coefficient, which has value that must fall between -1 and 1.

BREAKING DOWN 'Correlation'

A perfect positive correlation means that the correlation coefficient is exactly 1. This implies that as one security moves, either up or down, the other security moves in lockstep, in the same direction. A perfect negative correlation means that two assets move in opposite directions, while a zero correlation implies no relationship at all.

For example, large-cap mutual funds generally have a high positive correlation to the Standard and Poor's (S&P) 500 Index, very close to 1. Small-cap stocks have a positive correlation to that same index also, but it is not as high, generally around 0.8.

However, put option prices and underlying stock prices tend to have a negative correlation. As the stock price increases, the put option prices go down. This is a direct and high-magnitude negative correlation.

Correlation Calculation Example

Investment managers, traders and analysts find it very important to calculate correlation, because the risk reduction benefits of diversification rely on this statistic. Financial spreadsheets and software can calculate the value of correlation quickly.

Assume an analyst needs to calculate the correlation for the following two data sets:

X: 41, 19, 23, 40, 55, 57, 33

Y: 94, 60, 74, 71, 82, 76, 61

There are three steps involved in finding the correlation. The first is to add up all the X values to find SUM(X), add up all the Y values to fund SUM(Y) and multiply each X value with its corresponding Y value and sum them to find SUM(X,Y):

SUM(X) = (41 + 19 + 23 + 40 + 55 + 57 + 33) = 268

SUM(Y) = (94 + 60 + 74 + 71 + 82 + 76 + 61) = 518

SUM(X,Y) = (41 x 94) + (19 x 60) + (23 x 74) + ... (33 x 61) = 20,391

The next step is to take each X value, square it, and sum up all these values to find SUM(x^2). The same must be done for the Y values:

SUM(X^2) = (41^2) + (19^2) + (23^2) + ... (33^2) = 11,534

SUM(Y^2) = (94^2) + (60^2) + (74^2) + ... (61^2) = 39,174

Noting that there are seven observations, n, the following formula can be used to find the correlation coefficient, r:

r = (n x (SUM(X,Y) - (SUM(X) x (SUM(Y))) / SquareRoot((n x SUM(X^2) - SUM(X)^2) x (n x SUM(Y^2) - SUM(Y)^2))

In this example, the correlation would be:

r = (7 x 20,391 - (268 x 518) / SquareRoot((7 x 11,534 - 268^2) x (7 x 39,174 - 518^2)) = 3,913 / 7,248.4 = 0.54

RELATED TERMS
  1. Inverse Correlation

    A contrary relationship between two variables such that they ...
  2. Benchmark For Correlation Values

    A benchmark or point of reference chosen by an investment fund ...
  3. Negative Correlation

    A relationship between two variables in which one variable increases ...
  4. Correlation Coefficient

    A measure that determines the degree to which two variable's ...
  5. Positive Correlation

    A relationship between two variables in which both variables ...
  6. Forward Price

    The predetermined delivery price for an underlying commodity, ...
Related Articles
  1. Investing

    Correlation

    In the world of finance, correlation is a statistical measure of how two securities move in relation to each other.
  2. Financial Advisor

    4 Reasons Why Market Correlation Matters

    Learn about how correlation can be used to measure how broader markets move in relation to each other. See how correlation is used to manage risk.
  3. Investing

    What's the Correlation Coefficient?

    The correlation coefficient is a measure of how closely two variables move in relation to one another. If one variable goes up by a certain amount, the correlation coefficient indicates which ...
  4. Trading

    Using Currency Correlations To Your Advantage

    Knowing the relationships between pairs can help control risk exposure and maximize profits.
  5. Investing

    Understanding the Oil & Gas Price Correlation

    Learn how the correlation between the commodity prices for natural gas and oil changed from 2004 to 2015 due to increased natural gas production.
  6. Investing

    How To Trade Currency And Commodity Correlations

    Relationships between currencies and commodities exist throughout the financial markets. Find out how to trade these trends.
  7. Investing

    Tales From The Trenches: Perfectly Negative Profitability

    Use correlations to profit when two specific instruments move in opposite directions.
  8. Investing

    Diversification: Protecting Portfolios From Mass Destruction

    This investing strategy retains its charm as a protection against random events in the market.
  9. Investing

    Explaining Autocorrelation

    Autocorrelation is the measure of an internal correlation with a given time series.
RELATED FAQS
  1. How can you calculate correlation using Excel?

    Find out how to calculate the Pearson correlation coefficient between two data arrays in Microsoft Excel through the CORREL ... Read Answer >>
  2. How do I find positive correlation in the stock market?

    Learn how positive correlation is found in the stock market, how correlation is calculated and how positive correlation is ... Read Answer >>
  3. Does a negative correlation between two stocks mean anything?

    Learn what the concept of negative correlation means, understand how it is generally calculated and see how it is used in ... Read Answer >>
  4. What is the difference between a copay and a deductible?

    Learn how the correlation coefficient may be used to predict the relationship between the returns of two stocks, but also ... Read Answer >>
  5. What does a negative correlation coefficient mean?

    Discover the meaning of a negative correlation coefficient, how this compares to other correlation coefficients and examples ... Read Answer >>
  6. How do I calculate correlation between market indicators and specific stocks?

    Discover how to calculate the correlation coefficient between market indicators and stock prices, a critical skill in technical ... Read Answer >>
Hot Definitions
  1. Graduate Management Admission Test - GMAT

    A standardized test intended to measure a test taker's aptitude in mathematics and the English language. The GMAT is most ...
  2. Magna Cum Laude

    An academic level of distinction used by educational institutions to signify an academic degree which was received "with ...
  3. Cover Letter

    A written document submitted with a job application explaining the applicant's credentials and interest in the open position. ...
  4. 403(b) Plan

    A retirement plan for certain employees of public schools, tax-exempt organizations and certain ministers. Generally, retirement ...
  5. Master Of Business Administration - MBA

    A graduate degree achieved at a university or college that provides theoretical and practical training to help graduates ...
  6. Liquidity Event

    An event that allows initial investors in a company to cash out some or all of their ownership shares and is considered an ...
Trading Center