Data Interpretation – XYZ organization got into the business of delivering
XYZ organization got into the business of delivering groceries to home at the beginning of the last month. They have a two-day delivery promise. However, their deliveries are unreliable. An order booked on a particular day may be delivered the next day or the day after. If the order is not delivered at the end of two days, then the order is declared as lost at the end of the second day. XYZ then does not deliver the order, but informs the customer, marks the order as lost, returns the payment and pays a penalty for non-delivery. The following table provides details about the operations of XYZ for a week of the last month. The first column gives the date, the second gives the cumulative number of orders that were booked up to and including that day. The third column represents the number of orders delivered on that day. The last column gives the cumulative number of orders that were lost up to and including that day.
It is known that the numbers of orders that were booked on the 11th, 12th, and 13th of the last month that took two days to deliver were 4, 6, and 8 respectively.
Q.1 Among the following days, the largest fraction of orders booked on which day was lost?
- 13th
- 15th
- 16th
- 14th
Answer: 2
Q.2 On which of the following days was the number of orders booked the highest?
- 14th
- 15th
- 12th
- 13th
Answer: 4
Q.3 The delivery ratio for a given day is defined as the ratio of the number of orders booked on that day which are delivered on the next day to the number of orders booked on that day which are delivered on the second day after booking. On which of the following days, was the delivery ratio the highest?
- 15th
- 14th
- 16th
- 13th
Answer: 2
Q.4 The average time taken to deliver orders booked on a particular day is computed as follows. Let the number of orders delivered the next day be x and the number of orders delivered the day after be y. Then the average time to deliver order is (x+2y)/(x+y). On which of the following days was the average time taken to deliver orders booked the least?
- 14th
- 13th
- 15th
- 16th
Answer: 1
Solutions:
From the given table we can easily find the order that took two days to deliver.
For any day ordered book = cumulative order booked on that day – cumulative order booked on previous day
Ordered that took two days to deliver = order booked on any day – Orders delivered on next day – order lost
Now as the order lost was declared on 2nd day so we can say that the order lost for nth day booking will be equal to the number of ordered lost on (n+2)th day
So we can make the following table:
| Day | Cumulative orders booked | Order on that day | Orders delivered on day | Cumulative orders lost | Order lost on that day | Order lost on of that day booking | Order delivered on 2nd day | Order delivered on the next day (1st day) of booking |
| 11th | 4 | |||||||
| 12th | 6 | 11 – 4 = 7 | ||||||
| 13th | 219 | 11 | 91 | 2 | 8 | 27- 6 =21 | ||
| 14th | 249 | 249 – 219 = 30 | 27 | 92 | 92 – 91 = 1 | 12 | 23 – 8 = 15 | |
| 15th | 277 | 277 – 249 = 28 | 23 | 94 | 94 – 92 =2 | 12 | ||
| 16th | 302 | 302 – 277 = 25 | 11 | 106 | 106 – 94 = 12 | 2 | ||
| 17th | 327 | 327 – 302 = 25 | 21 | 118 | 118 – 106 = 12 | 9 | ||
| 18th | 332 | 332 – 327 = 5 | 13 | 120 | 120 – 118 = 2 | |||
| 19th | 337 | 337 – 332 = 5 | 14 | 129 | 129 – 120 = 9 |
From the table we can say ordered booked on 13th = 2+8+21 = 31
Q.1 From the given table we can easily find the order that took two days to deliver.
For any day ordered book = cumulative order booked on that day – cumulative order booked on previous day Ordered that took two days to deliver = order booked on any day – Orders delivered on next day – order lost Now as the order lost was declared on 2nd day so we can say that the order lost for nth day booking will be equal to the number of ordered lost on (n+2)th day
So we can make the following table:
| Day | Cumulative orders booked | Order on that day | Orders delivered on day | Cumulative orders lost | Order lost on that day | Order lost on of that day booking | Order delivered on 2nd day | Order delivered on the next day (1st day) of booking |
| 11th | 4 | |||||||
| 12th | 6 | 11 – 4 = 7 | ||||||
| 13th | 219 | 11 | 91 | 2 | 8 | 27- 6 =21 | ||
| 14th | 249 | 249 – 219 = 30 | 27 | 92 | 92 – 91 = 1 | 12 | 23 – 8 = 15 | |
| 15th | 277 | 277 – 249 = 28 | 23 | 94 | 94 – 92 =2 | 12 | ||
| 16th | 302 | 302 – 277 = 25 | 11 | 106 | 106 – 94 = 12 | 2 | ||
| 17th | 327 | 327 – 302 = 25 | 21 | 118 | 118 – 106 = 12 | 9 | ||
| 18th | 332 | 332 – 327 = 5 | 13 | 120 | 120 – 118 = 2 | |||
| 19th | 337 | 337 – 332 = 5 | 14 | 129 | 129 – 120 = 9 |
From the table we can say ordered booked on 13th = 2+8+21 = 31
Fraction of order lost over order booked on that day :
On 13th = 2/31
On 14th = 12/30
On 15th = 12/28
On 16th = 2/25
Clearly largest fraction of order lost is 12/28 on 13th day.
Q.2 From the given table we can easily find the order that took two days to deliver.
For any day ordered book = cumulative order booked on that day – cumulative order booked on previous day
Ordered that took two days to deliver = order booked on any day – Orders delivered on next day – order lost
Now as the order lost was declared on 2nd day so we can say that the order lost for nth day booking will be equal to the number of ordered lost on (n+2)th day
So we can make the following table:
| Day | Cumulative orders booked | Order on that day | Orders delivered on day | Cumulative orders lost | Order lost on that day | Order lost on of that day booking | Order delivered on 2nd day | Order delivered on the next day (1st day) of booking |
| 11th | 4 | |||||||
| 12th | 6 | 11 – 4 = 7 | ||||||
| 13th | 219 | 11 | 91 | 2 | 8 | 27- 6 =21 | ||
| 14th | 249 | 249 – 219 = 30 | 27 | 92 | 92 – 91 = 1 | 12 | 23 – 8 = 15 | |
| 15th | 277 | 277 – 249 = 28 | 23 | 94 | 94 – 92 =2 | 12 | ||
| 16th | 302 | 302 – 277 = 25 | 11 | 106 | 106 – 94 = 12 | 2 | ||
| 17th | 327 | 327 – 302 = 25 | 21 | 118 | 118 – 106 = 12 | 9 | ||
| 18th | 332 | 332 – 327 = 5 | 13 | 120 | 120 – 118 = 2 | |||
| 19th | 337 | 337 – 332 = 5 | 14 | 129 | 129 – 120 = 9 |
From the table we can say ordered booked on 13th = 2+8+21 = 31
Thus we can among the given days , maximum number of order were booked on 13th.
Q.3 From the given table we can easily find the order that took two days to deliver.
For any day ordered book = cumulative order booked on that day – cumulative order booked on previous day
Ordered that took two days to deliver = order booked on any day – Orders delivered on next day – order lost
Now as the order lost was declared on 2nd day so we can say that the order lost for nth day booking will be equal to the number of ordered lost on (n+2)th day
So we can make the following table:
| Day | Cumulative orders booked | Order on that day | Orders delivered on day | Cumulative orders lost | Order lost on that day | Order lost on of that day booking | Order delivered on 2nd day | Order delivered on the next day (1st day) of booking |
| 11th | 4 | |||||||
| 12th | 6 | 11 – 4 = 7 | ||||||
| 13th | 219 | 11 | 91 | 2 | 8 | 27- 6 =21 | ||
| 14th | 249 | 249 – 219 = 30 | 27 | 92 | 92 – 91 = 1 | 12 | 23 – 8 = 15 | |
| 15th | 277 | 277 – 249 = 28 | 23 | 94 | 94 – 92 =2 | 12 | ||
| 16th | 302 | 302 – 277 = 25 | 11 | 106 | 106 – 94 = 12 | 2 | ||
| 17th | 327 | 327 – 302 = 25 | 21 | 118 | 118 – 106 = 12 | 9 | ||
| 18th | 332 | 332 – 327 = 5 | 13 | 120 | 120 – 118 = 2 | |||
| 19th | 337 | 337 – 332 = 5 | 14 | 129 | 129 – 120 = 9 |
From the table we can say ordered booked on 13th = 2+8+21 = 31
Now for 14th -: order delivered on 2nd day = 30 – 15 – 12 = 3
For 15th :Order delivered on next day = order delivered on 16th – order delivered on 2nd day for 14th = 11– 3 =8
Now for 15th -: order delivered on 2nd day = 28 – 8 -12 = 8
For 16th :Order delivered on next day = order delivered on 17th – order delivered on 2nd day for 15th = 21– 8 =12
Now for 16th -: order delivered on 2nd day = 25 – 12 – 2 = 9
So The table will now look like :-
| Day | Cumulative orders booked | Order on that day | Orders delivered on day | Cumulative orders lost | Order lost on that day | Order lost on of that day booking | Order delivered on 2nd day | Order delivered on the next day (1st day) of booking |
| 11th | 4 | |||||||
| 12th | 6 | 11 – 4 = 7 | ||||||
| 13th | 219 | 11 | 91 | 2 | 8 | 27- 6 =21 | ||
| 14th | 249 | 249 – 219 = 30 | 27 | 92 | 92 – 91 = 1 | 12 | 3 | 23 – 8 = 15 |
| 15th | 277 | 277 – 249 = 28 | 23 | 94 | 94 – 92 =2 | 12 | 8 | 8 |
| 16th | 302 | 302 – 277 = 25 | 11 | 106 | 106 – 94 = 12 | 2 | 12 | 11 |
| 17th | 327 | 327 – 302 = 25 | 21 | 118 | 118 – 106 = 12 | 9 | ||
| 18th | 332 | 332 – 327 = 5 | 13 | 120 | 120 – 118 = 2 | |||
| 19th | 337 | 337 – 332 = 5 | 14 | 129 | 129 – 120 = 9 |
So delivery ratio on 13th =21/8= 2.625
delivery ratio on 14th = 15/3 = 5
delivery ratio on 15th = 8/8 =1
delivery ratio on 16th = 11/12
Thus we can see delivery ratio was highest on 14th.
Q.4 From the given table we can easily find the order that took two days to deliver.
For any day ordered book = cumulative order booked on that day – cumulative order booked on previous day
Ordered that took two days to deliver = order booked on any day – Orders delivered on next day – order lost
Now as the order lost was declared on 2nd day so we can say that the order lost for nth day booking will be equal to the number of ordered lost on (n+2)th day
So we can make the following table:
| Day | Cumulative orders booked | Order on that day | Orders delivered on day | Cumulative orders lost | Order lost on that day | Order lost on of that day booking | Order delivered on 2nd day | Order delivered on the next day (1st day) of booking |
| 11th | 4 | |||||||
| 12th | 6 | 11 – 4 = 7 | ||||||
| 13th | 219 | 11 | 91 | 2 | 8 | 27- 6 =21 | ||
| 14th | 249 | 249 – 219 = 30 | 27 | 92 | 92 – 91 = 1 | 12 | 23 – 8 = 15 | |
| 15th | 277 | 277 – 249 = 28 | 23 | 94 | 94 – 92 =2 | 12 | ||
| 16th | 302 | 302 – 277 = 25 | 11 | 106 | 106 – 94 = 12 | 2 | ||
| 17th | 327 | 327 – 302 = 25 | 21 | 118 | 118 – 106 = 12 | 9 | ||
| 18th | 332 | 332 – 327 = 5 | 13 | 120 | 120 – 118 = 2 | |||
| 19th | 337 | 337 – 332 = 5 | 14 | 129 | 129 – 120 = 9 |
From the table we can say ordered booked on 13th = 2+8+21 = 31
Now for 14th -: order delivered on 2nd day = 30 – 15 – 12 = 3
For 15th :Order delivered on next day = order delivered on 16th – order delivered on 2nd day for 14th = 11– 3 =8
Now for 15th -: order delivered on 2nd day = 28 – 8 -12 = 8
For 16th :Order delivered on next day = order delivered on 17th – order delivered on 2nd day for 15th = 21– 8 =12
Now for 16th -: order delivered on 2nd day = 25 – 12 – 2 = 9
So The table will now look like :-
| Day | Cumulative orders booked | Order on that day | Orders delivered on day | Cumulative orders lost | Order lost on that day | Order lost on of that day booking | Order delivered on 2nd day | Order delivered on the next day (1st day) of booking |
| 11th | 4 | |||||||
| 12th | 6 | 11 – 4 = 7 | ||||||
| 13th | 219 | 11 | 91 | 2 | 8 | 27- 6 =21 | ||
| 14th | 249 | 249 – 219 = 30 | 27 | 92 | 92 – 91 = 1 | 12 | 3 | 23 – 8 = 15 |
| 15th | 277 | 277 – 249 = 28 | 23 | 94 | 94 – 92 =2 | 12 | 8 | 8 |
| 16th | 302 | 302 – 277 = 25 | 11 | 106 | 106 – 94 = 12 | 2 | 12 | 11 |
| 17th | 327 | 327 – 302 = 25 | 21 | 118 | 118 – 106 = 12 | 9 | ||
| 18th | 332 | 332 – 327 = 5 | 13 | 120 | 120 – 118 = 2 | |||
| 19th | 337 | 337 – 332 = 5 | 14 | 129 | 129 – 120 = 9 |
Average time taken to deliver on 13th = (21+2*8)/29 = 37/29
Average time taken to deliver on 14th = (15+2*3)/(15+3) = 21/18 < 37/29
Average time taken to deliver on 15th = (8+2*8)/(8+8) = 3/2
Average time taken to deliver on 16th = (11+2*12)/(11+12) = 35/23 >3/2
Thus we can see the average time taken to deliver a order was least on 14th.
Online Coaching Course for CAT 2021 + Test Series
a) 1000+ Videos covering entire CAT syllabus
b) 2 Live Classes (online) every week for doubt clarification
c) Study Material & PDFs for practice and understanding
d) 10 Mock Tests in the latest pattern
e) Previous Year Questions solved on video