An Initiative by SAARTHI IAS
Maarg Manthan · Topic 25.1

Data Interpretation from Tables

Quantitative Aptitude › Data Interpretation · Topic 25.1

Data interpretation from tables means reading rows and columns of numbers and answering questions on totals, averages, percentages, ratios and comparisons. The numbers are already printed, so the skill lies in choosing the right row or column and doing a short, accurate calculation.

Share:
Data Interpretation from Tables - Quantitative Aptitude - MaargX UPSC Maarg Manthan

Quick Answer

Data interpretation from tables means reading rows and columns of numbers and answering questions on totals, averages, percentages, ratios and comparisons. The numbers are already printed, so the skill lies in choosing the right row or column and doing a short, accurate calculation.

At a Glance

  • Core skill Pick the right row or column
  • Common asks Total, average, share, ratio, growth
  • Share formula (Part / Total) × 100
  • Growth formula (New – Old) / Old × 100
  • Time per question About one minute
  • Data used here Fictional practice data

Where Does It Fit?

This is the first topic of the Data Interpretation macro, and the base for the chart-based topics. The next topic, Data Interpretation from Bar Graphs and Line Graphs, shows the same numbers as bars and lines, while Data Interpretation Involving Percentage, Ratio and Average Calculations adds the mixed percentage, ratio and average calculations used in most exam sets. The percentage steps rely on Percentage to Fraction and Fraction to Percentage Conversion, and the averages rely on Average of Numbers, Ages, Weights and Scores.

What Is a Data Table and How Do You Read It?

In short: a data table is a grid in which each row stands for one item (a year, a student or a region) and each column stands for one measure (sales, marks or cost). Every question points to a cell, a row total, a column total or a comparison between them.

Below is a fictional practice data set, used for the examples in this topic. It shows the number of units sold by a shop in four years.

Year Pens Books Bags Total
2022 120 80 60 260
2023 150 100 75 325
2024 180 90 90 360
2025 210 130 105 445
  • Read the title and units first: here the numbers are units sold, not rupees. A wrong unit gives a wrong answer even with correct arithmetic.
  • Check the totals column: the Total column is the sum of the other three. In 2022, 120 + 80 + 60 = 260.
  • Decide what the question needs: a single cell, a row total, a column total, or a comparison between two cells.
  • Use the printed totals: if the data table already gives a row total, do not add again. It saves time and avoids slips.

Which Calculations Are Asked on a Data Table?

In short: almost every table question uses one of five calculations: a total, an average, a percentage of total, a ratio or a percentage change.

Formulas to remember

  • Average = Sum of values / Number of values.
  • Percentage of total = (Part / Total) × 100.
  • Percentage change = (New value – Old value) / Old value × 100.
  • Ratio of A to B = A : B, reduced to the lowest terms.
  • Percentage point difference = one percentage minus another percentage.
Question type Method Example from the practice data
Row total Add across the row 2024 total = 180 + 90 + 90 = 360
Column total Add down the column Pens over four years = 120 + 150 + 180 + 210 = 660
Average Column total / 4 Average books per year = 400 / 4 = 100
Percentage of total Part / Total × 100 Bags in 2023 = 75 / 325 = 23.08%
Ratio Compare two cells Pens : Books in 2024 = 180 : 90 = 2 : 1
Percentage change (New – Old) / Old Bags 2022 to 2025 = 45 / 60 = 75%

Comparison questions ask for the highest value, the lowest value, or the year with the greatest rise. Scan the column quickly and mark the answer before doing any calculation.

How Do You Avoid Mistakes in Table Questions?

In short: most errors come from reading the wrong cell, mixing units, or using the wrong base for a percentage.

  • Base of the percentage: for growth, the base is the old value. For a share, the base is the total.
  • Same unit: if one column is in thousands and another in lakhs, convert before comparing.
  • Missing cells: a blank or dash may mean zero or not available. Read the footnote before using it.
  • Approximation: when answer options are far apart, rounding saves time. Methods are in Approximation-Based Techniques for Fast Calculation in Data Interpretation.

Solved Examples

Example 1

Question: Using the practice data, what is the total number of pens sold in the four years?

  1. Read the Pens column: 120, 150, 180 and 210.
  2. Add: 120 + 150 = 270; 270 + 180 = 450; 450 + 210 = 660.

Answer: 660 pens.

Example 2

Question: What is the average number of books sold per year?

  1. Books column: 80, 100, 90 and 130.
  2. Sum = 80 + 100 + 90 + 130 = 400.
  3. Average = 400 / 4 = 100.

Answer: 100 books per year.

Example 3

Question: By what percentage did bag sales rise from 2022 to 2025?

  1. Old value = 60 and new value = 105.
  2. Increase = 105 – 60 = 45.
  3. Percentage rise = 45 / 60 × 100 = 75%.

Answer: 75%.

Example 4

