Integrated Reasoning: Table Analysis:

by on December 28th, 2012

I’ve been wanting to do this problem with you for a while, but I’ve been delaying because… well, you’ll see when you get to the table. It takes a lot of work to recreate that in a blog post. :) But that ridiculously large table is also the reason why I want to talk about this one – so let’s test it out!

Try the problem

This problem can be found in GMATPrep© 2.0. Normally, on table problems, you’re able to re-sort the data according to various column headers. I can’t recreate that functionality in a blog post, but I’ll give you a hint: sorting actually isn’t necessary for this particular problem.

Set your timer for 2.5 minutes. (You can take up to 3 on this one, but if you do decide to use extra time, use it wisely! Otherwise, it’s better to cut yourself off faster.)

The Consumer Price Index (CPI) measures the average prices of goods and services purchased by consumers. In the United States, the CPI-U calculates the CPI for all urban customers.

The CPI-U is calculated based on prices of food, clothing, shelter, fuels, transportation fares, charges for doctors’ and dentists’ services, drugs, and other goods and services that people buy for day-to-day living. All taxes directly associated with the purchase and use of items (such as, in the United States, sales taxes) are included in the index. An increase in CPI-U by a certain fractional amount means an increase by that fractional amount in overall prices within the relevant category.

For analyzing general price trends in the economy, seasonally adjusted prices are usually preferred over unadjusted prices because adjusting eliminates the effect of changes that normally occur at the same time and in about the same magnitude every year – such as price movements resulting from climatic conditions, production cycles, model changeovers, and holidays.

For each of the following, select Yes if the statement is inferable from the given information. Otherwise select No.

The Solution

This table is ridiculous isn’t it? And three paragraphs to start, before I even get to the question? There’s no way I’m possibly going to look through all of this data in 2.5 minutes. (Hint. That’s one clue to solving these kinds of questions!)

In general, on tables, read the information that tells you what the table is about and look at all of the “big” labels (such as the column headers), but do NOT try to read / remember / understand all of the actual data points. You’ll use whatever data you need when you get a specific question about that data – but not before!

In this case, the first paragraph tells us that this CPI-U thing calculates average prices on a bunch of things for a certain population (urban consumers in the US). The second paragraph starts off by listing a bunch of categories – ignore them. If you need to know the specific categories, you can come back here later. In fact, ignore most of the details here until we figure out what the questions are about.

The third paragraph explains that we generally prefer to use “seasonally adjusted” prices. A quick glance at the table shows us that it includes both adjusted and unadjusted numbers. It also explains why – ignore this. Many, if not most, people will have used a minute or more at this point, so don’t spend that time now. If you need to know why, you can come back here later to understand.

Finally, glance at the table labels. The columns list a bunch of individual months from 2010 and those are labeled “seasonally adjusted changes from preceding month.” Notice two important things here: These numbers are seasonally adjusted, not unadjusted, and each monthly figure is based on the change from the preceding month. The final column is for a whole 12 month period and these numbers are unadjusted. Finally, there are a million individual categories listed in the rows. L

I’m not 100% sure that I understand the difference between adjusted and unadjusted – but I don’t care about that right now. I’ll figure that out if I need to based on a specific question. Just keep going!

Now it’s time to examine the statements; here’s the first one:

“The changes in seasonally adjusted prices for used cars and trucks between March 2010 and September 2010 were in most cases less in magnitude than the changes in seasonally adjusted prices of new vehicles for the same period.”

Let’s see. They mention two categories: “used cars and trucks” and “new vehicles.” Great, I only need to look at those two rows. They also specifically mention “adjusted” for these, so I only care about the monthly columns. Scan until you find the right rows; luckily, they’re already right next to each other in the table.

The question asks about the “magnitude” of the changes in the two categories, so we need to compare them, month by month, to see which changed more and which changed less. For March 2010, the magnitude of change for “used cars and trucks” was 0.5, but only 0.1 for new vehicles. For that month, then, the magnitude of change was larger for the used cars and trucks. Compare the other months. In each case, the magnitude of change (the distance from zero) is larger for used cars and trucks. (This was true even in September 2010 – the change was negative, but it was -0.7, which is 0.7 units away from 0. The magnitude of change for new cars was only 0.1.)

The statement says that the change for used cars and trucks was “in most cases less in magnitude,” but that’s not true. During all of the months in question, however, the change in magnitude (from zero) for used cars and trucks was greater.

Select “No” for statement 1.

Here’s the second statement:

