New UPSC Foundation, Optional and TGPSC/APPSC batches are open — book your counselling slot.Today's Current AffairsToday's Daily QuizCall 98804 87071

Prelims GS-II (CSAT) · Data interpretation · Charts and tables

Data comparison

Data comparison in CSAT involves comparing values, proportions, rates and changes presented in tables, bar charts, line graphs and pie charts. The central skill is identifying what the question actually asks and placing the relevant quantities on a common basis. Efficient solutions combine accurate reading, simple arithmetic, proportional reasoning and selective approximation. This page explains a systematic approach to comparisons, common traps and examination-oriented techniques.

1. What data comparison tests

Data comparison is the process of deciding whether one quantity is greater than, smaller than or equal to another, or determining the extent of the difference. In CSAT, the quantities may represent production, expenditure, population, marks, sales, rainfall or the distribution of people across categories. The mathematical operations are usually elementary, but the information must first be interpreted correctly.

Direct comparison asks which displayed value is largest or smallest. Derived comparison requires calculation, such as identifying the highest output per worker, the greatest percentage increase or the largest expenditure share. Ranking several quantities and checking whether a statement follows from the data are also common applications. Before calculating, translate the wording into a precise measure.

For example, highest production refers to total output, while highest productivity requires output divided by the relevant input, such as workers or hours. Similarly, the largest increase means the greatest absolute addition unless the question explicitly asks for a percentage increase. Treat these as different questions even when they use the same table.

CSAT is qualifying, but sound preparation remains essential. The official syllabus includes charts, graphs, tables and data sufficiency. Data comparison also draws on ratios, percentages and averages. Building these foundations is more useful than memorising shortcuts without understanding when they apply.

  • Identify the object of comparison: value, difference, ratio, share, rate or change.
  • Identify the reference: another category, a total, an initial year or a target.
  • Identify the required output: exact number, approximate value, ranking or valid statement.

2. Read the display before comparing

Start with the title, source note, period, headings and units. A table may report population in thousands and expenditure in lakh rupees. Convert only when needed, but never compare unlike units directly. If all entries share the same scale factor, it cancels in ratios and percentage calculations. However, an absolute difference must still be reported in the stated unit.

In bar charts, inspect the baseline and tick marks. A truncated vertical axis can exaggerate apparent differences. In line graphs, compare numerical changes and elapsed time rather than visual steepness alone. Unequal time intervals require special care. In tables, verify that rows and columns describe the same reference period and that totals do not mix overlapping categories.

For pie charts, a category's value equals its sector angle divided by 360, multiplied by the total. A larger sector means a larger share within the same chart. Across two charts with different totals, the larger share may represent a smaller absolute amount. For instance, 30% of 200 is 60, whereas 25% of 400 is 100.

Distinguish a zero from missing information. A dash may indicate unavailable data, a non-applicable category or a zero, depending on the legend. Rounded percentages may sum to 99.9 or 100.1 without invalidating the chart. Do not infer precise differences smaller than the rounding resolution. If essential totals or denominators are absent, the correct conclusion may be that the comparison cannot be determined.

  • Check whether the data are monthly, annual, cumulative or measured at a particular date.
  • Check whether values are totals, averages, percentages, index numbers or per-capita measures.
  • Read footnotes concerning coverage, estimates, revisions and changes in definitions.

From display to defensible comparison

  1. 1. Read the question and identify the required measure.
  2. 2. Check headings, units, periods, legends and coverage.
  3. 3. Extract the relevant values and denominators.
  4. 4. Standardise the basis of comparison.
  5. 5. Use subtraction, ratios, cross-products or weighted averages.
  6. 6. Check precision, plausibility and the selected option.

3. Core measures and worked comparisons

Absolute difference is obtained by subtraction. If district A produces 480 tonnes and district B produces 400 tonnes, the difference is 80 tonnes. A exceeds B by 20%, calculated as 80 divided by 400, multiplied by 100. Conversely, B is below A by about 16.67%, because the denominator becomes 480. Percentage comparisons are therefore not symmetric.

Growth rate equals the final value minus the initial value, divided by the initial value, multiplied by 100. An increase from 80 to 100 is 25%, while an increase from 200 to 240 is 20%. The second series has the greater absolute increase, but the first has faster percentage growth. Percentage growth from a zero initial value is undefined under this formula.

A share measures a part relative to its whole. If education spending rises from 20% to 25% of a budget, the increase is 5 percentage points. The relative increase in the share is 25%. This does not establish the percentage increase in education spending itself unless the budget totals are also known.

For positive denominators, compare a/b and c/d through the cross-products ad and bc. Comparing 42/60 with 55/80 requires only 42 × 80 = 3,360 and 55 × 60 = 3,300; therefore, the first ratio is larger. This avoids unnecessary decimal division and is particularly useful for success rates and productivity comparisons.

