85, 10.50, 5.50, 10.35, 10.20, 7.60, 10.10, 12.35, 8.35
(a) Calculate the correlation coefficient (r):
Using Excel, we can calculate the correlation coefficient using the formula =CORREL(X,Y), where X and Y are the ranges of the Age and Spent data, respectively.
Show more…