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

This result is extended in this paper to a matrix, which in a sense is the correlation coefficient between two vector variables x and y. The result is then used to obtain large sample null and ...