CAT DI Data Change Over Period Questions & Solutions

A sample of real CAT DI Data Change Over Period past-year questions, each with a worked solution and the correct answer highlighted. AthenaPrep has 75 DI Data Change Over Period questions in all — sign up free to practise them timed.

Passage

The horizontal bars in the above diagram represent 2020 aggregate sales (in ₹ million) of a company for the different subcategories of its products. The top four product subcategories (Bookcases, Chairs, Furnishings, Tables) belong to furniture product category; the bottom four product subcategories (Accessories, Copiers, Machines, Phones) belong to the technology product category while all other product subcategories belong to the office supply product category. For each of the product subcategories, there is a vertical line indicating the sales of the corresponding subcategory in 2019.
Q1.CAT 2021
The total sales (in ₹ million) in 2019 from products in office supplies category is closest to
- 18.0
- 16.5
- 13.5
- 12.5
Show solution
The total sales from products in the office supply category in 2019 is :

Sum of sales of :

Binders: 3.6 million

Art : 0.4 million.

Appliances: 1.9 million

Envelops: 0.3 million

Fasteners: 0.1 million

Labels: 0.2 million

Paper = 1.5 million.

Storage: 4.3 million.

Supplies: 1.1 million.

The sum of sales of these products = 3.6+0.4+1.9+0.3+0.1+0.2+1.5+4.3+1.1 = 13.4 million.

The closest among the option is 13.5 million.
Passage
There are 21 employees working in a division, out of whom 10 are special-skilled employees (SE) and the remaining are regular-skilled employees (RE). During the next five months, the division has to complete five projects every month. Out of the 25 projects, 5 projects are "challenging", while the remaining ones are "standard". Each of the challenging projects has to be completed in different months. Every month, five teams — T1 T2, T3, T4 and T5, work on one project each. T1, T2, T3, T4 and T5 are allotted the challenging project in the first, second, third, fourth and fifth month, respectively. The team assigned the challenging project has one more employee than the rest.
In the first month, T1 has one more SE than T2, T2 has one more SE than T3, T 3 has one more SE than T4, and T4 has one more SE than T5. Between two successive months, the composition of the teams changes as follows:
a. The team allotted the challenging project, gets two SE from the team which was allotted the challenging project in the previous month. In exchange, one RE is shifted from the former team to the latter team.
b. After the above exchange, if T1 has any SE and T5 has any RE, then one SE is shifted from T1 to T5, and one RE is shifted from T5 to T1. Also, if T2 has any SE and T4 has any RE, then one SE is shifted from T2 to T4, and one RE is shifted from T4 to T2.
Each standard project has a total of 100 credit points, while each challenging project has 200 credit points. The credit points are equally shared between the employees included in that team.
Q2.CAT 2017
Which of the following CANNOT be the total credit points earned by any employee from the projects?
- 140
- 150
- 170
- 200
Show solution
When challenging project is given, each employee gets 40 points.

When standard project is given, each employee gets 25 points.

Suppose:

If a particular employee is involved in all standard projects then his credit points will be: 125

If a particular employee is involved in 4 standard projects and 1 challenging project then his credit points will be: 140

If a particular employee is involved in 3 standard projects and 2 challenging projects then his credit points will be: 155

If a particular employee is involved in 2 standard projects and 3 challenging projects then his credit points will be: 170

If a particular employee is involved in 1 standard project and 4 challenging projects then his credit points will be: 185

If a particular employee is all challenging projects then his credit points will be: 200

Hence, an employee cannot earn 150 points.
Passage
DIRECTIONS for the following three questions: Answer the questions on the basis of the information given below.

One of the functions of the Reserve Bank of India is to mobilize funds for the Government of India by issuing securities. The following table shows details of funds mobilized during the period July 2002 - July 2003. Notice that on each date there were two rounds of issues, each with a different maturity.
Q3.CAT 2003
How many times was the issue of securities under-subscribed, i.e., how often did the total amount mobilized fall short of the amount notified?
- 0
- 1
- 2
- 3
Show solution
Only one security issued in 17 July 2002 was undersuscribed.
Passage
The following table shows the revenue and expenses in millions of Euros (European currency) associated with REPSOL YPF company’s oil and gas producing activities in operations in different parts of the world for 1998-2000.

Q4.CAT 2002
How many operations (Spain, North Africa and Middle East,..) of the company accounted for less than 5% of the total revenue earned in 1999?
- 2
- 3
- 4
- None of these
Show solution
5% of total revenue in the year 1999 is 168.7 . Manually counting number of countries where the revenue is less than 168.7, we see that 4 countries have revenue less than 168.7
Q5.CAT 2002
Of the following statements, which one is not true?
- The operations in Spain had the best efficiency in 2000
- The Far East operations witnessed an efficiency improvement from 1999 to 2000
- The North Sea operations witnessed an efficiency improvement from 1998 to 1999
- In 1998, the operations in Rest of Latin America were the least efficient
Show solution
In 1998, the efficiency in Rest of Latin America was $\frac{34}{57}$ .