Combined rates require weighting. If one centre has 80 successful candidates out of 100 and another has 90 out of 150, their combined success rate is 170/250, or 68%, not the simple average of 80% and 60%. Similarly, an overall percentage growth rate is weighted by initial values. For unequal time spans, compare annualised growth when required; compound annual growth is calculated as [(final/initial)^(1/years) − 1] × 100.

  • Part share = part ÷ total × 100.
  • Achievement rate = actual achievement ÷ target × 100.
  • Per-capita value = aggregate value ÷ relevant population.
  • Index with base 100 = current value ÷ base value × 100; independently rebased series do not reveal absolute size.
Illustrative dataset: output comparison across four units
UnitInitial output: tonnesFinal output: tonnesAbsolute increase: tonnesPercentage increase
A801002025%
B2002404020%
C1501803020%
D1201563630%

4. A time-efficient examination method

Read the question before processing every number in the display. Mark the required rows, columns and periods, then write the comparison in a short mathematical form. If the task asks for the highest success rate, construct successful candidates divided by total candidates for each relevant category. Do not rank categories using successful candidates alone.

Use elimination before detailed arithmetic. A positive fraction with a larger numerator and a smaller denominator than another positive fraction must be larger. Equal denominators permit direct numerator comparison. Equal positive numerators make the smaller denominator produce the larger fraction. Familiar benchmarks such as one-half, two-thirds and three-fourths can quickly separate options.

Approximate only to a precision that safely distinguishes the options. Ratios of 198/402 and 301/398 are close to one-half and three-fourths, so exact division is unnecessary. Closely matched values require cross-multiplication or more precise calculation. Keep intermediate values unrounded wherever possible and round the final result.

For multiple statements, test each independently and look for a decisive counterexample. A claim that a value increased every year requires all adjacent-year comparisons, not just the first and last observations. Finish with a plausibility check: a subgroup share cannot exceed 100% when the subgroup is genuinely contained in the total, and a weighted average must lie between the component values.

  • Reuse totals and differences when several questions share a dataset.
  • Avoid calculating every ratio when one clear comparison eliminates an option.
  • If a calculation becomes lengthy, recheck whether common factors cancel.

5. Interpretation limits and common traps

Comparability depends on definitions as well as arithmetic. Current-price output reflects both quantities and prices; constant-price measures are designed to remove price effects. A state with a larger aggregate economy may have lower per-capita income. Likewise, more reported incidents may reflect a larger population or improved reporting rather than a higher underlying incidence rate.

Stocks and flows should not be confused. Outstanding debt is measured at a point in time, whereas annual borrowing is measured over a period. Nor should a cumulative total be compared directly with a single month's addition. Where population sizes differ, a rate per thousand or per lakh may be more informative than a raw count.

Changes in composition can also reverse an apparent comparison. A combined success rate may rise because a larger proportion of candidates belongs to a high-success subgroup, even if subgroup rates do not improve. This illustrates why aggregate and subgroup comparisons can differ, a phenomenon associated with Simpson's paradox.

In the examination, use the supplied dataset and its assumptions rather than outside knowledge. A chart can show association, ranking or change, but usually cannot establish causation. If the question asks what must follow, distinguish a necessary conclusion from a plausible explanation. Correct data comparison is disciplined reasoning about what the evidence supports.

  • Common traps include changing denominators, unequal totals, misleading scales and unweighted averages.
  • Do not infer uninterrupted growth from an endpoint increase.
  • Do not treat a percentage-point change as an equal percentage change.

Real-world case studies

Census 2011: literacy changes

Census of India figures report literacy among persons aged seven and above at 64.83% in 2001 and 72.98% in 2011. The increase was 8.15 percentage points, while the relative increase in the literacy rate was approximately 12.57%. Neither figure directly gives the increase in the number of literate people, because the eligible population also changed. This is a practical example of distinguishing rates, percentage points and absolute counts.

NFHS: comparing like indicators

National Family Health Survey fact sheets report child stunting among children under five at 38.4% in NFHS-4, 2015–16, and 35.5% in NFHS-5, 2019–21. This is a decline of 2.9 percentage points, or approximately 7.55% relative to the earlier prevalence. Estimating the change in the number of affected children additionally requires corresponding population totals; interpreting small differences also requires attention to survey uncertainty.

Previous year questions

No source-linked PYQ is available here yet. Use the practice questions below.

Practice questions

Practice MCQ 1 · Easy

The following table gives the daily output and number of workers in four workshops: Workshop | Output (units) | Workers P | 360 | 30 Q | 420 | 28 R | 480 | 40 S | 390 | 30 Which workshop has the highest daily output per worker?

  • A. P
  • B. Q
  • C. R
  • D. S

