Navigate to the sheet titled Football Coach Ratings. This data set shows the coaching points (measure of a coach's quality during a specific game, typically awarded by other coaches) for a sample of college football teams during Week 7 and Week 8 of last season. We are interested to see if there is correlation between these 2 weeks. Calculate the Pearson correlation coefficient, the Spearman correlation coefficient, and then perform a hypothesis test of whether the Spearman correlation coefficient might really be zero. When finished, answer the following.

Team Week 7 coaching points Week 8 coaching points Oklahoma 1575 1622 Southern California 1502 1470 Florida State 1412 1320 LSU 1337 1241 Virginia Tech 1281 1026 Miami 1263 1563 Ohio State 1208 1226 Michigan 1135 938 Georgia 951 1378 lowa 932 762 Texas 881 605 TCU 875 727 Washington State 827 1260 Purdue 667 487 Michigan State 645 1041 Nebraska 558 924 Tennessee 544 449 Minnesota 490 149 Florida 480 246 Bowling Green 369 577