Next step analysis first look. First we can take a quick examination of the age distribution of your clients. The average age of your clients at age of first contact is 48 years.

We can also look at where your clients come from, geographically.

My first attempt at looking at clients by city and age was not successful, and highlighted your data coding problem. There are inconsistencies in spelling and capitalization in the spreadsheet that cause errors when trying advanced analysis.

There are obviously some duplicates and errors in this coding. We will subset this by summarizing your data and dropping the locations that only have a few clients (i.e. less than 10)

City count age
Marina 37 46.97222
Monterey 87 50.34884
Pacific Grove 20 48.85000
Salinas 33 47.15152
Sand City 21 44.33333
Seaside 148 47.61644
NA 35 63.26667

Finally, I’d like to consider age vs. income across all cities.