Finding Correlation in Excel There are several methods to calculate correlation in Excel. The simplest is to get two data sets side-by-side and use the built-in correlation formula: ...

You can calculate the correlation coefficient to find the correlation between any two variables, whether they are market indicators, stocks, or anything else that can be tracked numerically.