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

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

Calculate R-squared in Microsoft Excel by creating two data ranges to correlate. Use the correlation formula to correlate both sets of data, or x and y.