Practice MCQ 2 · Easy

The number of households connected to piped water in four villages is given below: Village | Year 1 | Year 2 P | 80 | 100 Q | 120 | 144 R | 150 | 180 S | 200 | 236 Which village recorded the greatest percentage increase in connected households?

  • A. P
  • B. Q
  • C. R
  • D. S

Practice MCQ 3 · Easy

Two pie charts represent the annual expenditure of municipalities X and Y. X has total expenditure of Rs 480 crore, and its education sector occupies 90°. Y has total expenditure of Rs 600 crore, and its education sector occupies 84°. How does Y's education expenditure compare with X's?

  • A. It is Rs 20 crore lower.
  • B. It is Rs 10 crore higher.
  • C. It is Rs 30 crore higher.
  • D. It is Rs 20 crore higher.

Practice MCQ 4 · Easy

Four districts report the following numbers of houses completed under a scheme: District | Target | Houses completed P | 200 | 180 Q | 240 | 228 R | 320 | 306 S | 300 | 285 Which district achieved the highest percentage of its target?

  • A. P
  • B. Q
  • C. R
  • D. S

Practice MCQ 5 · Easy

A state's total expenditure rose from Rs 1,200 crore in Year 1 to Rs 1,500 crore in Year 2. Its health expenditure rose from Rs 240 crore to Rs 390 crore during the same period. By how many percentage points did health expenditure's share in total expenditure increase?

  • A. 5 percentage points
  • B. 6 percentage points
  • C. 25 percentage points
  • D. 30 percentage points

Practice MCQ 6 · Moderate

The following table gives examination results for two batches at each training centre: Centre | Batch I: passed/appeared | Batch II: passed/appeared P | 80/100 | 120/200 Q | 126/140 | 112/160 R | 72/80 | 154/220 S | 135/150 | 105/150 Which centre has the highest combined pass percentage across its two batches?

  • A. P
  • B. Q
  • C. R
  • D. S

Practice MCQ 7 · Moderate

The expenditure and population of four districts are given below: District | Expenditure in Year 1 (Rs crore) | Expenditure in Year 2 (Rs crore) | Population in Year 1 (thousand) | Population in Year 2 (thousand) P | 60 | 78 | 200 | 240 Q | 80 | 100 | 250 | 275 R | 100 | 126 | 400 | 420 S | 90 | 108 | 300 | 360 Which district recorded the greatest percentage increase in expenditure per person?

  • A. P
  • B. Q
  • C. R
  • D. S

Practice MCQ 8 · Moderate

The annual production of two crops is shown below: Year | Crop P (thousand tonnes) | Crop Q (thousand tonnes) 2016 | 80 | 120 2020 | 100 | 156 2023 | 130 | 183 Consider the following statements: 1. Between 2020 and 2023, P had a greater percentage increase in production than Q. 2. Q had a greater average annual absolute increase in production in each of the two intervals, 2016–2020 and 2020–2023. 3. Between 2016 and 2023, P had a greater percentage increase in production than Q. Which of the statements given above are correct?

  • A. 1 only
  • B. 1 and 3 only
  • C. 2 and 3 only
  • D. 1, 2 and 3

Practice MCQ 9 · Moderate

Factories X and Y each have an output index with their own 2020 output set equal to 100. In 2024, X's output index is 160 and Y's is 150. The question is: Was X's actual output in 2024 greater than Y's? Consider the following additional statements: 1. X's actual output in 2020 was 90% of Y's actual output in 2020. 2. X employed 80% as many workers as Y in 2024. Which of the following correctly describes the sufficiency of the statements for answering the question?

  • A. Statement 1 alone is sufficient, but statement 2 alone is not sufficient.
  • B. Statement 2 alone is sufficient, but statement 1 alone is not sufficient.
  • C. Both statements together are necessary, and together they are sufficient.
  • D. Even both statements together are not sufficient.

Practice MCQ 10 · Moderate

The table gives nominal monthly income per person and a price index for four regions. Every region's price index was 100 in Year 1. Region | Year 1 income (Rs) | Year 2 income (Rs) | Year 2 price index P | 15,000 | 18,900 | 120 Q | 18,000 | 23,400 | 125 R | 25,000 | 31,500 | 120 S | 20,000 | 24,200 | 110 Real income is nominal income divided by the price index and multiplied by 100. Which region recorded the greatest percentage increase in real income?

  • A. P
  • B. Q
  • C. R
  • D. S

Practice MCQ 11 · Difficult

