Question

A market researcher looked at the quarterly sales revenue for a large e-commerce store and for a large brick-and-mortar retailer over the same period. The researcher recorded the revenue in millions of dollars for 30 quarters. The data are provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.

E-Commerce   Brick-and-mortar
1074   13.11
1155   13.08
1476   12.9
1548   13.77
1800   13.49
1977   13.83
2057   13.89
1955   13.86
1884   13.86
2193   12.9
2186   13.4
2301   12.72
2280   13.38
2457   12.86
2899   12.46
2663   12.28
3414   12.7
3251   12.83
3602   12.07
3697   12.93
3956   12.09
4349   12.63
4497   12.59
4664   12.46
4497   12.03
4473   11.28
4976   11.55
4853   11.84
5103   11.46
5204   11.91

Answer 1