Question: . The excel file Homework 2 Question 3 Data , posted with this assignment, provides data for 2010 professional season for the top 18 golfers.
. The excel file Homework 2 Question 3 Data, posted with this assignment,provides data for 2010 professional season for the top 18 golfers. Determine the correlation matrix for this data by using the Correlation tool in Data Analysis and suggest some associations.
Note: Please include the Excel worksheet with all the details with your answer
Information below is the excel info.
| Golfing Statistics | ||||||
| Earnings/Event | Events | Avg. Score | GIR (%)* | Driving Distance | Driving Accuracy (%) | Putts/Round |
| $239,493.68 | 22 | 70.37 | 67.9 | 288.4 | 60.2 | 31.82 |
| $177,249.18 | 28 | 69.43 | 69.4 | 286.9 | 67.9 | 31.30 |
| $218,619.18 | 22 | 70.23 | 67.1 | 276.0 | 71.0 | 31.81 |
| $186,380.08 | 24 | 70.46 | 68.0 | 308.5 | 56.4 | 31.81 |
| $209,511.75 | 20 | 69.78 | 68.3 | 282.9 | 68.5 | 31.43 |
| $181,987.29 | 21 | 70.34 | 65.1 | 299.1 | 52.7 | 31.72 |
| $162,536.13 | 23 | 69.92 | 66.3 | 287.8 | 65.2 | 31.68 |
| $174,534.95 | 21 | 70.25 | 65.3 | 277.0 | 62.4 | 31.52 |
| $135,353.70 | 27 | 70.64 | 68.0 | 291.8 | 67.9 | 32.35 |
| $212,540.82 | 17 | 69.93 | 68.7 | 294.2 | 61.3 | 31.55 |
| $297,079.50 | 12 | 70.26 | 69.3 | 298.7 | 61.3 | 32.31 |
| $168,904.45 | 20 | 69.96 | 66.0 | 291.4 | 64.8 | 31.79 |
| $135,791.58 | 24 | 70.21 | 68.5 | 309.8 | 55.7 | 31.73 |
| $133,695.52 | 23 | 70.53 | 68.2 | 289.1 | 64.8 | 31.86 |
| $112,192.04 | 26 | 70.59 | 66.5 | 279.7 | 71.2 | 31.30 |
| $215,121.67 | 12 | 70.22 | 66.5 | 292.4 | 60.1 | 32.29 |
| $183,922.93 | 14 | 70.86 | 62.9 | 287.2 | 52.0 | 31.99 |
| $150,251.76 | 17 | 70.94 | 66.2 | 300.0 | 62.6 | 32.31 |
| *GIR: Greens in Regulation |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
