Skip to content
Tutorials Center
My learning

Topics

Lesson 46 of 86 ยท Data Interpretation

Table and Caselet Data Interpretation

Read tables quickly, answer percent, ratio and growth questions, turn caselets into tables, and practice with a runnable data helper.

Data interpretation (DI) questions give you a block of numbers and ask for something you must work out: a total, a percentage, a ratio, a growth rate. There is rarely any new mathematics. The skill is reading the data accurately, choosing the shortest calculation, and not losing time on numbers you do not need.

Tables are the simplest DI format, so they are the best place to start. A caselet is the same data hidden in a short paragraph: you must first build the table yourself. This lesson covers both, using percent, ratio and average methods from Percentages, Ratio and Averages.

How to read a table

Before any calculation, spend ten seconds on three things:

  1. Title and units. Is it thousands, millions, percent, rupees, kilograms? Mixing units is the most expensive mistake in DI.
  2. Row and column labels. Which direction is time, which is category?
  3. Totals and blanks. Some tables include a total row, some leave cells blank for you to fill using other information.

Here is the table we will use. It shows yearly sales (in thousands of units) of four brands.

Brand 2021 2022 2023 2024
A 120 150 180 210
B 90 110 100 140
C 200 180 220 240
D 60 80 120 100

Column totals are 470 (2021), 520 (2022), 620 (2023) and 690 (2024). Row totals are A 660, B 440, C 840 and D 360.

The question types

Nearly all table questions fall into a few families.

Direct reading and totals. "What were the total sales in 2023?" Add the column: 180 + 100 + 220 + 120 = 620.

Percent of a whole (share). "D's sales in 2024 were what percent of the total for 2024?" The total is 690, so 100 รท 690 ร— 100 โ‰ˆ 14.49%. Percentages of a part to a total use the total as the base.

Percent change (growth). "By what percent did A's sales grow from 2021 to 2024?" Growth is change รท starting value: (210 โˆ’ 120) รท 120 = 0.75, so 75%. The start is the base, always. See Percentage Change if this is rusty.

One quantity as a percent of another. "B in 2023 as a percent of B in 2022": 100 รท 110 โ‰ˆ 90.9%, which is a fall of about 9.1%. Read carefully whether the question asks "as a percent of" (the ratio) or "by what percent more/less" (the change).

Ratio. "B to D in 2022": 110 : 80 = 11 : 8. Divide by the common factor 10.

Average. "Average yearly sales of C": 840 รท 4 = 210.

Comparison and ranking. "Which brand had the highest four-year total?" Add each row and compare: C with 840. You can often decide without exact sums, for instance by spotting that C is highest or near-highest in every year.

flowchart TD
    Q["Read the question"] --> W{"What is asked?"}
    W -->|"part of a total"| S["share = part / total x 100"]
    W -->|"more or less than before"| G["change = (new - old) / old x 100"]
    W -->|"comparison of two values"| R["ratio or difference"]
    W -->|"typical value"| V["average = sum / count"]

Decide which formula the wording asks for, then pick the right base.

Speed habits

  • Estimate first. If answer options are far apart, a rough calculation is enough. 100 รท 690 is about 1/7, so about 14%.
  • Compare without computing. To compare two growth rates, compare the fractions: is 90/120 bigger than 40/90? Cross-multiply instead of dividing.
  • Skip totals you do not need. Only compute a column total when the question needs it.
  • Use the table's own structure. If the data is in thousands, keep working in thousands and convert only at the end.
JS A data helper for the sales table

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Caselets: building the table yourself

A caselet states facts in a paragraph. Your first job is to turn it into a table, filling in every number that can be worked out. Then the questions are ordinary table questions.

Caselet 1. A school has 600 students. 40% are in the primary section. The remaining students are in secondary and senior sections in the ratio 3 : 2. In primary, 55% of the students are girls; in secondary, 50%; in senior, 25%.

Step by step:

  • Primary: 40% of 600 = 240. Remaining 360.
  • Secondary : senior = 3 : 2, so secondary = 360 ร— 3/5 = 216 and senior = 144.
  • Girls: 0.55 ร— 240 = 132; 0.50 ร— 216 = 108; 0.25 ร— 144 = 36.
  • Boys are the rest: 108, 108 and 108.
Level Total Girls Boys
Primary 240 132 108
Secondary 216 108 108
Senior 144 36 108
All 600 276 324

Now the questions are quick. Girls overall: 276 รท 600 = 46%. Girls to boys: 276 : 324 = 23 : 27. Which level has the highest share of girls? Primary, at 55%.

Caselet 2 (a chain of comparisons). Anil earns 20% more than Bina. Bina earns 25% less than Chitra. Chitra earns 40,000.

Work from the known number: Bina = 40,000 ร— 0.75 = 30,000, and Anil = 30,000 ร— 1.2 = 36,000. The ratio Anil : Bina : Chitra is 36 : 30 : 40 = 18 : 15 : 20, and their total is 106,000.

Always start a chain caselet from the person whose value is given; the "percent more than" statements then multiply forward. Beware of reversing them: Bina earns 25% less than Chitra, but Chitra earns 33.3% more than Bina, because the base changes.

JS Caselets as small tables

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Traps to watch for

  • Wrong base. "A is what percent more than B" uses B as the base; "B is what percent less than A" uses A.
  • Units. If one column is in thousands and another in lakhs, convert before comparing.
  • Percent points versus percent. A rise from 20% to 25% is 5 percentage points but a 25% increase.
  • Rounding too early. Round only the final answer, unless the options are far apart.
  • Looking at the wrong cell. Underline the brand and year in the question before searching the table.

Check your understanding

Use the sales table above.

Quick check ยท 5 questions

of 5 answered You scored / 5 ยท perfect!

  1. 1. What was the total sales of all four brands in 2022 (in thousands)?

    150 + 110 + 180 + 80 = 520.
  2. 2. B's sales fell from 110 in 2022 to 100 in 2023. By roughly what percent?

    The change is 10 on a base of 110, so 10 / 110 = 9.09%. The answer 90.9% would be 'B in 2023 as a percent of B in 2022', which is not what was asked.
  3. 3. What is the ratio of A's 2021 sales to C's 2021 sales?

    120 : 200 divides by 40 to give 3 : 5.
  4. 4. What was the average yearly sales of brand D over the four years (in thousands)?

    D's total is 60 + 80 + 120 + 100 = 360, and 360 / 4 = 90.
  5. 5. Bina earns 25% less than Chitra, who earns 40,000. Anil earns 20% more than Bina. What does Anil earn?

    Bina earns 0.75 x 40,000 = 30,000. Anil earns 1.2 x 30,000 = 36,000.

Summary

  • Before calculating, check the title, units, labels and any totals or blanks.
  • Share = part รท total ร— 100; growth = change รท starting value ร— 100; "as a percent of" is a ratio, "more or less than" is a change.
  • Estimate first and compare fractions by cross-multiplying, to save time.
  • A caselet is a table in disguise: start from the known quantity and fill every cell you can.
  • Watch the base, the units and percent versus percentage points.

Next: Bar and Line Graph Data Interpretation, where the same numbers arrive as pictures.