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.
7 min read · Quantitative Aptitude · Data Interpretation
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?
- Read the Pens column: 120, 150, 180 and 210.
- 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?
- Books column: 80, 100, 90 and 130.
- Sum = 80 + 100 + 90 + 130 = 400.
- Average = 400 / 4 = 100.
Answer: 100 books per year.
Example 3
Question: By what percentage did bag sales rise from 2022 to 2025?
- Old value = 60 and new value = 105.
- Increase = 105 – 60 = 45.
- 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)?
- Bags in 2023 = 75 and the 2023 total = 325.
- Share = 75 / 325 × 100.
- 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?
- Totals are 260, 325, 360 and 445, so the highest is 445 in 2025.
- In 2024, pens = 180 and books = 90.
- 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
- What is the total of all three items in 2022?
- What is the average number of pens sold per year?
- By what percentage did book sales rise from 2024 to 2025 (to one decimal place)?
- What is the ratio of total sales in 2022 to total sales in 2025?
- In which year did pens account for exactly half of the total?
- 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?
- Frequency Table sets appear in almost every data interpretation section.
- Foundation Charts in Data Interpretation from Bar Graphs and Line Graphs and Data Interpretation from Pie Charts are tables drawn as pictures.
- Speed A habit of reading units, bases and totals first saves minutes.
- Accuracy Clean table skills make the harder sets in Data Interpretation Involving Ratio and Percentage Change Across Multiple Years easier.
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
Related Topics
- Data Interpretation from Bar Graphs and Line Graphs
- Data Interpretation from Pie Charts
- Data Interpretation from Caselets (CAT-Level)
- Mixed Data Interpretation Sets Combining Multiple Graph Types
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
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.
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.
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.
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.
Adding it again counts every figure twice.
Related Topics
Browse the full Quantitative Aptitude index