Data Analysis of Singapore Community Day 2015 (Demographics and Location)
Here, we look at orders. An order is a set of tickets purchased at one go, and can be assumed to comprise of a family, a couple, or a single. There were just under 300 orders.
About a quarter of the attendees were families, another quarter couples, about one in twelve were groups of adults and the rest singles. The unaccompanied children were likely folks who registered their toddlers separately.
Most families had one or two children. 16% had three or more.
If you prefer to see it in means, here are some averages:
So in conclusion, it's 80% adults and 20% children (of which a quarter are between 0 and 3 and three-quarters between 3 and 12 - now that makes sense, doesn't it?)
About 19% of the attendees were volunteers or their friends and family.
Across the US, most orders naturally came from California, but there were some from Seattle, Chicago, and DC. The colours in the piechart for California show the breakdown by city (in some cases it is unknown). In the SF Bay Area, San Francisco and San Jose are by far the biggest chunks of the known pie.
Let's drill down to California. There are pockets in Las Vegas and Los Angeles, a sizeable chunk in Sacramento, then as expected, two big pies for San Francisco and South Bay+East Bay.
Zooming in further to the SF Bay Area, we can see a lot of orders from across the Bay, including 5 from Monterey! Must be the Naval School there!
In this final zoom in, we can clearly see quite a showing from Berkeley (light blue) and Stanford (mostly the orange in Palo Alto), where we get many students. The strongest sector of participation is from San Jose (the green pies), then the Mountain View (purple)/Sunnyvale (yellow) area, and of course, not forgetting San Francisco (blue). Milpitas makes a strong showing. Looking east, there's San Ramon, San Leandro, Fremont, and Livermore too.
Maps from Google Maps. Geospatial visualisation from batchgeo.com.
Have you ever wondered, when they split check-ins by last name A-L, M-Z, for example, is that a logical split since most last names are not evenly distributed by letter? How about last names from a predominantly Singaporean crowd?
So L is the most popular, followed by C, T, S, and W. But it's not because they are dominated by a single last name. The letter L is dominated by Lim and T by Tan. That wasn't too hard, right? But S, Sim? No. It had a mix of surnames, none dominant. C, also somewhat so, a split between Chan, Chong and Chua. Some letters, such as A, were dominated by Ang. And if you guessed that the W's are mostly Wong's, you're not wrong!