A correlation coefficient 1 would mean a perfect positive ... This formula tells Excel to calculate the correlation between the sales revenue data in A2:A201 and the advertising spend data on ...