Chart: 2014 U.S. Income by Percentile

john's Avatar

john

01 Apr, 2016 11:23 PM

I did this chart in a few hours as a response to a question on Quora:

"How can I see (or make) a chart that shows household income in the United States (including capital gains) by decile (or even better, by percentile)? So the x axis is people (deciles or whatever) and the y axis is dollars. Since there's such a big spread between the lowest and highest incomes, maybe the y axis should be logarithmic?"

This is a familiar problem in visualization. How do you handle charts when some of the values are so big they swamp the rest? Using logarithms is often not a satisfying solution; many non-technical users don't understand it and as a result the effect may be to conceal something which should instead be emphasized.

One alternative is to embrace the outliers and let them simply smash through the top of the chart. You can then replace the missing data by showing a thumbnail inset. This is what I attempted to do in this chart.

I got a CSV file of income broken down by tenth of percentiles from the University of Minnesota’s IPUMS-CPS project via the website DQYDJ.net. Income is defined by the 2014 whole year INCTOT variable, for people reporting 1+ hours usually worked in 2014. For more information about how INCTOT is defined, see https://cps.ipums.org/cps-action/variables/INCTOT#comparability_section

Creating a chart like this in NodeBox is fairly straightforward. I had to add a few extra nodes to show the first two negative income values below the X axis. I then colored everything above 95% blue and created a thumbnail by simply scaling my original chart by 10%. Because the highest income bar was so faint in the thumbnail, I added a slightly thicker line for emphasis.

I am attaching the NodeBox network, the CSV file, a screenshot, and the PDF output. Comments appreciated!

John

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • income_screenshot.png 139 KB
  • Income_chart.ndbx 18.9 KB
  • income2014.pdf 114 KB
  • incs2015.csv 10.5 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

10 Sep, 2024 03:41 AM
09 Sep, 2024 02:15 PM
07 Sep, 2024 05:16 AM
05 Sep, 2024 02:21 AM
04 Sep, 2024 05:01 AM

 

03 Sep, 2024 10:07 AM
02 Sep, 2024 05:56 AM
31 Aug, 2024 11:07 PM
27 Aug, 2024 12:08 AM
26 Aug, 2024 01:02 PM
26 Aug, 2024 07:18 AM