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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!