Home


Keywords: correlation coefficient

Correlation Coefficient: Correlation Coefficient



The Correlation Coefficient is a statistical measure that reflects the correlation between two securities. In other words, this statistic tells us how closely one security is related to the other. The Correlation Coefficient is positive when both securities move in the same direction, up or down. The Correlation Coefficient is negative when the two securities move in opposite directions. Determining the relationship between two securities is useful for analyzing intermarket relationships, sector/stock relationships and sector/market relationships. This indicator can also help investors diversify by identifying securities with a low or negative correlation to the stock market.



The calculation for the Correlation Coefficient is rather complicated so feel free to skip this section. We will simply look at the basics to see some of the method behind the madness. This indicator is right at the heart of classical statistics. The first step is to select two securities. In this example, we will be using Intel (INTC) and the Nasdaq 100 ETF (QQQ). Namely, we want to see the degree of correlation between Intel and QQQ. The excel table below lays out the groundwork.

Correlation Coefficient  -  Excel Example

©2003-2012 Copyright www.channellines.com 
Copyright/IP Policy Contact Webmaster