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, computed as the correlation coefficient, which has a 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, 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

    An inverse correlation, also known as negative correlation, is ...
  2. Cross-Correlation

    Cross correlation is a measurement that tracks the movements ...
  3. Positive Correlation

    Positive correlation is a relationship between two variables ...
  4. Serial Correlation

    Serial correlation is the relationship between a given variable ...
  5. Forward Price

    The predetermined delivery price of a forward contract, as agreed ...
  6. Alston D. Correll

    A former CEO and chairman of Atlanta-based paper and building ...
Related Articles
  1. 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.
  2. Insights

    Prices of Stocks and Bonds Move More in Tandem

    Correlation between stock and bond prices in the U.S. have reached a 10-year high, reversing a broader trend of negative correlation.
  3. Investing

    Tales From The Trenches: Perfectly Negative Profitability

    Use correlations to profit when two specific instruments move in opposite directions.
  4. Tech

    Are Bitcoin Price And Equity Markets Returns Correlated?

    Is there a correlation between bitcoin's price and the equity markets? We investigate.
  5. Trading

    Apple Earnings: A Lot Depends on iPhone X Outlook

    With reports of sluggish iPhone 8 sales, the outlook for Apple's iPhone X will be key.
  6. Investing

    Do Oil and Natural Gas Prices Rise And Fall Together?

    Do the prices of crude oil and natural gas affect each other? Investopedia explores price patterns and provides analysis.
  7. Financial Advisor

    Illiquid Real Estate: Correlation Pros and Cons

    Stock and bond markets are moving more closely in tandem with each other. Is illiquid real estate the vaccine for this correlation?
  8. Investing

    iPhone X Demand Won't Be Exceptional: Bernstein

    The iPhone X is coming in a few days and a new poll shows that while there will be substantial demand, it won't be exceptional.
RELATED FAQS
  1. What does it mean if the correlation coefficient is positive, negative, or zero?

    When a coefficient is greater than zero, it is a positive relationship; when the value is less than zero, it is a negative ... Read Answer >>
  2. How does correlation affect the stock market?

    Learn about the role correlation plays in prudent stock market investing, and how the correlation coefficient is used to ... Read Answer >>
  3. 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 >>
  4. How is correlation used in modern portfolio theory?

    Discover how modern portfolio theory and the efficient frontier use correlation between investment assets to predict an optimal ... Read Answer >>
  5. How should I interpret a negative correlation?

    Learn more about correlation and how businesses analyze variables. Find out how negative correlations are interpreted by ... Read Answer >>
  6. How are negative correlations used in risk management?

    Learn about risk management and how negative correlations between assets are used to diversify and hedge risk associated ... Read Answer >>
Trading Center