Income inequality in Canada: Part 3 – unattached individuals and families

In the previous post, I mentioned how there was too much data being represented for me to discern any clear trends.  Before I begin to simplify the data in terms of the number of income brackets, I wanted to see how the same chart looked for single individuals versus families.

Methodology:

I used the same data source as in Part 2http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=2020201&tabMode=dataTable&srchLan=-1&p1=-1&p2=9

I filtered the data the same way as in Part 2 except for the economic family type.  The excel versions of the raw data I downloaded from StatsCan are:

cansim-2020201-eng-8874750535882305506

cansim-2020201-eng-5722123482346608777

After cleaning up the data, you should be left with the following data:

cansim-2020201_1a

cansim-2020201_1ua

I then ran the same R code as in Part 2, only changing the name of the plots and the output files.

Results:

Each plot was done with 2 different colour scales.  Figures 2 and 3 illustrate a stark contrast between income for individuals and families.  Figure 2 shows that the most populous income category for families is also the highest; whereas figure 3 shows that for individuals it is the lowest.  Although one would expect families to out earn individuals on average given that they can have multiple bread winners, I am still a little surprised by the magnitude of the difference.  Heuristically, it appears as though median household income for families is 65-70k and 20-25k for unattached individuals.

I will update this post after I have learned more about the makeup of the different groups.

Fig_2a-page-001

Fig_2b-page-001

Fig_3a-page-001

Fig_3b-page-001

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s