Each week during the NCAA men’s college basketball season, teams are ranked according to two polls— the AP Poll and the Coach’s Poll. Each team’s position is determined by the number of points received by the polls. The Excel file NCAA basketball.xlsx lists the points 24 teams received for the week of March 11, 2013.

a. Using Excel, calculate the correlation coefficient for this sample.

b. Using α = 0.05, perform a hypothesis test to determine if the correlation coefficient is not equal to zero.

c. What conclusions can be drawn about the consistency of these two polls based on these results?