In 1998, the efficiency in Rest of the world was $\frac{5}{15}$ , which is less than $\frac{34}{57}$ .

Hence, the efficiency of rest of latin america was not the least.
Passage
Directions for the next 5 questions: Answer the questions with reference to the table given below: Information Technology Industry in India (Figures are in million US dollars)

Q6.CAT 2000
The total annual exports lay between 35 and 40 percent of the total annual business of the IT industry, in the years:
- 1997-98 & 1994-95
- 1996-97 & 1997-98
- 1996-97& 1998-99
- 1996-97& 1994-95
Show solution
Total annual exports lay of the total annual business of the IT industry in 96-97 can be given as 1383/3807 = 0.36= 36% also total annual exports layof the total annual business of the IT industry in 97-98 can be given as 1970/5031 = 0.39 = 39%. Hence option b.
Passage
The table given below gives the annual details of loans from rural banks and agricultural loans over the years 1970 to 1983. Using this data answer the questions that follow.

Q7.CAT 1997
From the given data, the number of rural loans up to 1980 formed approximately what percentage of those in 1983?
- 112%
- 80%
- 97%
- Cannot be determined
Show solution
Number of loans in 1970 = 90*28 = 2520

Number of loans in 1971 = 115*39 = 4485

Number of loans in 1972 = 130*52 = 6760

Number of loans in 1974 = 260*98 = 25480

Number of loans in 1975 = 318*121 = 38478

Number of loans in 1980 = 605*288 = 174240

Sum of these loans = 251963

Number of loans in 1983 = 840*380 = 319200

Ratio = $\frac{251963}{319200}$ = 80% approximately.
Q8.CAT 1997
If the consumer price index for 1970 is to be taken as 105 and the indices for the subsequent years are to be corrected accordingly, what is the approximate value of the agricultural loans in 1980 at 1983 prices?
- Rs. 570 million
- Rs. 680 million
- Rs. 525 million
- Rs. 440 million
Show solution
Since the consumer price indices for all years change, the ratios will remain the same as before.
Value of the agricultural loans in 1980 at 1983 prices = 498.4 * 149 / 131 = 570 approx.
Passage
The following table gives the tariff [in paise per kilo-watt-hour (kWh)] levied by the UPSEB in 1994-95, in four sectors and the regions within them. The table also gives the percentage change in the tariff as compared to 1991-92.

Q9.CAT 1997
What was the approximate average tariff in sector 3 in 1991-92?
- 407
- 420
- 429
- None of these
Show solution
Average tariff in sector 3= (428/1.08 + 478/.96 + 432/1.06 + 441/1.1 + 439/1.08)/5 = 421.8 ~ 420
Passage
Answer the questions based on the following information. The amount of money invested (rupees in crores) in the core infrastructure areas of two districts, Chittoor and Khammam, Andhra Pradesh, is as follows.

Q10.CAT 1996
In Khammam district, the investment in which area in 1996 showed the highest percentage increase over the investment in that area in 1995?
- Electricity
- Chemical
- Solar
- Nuclear
Show solution
In Electricity, the increase in investment is 300, which is less that 15%.

In Chemical, the increase is 241.1, which is greater than 32%.

In Thermal, there was a decrease in investment.

In Solar, the increase is 428.6, which is less than 32%.

In Nuclear, the increase in investment is 507.8, which is less than 31%.

Hence, the investment is the highest in chemical core area.
Passage
Direction for questions: Answer the questions based on the following information. The data given in the table shows the investment details in country ‘Fortune Land’ of companies A, B, C, D, E and F. Figures in the table are in US dollars in billions.

Q11.CAT 1996
For which company is investment not increased from year 1 to year 3?
- C
- D
- F
- None of these
Show solution
Investment has increased for all the companies.
Passage
The following table gives the national income and the population of a country for the years 1984 – 85 to 1989 – 90. For each of the following questions choose the best alternative:

Q12.CAT 1991
Increase in the per capita income compared to the previous year among the years given below was highest for the year:
- 1985-86
- 1986-87
- 1987-88
- 1988-89
Show solution
The per capita of each of the following years is given below.
1984-85 is Rs. 3,098
1985-86 is Rs. 3,482 (increased by Rs. 384)
1986-87 is Rs. 3,786 (increased by Rs. 304)
1987-88 is Rs. 4,203 (increased by Rs. 416)
1988-89 is Rs. 4,857 (increased by Rs. 653)
1989-90 is Rs. 5,339 (increased by Rs. 481)

Hence, the increase is highest for the year 1988-89

63+ more DI Data Change Over Period questions inside

Get the full CAT DI Data Change Over Period set with timed practice, bookmarks and analysis — free to start.

Start practising free

CAT DI Data Change Over Period previous year questions with solutions — AthenaPrep

CAT DI Data Change Over Period Questions & Solutions

Passage

The horizontal bars in the above diagram represent 2020 aggregate sales (in ₹ million) of a company for the different subcategories of its products. The top four product subcategories (Bookcases, Chairs, Furnishings, Tables) belong to furniture product category; the bottom four product subcategories (Accessories, Copiers, Machines, Phones) belong to the technology product category while all other product subcategories belong to the office supply product category. For each of the product subcategories, there is a vertical line indicating the sales of the corresponding subcategory in 2019.

Q1.CAT 2021

The total sales (in ₹ million) in 2019 from products in office supplies category is closest to

18.0
16.5
13.5
12.5

Show solution

The total sales from products in the office supply category in 2019 is :

Sum of sales of :

Binders: 3.6 million

Art : 0.4 million.

Appliances: 1.9 million

Envelops: 0.3 million

Fasteners: 0.1 million

Labels: 0.2 million

Paper = 1.5 million.

Storage: 4.3 million.

Supplies: 1.1 million.

The sum of sales of these products = 3.6+0.4+1.9+0.3+0.1+0.2+1.5+4.3+1.1 = 13.4 million.

The closest among the option is 13.5 million.

Passage

There are 21 employees working in a division, out of whom 10 are special-skilled employees (SE) and the remaining are regular-skilled employees (RE). During the next five months, the division has to complete five projects every month. Out of the 25 projects, 5 projects are "challenging", while the remaining ones are "standard". Each of the challenging projects has to be completed in different months. Every month, five teams — T1 T2, T3, T4 and T5, work on one project each. T1, T2, T3, T4 and T5 are allotted the challenging project in the first, second, third, fourth and fifth month, respectively. The team assigned the challenging project has one more employee than the rest.
In the first month, T1 has one more SE than T2, T2 has one more SE than T3, T 3 has one more SE than T4, and T4 has one more SE than T5. Between two successive months, the composition of the teams changes as follows:
a. The team allotted the challenging project, gets two SE from the team which was allotted the challenging project in the previous month. In exchange, one RE is shifted from the former team to the latter team.
b. After the above exchange, if T1 has any SE and T5 has any RE, then one SE is shifted from T1 to T5, and one RE is shifted from T5 to T1. Also, if T2 has any SE and T4 has any RE, then one SE is shifted from T2 to T4, and one RE is shifted from T4 to T2.
Each standard project has a total of 100 credit points, while each challenging project has 200 credit points. The credit points are equally shared between the employees included in that team.

Q2.CAT 2017

Which of the following CANNOT be the total credit points earned by any employee from the projects?

Show solution

When challenging project is given, each employee gets 40 points.

When standard project is given, each employee gets 25 points.

Suppose:

If a particular employee is involved in all standard projects then his credit points will be: 125

If a particular employee is involved in 4 standard projects and 1 challenging project then his credit points will be: 140

If a particular employee is involved in 3 standard projects and 2 challenging projects then his credit points will be: 155

If a particular employee is involved in 2 standard projects and 3 challenging projects then his credit points will be: 170

If a particular employee is involved in 1 standard project and 4 challenging projects then his credit points will be: 185

If a particular employee is all challenging projects then his credit points will be: 200

Hence, an employee cannot earn 150 points.

Passage

DIRECTIONS for the following three questions: Answer the questions on the basis of the information given below.

One of the functions of the Reserve Bank of India is to mobilize funds for the Government of India by issuing securities. The following table shows details of funds mobilized during the period July 2002 - July 2003. Notice that on each date there were two rounds of issues, each with a different maturity.

Q3.CAT 2003

How many times was the issue of securities under-subscribed, i.e., how often did the total amount mobilized fall short of the amount notified?

Show solution

Only one security issued in 17 July 2002 was undersuscribed.

Passage

The following table shows the revenue and expenses in millions of Euros (European currency) associated with REPSOL YPF company’s oil and gas producing activities in operations in different parts of the world for 1998-2000.

Q4.CAT 2002

How many operations (Spain, North Africa and Middle East,..) of the company accounted for less than 5% of the total revenue earned in 1999?

2
3
4
None of these

Show solution

5% of total revenue in the year 1999 is 168.7 . Manually counting number of countries where the revenue is less than 168.7, we see that 4 countries have revenue less than 168.7

Q5.CAT 2002

Of the following statements, which one is not true?

The operations in Spain had the best efficiency in 2000
The Far East operations witnessed an efficiency improvement from 1999 to 2000
The North Sea operations witnessed an efficiency improvement from 1998 to 1999
In 1998, the operations in Rest of Latin America were the least efficient

