Wednesday, October 31, 2012

South Africa Census 2011

South Africa Census 2011 results were published today and I examined some of the data from official Statssa website.  Follow the link to the official report:  Census 2011 Results.
To illustrate the relative movement in population sizes by provinces I decided to use Bubble charts in MS Excel. Size of bubble reflects the population in each province, the height (Y-axis) reflects the increase in population size within each province and the X-axis reflects the change in Provinces population as contributor to the total population of SA.

KZN (Kwa-Zulu Natal) and EC (Eastern Cape) population stagnation reflects some of the effects of AIDS related deaths whilst Gauteng gains from economic migration. I found the bubble chart to be a striking illustration of the population changes. Using relative measures for the X and Y axis makes the most effective use of Bubble charts such that it models the actual movements and the sizes of the provincial populations. You will notice that I also added in a small map of South Africa's provinces and data legend for quick reference.

No comments: