Homework Sourse343 College football players trying out for the NFL are give
3.43 College football players trying out for the NFL are given the Wonderlic standardized intelligence test. The file Wonderlic contains the average Wonderlic score of football players trying out for the NFL and the graduation rate for football players at selected schools.
Source: Data extracted from S. Walker, “The NFL’s Smartest Team,”
The Wall Street Journal, September 30, 2005, pp. W1, W10.
a. Compute the covariance.
b. Compute the coefficient of correlation.
c. Based on (a) and (b), what conclusions can you reach about the relationship between the average Wonderlic score and graduation rate?
| School | Wonderlic | Graduation% |
| Stanford | 28.8 | 85 |
| Purdue | 25.3 | 63 |
| California | 25.2 | 48 |
| UCLA | 24.0 | 55 |
| Oregon | 23.5 | 68 |
| Wisconsin | 23.2 | 56 |
| Iowa | 23.0 | 58 |
| Oregon State | 22.8 | 44 |
| Nebraska | 22.6 | 63 |
| Notre Dame | 22.5 | 77 |
| Boston College | 22.0 | 78 |
| Colorado | 21.8 | 43 |
| Michigan | 21.7 | 57 |
| Virginia | 21.5 | 75 |
| Texas A & M | 21.0 | 50 |
| Florida | 20.8 | 42 |
| Ohio State | 20.8 | 52 |
| Penn State | 20.7 | 74 |
| Virginia Tech | 20.7 | 58 |
| Southern California | 20.3 | 58 |
| West Virginia | 20.3 | 46 |
| Arizona State | 20.2 | 44 |
| Kansas State | 19.8 | 61 |
| Georgia | 19.8 | 53 |
| Texas | 19.7 | 34 |
| North Carolina State | 19.6 | 42 |
| Florida State | 19.4 | 49 |
| Oklahoma | 19.0 | 40 |
| North Carolina | 18.9 | 53 |
| Arkansas | 18.6 | 35 |
| Auburn | 18.5 | 48 |
| LSU | 18.5 | 42 |
| Clemson | 18.3 | 51 |
| Alabama | 18.2 | 49 |
| South Carolina | 17.9 | 54 |
| Tennessee | 17.7 | 38 |
| Michigan State | 16.6 | 41 |
| Miami (Florida) | 16.3 | 57 |
Solution
excel is used for the calculations.
a) the covarience value is 17.12209
b) correlation is 0.54973
c) Based on a and b we notice that there is positive moderate correlation between the two variables.
