« Light entertainment: how to compare apples and oranges | Main | Light entertainment: taxing our mental capacity »



So actually I don't see how they compute the "needed" sales! For example why do we need more 19.6MPG (almost double) luxury sports cars. I can see maybe that the reduction large truck might only be compensated by buying more small trucks. Nevertheless I'm puzzled.

For me the bump chart doesn't work very well I don't understand whether the colors have any meaning (efficient/inefficient, differentiation?). Nor do I manage to connect the lines with the car groups (esp. the large group of cars in the lower third).


How do you draw these charts? Excel or some other software?


Charting aside, MPG is a backwards metric for measuring fuel efficiency, especially when you're averaging across a fleet. Gallons per mile (or per 100 miles, which get the units easier) is a more appropriate measure. Improvements to "Average" MPG overstate the actual efficiency gains.

Let's imagine the simple case: two cars, each drives 1000 miles.

Let's start with MPG since that's familiar. one car is 20 MPG, one car is 33.3 MPG. Average MPG = 26.7. Let's improve MPG by 25% in both cars. Now we have 25 and 41.6 MPG, for an average of 33.3 MPG.

25 better fuel economy, right? But if you look at the gallons used you get a different picture. You started using 50 gallons for the one car and 30 gallons for the other to drive 1000 miles, for a total of 80. In the new case, you'll use 40 and 24 gallons for a total of 64. So your efficiency really only rises 20% for your "25% MPG improvement." This difference gets worse as the efficiency difference between the cars is larger.

Short story is that the gas guzzlers use most of the gas, so improving a 15 mpg (er, .07 GPM) car by 10% is far more important than improving a 40 mpg (er, .005 GPM) car by 20% or even 30%.

It's a case of measurement (MPG) affecting decisions in a counterproductive way.


Seems as if the government is making us cut our purchasing of these vehicles just by the inflated gas costs. It's got to happen some way and I just assume they are making it seem like our own decision.


I realized my example wasn't extreme enough.

Two-car example again: one with 20 mpg and one with 33.3 mpg. I can more than quadruple the average mpg from 26.7 to 110 by increasing the second car's mpg to 200mpg. But my gallons to drive 1000 miles have dropped only from the original 80 to 50+5 = 55 gallons, which is a savings of only 40% or so. You see some of this if you target average GPM instead of MPG.

Mathematically, there are a lot of solutions to the "get to 30mpg average fuel economy" but they don't all result in the same fuel savings. We should target the ones that do, not the ones that don't (get the prius up to 100mpg!).

Chris Pudney

I had a quick go at combining the MPG and Sales targets into a single scatter plot. It was done in an Open Office SpreadSheet so I wasn't able to add arrows to the lines. I can share the data if there's any interest.


Floatofmath: yes, their proposed shift in mix of vehicles is certainly not the only solution that can bring the MPG to the target level. There is an infinite number of possible solutions. The color scheme for the bumps chart: dark blue (increase in proportion needed); light blue (decrease in proportion needed); gray (no change in proportion).

Rohit: most of my charts are "scratch book" charts which has upset a certain contingent of readers. For me, getting the concept right is much harder than finding the right software to make a nice chart. Bumps chart can be made using the line chart function in Excel, making the data fall on the axis ticks rather than between, adding a secondary axis, and a few other cosmetic changes.

Chris: good idea to test out.


On Gary's comment about MPG vs gallons-per-mile, the actual way CAFE standards are calculated uses the harmonic mean to accomplish this more relevant measure of efficiency. Citation: http://www.nhtsa.gov/cars/rules/cafe/overview.htm


@Gabe - thank you for that piece of information; I am glad the EPA (who makes the rules I assume?) thought this through. Did the WSJ article use the appropriate methodology? I can't tell at a glance.

Junior Perrera

It seems like people would most likely buy cars that can carry the whole family, even if it's less fuel-efficient. In order to balance the target sales, car companies should be willing to boost the marketing of small vehicles since these have high MPG rate.

Used Cars Minneapolis

From my understanding, it seems like the CAFE standards apply to the entire fleet and not individual cars. Car companies can still sell SUV's and trucks if they offset them with EV's and hybrids.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment

Your Information

(Name is required. Email address will not be displayed with the comment.)


Link to Principal Analytics Prep

See our curriculum, instructors. Apply.
Marketing analytics and data visualization expert. Author and Speaker. Currently at Columbia. See my full bio.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Good Books

Keep in Touch

follow me on Twitter