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.


I used the same data source as in Part 2

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:



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



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


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.





Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s