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: http://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:
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.