Show solution

In 1998, the efficiency in Rest of Latin America was $\frac{34}{57}$ .

In 1998, the efficiency in Rest of the world was $\frac{5}{15}$ , which is less than $\frac{34}{57}$ .

Hence, the efficiency of rest of latin america was not the least.

Passage

Directions for the next 5 questions: Answer the questions with reference to the table given below: Information Technology Industry in India (Figures are in million US dollars)

Q6.CAT 2000

The total annual exports lay between 35 and 40 percent of the total annual business of the IT industry, in the years:

1997-98 & 1994-95
1996-97 & 1997-98
1996-97& 1998-99
1996-97& 1994-95

Show solution

Total annual exports lay of the total annual business of the IT industry in 96-97 can be given as 1383/3807 = 0.36= 36% also total annual exports layof the total annual business of the IT industry in 97-98 can be given as 1970/5031 = 0.39 = 39%. Hence option b.

Passage

The table given below gives the annual details of loans from rural banks and agricultural loans over the years 1970 to 1983. Using this data answer the questions that follow.

Q7.CAT 1997

From the given data, the number of rural loans up to 1980 formed approximately what percentage of those in 1983?

112%
80%
97%
Cannot be determined

Show solution

Number of loans in 1970 = 90*28 = 2520

Number of loans in 1971 = 115*39 = 4485

Number of loans in 1972 = 130*52 = 6760

Number of loans in 1974 = 260*98 = 25480

Number of loans in 1975 = 318*121 = 38478

Number of loans in 1980 = 605*288 = 174240

Sum of these loans = 251963

Number of loans in 1983 = 840*380 = 319200

Ratio = $\frac{251963}{319200}$ = 80% approximately.

Q8.CAT 1997

If the consumer price index for 1970 is to be taken as 105 and the indices for the subsequent years are to be corrected accordingly, what is the approximate value of the agricultural loans in 1980 at 1983 prices?

Rs. 570 million
Rs. 680 million
Rs. 525 million
Rs. 440 million

Show solution

Since the consumer price indices for all years change, the ratios will remain the same as before.

Value of the agricultural loans in 1980 at 1983 prices = 498.4 * 149 / 131 = 570 approx.

Passage

The following table gives the tariff [in paise per kilo-watt-hour (kWh)] levied by the UPSEB in 1994-95, in four sectors and the regions within them. The table also gives the percentage change in the tariff as compared to 1991-92.

Q9.CAT 1997

What was the approximate average tariff in sector 3 in 1991-92?

407
420
429
None of these

Show solution

Average tariff in sector 3= (428/1.08 + 478/.96 + 432/1.06 + 441/1.1 + 439/1.08)/5 = 421.8 ~ 420

Passage

Answer the questions based on the following information. The amount of money invested (rupees in crores) in the core infrastructure areas of two districts, Chittoor and Khammam, Andhra Pradesh, is as follows.

Q10.CAT 1996

In Khammam district, the investment in which area in 1996 showed the highest percentage increase over the investment in that area in 1995?

Electricity
Chemical
Solar
Nuclear

Show solution

In Electricity, the increase in investment is 300, which is less that 15%.

In Chemical, the increase is 241.1, which is greater than 32%.

In Thermal, there was a decrease in investment.

In Solar, the increase is 428.6, which is less than 32%.

In Nuclear, the increase in investment is 507.8, which is less than 31%.

Hence, the investment is the highest in chemical core area.

Passage

Direction for questions: Answer the questions based on the following information. The data given in the table shows the investment details in country ‘Fortune Land’ of companies A, B, C, D, E and F. Figures in the table are in US dollars in billions.

Q11.CAT 1996

For which company is investment not increased from year 1 to year 3?

C
D
F
None of these

Show solution

Investment has increased for all the companies.

Passage

The following table gives the national income and the population of a country for the years 1984 – 85 to 1989 – 90. For each of the following questions choose the best alternative:

Q12.CAT 1991

Increase in the per capita income compared to the previous year among the years given below was highest for the year:

1985-86
1986-87
1987-88
1988-89

Show solution

The per capita of each of the following years is given below.

1984-85 is Rs. 3,098
1985-86 is Rs. 3,482 (increased by Rs. 384)
1986-87 is Rs. 3,786 (increased by Rs. 304)
1987-88 is Rs. 4,203 (increased by Rs. 416)
1988-89 is Rs. 4,857 (increased by Rs. 653)
1989-90 is Rs. 5,339 (increased by Rs. 481)

Hence, the increase is highest for the year 1988-89

63+ more DI Data Change Over Period questions inside

Get the full CAT DI Data Change Over Period set with timed practice, bookmarks and analysis — free to start.

Start practising free

CAT DI Data Change Over Period previous year questions with solutions — AthenaPrep