Tables

1. Reading a table before calculating

A table presents observations at the intersection of rows and columns. Rows may identify districts, companies, years or population groups; columns may show applicants, expenditure, output, percentages or other variables. The first task is to understand what each cell represents. A number such as 250 is meaningless until its category, period and unit are known. It could mean 250 persons, 250 thousand tonnes or ₹250 crore.

Read the title, row labels, column headings, units and footnotes before attempting arithmetic. Check whether the period is a calendar year, a financial year or a point-in-time reference date. A table of stocks, such as population on a specified date, differs from a table of flows, such as annual migration. Similarly, a cumulative figure includes earlier periods and must not be treated as an additional, independent annual observation.

Identify whether entries are absolute numbers, percentages, ratios or index values. Blank cells, dashes and zeroes are not automatically interchangeable: a dash may mean unavailable, not applicable or negligible, depending on the legend. If a question provides insufficient information to interpret an entry, do not invent a value. This reading discipline prevents more errors than faster multiplication alone.

• Mark the required category, time period and unit mentally before selecting values.
• Check whether totals include all categories and whether categories overlap.
• Treat footnotes as part of the data, not as optional background.

2. Core calculations and the correct denominator

Most table questions use a small set of operations: addition, subtraction, ratios, percentages, averages and growth rates. A category’s share equals its value divided by the relevant total, multiplied by 100. A selection rate equals selected candidates divided by applicants, multiplied by 100. Percentage change equals the new value minus the old value, divided by the old value, multiplied by 100. Although similar in appearance, these expressions answer different questions.

Direction matters in comparisons. If A is 25% greater than B, then A equals 1.25 times B; consequently, B is 20% less than A, not 25% less. Likewise, a rate rising from 15% to 20% increases by 5 percentage points but by approximately 33.33% relative to its initial level. CSAT options may deliberately place these two results close together.

An overall rate is usually a weighted average. If groups contain different numbers of applicants, their selection rates cannot simply be added and divided by the number of groups. Instead, divide total selections by total applicants. For other applications, use the corresponding weights: quantities for average purchase prices, student numbers for combined class averages, and relevant population counts for combined population rates.

• Average per unit = total quantity ÷ number of units.
• Weighted average = sum of each value multiplied by its weight ÷ sum of weights.
• For successive changes, multiply growth factors; a 20% rise followed by a 20% fall produces a net fall of 4%.

3. Worked interpretation of an illustrative table

The accompanying table is hypothetical and represents recruitment data for four districts. Applicants total 5,000 and selections total 900. Therefore, the overall selection rate is 18%. District D has the largest number selected, 315, and the highest selection rate, 22.5%. District C has the most applicants, 1,500, but its selection rate is only 15%. The largest denominator does not necessarily produce the highest rate.

Districts A and B each have 180 selected candidates, but their rates differ because A has 1,200 applicants while B has 900. Their respective rates are 15% and 20%. District B’s rate is therefore 5 percentage points higher, or approximately 33.33% higher relative to A’s rate. Meanwhile, B contributes 20% of all selections because 180 divided by 900 equals 0.20. This happens to equal its own selection rate, but the denominators are different.

For A and B together, divide 360 selections by 2,100 applicants to obtain approximately 17.14%. Averaging their two rates gives 17.5%, which is incorrect because the groups have unequal sizes. Across all four districts, the simple average of the rates is 18.125%, not the correct combined rate of 18%. Even a small discrepancy can determine the correct option.

• District D’s share of total selections is 315 ÷ 900 × 100 = 35%.
• District C’s share of total applicants is 1,500 ÷ 5,000 × 100 = 30%.
• The difference between applicants and selections is 4,100; this does not establish how many candidates actually appeared for the examination.

4. Efficient calculation and option elimination

Read the question before performing detailed calculations. A question asking for the highest selection rate requires comparison of selected-to-applicant ratios, not every total in the table. Cancel common factors before multiplying. To compare a/b and c/d for positive denominators, compare ad and bc. Cross-multiplication is useful when decimal division would be lengthy, although easy benchmark fractions may be quicker.

Memorise common fraction-percentage equivalents: one-half is 50%, one-third is approximately 33.33%, one-fourth is 25%, one-fifth is 20%, one-eighth is 12.5%, and one-sixth is approximately 16.67%. For example, 225 out of 1,500 can be simplified to 15 out of 100. Recognising such relationships reduces arithmetic and lowers the chance of copying a number incorrectly.

Use approximation only when the options are sufficiently separated. If possible answers are 12%, 18%, 30% and 45%, a rough estimate may suffice; if they are 18.0% and 18.1%, exact calculation may be necessary. Establish bounds before calculating: a combined rate with positive weights must lie between the smallest and largest subgroup rates. An answer outside that range can immediately be rejected.

• Keep intermediate fractions exact and round only the final result when practical.
• Convert units consistently: one lakh equals 100,000 and one crore equals 100 lakh.
• If a long set is consuming disproportionate time, mark it for review rather than letting it crowd out easier questions.

5. Inference limits and common traps

A table supports only conclusions justified by its definitions and entries. Higher district expenditure does not establish better administrative performance unless relevant outcomes and needs are known. More selected candidates do not necessarily imply a fairer or easier recruitment process. Similarly, two variables moving together do not establish that one caused the other. Distinguish numerical description from explanation.

Watch for totals that are counted twice. If a table lists male applicants, female applicants and all applicants, adding all three columns duplicates the population. Percentages may not sum to exactly 100 because of rounding; alternatively, they may exceed 100 when respondents can choose multiple answers. The table’s structure and notes determine which interpretation is valid.

Missing information can sometimes be recovered using a genuine total, but only if the listed components are mutually exclusive and exhaustive. A percentage without its denominator usually cannot yield an absolute count. Similarly, a rise in nominal expenditure does not prove an equivalent rise in real expenditure without price information. For every statement-based question, ask whether the conclusion must follow, merely could follow, or cannot be established.

• Do not infer appearance, eligibility or withdrawal figures from applicant and selection counts alone.
• For an index with base year equal to 100, distinguish index-point changes from percentage changes.
• Recheck the selected option against the exact wording: highest number, highest share and highest growth are different demands.

Previous year questions

No UPSC question has been asked directly on this micro-topic yet. Use the practice questions below.

Practice questions