Tabular Data Interpretation with Step-by-Step Questions
Tabular Data Interpretation involves reading numerical information arranged in rows and columns and answering questions based on totals, averages, ratios, percentages and comparisons. This page explains the main formulas, calculation methods and shortcuts used in tabular data interpretation questions, with a compact dataset for understanding common aptitude problems.
On this page
What is Tabular Data Interpretation?
Read the row and column headings first, identify the required values, and then apply the appropriate operation. For example, if the sales of Product A are 100 units in 2023 and 120 units in 2024, the increase is 20 units and the percentage increase is (20 ÷ 100) × 100 = 20%.
Tabular Data Interpretation Video Lessons
Watch short topic-wise lessons for quick revision.
Table DI: Percentage Share and Change
Learn to calculate percentage share and percentage change from tabular data, interpret comparisons, and solve related Data Interpretation questions accurately.
Tabular Data Interpretation Formula & Tricks
Important Formulas
Add the values from the specified rows or columns.
Use the number of included entries as the divisor.
A positive result shows an increase, while a negative result shows a decrease.
Write both quantities in the same units and simplify the ratio by their greatest common divisor.
Use this when the final value is known after an r% increase.
Use this when the final value is known after an r% decrease.
Quick Tricks
Before calculating, locate the exact category and year or heading mentioned in the question. This prevents using a value from a neighbouring column.
Simplify ratios and fractions before performing multiplication or division. This reduces calculation time and errors.
The denominator in a percentage increase or decrease is always the original value, not the new value.
If several questions use the same column, calculate its total once and reuse it.
Tabular Data Interpretation Concepts
Reading Rows and Columns
First identify the table heading and the unit of measurement. Then trace horizontally to find the required category and vertically to confirm the correct column. A value should be read only after both its row and column are identified.
Totals and Averages from a Table
For the 2024 column, the total is 120 + 150 + 180 + 160 = 610 units. The average 2024 sales are 610 ÷ 4 = 152.5 units.
Ratios and Comparisons
To compare the 2024 sales of Product A and Product B, write 120:150 and divide both terms by 30. The simplified ratio is 4:5. A difference is found by subtraction, while a ratio is found by division.
Percentage Increase and Decrease
For Product A, sales increased from 100 units in 2023 to 120 units in 2024. The change is 20 units, so the percentage increase is (20 ÷ 100) × 100 = 20%. If a value decreases, use the same formula with the decrease as the change and the old value as the base.
Combined Data from Multiple Columns
The combined sales of Product B over 2023 and 2024 are 130 + 150 = 280 units. The combined sales of all products over both years are 550 + 610 = 1,160 units.
Tabular Data Interpretation Data Table
Use the structured data below while following the explanation and examples.
Product Sales Used for Tabular Data Interpretation
Sales are given in units for two years.
| Product | Sales in 2024 | Sales in 2023 |
|---|---|---|
| Product A | 120 | 100 |
| Product B | 150 | 130 |
| Product C | 180 | 160 |
| Product D | 160 | 170 |
Note: The 2024 total is 610 units and the 2023 total is 560 units.
Learn more concepts on PrepShots
Start ₹1 Trial →Practice Tabular Data Interpretation Questions
Practise published questions related to this topic.
Want more practice questions?
Practice in App →Tabular Data Interpretation Quick Quiz
Attempt 5 questions and check your score instantly.
Keep practising
Practice more Tabular Data Interpretation questions in the PrepShots app and continue from your current topic.
Practice More Questions - Start ₹1 Trial →Quick Revision Notes
Tabular Data Interpretation Revision Points
Use the following rules while solving table-based data questions.
- Read the row heading, column heading and unit before calculating.
- Total = sum of the selected values.
- Average = total ÷ number of values.
- Percentage change = (change ÷ original value) × 100.
- For a ratio, convert quantities to the same units and simplify.
- After an r% increase, Original = Final ÷ (1 + r/100).
- After an r% decrease, Original = Final ÷ (1 − r/100).
- The base for percentage change is the original value.
Tabular Data Interpretation FAQs
How is the average of table values calculated?
Add the selected values and divide by their count. For example, the average of 120, 150 and 180 is 450 ÷ 3 = 150.
What is the percentage increase from 100 to 120?
The increase is 20. Therefore, percentage increase = (20 ÷ 100) × 100 = 20%.
What is the percentage decrease from 170 to 160?
The decrease is 10. Percentage decrease = (10 ÷ 170) × 100 = 5.88% approximately.
What is the ratio of 2024 sales of Product A and Product B?
The ratio is 120:150. Dividing both terms by 30 gives 4:5.
What are the total sales in 2024 in the given table?
The total is 120 + 150 + 180 + 160 = 610 units.
How do you find the original value after a 20% increase if the final value is 240?
Original = 240 ÷ 1.20 = 200. Thus, the original value was 200.