Question: What percentage of the 2023 total was made up by bags (correct to two decimal places)?

  1. Bags in 2023 = 75 and the 2023 total = 325.
  2. Share = 75 / 325 × 100.
  3. 75 / 325 = 0.2308, so the share is 23.08%.

Answer: About 23.08%.

Example 5

Question: In which year was the total highest, and what was the ratio of pens to books in 2024?

  1. Totals are 260, 325, 360 and 445, so the highest is 445 in 2025.
  2. In 2024, pens = 180 and books = 90.
  3. Ratio = 180 : 90 = 2 : 1.

Answer: 2025 is the highest, and the ratio in 2024 is 2 : 1.

Shortcuts and Tricks

  • Underline the exact words in the question: total, average, per year, increase, share. They decide the formula.
  • Use the printed Total column when it is given, and check it once with one row.
  • For a percentage rise, write old and new values on paper first. The old value goes in the denominator.
  • Compare columns by looking at differences between neighbours, not by recomputing everything.
  • Convert percentages to simple fractions when possible: 75% is 3/4, 25% is 1/4.

Common Mistakes

  • Using the new value as the base for a percentage rise instead of the old value.
  • Adding the Total column into the sum of items, which counts every figure twice.
  • Confusing units, such as treating thousands as units.
  • Reading the wrong year because the table is printed with years in rows in one question and in columns in another.
  • Rounding too early, which can change the final answer when options are close.

Practice Questions

  1. What is the total of all three items in 2022?
  2. What is the average number of pens sold per year?
  3. By what percentage did book sales rise from 2024 to 2025 (to one decimal place)?
  4. What is the ratio of total sales in 2022 to total sales in 2025?
  5. In which year did pens account for exactly half of the total?
  6. What is the total of books and bags in 2025?

Answers: 1) 260; 2) 165; 3) 44.4%; 4) 52 : 89; 5) 2024 (180 out of 360); 6) 235.

Why Is This Topic Important?

What Comes Next?

The next topic is Data Interpretation from Bar Graphs and Line Graphs. It uses the same ideas of totals, shares and growth, but reads values from the heights of bars and the points of a line.

Key Terms and Formulas

  • Row A horizontal line of values, such as one year
  • Column A vertical line of values, such as one product
  • Total The sum of the parts shown
  • Percentage change (New – Old) / Old × 100
  • Share Part divided by total, shown as a percentage
  • Base The value that a percentage is calculated on

Exam Corner

Points to Remember

  • Read the title, units and footnotes before any calculation.
  • For growth, divide the change by the old value.
  • For share, divide the part by the total.
  • Use printed totals where they are given.
  • Estimate first when answer options are far apart.

Do Not Confuse With

  • Share vs growth Share uses the total as base. Growth uses the old value as base.
  • Average vs total An average divides the total by the number of items.
  • Ratio vs percentage A ratio compares two parts, and a percentage compares a part with the whole.
  • Percentage vs percentage point A rise from 20% to 25% is 5 percentage points, and 25% in relative terms.

Memory Hook

Title, units, base, then calculate.

GS Relevance

Table-based data interpretation for SSC CGL, CAT and CSAT: reading rows and columns, totals, shares, averages, ratios and percentage change.

Frequently Asked Questions

What is data interpretation from tables?

Data interpretation from tables is the skill of reading rows and columns of numbers and answering questions on totals, averages, percentages, ratios and growth. In competitive exams the numbers are printed, so success depends on choosing the right cells and doing short, accurate calculations.

How do you calculate percentage change in a data table?

Percentage change in a data table is the difference between the new and old values divided by the old value, multiplied by 100. For example, bags rising from 60 to 105 units is a change of 45 on a base of 60, which is 75 per cent.

How do you find the share of one item in a table total?

The share of an item is its value divided by the total, multiplied by 100. In the practice data, bags in 2023 were 75 units out of a total of 325 units, so the share is about 23.08 per cent of that year's sales.

What are common mistakes in table-based questions?

Common mistakes in table-based questions are using the new value as the base for growth, adding the printed total again, mixing units such as thousands and lakhs, and reading the wrong row or column. Checking units and the base before calculating prevents most of these errors.

How much time should one table question take?

One table question should take about one minute in an exam. Reading the title and units takes a few seconds, locating the cells takes a few more, and a short calculation or estimate finishes the answer, so practice should aim for speed with accuracy.

PYQ Practice — Statement Analysis

1 In a percentage rise question, the base is the new value.
False

The base is the old value, so the change is divided by the old value.

2 The share of an item in a total is the item divided by the total, multiplied by 100.
True

For example, 75 out of 325 is about 23.08 per cent.

3 If bag sales rise from 60 to 105 units, the percentage rise is 75 per cent.
True

The rise is 45 and 45 / 60 = 0.75.

4 A row total printed in the table should be added again to the items in that row.
False

Adding it again counts every figure twice.

Share: