Using the lobbying data from the previous assignment, we will combine/join it with population data in order to make more sense of what is going on. Answer the following questions in separate Worksheets in Tableau. Use different charts to explain your answers (not just bar chart).
• Which city has the highest spending per person (per-capita) on lobbyists? What are the top 3 counties with the highest spending per-capita?
• How many counties with more than 10,000 are there, and how many cities with more than 10,000 are there (2010 population)?
• Compare the highest spending county and city with 2010 population and 2000 population. Any difference?
• What is your new conclusions based on the data? Has your story changed compared to last week’s exercise?