- Advanced
- About 14 min
- 5 practice questions
Reading tables: percentage change, averages and profit share
Extract numbers from a table and compute percentage change, averages and ratios of two columns accurately and quickly.
If something looks wrong, please tell us.
Data interpretation tests your reading as much as your arithmetic. First read the title, the units and every column heading; then decide exactly which cells the question needs. All data in this course is made up for practice.
| Year | Sales | Expenses | Profit (Sales - Expenses) |
|---|---|---|---|
| 2021 | 120 | 90 | 30 |
| 2022 | 150 | 105 | 45 |
| 2023 | 135 | 108 | 27 |
| 2024 | 180 | 126 | 54 |
Percentage change
Percentage change = (new - old)/old x 100. Always divide by the earlier value. From 2021 to 2022 sales rise from 120 to 150: 30/120 = 25% increase. From 2022 to 2023 sales fall from 150 to 135: 15/150 = 10% decrease. From 2023 to 2024: 45/135 = 33 1/3% increase.
Averages and profit share
Average sales over the four years = (120 + 150 + 135 + 180)/4 = 585/4 = 146.25 lakh. Profit as a percentage of sales: 2021 = 30/120 = 25%; 2022 = 45/150 = 30%; 2023 = 27/135 = 20%; 2024 = 54/180 = 30%.
Worked example
Profit grew from 27 in 2023 to 54 in 2024: 27/27 = 100% increase, even though sales rose only 33 1/3%. Profit moves faster than sales because expenses grow more slowly.
Percentage change = (new - old)/old x 100. Percentage share = part/whole x 100.
Key takeaways
- Read the title and units before using any number.
- Percentage change always uses the earlier value as the base.
- Compute a column of derived values (such as profit %) once, then compare.
- Estimate first to catch slips.
Check your understanding
-
1. A company's figures (₹ lakh): 2021 - sales 120, expenses 90, profit 30; 2022 - 150, 105, 45; 2023 - 135, 108, 27; 2024 - 180, 126, 54. What is the percentage increase in sales from 2021 to 2022?
- 20%
- 33 1/3%
- 30%
- 25%
Show answer
Answer: D. (150 − 120) ÷ 120 × 100 = 30 ÷ 120 × 100 = 25%.
-
2. A company's figures (₹ lakh): 2021 - sales 120, expenses 90, profit 30; 2022 - 150, 105, 45; 2023 - 135, 108, 27; 2024 - 180, 126, 54. What is the percentage decrease in sales from 2022 to 2023?
- 10%
- 11.1%
- 15%
- 20%
Show answer
Answer: A. (150 − 135) ÷ 150 × 100 = 15 ÷ 150 × 100 = 10%. Dividing by 135 (the later value) would wrongly give 11.1%.
-
3. A company's figures (₹ lakh): 2021 - sales 120, expenses 90, profit 30; 2022 - 150, 105, 45; 2023 - 135, 108, 27; 2024 - 180, 126, 54. What are the average yearly sales over the four years (₹ lakh)?
- 140
- 145
- 146.25
- 150
Show answer
Answer: C. (120 + 150 + 135 + 180) ÷ 4 = 585 ÷ 4 = 146.25.
-
4. A company's figures (₹ lakh): 2021 - sales 120, expenses 90, profit 30; 2022 - 150, 105, 45; 2023 - 135, 108, 27; 2024 - 180, 126, 54. What is the percentage increase in profit from 2023 to 2024?
- 33 1/3%
- 100%
- 50%
- 27%
Show answer
Answer: B. (54 − 27) ÷ 27 × 100 = 100%. Profit doubled even though sales rose only 33 1/3%.
-
5. A company's figures (₹ lakh): 2021 - sales 120, expenses 90, profit 30; 2022 - 150, 105, 45; 2023 - 135, 108, 27; 2024 - 180, 126, 54. What is the percentage increase in expenses from 2021 to 2024?
- 36%
- 28.6%
- 45%
- 40%
Show answer
Answer: D. (126 − 90) ÷ 90 × 100 = 36 ÷ 90 × 100 = 40%. (28.6% wrongly divides by 126.)
Sign in to keep track of the lessons you finish.