Herman Cain's 9-9-9 Plan

The name Herman Cain came up a few times in my reading materials recently. A former business executive, he is in the news as the leading Republican presidential candidate in the primaries, and for his 9-9-9 Tax Plan.

Kaiser, of Junk Charts has made a couple of attempts to visualize the 9-9-9 Tax Plan and its possible impact on people belonging to different cash income quintiles. One can read and learn about his first attempt here. In all fairness, the chart appears somewhat mangled and hence lacks clarity and the utility for the purpose.

At first glance, the lines looked far too thick and the labels were wrongly positioned. But the most critical omission is missing out on 6.2% of the lowest quintile population who remains undisturbed in this tax shake-up.

The data table is available here. I decided to keep the vertical and horizontal axes similar. The horizontal axis labels are brought down below and major gridlines are formatted to create quintile panels every 20 percentage points. The chart lines, which were plotted overlapping each other in the original chart were plotted within their respective quintile panel to render legibility. Finally, labels were placed to mention the increase/decrease of tax for the percentage of people in the quintile.

The new chart clearly shows the answer to "How Tax hike will affect different income groups"? - The higher the income, the greater is the tax relief for a larger number of people.

Comments

The Cricket Graphs: The Forgotten Chart

The fun of receiving feedback to blog posts is that one isn't quite sure what they might come up against. While mostly it provides fascinating discussions, insightful comments or explanatory questions, there is also the odd occasion when it throws up unusual requests. The other day I received an email in response to my post, The Cricket Graphs . The sender wanted me to create a "Partnership" chart, which would show the runs scored by the pair of batsmen for every wicket and the balls faced. I went searching for data on the Cricinfo website , and picked out the 3rd ODI between the South African and Australian cricket teams which was played out in Kingsmead, Durban on October 28, 2011. The Partnership details were taken from the page titled Partnerships Table and the total balls faced by individual batsmen from the Scorecard. Constructing the graphs was a somewhat tricky affair, with two potential bar charts in two axes representing Balls and Runs, which had me w

Florence Nightingale Circumplex Chart

I was taken to the Florence Nightingale's Wiki page during a recent research, and one of the interesting things I noted was her contribution to statistics. It came to me as a pleasant surprise that she is credited with inventing the polar area diagram , or occasionally the Nightingale rose diagram, which is equivalent to a modern circular histogram. Following the completion of my project and in my weekend to spare, I devoted time to recreating the chart in Excel. It took a combination of Doughnut-Pie-and XY charts and close to four hours to finish it. The colours are a bit darker, the values are approximate and the labels differently oriented, yet the chart looks fairly close to the original as is shown by the picture below.

The Dorling Cartogram

My last project involved using a multitude of regions for drawing analysis, parallels and comparison. Not wanting to use yet another Choropleth graph, I decided to look up alternatives that were easier to create and preferably required no VBA. Soon I stumbled upon "The Dorling Cartogram", defined in the UCSB site as, "This type of cartogram was named after its inventor, Danny Dorling of the University of Leeds. A Dorling cartogram maintains neither shape, topology nor object centroids, though it has proven to be a very effective cartogram method. To create a Dorling cartogram, instead of enlarging or shrinking the objects themselves, the cartographer will replace the objects with a uniform shape, usually a circle, of the appropriate size." I had the data for Obesity in the United States handy, so I decided to give it a try before using it in my project. I opted to use Bubble charts because data points within a series may need to be of varied shapes based on

Somnath's Excel Charts

Search This Blog