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: ...

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

Calculating the Pearson correlation coefficient can be complicated but software makes it much easier. You can use several methods to calculate correlation in Excel.