UPSC CAPF AC · Module 46 · standard depth · 14 min
Reading tables
What UPSC CAPF AC asks from this chapter
Syllabus lines this chapter covers:
- Paper I: General Ability and Intelligence · General Mental Ability The questions will be designed to test the logical reasoning, quantitative aptitude including numerical ability, and data interpretation.
UPSC CAPF AC questions from this module are being sorted into our bank.
Cut to standard depth for UPSC CAPF AC. 7 deeper paragraphs are in the full chapter.
Start from zero: why tables exist
A block office collects rice production from five villages for three years. Written as sentences, it would take fifteen statements, and comparing them would be slow. Placed in a grid, with villages as rows and years as columns, the same facts can be read in a glance.
That grid is a table. Each row is one item, each column is one feature or period, and each box, called a cell, holds the value for that row and column. The title says what the table is about, and a unit line says how the numbers are measured.
Why governments love tables. The Census, the Budget, crop reports and economic surveys all arrive as tables. A table packs many facts into little space, keeps them in the same units and lets a reader compare across rows and down columns. That is why an officer reads more tables than paragraphs.
What this chapter does. Data interpretation starts with tables, because every graph is a table drawn as a picture. We learn to read a table correctly, to do the five common calculations quickly and to avoid the conclusions a table cannot support.
Reading a table before calculating
Step 1: the title. It tells you what is measured, where and when. "Rice production in five districts, 2021 to 2023" rules out any question about wheat or about 2020. Many wrong options in the exam are about things the table does not cover.
Step 2: the unit. A line such as "in thousand tonnes" or "₹ crore" applies to every cell. So 240 in a "thousand tonnes" table means 2,40,000 tonnes. Students who skip the unit pick options that are off by a factor of 1,000 or 100.
Step 3: rows, columns and notes. Check what each row and each column stands for, and whether there is a total row already. Read any footnote, such as "figures are provisional" or "excludes Union Territories", because a question may turn on it.
Here is the table we will use in this chapter. The figures are made up for practice.
| District | 2021 | 2022 | 2023 |
|---|---|---|---|
| A | 240 | 264 | 300 |
| B | 180 | 171 | 198 |
| C | 320 | 336 | 352 |
| D | 150 | 165 | 180 |
| E | 110 | 121 | 110 |
The table in words. It shows rice production in thousand tonnes, for five districts over three years. Before any calculation, notice two things at a glance: district C is the largest producer every year, and district B fell in 2022 while every other district rose.
Why it matters. Reading before calculating takes ten seconds and saves minutes. It also catches the questions that need no calculation at all.
The five calculations
Totals. Add down a column to get a year's total. In 2021 the total is 240 + 180 + 320 + 150 + 110 = 1,000 thousand tonnes, in 2022 it is 1,057 and in 2023 it is 1,140. Write the totals under the table once, because many questions reuse them.
Shares. A share is part ÷ total × 100. District C's share in 2021 is ³²⁰⁄₁,₀₀₀ × 100 = 32%. All five shares in a year add up to 100%, which is a useful check.
Growth. Growth is (later − earlier) ÷ earlier × 100, as in the percentage chapter. District A grew from 240 to 300 between 2021 and 2023, which is ⁶⁰⁄₂₄₀ × 100 = 25%. Total production grew from 1,000 to 1,140, which is 14%.
Averages. An average across years is the row total divided by the number of years. District D's average is (150 + 165 + 180) ÷ 3 = 165 thousand tonnes. Since D's values are equally spaced, the middle value is the average, so no addition was needed.
Ratios. A ratio compares two cells. In 2023, B : E = 198 : 110, and dividing both by 22 gives 9 : 5. Simplify with the HCF and check the options, which are usually given in lowest terms.
Why these five. Almost every table question in the exam is one of these five, or two of them joined. Recognising which one is asked is half the work.
Comparing quickly without full division
Absolute change versus percentage change. From 2022 to 2023, district A rose by 36 and district B rose by 27. A has the bigger absolute rise, but B's percentage rise is larger: ²⁷⁄₁₇₁ is about 15.8%, while ³⁶⁄₂₆₄ is about 13.6%. A small base turns a smaller change into a bigger percentage.
Why the two can disagree. Percentage change divides the change by the starting value. If the starting value is small, even a modest change becomes a large share of it. So always check whether a question asks "by how much" or "by what percent".
Benchmarks instead of division. To compare ²⁷⁄₁₇₁ with ³⁶⁄₂₆₄, ask whether each is above or below a friendly mark such as 15%. Since 15% of 171 is about 25.7, and 27 is more, B is above 15%. Since 15% of 264 is 39.6, and 36 is less, A is below 15%, so B wins without exact division.
Cross-multiplication. When benchmarks are close, compare a⁄b and c⁄d by checking a × d against b × c. Here 27 × 264 = 7,128 and 36 × 171 = 6,156, so ²⁷⁄₁₇₁ is larger. This is the same rule you learnt for fractions.
Rounding safely. Round to two significant figures, such as 171 to 170 and 264 to 260, when the options are far apart. If you round a numerator up and a denominator down, the errors add up, so round both the same way. When two options are within about 2% of each other, keep the numbers exact.
Why it matters. The exam gives options far enough apart that a clean estimate is enough. Saving one exact division per question can save several minutes in a set.
Rates, averages of rates and what a table cannot say
A second table. This one shows population and hospital beds in four districts of a state. The figures are made up for practice.
| District | Population (lakh) | Hospital beds | Beds per lakh |
|---|---|---|---|
| P | 20 | 1,600 | 80 |
| Q | 35 | 2,450 | 70 |
| R | 15 | 1,500 | 100 |
| S | 30 | 1,800 | 60 |
The overall rate. The state has 1,600 + 2,450 + 1,500 + 1,800 = 7,350 beds for 20 + 35 + 15 + 30 = 100 lakh people. So the state's rate is 73.5 beds per lakh. The simple average of the four district rates is (80 + 70 + 100 + 60) ÷ 4 = 77.5, which is wrong.
Why the simple average fails. District R has the best rate but the smallest population, so it should count for less. The simple average gives every district equal weight, as if all had the same population. The correct overall rate always comes from the totals, the same weighted-average idea as in the averages chapter.
What a table cannot tell you. The table shows that R has the most beds per lakh. It does not say why, whether R's hospitals are better, or how many beds are empty. A statement such as "R's people are healthier" cannot be concluded, because health is not in the table.
Why it matters. Questions often add one true statement and one that sounds reasonable but goes beyond the data. Ask of every statement, "Is this in the table, or can it be computed from it?".
Where and why this is asked
Why examiners test tables. An officer's day is full of tables: progress reports, district rankings, budget releases and survey results. Reading the unit wrongly or averaging rates naively can lead to a wrong ranking or a wrong allocation of funds. The paper checks whether you can draw correct, limited conclusions from data under time pressure.
Where it shows up. Data interpretation sets appear in the UPSC aptitude paper, in every state aptitude paper and in mental-ability sections of GS papers. The BPSC GS paper names statistical analysis, graphs and diagrams in its syllabus. Tables are the commonest form, either alone or alongside a graph.
When it goes wrong. The usual slips are ignoring the unit, using the later year as the base for growth, confusing absolute and percentage change and averaging rates that have different bases. The last kind of error is a favourite trap in UPSC-style questions.
The habit to build. Spend ten seconds reading the table before the questions. Write the column totals once, estimate before you divide, and check every statement against what the table actually contains.
Practice set: twelve solved problems
All twelve problems use the rice-production table in thousand tonnes. Try each problem first, then read the steps.
1. What was the total production in 2021?
Add the 2021 column: 240 + 180 + 320 + 150 + 110. The total is 1,000 thousand tonnes.
2. Which district's production fell from 2021 to 2022?
Only B went down, from 180 to 171. The answer is B.
3. By what percent did A grow from 2021 to 2022?
The rise is 24 on a base of 240. The growth is 10%.
4. What was C's share of total production in 2021?
C produced 320 out of 1,000. Its share was 32%.
5. What was D's average production over the three years?
The values 150, 165 and 180 are equally spaced, so the middle one is the average. The average is 165 thousand tonnes.
6. What was the ratio of B's to E's production in 2023?
198 : 110, and dividing both by 22 gives 9 : 5. The ratio is 9 : 5.
7. Which district grew the most in percentage terms from 2022 to 2023?
B grew 27 on 171, about 15.8%, more than A's 36 on 264, about 13.6%. The answer is B.
8. By what percent did total production grow from 2021 to 2023?
It rose from 1,000 to 1,140, a rise of 140 on 1,000. The growth is 14%.
9. By what percent did E fall from 2022 to 2023?
The fall is 11 on a base of 121, so ¹¹⁄₁₂₁ × 100. The fall is 9¹⁄₁₁%.
10. In 2023, by what percent did C's production exceed A's?
The gap is 52 on A's 300, so ⁵²⁄₃₀₀ × 100. C exceeded A by 17⅓%.
11. Which two districts increased their share of the total between 2021 and 2023?
A went from 24% to about 26.3% and D from 15% to about 15.8%, while B, C and E fell. The answer is A and D.
12. If A grows from 2023 to 2024 at the same rate as from 2022 to 2023, about how much will it produce?
The rate is ³⁰⁰⁄₂₆₄, about 1.136 times, so 300 × 1.136. A will produce about 341 thousand tonnes.
Quick revision
- Read the title, the unit, the headings and the notes before any calculation.
- Share = part ÷ total × 100, and all shares in a total add to 100%.
- Growth = (later − earlier) ÷ earlier × 100.
- The biggest absolute change and the biggest percentage change can be in different rows.
- Compare fractions with benchmarks or cross-multiplication before dividing fully.
- An overall rate comes from totals, not from the average of the rows' rates.
- A table shows what happened, not why, so conclusions must stay inside its data.