Data Interpretation Previous Year Questions (CAT) - Set 01
Answer: Option 3 Option 3 Option 2
Abdul, Bikram and Chetan are three professional traders who trade in shares of a company XYZ Ltd. Abdul follows the strategy of buying at the opening of the day at 10 am and selling the whole lot at the close of the day at 3 pm. Bikram follows the strategy of buying at hourly intervals: 10 am, 11 am, 12 noon, 1 pm and 2 pm, and selling the whole lot at the close of the day. Further, he buys an equal number of shares in each purchase. Chetan follows a similar pattern as Bikram but his strategy is somewhat different. Chetan‟s total investment amount is divided equally among his purchases. The profit or loss made by each investor is the difference between the sale value at the close of the day less the investment in purchase. The “return” for each investor is defined as the ratio of the profit or loss to the investment amount expressed as a percentage.
1. On a “boom” day the price of XYZ Ltd. keeps rising throughout the day and peaks at the close of the day. Which trader got the minimum return on that day?
(1) Bikram (2) Chetan (3) Abdul (4) Abdul or Chetan (5) cannot be determined
2. On a day of fluctuating market prices, the share price of XYZ Ltd. ends with a gain, i.e., it is higher at the close of the day compared to the opening value. Which trader got the maximum return on that day?
(1) Bikram (2) Chetan (3) Abdul (4) Bikram or Chetan (5) cannot be determined
3. Which one of the following statements is always true?
(1) Abdul will not be the one with the minimum return
(2) Return for Chetan will be higher than that of Bikram
(3) Return for Bikram will be higher than that of Chetan
(4) Return for Chetan cannot be higher than that of Abdul
(5) none of the above
One day, two other traders, Dane and Emily joined Abdul, Bikram and Chetan for trading in the shares of XYZ Ltd. Dane followed a strategy of buying equal numbers of shares at 10 am, 11 am and 12 noon, and selling the same numbers at 1 pm, 2 pm and 3 pm. Emily, on the other hand, followed the strategy of buying shares using all her money at 10 am and selling all of them at 12 noon and again buying the shares for all the money at 1 pm and again selling all of them at the close of the day at 3 pm. At the close of the day the following was observed:
- Abdul lost money in the transactions.
- Both Dane and Emily made profits.
- There was an increase in share price during the closing hour compared to the price at 2 pm.
- Share price at 12 noon was lower than the opening price.
4. Which of the following is necessarily false?
(1) Share price was at its lowest at 2 pm
(2) Share price was at its lowest at 11 am
(3) Share price at 1 pm was higher than the share price at 2 pm
(4) Share price at 1 pm was higher than the share price at 12 noon
(5) none of the above
5. Share price was at its highest at
(1) 10 am (2) 11 am (3) 12 noon (4) 1 pm (5) cannot be determined
(CAT 2008 )
Answer: Option 1 Option 5 Option 5 Option 5 Option 1
Telecom operators get revenue from transfer of data and voice. Average revenue received from transfer of each unit of data is known as ARDT. In the diagram below, the revenue received from data transfer as percentage of total revenue received and the ARDT in US Dollars (USD) are given for various countries.Â
1.Â If the total revenue received is the same for the pairs of countries listed in the choices below, choose the pair that has approximately the same volume of data transfer.
(1) Philippines and Austria
(2) Canada and Poland
(3) Germany and USA
(4) UK and Spain
(5) Denmark and Mexico
2. It was found that the volume of data transfer in India is the same as that of Singapore. Then which of the following statements are true?
(1) Total revenue is the same in both countries.
(2) Total revenue in India is about 2 times that of Singapore
(3) Total revenue in India is about 4 times that of Singapore
(4) Total revenue in Singapore is about 2 times that of India
(5) Total revenue in Singapore is about 4 times that of India
3. It is expected that by 2010, revenue from the data transfer as a percentage of total revenue will triple for India and double for Sweden. Assume that in 2010, the total revenue in India is twice that of Sweden and that the volume of data transfer is the same in both the countries. What is the percentage increase of ARDT in India if there is no change in ARDT in Sweden?
(5) cannot be determined
(CAT 2008 )
Answer: Option 4 Option 5 Option 3
Q1: We need to find Max Aggregate marks of Aditya and our Clue is that he didnt get ANY call. Means he should not clear the cutoff of one/more section or the aggregate cutoff or both.. Now the trick is that no college has cutoff for the all the sections. Means if Aditya missed only one sectional cutoff he can still get some calls.. say Aditya scored less in Section A, he may still get calls from College 2,3 and 6 as they are not considering Section A cutoff. So in order to ensure that he is not getting any calls he need to miss the cut off of two section..now million $ question.. which two sections ? :)
See the table and check for two sections so that at least one is always present in the selection criteria of any college we choose.
A & B - Not an option as College 3 is not interested in both
A & C - Nopes.. as College 6 is not interested in both..
similarly quickly check for other pairs.. its easy.. visual inspection will suffice :)
we can get that Section C & D are the only two sections which satisfies the condition. Every college is interested in either C or D.
So coming back to our question to miss all the calls Aditya has two options
- miss the aggregate cutoff of all colleges - he can score 170 as the least aggregate cutoff is 171 for college 3.
- miss the cut off of C and D - In this case he can score 41 in C and 43 in D ( as least cutoff for Section C is 42 for College 1 and for section D least cutoff score is 44 for College 6). Now remember we need max score. so he is free to score full marks in other two sections (A & B).
so this case he can score a max aggregate of 50 + 50 + 41 + 43 = 184
Q2: We need to find the min score of bhama and clue is that she got calls from all the colleges. Means she should clear all sectional cutoffs and the aggregate cutoff.
She should score min 180 as that is the highest cutoff for college5. Otherwise she wont get call from there.
Now she should score at least the highest sectional cutoff for each sections to get calls from all colleges. She should score min 45 in section A (Otherwise no calls from College5), 45 in Section B (Otherwise no calls from College2), 46 in SectionC (otherwise no calls from College3) and 45 in sectionD (otherwise no calls from College4).
so she should score min 45 + 45 + 46 + 45 = 181 ( easy to solve as 45 * 4 + 1)
now this is already higher than the min aggregate cutoff so bhama should score min of 181 to get calls from all colleges.
Q3. we need to find the min score of charlie in a section. clue is he got only 2 calls.
to score min in a section charlie should score maximum in other sections. we can solve this question through options. As we need the min marks we will start with the option with least value. and good thing is options are already in ascending order.. :)
Option 1 - 0: not possible. if charlie score 0 in a section he can score max aggregate of 150 only (50+50+50) wont get call from any college.
Option 2 - 21: Charlie can score max of 171 ( 21 + 50 + 50 + 50 ). can get call from only one college. (college3)
Option 3 - 25: He can score max 175 (25 + 50 + 50 + 50). can get call from only 2 colleges (College 2 & 3). College 2 and 3 are not interested in cutoffs of section A and D. so charlie is free to score 25 in Section A or D !!!
our answer is option 3 :)
zabeer last edited by zabeer
for 2007 : 500
for 2006 : 380
for 2005 : 270
for 2004 : 180
Growth rate for the period 2006-2007 : ( 500 - 380 ) / 380 = 120/380 = 6/19
Growth rate for the period 2004-2005 : ( 270 - 180 ) / 180 = 90/180 = 1/2
% change = [( 1/2 - 6/19 ) / 1/2] * 100
~ ( 1 - 2/3 ) * 100 ~ 33.33
Safe to go with Option 3
for 2008 = 610
we already know the growth rate for 2006-2007 from Q1 ( 6/19)
so if we use this growth rate to calculate 2008 subscriptions,
500 ( 1 + 6/19) > 500 + 150 > 650. difference is greater than 40 ( 650 - 610 )
Will go with Option 1
we have 100 subscribers for 2003.
we have 60 men and 40 women
2010 we will have 60 * (1.05)7 men and 40 * (1.1)7 women
using binomial series, ( 1 + n )x = 1 + nx + n (n - 1 )/2! x2 + ...
60 * (1.05)7 ~ 60 * ( 1 + 0.35 + 0.05 + ... ) ~ 84
40 * (1.1)7 ~ 40 * ( 1 + 0.7 + 0.21 + ... ) ~ 76
total number of subscribers by 2010 = 84 + 76 = 160
% growth = (160 - 100) / 100 = 60
actual value will be little greater than 60 as we avoided the terms from x3 in binomial series.
Option 1, 62%
This one we will solve visually. We are asked to find the year in which the absolute value for annual percent change in the gap between subscription revenues in the US and Europe. We need to find the year where the the height difference between black and white bars increased/decreased (as we are taking absolute) the most.
for 2003 we can see the difference between white/black bars are 3 blocks and for 2004 it is 3.5 blocks. given below is a rough diagram plotting all the values ( interms of blocks.. dont go and find the values.. its a trap :D ). We can see that max difference ( in terms of % ) happened during 2008 - 2009 ( 1.75 -> 1.25 ). Hence Answer d
The person who joined finance from marketing is 20 years elder to the person who joined marketing from finance. ( As the average age increased by 1 for 20 people ). Avg age of marketing department remains the same. Marketing dept's net loss is one person so there should be a total reduction of 35 years. 20 years Marketing department "lost" to fin. which means the guy who moved to HR is 15 years old. so HR dept's ( now 5 + 1 ) avg age = ( 45 * 5 + 15 ) / 6 = 40 years.
HR dept's avg age is 45 and marketing dept's avg age is 35. Transfer from lower avg age to higher avg age means 10% additional allowance of basic pay.
Guy from marketing has an allowance of 80% of 8000 = 6400,
new allowance = 6400 * ( 1 + 10/100) = 7040
new gross pay of the transferred person = 8000 + 7040 = 15040
initial avg gross pay of HR = 5000 + 70/100 * 5000 = 8500
new avg gross pay of HR (after transfer) = ( 8500 * 5 + 15040 ) / 6 = 9590
% change = (9590 - 8500)/8500 ~ 13
new avg basic pay after the transfer,
(5 * 5000 + 2 * 6000 + 8000)/8 = 5625
% change = (5625 - 5000/5000) * 100 = 12.5%
share price is rising through out, so abdul will make the max returns as he buys @ the least price and sells @ max price.
Let's say share price was as below for various time slots
Bikram brought say 20 shares in all slots.
So he spent 100 + 200 + 400 + 500 + 1000 = 2200 rupees
he recieved 5000 rupees @ 3 PM
Chetan brought shares for say 100 rs in all slots.
so he spent 500 rupees.
Total shares he bought = 100/5 + 100/10 + 100/20 + 100/25 + 100/50 = 41
he recieved 41 * 50 = 2050 rupees.
Chetan's returns is higher than Bikram's. So Bikram got the minimum returns.
Question 2 :
Cannot say anything about Chetan and Bikram as their return depends on the variation of the price in each hour slot. Option 5
Question 3 :
On a day when the price starts @ peak and ends at the least, Abdul will have the minimum returns. So option 1 ruled out. Option 2 and Option 3 are not always true. if the share price doesn't change then all three of them can have the same returns. Option 4 is also not always true as if the least price happens to be @ 11 AM and then rises to max @ 3PM Chetan can have better returns than Abdul. so none of the given options are always true.
Question 4 :
Abdul lost money => [email protected] > [email protected]
[email protected] > [email protected] (given)
[email protected] < [email protected] (given)
Emiley made profit
=> [email protected] > [email protected]
[email protected] < [email protected]
Dane made profit
=> [email protected] + [email protected] + [email protected] < [email protected] + [email protected] + [email protected]
=> [email protected] < [email protected] ( [email protected] > [email protected] & [email protected] > [email protected] )
we will try to list the price in decreasing order
Question 5 :
From the order we got above [email protected] is the highest, hence Option 1
( % revenue from data transfer/100 ) = X
ARDT = Y
Question 1 :
X * total revenue = Y * volume
as total revenue is same volume = X / Y
we need to find countries with same volume. if X/Y = const then the plot will be a straight line passing through the origin. so in this case we are looking for pair of countries that will fall in the line that can pass through the origin, only pair that can form the line passing through origin is UK and Spain.
Question 2 :
X * total revenue = Y * volume
total revenue = Y * volume / X
as volume is same, the ratio of total revenues of India and singapore will be
(totat revenue - India)/(total revenue singapore) = (Y/X) - India / (Y/X)-Singapore
(Y/X) - India = 1/9
(Y/X)-Singapore = 9/20
(totat revenue - India)/(total revenue singapore) = (1/9)/(9/20) = 20/81 ~ 1/4
(total revenue singapore) = 4 * (totat revenue - India)
Question 3 :
27 * 2R = ARDT (India) * V
36 * R = 6 * V
ARDT(India) = (27 * 2 * 6) / 36 = 27/3 = 9
Current value of ARDT(India) = 1
so % change = [ ( 9 - 1 ) / 1 ] * 100 = 800%