The tab "2011" contains data on 200 Golfers in the PGA tour in the order of their rankings. Detailed information on the specific fields are available under "comments". Understand the data and conduct the following:
1. Clean up the data set. Only keep rows that have complete information.
2. Utilize Pivot Tables to summarize the data
- Classify ages into distributions to create a histogram; provide frequencies and relative frequencies of each age group
- Provide summary statistics of rounds, cuts, and wins for each of your age group
3. The dataset provides data on a lot of leading indicators (driving accuracy, putting average, birdies, eagles, etc.) towards success in the game. Design a model that best describes earnings in this game as a factor of the indicators provided.
Correct approach; well structured, fantastic visual appeal and readability; well labeled, cited, and information flows properly between sheets, and the most important outcome(s) are easy to detect on the page.