Two employment programmes report the following outcomes: Programme | Urban participants | Urban participants placed | Rural participants | Rural participants placed | Cost per participant P | 900 | 720 | 100 | 40 | Rs 1,400 Q | 200 | 180 | 800 | 400 | Rs 1,800 For a fair comparison, both programmes are evaluated for a hypothetical participant mix of 40% urban and 60% rural. Assume that each programme retains its observed urban and rural placement rates, and that its cost per participant is the same in both categories. Under this common participant mix, which programme has the lower cost per expected placement, and by what percentage is it lower than the other programme's cost?

  • A. P, by 8⅓%
  • B. P, by 10%
  • C. Q, by 8⅓%
  • D. Q, by 10%

Practice MCQ 12 · Difficult

The following data relate to health expenditure in two districts: District | Total budget (Rs crore) | Health sector angle in budget pie chart | Capital expenditure as % of health budget | Administration as % of non-capital health expenditure | Population (lakh) | Eligible population as % of total population | Persons served as % of eligible population A | 900 | 96° | 25% | 10% | 12 | 40% | 75% B | 1,200 | 90° | 40% | 20% | 10 | 50% | 80% Direct-service expenditure equals the health budget after deducting capital expenditure and administration expenditure. All expenditure amounts refer to the same year. How does direct-service expenditure per person actually served compare between the districts?

  • A. B's expenditure per person served is 25% higher than A's.
  • B. A's expenditure per person served is 20% higher than B's.
  • C. A's expenditure per person served is 25% higher than B's.
  • D. The expenditure per person served is equal in both districts.

Practice MCQ 13 · Difficult

An agency must retain exactly 1,000 usable components. It must purchase exclusively from one of the following suppliers, in whole lots: Supplier | Components per lot | Purchase price per lot | Transport cost per lot | Rejected components per lot P | 500 | Rs 25,000 | Rs 2,000 | 50 Q | 400 | Rs 24,000 | Rs 1,000 | 20 For each supplier, the agency buys the smallest number of whole lots that provides at least 1,000 usable components. Every rejected component is sold for Rs 10, and every usable component in excess of 1,000 is sold for Rs 40. There are no other costs or receipts. Which supplier results in the lower net expenditure, and by how much?

  • A. P, by Rs 5,100
  • B. P, by Rs 3,300
  • C. Q, by Rs 3,300
  • D. Q, by Rs 5,100

Practice MCQ 14 · Difficult

Changes in output and workforce at two factories are given below. Each percentage change is measured relative to the beginning of the specified interval. Factory | Output change, 2020–2022 | Workforce change, 2020–2022 | Output change, 2022–2024 | Workforce change, 2022–2024 P | +20% | +20% | +25% | −10% Q | +50% | +10% | +10% | +20% Productivity is defined as output per worker. Compare the percentage increases in productivity from 2020 to 2024, each measured relative to the respective factory's 2020 productivity.

  • A. P's productivity increase exceeds Q's by 11⅑ percentage points.
  • B. Q's productivity increase exceeds P's by 13⅞ percentage points.
  • C. P's productivity increase exceeds Q's by 25 percentage points.
  • D. P's productivity increase exceeds Q's by 13⅘ + 4/45 percentage points.

Practice MCQ 15 · Difficult

Two plants operate two production lines each. Their current monthly output and expected rejection rates are: Plant | Line | Output (units) | Expected rejection rate A | I | 600 | 5% A | II | 400 | 10% B | I | 400 | 2% B | II | 600 | 8% Next month, A will shift production of 100 units from Line II to Line I without changing its total output. B will increase Line I's output by 25% and Line II's output by x%, where x is a non-negative whole number. All line-specific expected rejection rates remain unchanged. What is the smallest value of x for which A's expected proportion of accepted units will be strictly greater than B's?

  • A. 149
  • B. 150
  • C. 151
  • D. 152

Further reading

  • UPSC: Civil Services Examination notification, Preliminary Examination syllabus and examination scheme, upsc.gov.in.
  • UPSC: Official Civil Services Preliminary Examination General Studies Paper II question papers.
  • NCERT Mathematics, Class VII: Comparing Quantities and Data Handling.
  • NCERT Mathematics, Class VIII: Comparing Quantities and Data Handling.
  • Office of the Registrar General and Census Commissioner, India: Census 2011 literacy tables, censusindia.gov.in.
  • Ministry of Health and Family Welfare and International Institute for Population Sciences: NFHS-4 and NFHS-5 India fact sheets.

Preparing for UPSC Civil Services? Get classroom teaching, answer-writing evaluation and mentorship at Pragnya IAS Academy, Ashok Nagar — see why aspirants choose us for IAS coaching in Hyderabad.

Talk to a counsellor

Tell us your preparation stage and preferred programme — a counsellor will call back with batch timings and a study plan.

Or call 98804 87071 · Mon–Sat 9 am–7 pm

Free UPSC daily current affairs quiz — 10 questions, new every day at 8 am IST.

Call nowWhatsApp