# XAT Data Interpretation Basics questions

## XAT 2016 Data Interpretation Basics questions

Instruction for set 1:

Study the data given in the table below and answer the question that follow:

All figures are in percentage
Based on survey of ‘shop types’ Kamath categorized Indian states into four geographical regions as shown in the table above. His boss felt that the categorization was inadequate since important labels were missing. Kamath argued that no further labels are required to interpret the data.

#### Question 1

A consultant observing the data made the following two inferences:
Inference I: The number of Grocers per-thousand-population is the highest in North India.
Inference II: The number of Cosmetic per-thousand-population is the highest in South India.

Which of following options is DEFINITELY correct?

Instruction for set 1:

Study the data given in the table below and answer the question that follow:

All figures are in percentage
Based on survey of ‘shop types’ Kamath categorized Indian states into four geographical regions as shown in the table above. His boss felt that the categorization was inadequate since important labels were missing. Kamath argued that no further labels are required to interpret the data.

#### Question 2

The average size of Food Shops in East India was twice that of Food Shops in West India. Which of the following cannot be inferred from the above data?

Instruction for set 1:

Study the data given in the table below and answer the question that follow:

All figures are in percentage
Based on survey of ‘shop types’ Kamath categorized Indian states into four geographical regions as shown in the table above. His boss felt that the categorization was inadequate since important labels were missing. Kamath argued that no further labels are required to interpret the data.

#### Question 3

Bala collected the same data five years after Kamath, using the same categorization.

Which of the following statements can DEFINITELY be concluded?

## XAT 2011 Data Interpretation Basics questions

Instruction for set 1:

answer questions based on the following information:

In the beginning of the year 2010, Mr. Sanyal had the option to invest Rs. 800000 in one or more of the following assets – gold, silver, US bonds, EU bonds, UK bonds and Japanese bonds. In order to invest in US bonds, one must first convert his investible fund into US Dollars at the ongoing exchange rate. Similarly, if one wants to invest in EU bonds or UK bonds or Japanese bonds one must first convert his investible fund into Euro, British Pounds and Japanese Yen respectively at the ongoing exchange rates. Transactions were allowed only in the beginning of every month. Bullion prices and exchange rates were fixed at the beginning of every
month and remained unchanged throughout the month. Refer to the table titled “Bullion Prices and Exchange Rates in 2010" for the relevant data.
Bullion Prices and Exchange Rates in 2010

Interest rates on US, EU, UK and Japanese bonds are 10%, 20%, 15% and 5% respectively.

#### Question 1

Mr. Sanyal adopted the following investment strategy. On lst January 2010 he invested half of his investible fund in gold and the other half he kept in fixed deposit of an Indian bank that offered 25% interest per annum. At the beginning of every quarter he liquefied his assets to create his investible fund for that quarter. Every quarter he invested half of his fund in the bullion that gave maximum return in the previous quarter and the other half in the foreign bond that gave maximum return in the previous quarter. However, if in any quarter none of the foreign bonds gave a better return than the fixed deposit of his Indian bank, he invested half of his investible fund in the fixed deposit for the next quarter. On 31st December 2010 Mr. Sanyal liquefied his assets and realized that all of the following options are true except:

Instruction for set 1:

answer questions based on the following information:

In the beginning of the year 2010, Mr. Sanyal had the option to invest Rs. 800000 in one or more of the following assets – gold, silver, US bonds, EU bonds, UK bonds and Japanese bonds. In order to invest in US bonds, one must first convert his investible fund into US Dollars at the ongoing exchange rate. Similarly, if one wants to invest in EU bonds or UK bonds or Japanese bonds one must first convert his investible fund into Euro, British Pounds and Japanese Yen respectively at the ongoing exchange rates. Transactions were allowed only in the beginning of every month. Bullion prices and exchange rates were fixed at the beginning of every
month and remained unchanged throughout the month. Refer to the table titled “Bullion Prices and Exchange Rates in 2010" for the relevant data.
Bullion Prices and Exchange Rates in 2010

Interest rates on US, EU, UK and Japanese bonds are 10%, 20%, 15% and 5% respectively.

#### Question 2

Advisors were asked to prepare an investment strategy that involved US Bonds, EU Bonds and Japanese Bonds, keeping at least 20% of the initial fund in each of these assets for the entire year, and allowing exactly four additional transactions in the course of the year. On 2nd January 2011, while comparing five different recommendations that he had received from his financial advisors in the beginning of 2010, Mr. Sanyal referred to the table “Bullion Prices and Exchange Rates in 20
10”. One transaction is defined as the buying or selling of an asset. Which of the recommendation out of the following was the best one?

Instruction for set 1:

answer questions based on the following information:

In the beginning of the year 2010, Mr. Sanyal had the option to invest Rs. 800000 in one or more of the following assets – gold, silver, US bonds, EU bonds, UK bonds and Japanese bonds. In order to invest in US bonds, one must first convert his investible fund into US Dollars at the ongoing exchange rate. Similarly, if one wants to invest in EU bonds or UK bonds or Japanese bonds one must first convert his investible fund into Euro, British Pounds and Japanese Yen respectively at the ongoing exchange rates. Transactions were allowed only in the beginning of every month. Bullion prices and exchange rates were fixed at the beginning of every
month and remained unchanged throughout the month. Refer to the table titled “Bullion Prices and Exchange Rates in 2010" for the relevant data.
Bullion Prices and Exchange Rates in 2010

Interest rates on US, EU, UK and Japanese bonds are 10%, 20%, 15% and 5% respectively.

#### Question 3

Mr. Sanyal invested his entire fund in gold, US bonds and EU bonds in January 2010. He liquefied his assets on 31st August 2010 and gained 13% on his investments. If instead he had held his assets for an additional month he would have gained l6.25%. Which of the following options is correct?

Instruction for set 1:

answer questions based on the following information:

In the beginning of the year 2010, Mr. Sanyal had the option to invest Rs. 800000 in one or more of the following assets – gold, silver, US bonds, EU bonds, UK bonds and Japanese bonds. In order to invest in US bonds, one must first convert his investible fund into US Dollars at the ongoing exchange rate. Similarly, if one wants to invest in EU bonds or UK bonds or Japanese bonds one must first convert his investible fund into Euro, British Pounds and Japanese Yen respectively at the ongoing exchange rates. Transactions were allowed only in the beginning of every month. Bullion prices and exchange rates were fixed at the beginning of every
month and remained unchanged throughout the month. Refer to the table titled “Bullion Prices and Exchange Rates in 2010" for the relevant data.
Bullion Prices and Exchange Rates in 2010

Interest rates on US, EU, UK and Japanese bonds are 10%, 20%, 15% and 5% respectively.

#### Question 4

At the beginning of every month, by sheer luck, Mr. Sanyal managed to correctly guess the asset that gave maximum return during that month and invested accordingly. If he liquefied his assets on 31st December 2010, how much was the percentage gain from his investments?

Instruction for set 2:

Answer questions based on the following information:
Mulchand Textiles produces a single product of only one quality – waterproof synthetic fabric. Mr.Sharma, the cost accountant of Mulchand Textiles, estimated the costs of Mulchand Textiles for different possible monthly output levels. Before he could tabulate his estimates his computer crashed, and Mr. Sharma lost all data. Fortunately he had some printouts of some incomplete tables, charts and diagrams. The table titled “Variable Cost Estimates of Mulchand Textiles” provided the estimates of labour and material costs.

Apart from labour and material costs Mulchand Textiles incurs administrative costs of Rs. 40,000 per month, and electricity costs. Mr. Sharma recalled that estimate data of variable electricity cost had certain peculiar characteristics. Values at every 25000 sq ft of output increased in geometric progression till 150000 sq ft of output, after which values increased in arithmetic progression for every 25000 sq ft of output. Mr. Sharma remembered that the electricity cost was estimated to be Rs. 3800 for 25000 sq.ft. of output, Rs. 5700 for 50000 square feet of output and Rs. 38856.50 for 175000 square feet of output.

#### Question 5

The estimated cost per square feet of output is least for:

Instruction for set 2:

Answer questions based on the following information:
Mulchand Textiles produces a single product of only one quality – waterproof synthetic fabric. Mr.Sharma, the cost accountant of Mulchand Textiles, estimated the costs of Mulchand Textiles for different possible monthly output levels. Before he could tabulate his estimates his computer crashed, and Mr. Sharma lost all data. Fortunately he had some printouts of some incomplete tables, charts and diagrams. The table titled “Variable Cost Estimates of Mulchand Textiles” provided the estimates of labour and material costs.

Apart from labour and material costs Mulchand Textiles incurs administrative costs of Rs. 40,000 per month, and electricity costs. Mr. Sharma recalled that estimate data of variable electricity cost had certain peculiar characteristics. Values at every 25000 sq ft of output increased in geometric progression till 150000 sq ft of output, after which values increased in arithmetic progression for every 25000 sq ft of output. Mr. Sharma remembered that the electricity cost was estimated to be Rs. 3800 for 25000 sq.ft. of output, Rs. 5700 for 50000 square feet of output and Rs. 38856.50 for 175000 square feet of output.

#### Question 6

The estimated material cost given in the table titled “Variable Cost Estimates of Mulchand Textiles” included the cost of material that gets spoiled in the production process. Mr. Sharma decomposed the estimated material cost into material spoilage cost and material usage cost, but he lost the data when his computer crashed. When he saw the following line diagram, here called that he measured the estimate of material spoilage cost per square feet of output on the y - axis and monthly output on the x - axis.

Estimated material usage cost per square feet of output.

Instruction for set 2:

Answer questions based on the following information:
Mulchand Textiles produces a single product of only one quality – waterproof synthetic fabric. Mr.Sharma, the cost accountant of Mulchand Textiles, estimated the costs of Mulchand Textiles for different possible monthly output levels. Before he could tabulate his estimates his computer crashed, and Mr. Sharma lost all data. Fortunately he had some printouts of some incomplete tables, charts and diagrams. The table titled “Variable Cost Estimates of Mulchand Textiles” provided the estimates of labour and material costs.

Apart from labour and material costs Mulchand Textiles incurs administrative costs of Rs. 40,000 per month, and electricity costs. Mr. Sharma recalled that estimate data of variable electricity cost had certain peculiar characteristics. Values at every 25000 sq ft of output increased in geometric progression till 150000 sq ft of output, after which values increased in arithmetic progression for every 25000 sq ft of output. Mr. Sharma remembered that the electricity cost was estimated to be Rs. 3800 for 25000 sq.ft. of output, Rs. 5700 for 50000 square feet of output and Rs. 38856.50 for 175000 square feet of output.

#### Question 7

Mr. Sharma found some printouts of line diagrams. The axes of the graphs were not marked, but Mr. Sharma remembered that he measured monthly output on the x - axis. Which of the following diagrams would represent the estimates of electricity cost per square feet of output versus monthly output?

Instruction for set 3:

Based on the following information

Total income tax payable is obtained by adding two additional surcharges on calculated income tax.

Education Cess : An additional surcharge called ‘Education Cess’ is levied at the rate of 2% on the amount of income tax.

Secondary and Higher Education Cess : An additional surcharge called ‘Secondary and Higher Education Cess is levied at the rate of 1% on the amount of income tax.

#### Question 8

Sangeeta is a young working lady. Towards the end of the financial year 2009 - 10, she found her total annual income to be Rs. 3, 37, 425/ -. What % of her income is payable as income tax?

Instruction for set 3:

Based on the following information

Total income tax payable is obtained by adding two additional surcharges on calculated income tax.

Education Cess : An additional surcharge called ‘Education Cess’ is levied at the rate of 2% on the amount of income tax.

Secondary and Higher Education Cess : An additional surcharge called ‘Secondary and Higher Education Cess is levied at the rate of 1% on the amount of income tax.

#### Question 9

Mr. Madan observed his tax deduction at source, done by his employer, as Rs. 3,17,910/-. What was his total income (in Rs.) if he neither has to pay any additional tax nor is eligible for any refund?

## XAT 2010 Data Interpretation Basics questions

Instruction for set 1:

Answer questions based on the following information:

An automobiles company’s annual sales of its small cars depends on the state of the economy as well as on whether the company uses some high profile individual as its brand ambassador in advertisements of its product. The state of the economy is “good”, “okay” and “bad” with probabilities 0.3, 0.4 and 0.3 respectively. The company may choose a high profile individual as its brand ambassador in TV ads or may go for the TV ads without a high profile brand ambassador.

