Figure 9: Calculating the correlation coefficient. Enter the formula = Pearson (array 1, array 2) in any cell.