Read the information given below and answer the 3 associated questions.
During 2015-2019, the revenues of four companies P-S were as follows:
XAT Data change over a period Questions
Question 1
Which of the given companies has seen the highest year-on-year growth (in percentage) in any single year during this five-year period?
Solution
By noticing the table, we can come to the conclusion that either P in 2018 or Q in 2017 must-have the highest YoY growth.
YOY of P from 2017 to 2018=50/200 *100=25%
YOY of Q from 2016 to 2017 = 40/140 *100 = 28.57%
Hence D is the correct answer.
Read the information given below and answer the 3 associated questions.
During 2015-2019, the revenues of four companies P-S were as follows:
Question 2
It was discovered later that one of the companies misreported its revenue of one of the years. If the misreported revenue is replaced by the correct revenue, the revenues of that company over the five-year period will be in an arithmetic progression. The company that misreported its revenue was
Solution
Let us observe the revenue of the four companies over four years. We see that Company Q and Company S can form an arithmetic progression. This is because the differences between revenues over the years are different, and we are only looking to replace one value over five years to achieve an arithmetic progression.
Looking at Company P, we see that it maintains a +25 over the years except for one year. If 2018 revenue was 225, then we would achieve an arithmetic progression.
Similarly, for Company S, we see that it maintains a +20 over the years except for one year. If 2018 revenue were 160, then we would achieve an arithmetic progression.
Read the information given below and answer the 3 associated questions.
During 2015-2019, the revenues of four companies P-S were as follows:
Question 3
During the period from 2014 to 2015, the revenue increased by 25% for three of the companies and by 50% for the remaining company. The total increase in revenue, for all four companies put together, was Rs. 125 lakhs.
Which of the following CANNOT be true?
Solution
Let us first compute the individual changes in value in both years before zeroing in on the companies that fall into the 25% increase and 50% increase groups.
For 25% increase:
For 50% increase:
We can move forth with the assumption that P saw a 50% increase while the rest of the companies saw a 25% increase. In this case, the total increase in revenue, for all four companies put together, will be Rs. 125 lakhs. Same is the case when we consider company R to have seen a 50% increase, while the rest had a 25% increase. {Hence, Option D is true} We observe that Options B, C and E hold true as well. The increase observed for each of the companies is distinct, based on the given condition. Thus, Option A cannot be true.
.png)
.png)
Frequently Asked Questions
Yes, Data Change Over a Period is an important topic in the XAT DI section. It tests a candidate's ability to analyse how data values change over time, identify trends, calculate growth rates, and compare values across different periods.
XAT Data Change Over a Period questions typically involve time-series data presented in tables or line graphs. Questions may ask candidates to calculate year-on-year growth, compound growth rates, percentage change, or identify the period of maximum or minimum change.
Candidates should practise calculating percentage change, absolute change, CAGR (Compound Annual Growth Rate), and identifying trends from time-series data. Learning approximation techniques for multi-year growth calculations will improve speed significantly.
These questions are of moderate difficulty in XAT. Multi-step growth rate calculations or questions requiring comparisons across multiple time periods can be more demanding in terms of both time and calculation accuracy.
Cracku's XAT Data Change Over a Period questions provide comprehensive practice with time-series data of varying complexity. The detailed solutions demonstrate efficient methods for calculating growth rates and identifying trends, helping candidates answer these questions quickly and accurately.