If the company fixes price at Rs. 3.5 lakh, the annual sales of its small cars for different states of the economy and for different kinds of TV ads are summarized in table 1. The figures in the first row are annual sales of the small cars when the company uses a high profile individual as its brand ambassador in its TV ads and the ones in the second row are that when the company does not use any brand ambassador in TV ads, for different states of the economy.
Table 1:

Without knowing what exactly will be the state of the company in the coming one year, the company will either have to sign a TV ad contract with some high profile individual, who will be the company’s brand ambassador for its small car for the next one year, or go for a TV ad without featuring any high profile individual. It incurs a cost of Rs. 3.45 lakh (excluding the payment to the brand ambassador) to put a car on the road.

When the company’s profit is uncertain, the company makes decisions on basis of its expected profit. If the company can earn a profit xi with probability pi (the probability depends on the state of economy), then the expected profit of the company is $$\sum_1XiPi$$

#### Question 1

The maximum that the company can afford to pay its brand ambassador is

Instruction for set 1:

Answer questions based on the following information:

An automobiles company’s annual sales of its small cars depends on the state of the economy as well as on whether the company uses some high profile individual as its brand ambassador in advertisements of its product. The state of the economy is “good”, “okay” and “bad” with probabilities 0.3, 0.4 and 0.3 respectively. The company may choose a high profile individual as its brand ambassador in TV ads or may go for the TV ads without a high profile brand ambassador.

If the company fixes price at Rs. 3.5 lakh, the annual sales of its small cars for different states of the economy and for different kinds of TV ads are summarized in table 1. The figures in the first row are annual sales of the small cars when the company uses a high profile individual as its brand ambassador in its TV ads and the ones in the second row are that when the company does not use any brand ambassador in TV ads, for different states of the economy.
Table 1:

Without knowing what exactly will be the state of the company in the coming one year, the company will either have to sign a TV ad contract with some high profile individual, who will be the company’s brand ambassador for its small car for the next one year, or go for a TV ad without featuring any high profile individual. It incurs a cost of Rs. 3.45 lakh (excluding the payment to the brand ambassador) to put a car on the road.

When the company’s profit is uncertain, the company makes decisions on basis of its expected profit. If the company can earn a profit xi with probability pi (the probability depends on the state of economy), then the expected profit of the company is $$\sum_1XiPi$$

#### Question 2

Mr. Khan a popular film actor, agrees to sign the contract to become the company’s brand ambassador for Rs. 9 crore. The cost to the company of putting a car on the road also got escalated. The maximum escalation in cost of putting a car on the road, for which the company can afford to sign the contract with Mr.Khan is

Instruction for set 1:

Answer questions based on the following information:

An automobiles company’s annual sales of its small cars depends on the state of the economy as well as on whether the company uses some high profile individual as its brand ambassador in advertisements of its product. The state of the economy is “good”, “okay” and “bad” with probabilities 0.3, 0.4 and 0.3 respectively. The company may choose a high profile individual as its brand ambassador in TV ads or may go for the TV ads without a high profile brand ambassador.

If the company fixes price at Rs. 3.5 lakh, the annual sales of its small cars for different states of the economy and for different kinds of TV ads are summarized in table 1. The figures in the first row are annual sales of the small cars when the company uses a high profile individual as its brand ambassador in its TV ads and the ones in the second row are that when the company does not use any brand ambassador in TV ads, for different states of the economy.
Table 1:

Without knowing what exactly will be the state of the company in the coming one year, the company will either have to sign a TV ad contract with some high profile individual, who will be the company’s brand ambassador for its small car for the next one year, or go for a TV ad without featuring any high profile individual. It incurs a cost of Rs. 3.45 lakh (excluding the payment to the brand ambassador) to put a car on the road.

When the company’s profit is uncertain, the company makes decisions on basis of its expected profit. If the company can earn a profit xi with probability pi (the probability depends on the state of economy), then the expected profit of the company is $$\sum_1XiPi$$

#### Question 3

Mr. Khan a popular film actor, agrees to sign the contract to become the company’s brand ambassador for Rs. 9 crore. The cost to the company of putting a car on the road also got escalated by Rs. 1000. If the company signs the contract with Mr.Khan, its profit will