“The seasonally adjusted CPI-U for all items was higher in March 2010 than in the previous month.”

This time, the statement is directing me to the “all items” category in the month-by-month (adjusted) timeframe. That’s right at the top of the table. We’re specifically asked about March 2010 compared to the previous month, but the table doesn’t include the previous month, so how can it tell us anything at all about February?

Read the labels! Right above the months, the table says “Seasonally adjusted changes from preceding month.” (Emphasis added.) In other words, the figure for March 2010 is based upon the change from February 2010. That change is positive, so it is true that the number for March is higher than the number for February.

Select “Yes” for statement 2.

And finally our third statement:

“The seasonally unadjusted change in the price of new vehicles in August 2010 over the previous month was about the same as the seasonally unadjusted change in the price of food away from home over the same period.”

Read carefully! What data do they want now? Seasonally UNadjusted this time, not adjusted! The only data we have for the unadjusted category is based on the “12 months ended Sep 2010” – we don’t have month-by-month data! Therefore, I can’t tell anything at all about what happened in August 2010 vs. July 2010 – not for the UNadjusted data.

Note something very tricky. If you gloss over the “Un” in the word unadjusted, you might just go check the Aug and Jul columns for new vehicles and food away from home. For new vehicles, the change was 0.3. For food away from home, the change was 0.3. Those two numbers are the same – and so you would pick Yes, and you would fall into the trap. We don’t have any unadjusted data for the month of August alone.

Select “No” for statement 3.

The answers to the three statements are No, Yes, No.

Finally, notice something. How many rows and cells did you need in order to answer all three statements here? The first statement required us to use most of the cells in two adjacent rows. The second statement required us to use one cell in one row. The third statement required us to use nothing – but, even if we fell into the trap, we’d still only have used two cells in two different rows (one of which was a row we’d already used previously).

In other words, we never have to look at the vast majority of the data in this table. They could have cut out 3/4 of the rows without changing the question at all – except, perhaps, reducing the anxiety of a lot of test-takers when they saw a table with nearly 20 rows.

Key Takeaways for Table Analysis questions:

(1) You will NOT need to use all of the data, so when you see a crazy number of rows or columns, don’t let yourself get anxious; instead, remind yourself that you won’t need to look at most of this. Ditto for those three paragraphs of text at the top. Don’t bother to read the table thoroughly or take in all of the data – just know what kind of information is available, then return to whatever you need based on the question statements.

(2) For many table questions, the ability to re-sort the data is critically important to our ability to answer these questions efficiently. Sometimes, though, we don’t need to sort the data at all – as in this case. Learn how to decide when and how to re-sort the data.

(3) Read carefully. When you have a table, by definition, the questions are going to hinge around whether you’re examining the right cell or cells from the table. Make sure you read the statements carefully with this question in mind: “What group / category are they asking me about now?”

* All quotes copyright and courtesy of the Graduate Management Admissions Council. Usage of this material does not imply endorsement by GMAC.


  • I have a question about number 2. I saw the differences were ranged from (-) to (+), thus in March there can't be ALL items that have higher CPI than those in Feb. Is that correct? 

    • oh sorry i misread the "all item" categories part. Quite tricky!!!

    • Glad you figured it out without me - that's always the best way. :) Keep up the good work!

  • thanks for d tips....i just took the first prep test and d result is a disaster.... then saw ur tips and this table came back....... i was puzzled by the third one...... now i know this was a trick question!!!

  • Please help me understand.  The instructions say "For each of the following, select Yes if the statement is inferable from the given information. Otherwise select No."
    I take this to mean that I don't need to actually find the answer, I need to determine if the question is answerable.  Therefore, I though answer 1 should be yes, because I could infer the answer from the table.  Thank you.

  • "Inferable" means "this statement must be *true*, given the information in the table."

    Statement 1 specifically says that the relevant categories were "less in magnitude" than some other categories. Is that statement true? No - those categories were greater in magnitude.

    Therefore, it is NOT possible to Infer that the relevant categories were less in magnitude.

    They're not asking you whether you can tell which is greater or lesser. They're asking you whether the exact statement is true, according to the given data.

  • for statement 2 which you said" That change is positive"
    the gasoline change is negative the table started with -0.8

    could you explain more please?

Ask a Question or Leave a Reply

The author Manhattan Prep gets email notifications for all questions or replies to this post.

Some HTML allowed. Keep your comments above the belt or risk having them deleted. Signup for a Gravatar to have your pictures show up by your comment.