You can use several methods to calculate correlation in Excel. Understanding Correlation. The correlation coefficient ranges from -1 to 1. Exactly 1 is considered perfect.

How to Do Residuals in Excel. ... Excel 2013 can compare this data to determine the correlation which is defined by a ... Enter "=B1-C1" without quotes in cell D1 to calculate the ...

The other key result is the correlation of the two. Regression statistics will typically include an R-squared value. The closer to 1 this is, the stronger the correlation between the returns of ...