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