UPSC CSE · CSAT · Numeracy and data interpretation · TOPIC LESSON
Tables and charts
Read the variable, scale and denominator before calculating from a table or chart.
UPSC Civil Services45 min study guide9 indexed sections
BY THE END, YOU CAN
Interpret tables, grouped and stacked bars, line graphs and pie sectors.
Calculate totals, shares and interval changes from complete supplied data.
Identify missing values, misleading scales and unsupported explanations.
BEFORE YOU START
Use fractions, percentages and rate calculations.
Original educational lesson. Work through the examples before revealing the practice answers. This original common-core lesson supports its declared paper scope. Optional subjects, qualifying language papers and the interview are outside this resource.
LEARN THROUGH ORIGINAL PRACTICE
Original UPSC-style worked applications and practice
All teaching examples, cases, prompts and model answers are original. Official exam questions and answer keys are not reproduced. This common-core lesson does not imply complete historical paper coverage or an official score.
01 / UNDERSTAND & APPLY
What does the display measure?
Begin with the title, variable, unit, population and period. A chart of loans counts transactions, not necessarily distinct borrowers or books owned. A rate needs a denominator, and an index expresses a relative level against a base rather than an absolute count.
The original datasets in this lesson are hypothetical. Their displays are alternative ways to inspect the same specified numbers, not evidence about actual libraries, tanks or budgets. Ask the exact question before choosing an operation: largest count, largest share and fastest change can have different answers.
Do not infer causation from a visible pattern. A branch with more weekend loans may differ in size, opening hours or users; the chart alone does not establish which explanation is correct.
02 / UNDERSTAND & APPLY
Read rows, columns and totals
A table places each value at the intersection of a row category and column category. Read both labels before calculating. Totals can be added only when categories are compatible and nonoverlapping for the intended quantity. Adding a subtotal to its component cells double-counts them.
Here weekday and weekend loan categories are disjoint and cover the stated observation period. Each transaction belongs to one branch and one time category. This permits both row totals and column totals. A blank in another table would mean missing or unspecified unless the legend explicitly defines it as zero.
Full-size scientific diagram. Swipe or scroll horizontally; keyboard users can focus the diagram and use arrow keys.
Original dataset. Weekday/weekend and branch categories partition the 700 loan transactions in the stated period.
ORIGINAL WORKED EXAMPLE
One dataset, two directions of addition
For a hypothetical observation period, branch A records 120 weekday and 80 weekend loans; B records 180 and 60; C records 100 and 160. Each loan belongs to exactly one branch and one of these two categories. Find branch totals, the grand total and the weekend share.
Row totals: A 120+80=200; B 180+60=240; C 100+160=260.
Answer Branch totals 200,240,260; grand total 700; weekend share 3/7. The share is of transactions, not necessarily of distinct users.
ORIGINAL PRACTICE · 1
Using the supplied lending data, what is branch A’s total?
Reveal answer & reasoning
200 loans.
Add its two disjoint categories:120+80=200. Do not add the row total again when forming the grand total.
ORIGINAL PRACTICE · 2
A new table row has a blank weekend entry with no legend explaining it. May it be treated as zero?
Reveal answer & reasoning
No.
Blank could mean missing, not collected or not applicable. Without a definition, adding it as zero would invent a value and could distort the total.
03 / UNDERSTAND & APPLY
Bar lengths require a scale
A bar chart represents magnitude by length from a baseline. Read numerical tick marks rather than estimating from colour or width. A zero baseline makes length ratios correspond to value ratios. A truncated baseline can exaggerate visual differences even when labels remain arithmetically correct.
For example, values 100 and 110 differ by 10%, but bars drawn from a baseline of 90 have visible lengths 10 and 20. The second looks twice as long though its actual value is only 1.1 times the first. Use the actual values, and notice any axis break.
Bar width usually identifies a category rather than another quantity. Unless explicitly defined otherwise, wider bars should not be interpreted as larger counts. Keep series units compatible before comparing heights.
ORIGINAL PRACTICE · 1
Branch B has 240 total loans and A has 200. By what percentage is B’s count larger than A’s?
Reveal answer & reasoning
20%.
Difference 40 divided by the stated comparison base A’s 200 gives 0.20. Dividing by 240 would answer a different relative question.
04 / UNDERSTAND & APPLY
Compare like series
Grouped bars place several series side by side within each category. The legend identifies which bar is weekday and which weekend. Compare one series across branches to find the largest weekday value; compare bars within a branch to find its weekday-weekend difference.
Keep the series visible in your answer. The largest individual weekday bar need not belong to the branch with the largest total. A stacked height and a single grouped component are different quantities even when the charts use the same data.
Full-size scientific diagram. Swipe or scroll horizontally; keyboard users can focus the diagram and use arrow keys.
Same original lending dataset. Compare matching series across branches or the two components within a branch.
ORIGINAL WORKED EXAMPLE
The largest weekday count and a within-branch gap
From the grouped lending chart, identify the largest weekday count and calculate how much C’s weekend count exceeds its weekday count.
Weekday values are A 120,B 180,C 100; the largest is B 180.
For C, weekend 160 minus weekday 100 equals 60.
C has the largest weekend value, but that does not make it the largest weekday value.
Answer B has 180 weekday loans, and C’s weekend count exceeds its weekday count by 60 loans.
ORIGINAL PRACTICE · 1
Compare C’s 160 weekend loans with A’s 80 weekend loans.
Reveal answer & reasoning
C has twice A’s weekend count, or 100% more relative to A.
160/80=2 and(160−80)/80=1. The comparison uses the same series and observation period.
05 / UNDERSTAND & APPLY
Separate component size from total height
In a stacked bar, the full height is the sum of components. An upper segment’s value is its top boundary minus its bottom boundary, not simply its top coordinate. For C, the weekday segment ends at 100 and the total at 260, so the weekend segment is 160.
Absolute stacked bars compare totals and contributions. A 100% stacked chart instead normalizes every bar to equal total height and compares shares; it cannot reveal absolute totals unless those are separately supplied. Do not read equal normalized heights as equal loan counts.
A larger total does not imply every component is larger. C’s 260 total exceeds B’s 240, yet C’s weekday 100 is lower than B’s 180. State which component or share is relevant.
Full-size scientific diagram. Swipe or scroll horizontally; keyboard users can focus the diagram and use arrow keys.
Same original lending dataset. Full heights200,240,260 are totals; upper segment values are80,60,160.
ORIGINAL WORKED EXAMPLE
Different totals and different compositions
Using the same dataset, compare C and B by total loans and weekend share.
Totals are C 260 and B 240, so C has 20 more transactions.
C’s weekend share=160/260=8/13, approximately 61.54%.
B’s weekend share=60/240=1/4=25%.
C has a larger total and weekend share, but its weekday count 100 is below B’s 180.
Answer C has 260 total loans with weekend share 8/13; B has 240 with weekend share 25%. Total and component comparisons must remain distinct.
ORIGINAL PRACTICE · 1
All branches together record 400 weekday loans and 300 weekend loans. By what percentage is the weekend count below the weekday count?
Reveal answer & reasoning
25%.
The decrease is 100 relative to weekday base 400, so 100/400=25%. The weekend share of all 700 loans is a different calculation,300/700.
06 / UNDERSTAND & APPLY
Change divided by elapsed interval
A line graph connects observations ordered along an axis, often time. Read both coordinates of each point. The slope over an interval is vertical change divided by horizontal change; unequal time intervals must occupy proportional horizontal space if the graph is to show slopes faithfully.
A connecting line may be a visual guide or an explicit piecewise-linear model. Observations at endpoints alone do not prove that every intermediate value followed that straight line. The exercise must state when uniform change between points is assumed.
A flat segment means no change in the measured quantity over the modelled interval, not necessarily no activity in the underlying system: equal inflow and outflow could keep a tank’s level constant.
Full-size scientific diagram. Swipe or scroll horizontally; keyboard users can focus the diagram and use arrow keys.
Original hypothetical data. Straight connecting segments are the exercise’s explicit model, not an inference that real unobserved values must follow it.
ORIGINAL WORKED EXAMPLE
A tank with unequal observation intervals
A hypothetical tank contains 100 L at time 0 hours,160 L at 2 hours,160 L at 5 hours and 80 L at 9 hours. For this exercise assume straight-line change between successive observations. Find the three interval rates and the amount lost from hour 5 to 9.
From 0 to 2 hours: change 60 L over 2 hours gives+30 L/h.
From 2 to 5 hours: change 0 L over 3 hours gives 0 L/h.
From 5 to 9 hours: change−80 L over 4 hours gives−20 L/h.
The last interval’s loss magnitude is 80 L, distinct from its rate 20 L/h.
Answer Rates are+30,0 and−20 L/h; the final interval loses 80 L. Without the stated straight-line assumption, only interval-average rates would be established.
ORIGINAL PRACTICE · 1
What is the tank value at hour 5, and what is its net change from hour 2 to 5?
Reveal answer & reasoning
160 L, with zero net change over that interval.
Both endpoint observations are 160 L. Under the stated straight-line model the level stays constant between them; the data do not identify the underlying inflows or outflows.
ORIGINAL PRACTICE · 2
Find the tank’s average rate of change from hour 0 to 9.
Reveal answer & reasoning
−20/9 L/h, approximately−2.22 L/h.
Use final minus initial amount 80−100=−20 L, divided by 9 hours. Do not average the three segment rates equally because their durations differ.
07 / UNDERSTAND & APPLY
Recover amounts from shares and totals
A pie chart divides a whole into exhaustive nonoverlapping categories. A share p corresponds to sector angle 360 p degrees when p is expressed as a fraction. Shares sum to 1 and angles to 360 degrees. If categories overlap, a simple whole-part pie representation is inappropriate.
A percentage alone does not supply an amount:40% of 7200 differs from 40% of 1000. Read the stated total. Three-dimensional perspective and exploded sectors can distort visual area judgments; use the labels and arithmetic rather than apparent front-facing size.
Full-size scientific diagram. Swipe or scroll horizontally; keyboard users can focus the diagram and use arrow keys.
Original whole-part chart. Amounts are2880,1800,1440,1080units respectively; no empirical budget claim.
ORIGINAL WORKED EXAMPLE
A hypothetical budget
A 7200-unit budget allocates 40% to books,25% to repairs,20% to activities and 15% to reserve. Find category amounts, sector angles and the difference between largest and smallest allocations.
Amounts: books 2880, repairs 1800, activities 1440, reserve 1080, obtained by multiplying 7200 by each fraction.
What amount and sector angle correspond to repairs plus activities in this budget?
Reveal answer & reasoning
3240 units and 162 degrees.
Their shares sum 25%+20%=45%. Thus 0.45×7200=3240 and 0.45×360=162 degrees.
08 / UNDERSTAND & APPLY
Aggregate rates need their denominators
A pooled rate uses the combined numerator divided by the combined denominator. For a separate hypothetical service dataset, desk X resolves 9 of 10 cases and desk Y resolves 45 of 90 cases. The pooled rate is(9+45)/(10+90)=54%, not the unweighted mean of 90% and 50%, which is 70%.
The larger desk contributes more cases and therefore more weight. A table that supplies only subgroup percentages without group sizes generally cannot determine the pooled rate. Conversely, complete numerators and denominators make the calculation checkable.
Choose the denominator matching the question. A branch’s weekend share uses that branch’s total; the branch’s share of all weekend loans uses the weekend column total. For A these are 80/200=40% and 80/300≈26.67%, different but both meaningful quantities.
09 / UNDERSTAND & APPLY
Audit the display and your conclusion
Check the baseline, axis labels, equal or unequal interval spacing, legends, rounding and category definitions before comparing shapes. A missing unit or an unexplained axis break can make a confident visual judgment unreliable.
Distinguish displayed facts from inferred explanations. The lending chart establishes counts in its hypothetical dataset, not why users chose a branch. The tank line shows a specified amount over time, not whether a leak, withdrawal or pump caused the change.
Finally test the result against totals and bounds: a component cannot exceed its whole under the stated nonnegative partition, shares should sum appropriately, and a pooled rate should lie between positive-weight subgroup rates. These checks complement exact arithmetic rather than replace it.
KEEP THE BIG IDEAS
Quick revision
Identify the variable, unit, period and denominator first.
Grouped components, stacked totals and normalized shares answer different questions.
Line slopes require the actual elapsed interval.
Pie amounts need a total and nonoverlapping categories.
Pool numerators and denominators rather than averaging unequal-group rates.
The teaching notes, passages, worked explanations and practice are original. Official references identify the assessment framework and skill scope; they do not endorse this lesson or license official question reproduction.
The 2026 official notice was checked on 12 October 2026 for the broad skill scope. The public landing page did not respond reliably during that check. All teaching, passages, scenarios and solutions here are original educational material; no official questions, answer keys or future-topic guarantees are supplied.