Census 2011 Tableau 6.1 Man Drought data viz

[admin]

Just a few dataliciously important things to mention...

Today is the day of the Australian Census, hooray! - more details on what to do here.

Last week Tableau Software released a sizeable upgrade of Tableau Desktop 6.0 to 6.1, hooray!

As far as the changes to Desktop go, we think the best ones are:

• dashboards are now rendered specifically for iPads
• data at the level of Australian postcodes can be plotted on a map automatically
• data extraction times are shorter
• you can now append additional data to extracts or other data connections
• processing times are faster especially for text files
• being able to view the input data as a whole via the left-hand side Data Window

A full demo of the new features of Desktop 6.1 is here but we thought we should have at look at some data from the last Census in 2006 to demonstrate Tableau Desktop 6.1's new postcode mapping functionality and sexy dark background.

The topic of interest: Australia's supposed man drought.

You can read some background on the man drought here but the basic theory is that there's a severe undersupply of single men for single women, particularly in their 30's. At first glance, this would seem a bit odd given that there's a roughly 50/50 split of men and women at birth. So let's see if it's true...

At the national level (see first chart below), there are actually more single men than women for ages 20 to 34. And for the 35 to 39 age group there's only around 10,000 more single women than single men. Overall, the man drought doesn't really exist for 30-somethings.

However, the man drought may just be a regional phenomenon.

The second chart below highlights the ratio of women to men in between the ages of 30 and 39. A redder shade indicates more women relative to men while a greener indicates more men relative to women. The size of the location represents the total number of people aged 30 to 39.

Northern NSW appears to have the largest scarcity of single men aged 30-39 (ratio of 1.07), while there's an abundance of men in Regional SA (ratio of 0.85).

So although these ratio's aren't particularly high, there's some evidence of the man drought in particular regions of Australia.

Now, here's the best bit. If we look at ratios of single women to single men aged 30 to 39 in particular postcodes, then there are some places in Australia with an obvious scarcity of men (see final chart below). The top 3 places (of notable size) are:

1. 2559, Blairmount, NSW - 2.4 women for every man
2. 4509, Mango Hill/North Lakes, QLD - 1.9
3. 6770, Halls Creek, WA - 1.8

It seems that there is a man drought, but it just depends on where you live. Similarly, there are places with a severe absence of single women in their 30s too. Here's the top 3:

1. 3008, Docklands, VIC - 0.4 women for every man
2. 5725, Roxby Downs/Olympic Dam, SA - 0.5
3. 4774, Moranbah, WA - 0.5

To find out where you should be looking for your next man, you can play around with the postcode visualisation here.

If women are more your thing, then go here.









Permalink | Leave a comment »



More from the Datalicious Blog...