Some questions give you two tables and ask you to combine them: sales in two years, loans and average loan sizes, or hectares and profit per hectare. The skill is to work row by row before you total or compare. This guide shows how.
What these questions look like
Table 1 and Table 2 cover the same rows (categories, branches or crops). The question asks which row grew the most, what the total is when you combine the two tables, or how two options compare once everything is counted. At Managerial level you may compare two farms or two offers across several rows.
The method, step by step
- Check that the two tables use the same rows and the same units.
- Work out the measure for each row first: the percentage change, or the number × the average, or hectares × profit per hectare.
- Then total, rank or compare those row results.
- Answer exactly what is asked: the largest percentage, the total, or the difference.
The quickest route
For "which grew the most", estimate first: a row that went from 11,100,000 to 13,764,000 has grown by about a quarter, while the others have barely moved. Calculate only the rows that could win. For totals, multiply each row before adding: never multiply the two column totals or the two averages.
Common traps
- Biggest in money, not in percentage. The row with the biggest rise in money is often not the one with the biggest percentage rise.
- Multiplying the averages. You multiply the total count by the average of the averages, which treats a small branch like a busy one.
- Leaving a row out. You add only some of the rows.
- The wrong base or the ratio. You divide the change by the new value, or give new ÷ old instead of the change.
- One side only. When comparing two farms or offers, you give one total instead of the difference.
Worked examples
Try each question before you open the answer. (Intermediate figures in the worked answers are rounded for reading; the answer comes from the exact calculation.)
Example 1 — Graduate · Comparing tables
BazarJunio: sales by category (KES) — Table 1: 2024; Table 2: 2025
| Category | Table 1 (2024) | Table 2 (2025) |
|---|---|---|
| Fresh produce | 11,100,000 | 13,764,000 |
| Electronics | 8,980,000 | 9,249,400 |
| School supplies | 5,680,000 | 5,339,200 |
| Beverages | 11,680,000 | 11,913,600 |
Compare the two tables. For the category whose sales grew by the largest percentage, what was that percentage increase?
- A +19.4%
- B +3.0%
- C +2.0%
- D +124.0%
- E +24.0%
Show the answer
Answer: E +24.0%
Worked answer: Work out each category's % change = (new − old) ÷ old. Fresh produce +24.0%; Electronics +3.0%; School supplies −6.0%; Beverages +2.0%. The largest is Fresh produce: +24.0%. +3.0% and +2.0% are the second- and third-largest percentage changes. +19.4% divides by the new value. +124.0% is new ÷ old, not the change.
Speed tip: Biggest increase in money is not always the biggest in percentage: a small category can grow fastest.
Example 2 — Graduate · Comparing tables
CrediJulio: Table 1 loans issued last month; Table 2 average loan size (EUR)
| Branch | Table 1: loans | Table 2: average size |
|---|---|---|
| East branch | 475 | 6,500 |
| Lakeside branch | 750 | 8,900 |
| North branch | 1,425 | 23,700 |
| Central branch | 685 | 21,700 |
From Table 1 (number of loans) and Table 2 (average loan size), find the total amount lent by all four branches.
- A EUR 58,399,500
- B EUR 64,239,500
- C EUR 55,312,000
- D EUR 50,692,000
- E EUR 43,535,000
Show the answer
Answer: A EUR 58,399,500
Worked answer: For each branch, value = number of loans × average loan size: 475 × 6,500 = 3,087,500; 750 × 8,900 = 6,675,000; 1,425 × 23,700 = 33,772,500; 685 × 21,700 = 14,864,500. Total = EUR 58,399,500. EUR 50,692,000 multiplies all loans by the average of the four averages: it treats a branch with few loans like a busy one. EUR 55,312,000 and EUR 43,535,000 leave out one branch. EUR 64,239,500 is close but does not come from the data.
Speed tip: Two tables for the same rows: multiply row by row first, then add. Never multiply the totals or the averages.
Example 3 — Managerial · Comparing tables
AgroAbril: Table 1 hectares by farm · Table 2 profit per hectare (USD)
| Crop | Farm North (ha) | Farm South (ha) | Profit per ha (USD) |
|---|---|---|---|
| Maize | 360 | 105 | 520 |
| Soya beans | 195 | 215 | 490 |
| Wheat | 215 | 90 | 500 |
Using both tables, how much more profit does Farm North make than Farm South?
- A USD 203,800
- B USD 181,200
- C USD 185,300
- D USD 122,800
- E USD 390,250
Show the answer
Answer: C USD 185,300
Worked answer: Farm North: 360 × 520 + 195 × 490 + 215 × 500 = 390,250. Farm South: 105 × 520 + 215 × 490 + 90 × 500 = 204,950. Difference = USD 185,300. USD 181,200 multiplies the difference in total hectares by the average profit per hectare, which ignores the crop mix. USD 122,800 leaves out wheat. USD 390,250 is Farm North's profit alone. USD 203,800 is close but does not come from the data.
Speed tip: Profit for each crop = hectares × profit per hectare. Do the whole farm before you compare.
Practise this type
Get a pass to drill this type Table comparison questions appear at Graduate and Managerial level.
Frequently asked questions
Why can't I multiply the totals of two tables?
Because each row has its own figures. A branch with many small loans and a branch with a few large loans would be mixed together. Multiply row by row, then add the results.
How do I find which row grew by the biggest percentage?
Work out (new − old) ÷ old for each row and compare the percentages, not the amounts. A small row can grow fastest even if a big row added more money.
