All Exams Test series for 1 year @ ₹349 only
Question

Study the table carefully and answer the questions that follow

In the following table, total Exports and Imports of 5 countries over 4 years (in Rs Crore) is given. Study the table carefully and answer the given questions. (I-import, E-export)

Year2017201820192020
CountryIEIEIEIE
P2530243228362232
Q2826263129372634
R2432282532362834
S2228182816212332
T2631163312232128

Which year has the minimum average import?

The correct answer is

2018

Analyzing Exports and Imports Data Table

The question asks us to identify the year with the minimum average import based on the provided table showing exports and imports for five countries (P, Q, R, S, T) over four years (2017, 2018, 2019, 2020). The values are given in Rs Crore.

To find the year with the minimum average import, we need to calculate the average import for each of the four years. The average import for a year is the sum of the imports for all five countries in that year divided by the number of countries, which is 5.

Year Country I (Import) E (Export)
2017 P 25 30
Q 28 26
R 24 32
S 22 28
T 26 31
2018 P 24 32
Q 26 31
R 28 25
S 18 28
T 16 33
2019 P 28 36
Q 29 37
R 32 36
S 16 21
T 12 23
2020 P 22 32
Q 26 34
R 28 34
S 23 32
T 21 28

Calculating Average Import for Each Year

Let's calculate the total import for each year and then find the average.

Year 2017:

  • Total Import = Import (P) + Import (Q) + Import (R) + Import (S) + Import (T)
  • Total Import = $25 + 28 + 24 + 22 + 26 = 125$ Rs Crore
  • Average Import = $\frac{\text{Total Import}}{\text{Number of Countries}} = \frac{125}{5} = 25$ Rs Crore

Year 2018:

  • Total Import = Import (P) + Import (Q) + Import (R) + Import (S) + Import (T)
  • Total Import = $24 + 26 + 28 + 18 + 16 = 112$ Rs Crore
  • Average Import = $\frac{\text{Total Import}}{\text{Number of Countries}} = \frac{112}{5} = 22.4$ Rs Crore

Year 2019:

  • Total Import = Import (P) + Import (Q) + Import (R) + Import (S) + Import (T)
  • Total Import = $28 + 29 + 32 + 16 + 12 = 117$ Rs Crore
  • Average Import = $\frac{\text{Total Import}}{\text{Number of Countries}} = \frac{117}{5} = 23.4$ Rs Crore

Year 2020:

  • Total Import = Import (P) + Import (Q) + Import (R) + Import (S) + Import (T)
  • Total Import = $22 + 26 + 28 + 23 + 21 = 120$ Rs Crore
  • Average Import = $\frac{\text{Total Import}}{\text{Number of Countries}} = \frac{120}{5} = 24$ Rs Crore

Comparing Average Imports

Now, let's compare the average import values for all four years:

  • Average Import 2017: 25 Rs Crore
  • Average Import 2018: 22.4 Rs Crore
  • Average Import 2019: 23.4 Rs Crore
  • Average Import 2020: 24 Rs Crore

Comparing these values, we can see that the minimum average import is 22.4 Rs Crore, which occurred in the year 2018.

Conclusion

Based on the calculations, the year with the minimum average import is 2018.

Revision Table: Average Import Analysis

Year Total Import (Rs Crore) Average Import (Rs Crore)
2017 125 25.0
2018 112 22.4
2019 117 23.4
2020 120 24.0

Additional Information: Data Analysis Concepts

Understanding how to work with data tables is crucial for quantitative aptitude questions. Key concepts involved in this problem include:

  • Data Extraction: Carefully reading the table and extracting the required data (Import values for each country in each year).
  • Summation: Adding up values (total import for a year).
  • Average Calculation: Dividing the total sum by the number of entries (average import per year). The formula for average is $\text{Average} = \frac{\text{Sum of observations}}{\text{Number of observations}}$.
  • Comparison: Comparing calculated values to find the minimum, maximum, or other relationships.

These skills are fundamental for solving data interpretation problems often found in exams.

Was this answer helpful?

Important Questions from Tabulation

  1. The table shows District-wise data of a number of primary school teachers posted in schools of a city.

    Study the table and answer the question:

    District

    Male teachers

    Female teachers

    East

    1650

    2375

    North

    1075

    2651

    West

    1280

    1520

    South

    1170

    1085

    Central

    690

    859


    What is the difference between the total number of male teachers in the districts East, North, West taken together and the total number of female teachers in the districts East and South?
  2. Table shows income (in Rs. ) received by 4 employees of a company during the month of December 2020 and all their income sources.

    Source

    Amit

    Suresh

    Nitin

    Varun

    Salary

    35000

    38500

    29000

    42000

    Arrears

    6000

    6300

    5000

    7500

    Bonus

    1000

    1100

    1000

    1240

    Overtime

    1800

    1950

    1400

    1500


    What is the ratio of salary of Varun to his income other than salary?
  3. Study the table and answer the question:

    Income (Rs.)

    No. of persons

    Less than 200

    12

    Less than 250

    26

    Less than 300

    34

    Less than 350

    40

    Less than 400

    50


    What is the percentage of persons earning Rs. 250 or more?
  4. The following table shows the annual profit of a company (in Rs. lakh).

    2014-2015

    2015-2016

    2016-0217

    2017-2018

    2018-2019

    625

    690

    725

    775

    815

    The period which has the maximum percentage increase in profit over the previous year is:

  5. The table given below shows the number of persons participating in a survey from 6 different states.

    States Persons 
    S1100
    S2200 
    S3400 
    S4500 
    S5600 
    S6800

    What is the ratio of number of person participating in a survey from state S3 to the number of person participating in a survey from state S4?

Need Expert Advice?

Start Your Preparation with Prepp Mobile App

Download the app from Google Play & App Store
Download the app from Google Play & App Store
Prepp Mobile App