Big Revenues or Big Profits? Part II - Page 2

Author: KaiserPublished: Aug 01, 2005 at 5:34 am 3 comments

A much better chart, favored by statisticians, is the following scatter plot, which brings out insights from the data.

Redobigco2_1

  • The 10 companies fall into three groups: Giants (Exxon Mobil, Royal Dutch/Shell, BP, Walmart), Big and Mean (GE, Total, Toyota) and Big and Fat (Ford, DiamlerChrysler, GM).
  • Giants have revenues over $270 billion, among them the oil companies are more profitable than Walmart, even though it has the highest revenues.
  • Big and Fat consists of auto companies with big revenues but low profit margin.
  • The ranking and relative size of revenues can be read off the horizontal axis.  Similarly for profits on the vertical axis.  So both bivariate and univariate distributions are available on one chart.

This chart is not without problems.  It is difficult to place the data labels without obstructing readability.  I placed the labels where they don't interfere with any reader tracing  dots to the axes, effectively in the northeast quadrant of each dot.  I omitted the country labels so as not to clutter the space.  I used color to further separate the dots from the labels.  I also sacrificed printing every data value for readability, assuming that the reader's interest in magnitude is not absolute.

pub:NB

Page 1 — Page 2

Article tags

Spread the word
Bookmark and Share
Read comments on this article, and add some feedback of your own
  • No image found

Article comments

  • 1 - Phillip Winn

    Aug 01, 2005 at 1:36 pm

    While the scatter-chart is information-dense, it fails to communicate the data quickly, which the Economist chart does very well.

    I definitely see your point about lines versus bars. While the bars look attractive, they don't communicate anything more than the lines, and I did fine myself better able to determine the different between lines.

    However, in defense of the Economist chart:

    1. It doesn't purport to be a chart of the most profitable companies, but the largest. As such, the focus on total revenue to the almost-exclusion of profit seems warranted.

    2. Your chart takes up a lot more space, to communicate not very much more information.

    However, the Economist chart could be improved, to be sure. I would suggest sticking with the bar chart in this case, so that the actual number could be put within the bar in the way that the profit numbers are put witin the boxes to the right.

    The profit is a little more difficult to know how to handle. They can't embed the profit data within the revenue bar without making the chart much, much larger, since $2.8bn barely registers as a blip (1.4%!) of GM's revenue. If the profit bar is big enough to embed '2.8' within it, Wal-Mart's revenue bar (100 times larger) would have to stretch pretty far across the page.

    They could simply print the raw data inside the revenue bar, along with the revenue data. That would present no less information than they're presenting now, and the saved horizontal space could be used to extend the scale of the revenue bars.

    They could switch the profit boxes to scaled lines and print the numbers above the lines. However, if this is within the same chart box, they need to use the same scale. I really, really, really dislike having two different scales used in the same chart. I think it's very, very, very confusing. So GM's profit ends up looking pretty tiny. As I suppose it should, at 1.4%!

    You still end up with the issue of sorting -- which gets back to my first point above. Since the largest companies are not necessarily the most profitable companies, you must sort the chart elements by one or the other. It seems difficult to then mentally sort elements that aren't next to each other.

    Of course, creating a second chart in a separate box would allow them to use a less-compressed scale and sort by profit, but then the chart would have to be labeled well: "Profits of the world's biggest companies" so nobody comes away thinking that these are the companies with the ten biggest companies.

    My bottom line: I think they should have kept to a single graphical element in the chart and put the raw revenue number, the raw profit number, and the profit as a percentage of revenue inside the bars.

    What do you think?

  • 2 - Phillip Winn

    Aug 01, 2005 at 1:36 pm

    P.S. I'm loving these posts! Keep 'em up!

  • 3 - Kaiser

    Aug 01, 2005 at 7:56 pm

    The line chart is only a slight improvement over the bar chart IMO. If space is an issue, I'd just print a table of numbers, or else I'd replace the numbers with revenues data and forego the profit data at all.

    The graph loses nothing by not including profits since as you said it is about the "biggest" companies as defined by revenues.

    Adding profit to the graph implies they want to make a separate point, which is that the biggest revenues companies are not the most profitable, which is much better shown with the scatter or line plot.

    The scatter plot takes some getting used to but it is the only graph out of the three that actually interprets the data.

Add your comment, speak your mind

Personal attacks are NOT allowed.
Please read our comment policy.
Please preview your comment.

blogcritics lists for May 18, 2013

fresh articles Most recent articles site-wide

fresh comments Most recent comments site-wide

most comments Most comments in 24hrs

top writers Most prolific Blogcritics for April

top commenters Most prolific Commenters in 24 hrs