Comments on: Household Income Distribution 1967 – 2005 As Small Multiples Chart ../../../../2008/09/household-income-distribution-1967-2005-as-small-multiples-chart/ XLCubed Blog Thu, 10 Jan 2019 09:09:37 +0000 hourly 1 https://wordpress.org/?v=5.3.21 By: Data Loss Aversion II - R Lattice Plot « Charts & Graphs ../../../../2008/09/household-income-distribution-1967-2005-as-small-multiples-chart/#comment-176 Mon, 29 Sep 2008 16:27:23 +0000 http://blog.xlcubed.com/?p=545#comment-176 […] used a logarithmic axis technique to show all data in intervening years between 1967 and 2005. Andreas Lipphardt used small multiples to show 1967 and 2005 values as well as the overall change by bracket. We can […]

]]>
By: Excel Links of the Week [Sep 29] | Pointy Haired Dilbert - Chandoo.org ../../../../2008/09/household-income-distribution-1967-2005-as-small-multiples-chart/#comment-175 Mon, 29 Sep 2008 12:15:06 +0000 http://blog.xlcubed.com/?p=545#comment-175 […] Designing a chart when you have lots of data, This is a common problem we all face. Often we have lots of data (in this case household income distribution data from 1967 to 2005) and we try to come up with *ONE* chart to show all of it along with our insights. This works in some rare cases, most of the time resulting in chart mess. Xlcubed has done some analysis of a simple problem and tries to propose an alternative. […]

]]>
By: D Kelly O'Day ../../../../2008/09/household-income-distribution-1967-2005-as-small-multiples-chart/#comment-174 Thu, 25 Sep 2008 19:56:17 +0000 http://blog.xlcubed.com/?p=545#comment-174 Andreas –

Very good post. I’m still thinking about the loss aversion issue. Looking at your’s and Derek’s post shows me that each of us has focused on different questions, leading to different charts.

As I commented on Derek’s blog, it’s like a photographer who uses different lenses to shoot a scene. While the scene doesn’t change, the view of the scene does.

While some scene views (photos or charts for us) may be more interesting – pleasing than others, each has a role to play in understanding the actual scene that the photographer shot.

Chart type selection is a very important topic. Jorge’s income data provides a good example of the role of question to chart type.

I will try to synthesize Derek’s, yours and my charts and show how they address different questions about the same data. Since a lot of readers work with time series data, it would be nice to put together some time series chart type guidelines that help sort out potential questions and corresponding chart types.

Kelly

]]>
By: Logarithmic Scale for Time Series Charts « Charts & Graphs ../../../../2008/09/household-income-distribution-1967-2005-as-small-multiples-chart/#comment-173 Thu, 25 Sep 2008 19:30:22 +0000 http://blog.xlcubed.com/?p=545#comment-173 […] to evaluate the % income distribution by total household data set that Jorge Cameos , Derek, Andreas at  XLCubed and I have been discussing recently.  Derek and Andreas have both shed considerable […]

]]>
By: Andreas ../../../../2008/09/household-income-distribution-1967-2005-as-small-multiples-chart/#comment-172 Wed, 24 Sep 2008 14:15:07 +0000 http://blog.xlcubed.com/?p=545#comment-172 Tim,

I had a second look on the scale and think the first version with the -15%- 15% scale is right. This way all charts scales span from min to max 30%, and a 5% change has the same height in all charts.

Andreas

]]>
By: Andreas ../../../../2008/09/household-income-distribution-1967-2005-as-small-multiples-chart/#comment-171 Wed, 24 Sep 2008 12:52:52 +0000 http://blog.xlcubed.com/?p=545#comment-171 Tim,

Thanks for pointing out the problem with the common scale.
I fixed that in the blog post.

Thanks,

Andreas

]]>
By: Hadley Wickham ../../../../2008/09/household-income-distribution-1967-2005-as-small-multiples-chart/#comment-170 Wed, 24 Sep 2008 12:22:49 +0000 http://blog.xlcubed.com/?p=545#comment-170 I think you’ve drawn a histogram, but with two mistakes: the bars aren’t abutting, and the bar lengths aren’t proportional to the size of the classes. You could also label the bars better – label the breakpoints, not the range of each individual bar. Once you do this, you might start to wonder about how the divisions were chosen, and if they are the most revealing for this data.

You also need to be careful about labelling the axis on the final graph – the values need to be interpreted as differences of percentages, not percentages themselves. i.e. the number of people in the >$100 bracket did not increase by 15%.

]]>
By: tim ../../../../2008/09/household-income-distribution-1967-2005-as-small-multiples-chart/#comment-169 Wed, 24 Sep 2008 11:24:40 +0000 http://blog.xlcubed.com/?p=545#comment-169 i like it Andreas. I couldn’t make sense of line charts or the dot plot, but the small multiple columns make sense right away. Although I don’t know why you changed the scale on the third one.

]]>
By: derek ../../../../2008/09/household-income-distribution-1967-2005-as-small-multiples-chart/#comment-168 Wed, 24 Sep 2008 11:05:47 +0000 http://blog.xlcubed.com/?p=545#comment-168 As I say in my post on Information Ocean, simply presenting the change between the start and end of the period tells a story of improvement in household fortunes between 1967 and 2005, but masks the more complex story, of gains made between 1967 and 1979, and losses between 1979 and 2005.

]]>
By: Carlos De la Peña ../../../../2008/09/household-income-distribution-1967-2005-as-small-multiples-chart/#comment-167 Wed, 24 Sep 2008 09:23:47 +0000 http://blog.xlcubed.com/?p=545#comment-167 ¡Great article! Very enlightening for my line of work

]]>