Posts Tagged ‘data visualization’

When fancy graphics lie…

Thursday, May 14th, 2009

Take a look at the heat map of proposed Chrysler dealer closures posted by the Wall Street Journal. The graphic is titled “Hardest Hit States”. What States will be hit hardest by this closure? If you included California, Texas or Florida in you analysis then you would probably be mistaken. But it is likely that you missed at least 3 of the top 5, North Dakota, South Dakota and Wyoming.

The problem with the WSJ map is that it doesn’t account for either population or availability of other dealers nearby. Something that Chrysler surely considered when creating the list. Simply by factoring in population, a method itself not perfect, we see that the areas losing the most will be rural areas and the rust belt. Areas that will have the least ability to cover the job losses with other industries. A real analysis of the problem should address not only population, but driving time to the nearest alternative dealership and the economic impact to the local community and it’s ability to absorb the losses.

As the Chrysler reorganization moves forward the question to be asked is: “Is Chrysler and, through its approval, the US abandoning a whole segment of the country”? The specific question I am asking now is, “Was the poor use of statistics by the Wall Street Journal intentional to shape opinion or was it merely laziness”?

Below are the top 15 States ranked according to dealerships lost per 1 million people (2008 population numbers):


State Population Dealers Lost Lost/M
ND 641481 8 12.47
WY 532668 5 9.39
WV 1814468 17 9.37
SD 804194 7 8.70
IA 3002555 22 7.33
KS 2802134 16 5.71
MO 5911605 27 4.57
NH 1315809 6 4.56
NE 1783432 8 4.49
PA 12448279 53 4.26
MT 967440 4 4.13
OH 11485910 47 4.09
MI 10003422 40 4.00
LA 4410796 17 3.85
UT 2736424 10 3.65

My thoughts are with those who have learned that their jobs are at risk today. They join many of my friends and some family members who are struggling to find and hold onto employment. We need to pull together and make the best of this situation, our best days are always ahead.

I also have data tables suitable for use with Google Map gadgets if you need them.