TABULATION

TABULATION
This section comprises of questions in which certain data regarding common
disciplines as production over a period of a few years: imports, exports,
incomes of employees in a factory, students applying for and qualifying a
certain field of study etc. are given in the form of a table. The candidate is
required to understand the given information and thereafter answer the given
questions on the basis of comparative analysis of the data.
Thus, here the data collected by the investigator are arranged in a systematic
form in a table called the tabular form. In order to avoid some heads again
and again, tables are made consisting of horizontal lines called rows and
vertical lines called columns with distinctive heads, known as captions. Units
of measurements are given with the captions.
SOLVED EXAMPLES
The following table gives the sales of batteries manufactured by a company
lit the years. Study the table and answer the questions that follow:
(S.B.I.P.O. 1998)
NUMBER OF DIFFERENT TYPES OF BATTERIES SOLD BY A
COMPANY OVER THE YEARS (NUMBERS _N THOUSANDS)
TYPES OF BATTERIES
Year 4AH 7AH 32AH 35AH 55AH T0TAL
1992 75 144 114 102 108 543
1993 90 126 102 84 426 528
1994 96 114 75 105 135 525
1995 105 90 150 90 75 510
1996 90 75 135 75 90 465
1997 105 60 165 45 120 495
1998 115 85 160 100 145 605
1. The total sales of all the seven years is the maximum for which battery ?
(a) 4AH (b) 7AH (c) 32AH (d) 35AH (e) 55AH
2. What is the difference in the number of 35AH batteries sold in 1993 and
1997 ?
(a) 24000 (b) 28000 (c) 35000 (d) 39000 (e) 42000
3. The percentage of 4AH batteries sold to the total number of batteries sold
was maximum in the year:
(a) 1994 . (b) 1995 (c) 1996 (d) 1997 (e) 1998
4. In the case of which battery there was a continuous decrease in sales from
1992 to 1997 ?
(8) 4AH (b) 7 AH (c) 32AH (d) 35AH (e) 55AH
5. What was the approximate percentage increase in the sales of 55AH
batteries in 1998 compared to that in 1992 ?
(a) 28% (b) 31% (c) 33% (d)34% (e)37%
Sol. 1. (c) : The total sales (in thousands) of all the seven years for various
batteries are:
For 4AH = 75 + 90 + 96 + 105 + 90 + 105 + 115 = 676
For 7AH = 144 + 126 + 114 + 90 + 75 + 60 + 85 = 694
For 32AH = 114 + 102 + 75 + 150 + 135 + 165 + 160 = 901
For 35 AH= 102 + 84 + 105 + 90 + 75 + 45 + 100 = 601
For 55 AH= 108 + 126 + 135 + 75 + 90 + 120 + 145 = 799.
Clearly, sales are maximum in case of 32AH batteries.
2. (d\ : Required difference = [(84 - 45) x 1000] = 39000.
3. (d) : The percentages of sales of 4AH batteries to the total sales in different
years are:
For 1992 =(75*100/543)%=13.81%
For 1993=(90*100)/528%=17.05%
For 1994=(96*100/465)%=19.35%
For 1995=(105*100/495)%=20.59%
For 1996=(96*100/465)%=19.35%
For 1997=(105*100/495)%=21.21%
For 1998=(115*100/605)%=19.01%
Clearly, the percentage is maximum in 1997.
4. (b) : From the table it is clear that the sales of 7AH batteries have
been decreasing continuously from 1992 to 1997.
5. (d) : Required Percentage =(145-108)/108)*100 %=34.26%=34%.
Ex 2: Study the following table carefully and answer these questions:
NUMBER OF CANDIDATES APPEARED AND QUALIFIED IN A COMPETITIVE
EXAMINATION FROM DIFFERENT STATES OVER THE YEAR
1997 1998 1999 2000 2001
App. Qual. App. Qal. App. Qual. App. Qual. App. Qual
M 5200 720 8500 980 7400 850 6800 775 95001125
N 7500 840 9200 1050 8450 920 9200 980 88001020
P 6400 780 8800 1020 7800 890 8750 1010 97501250
Q 8100 950 9500 1240 8700 980 9700 1200 8950995
R 7800 870 7600 940 9800 1350 7600 945 7990885
1. Combining the states P and Q, together in 1998, what is the percentage
of the candidates qualified to that of the canditates appeared?
(8) 10.87% (b) 11.49% (c) 12.35% (d) 12.54% (e) 13.50%
2.The percentage of the total number of qualified candidates to the total
number appeared candidates among all the five states in 1999 is :
(a) 11.49%(b) 11.84% (c)- 12.21% (d) 12.57%(e) 12.7a1
3. What is the percentage of candidates qualified from State N for all the
years together, over the candidates appeared from State N during all the years
together?
(a) 12.36% (b) 12.16% (c) 11.47% (d) 11.15%(e)None of these
4. What is the average of candidates who appeared from State Q during the
given yeas?
(8) 8700 (b) 8760 (c) 8810 (d) 8920 (e) 8990
5 . In which of the given years the number of candidates appeared from
State P has maximum percentage of qualified candidates?
(8) 1997 (b) 1998 (c) 1999 (d) 2000 (e) 2001
6. Total number of candidates qualified from all the states together in 1997
is approximately what percentage of the total number of candidates qualified
from all the states together in 1998 ?
(8) 72% (b) 77% (c) 80% (d) 83% (e) 86%
Sol.1.(c)Required Percentage=(1020+1240) *100%=(2260*100)/18300%
(8800+9500)
=12.35%
Required Percentage= (850+920+890+980+1350) *100%
(7400+8450+7800+8700+9800)
=(4990*100)/42150%
=11.84%
(e) : Required Percentage=(84-
+1050+920+980+1020)/(7500+9200+8450+9200+8800)*100%
=(4810*100)/43150* %
=11.15%
4. (e) Required average =(8100+9500+8700+9700+8950)/5
=44950/5
=8990
5. (e) : The percentages of candidates qualified to candidates appeared from
State P during different years are:
For 1997= 780 * 100% =12.19%
6400
for 1998 = 1020*100 %=11.59%
8800
For 1999 = 890*100 %=11.41%;
7800
For 2000 = 1010* 100 % = 11.54%.
8 750
For 2001=1250*100 %= 12.82%
9750
:. Maximum percentage is for the year 2001.
6. (c) : Required Percentage =( 720 + 840 + 780 + 950 + 870) . x 100
980+1050+1020+1240+940
=80%
Ex. 3. The following table gives the percentage of marks obtained by seven
students in six , different subjects in an examination. Study the table and
answer the questions based on it. The numbers in the brackets give the
maximum marks in each subject.
(Bank P.O. 2003)
\ I
(Max. Maths Chemistry Physics GeographyHistory Computer
marks) Science
Student (160) (130) (120) (100) (60) (40)
Ayush 90 50 90 60 70 80
Aman 100 80 80 40 80 70
Sajal 90 60 70 70 90 70
Rohit 80 65 80 80 60 60
Muskan 80 65 85 95 50 90
Tanvi 70 75 65 85 40 60
Tharun 65 35 50 77 80 80
1. What was the aggregate of marks obtained by Sajal in all the six subjects?
(a) 409 (b) 419 (c) 429 (d) 439 (e) 449
2. What is the overall percentage of Thrun?
(a) 52.5% (b) 55% (c) 60% (d) 63% (e) 64.5%
3. What are the average marks obtained by all the seven students in Physics?
(rounded off to two digits after decimal)
(a) 77.26 (b) 89.14 (c) 91.37 (d) 96.11 (e) 103.21
4. The number of students who obtained 60% and above marks in all the
subjects is :
(a) 1 (b) 2 (c) 3 (d) None (e) None of these

6. In which subject is the overall percentage the best?
(a) History (b) Maths (c) Physics (d) Chemistry (e) Geography
Sol. 1.. (e) : Aggregate marks obtained by Sajal
= [(90% of 150) + (60% of 130) + (70% of 120) + (70% of 100) +
(90% of 60) + (70% of 40)] = 135 + 78 + 84 + 70 + 54 + 28 = 449.
2. (c) : Aggregate marks obtained by Tarun .
= [(65% of 150) + (35% of 130) + (50% of 120) + (77% of 100) + (80% of
60) + (80% of 40)] = 97.5 + 45.5 + 60 + 77 + 48 + 32 = 360.
Total maximum marks (of all the six subjects)
= (150 + 130 + 120 + 100 + 60 + 40) = 600.
Overall percentage of Tarun = 360 x 100 % = 60%.
. 600
3. (b) : Average marks obtained in Physics by all the seven students
= 1 [(90% of 120) + (80% of 120) + (70% of 120) + (80% of 120)
7
+ (85% of 120) + (65% of 120) + (50% of 120)]
= 1 [(90 + 80 + 70 +80 + 85 + 65 + 50)% of 120]
7
=1 [520% of 120] = 89.14.
7
4. (b) : From the table it is clear that Sajal and Rohit have 60% or more
marks
in each of the six subjects.
6. (b) : We shall find the overall percentage (for all the seven students) with
respect to each subject.
The overall percentage for any subject is equal to the average of percentages
obtained by all the seven students since the maximum marks for any subject
is the same for all the students.
Therefore, overall percentage for:
(i) Maths = [1(90+100+90+80+80+70+65)]%
7
= [1(575)]% = 82.14%.
7
(ii) Chemistry = [1(50 + 80 + 60 + 65 + 65 + 75 + 35)]%
7
= [1(430)]% = 61.43%. .
7
(iii) Physics = [1(90 + 80 + 70 + 80 + 85 + 65 + 50)]%
7
=[1 (520)]% = 74.29%.
7
(iv) Geography = [1(60 + 40 + 70 + 80 + 95 + 85 + 77)]%
7
= [1 (507)}_ = 72.43%.
7
(v) History = [1 (70 + 80 + 90+ 60 + 50 + 40 + 80)]%
7
=1 [(470)]% = 67.14%.
7
(vi) Computer Science = [1/7 (80 + 70 + 70 + 60 + 90 + 60 + 80)]%
= [1 (510)]% = 72.86%.
7
Clearly; this. percentage is highest for Maths.
ex.4. Study the following table carefully and answer tbe questions given
below:(Bank P.O. 2001)
CLASSIFICATION OF 100 STUDENTS BASED ON THE MARKS
OBTAINED BY THEM IN PHYSICS AND CHEMISTRY IN AN
EXAMINATION
Marks out
Of 50 40 and 30 and 20 and 10 and 0 and
Subject above Above above above above
physics 9 32 80 92 100
,.
chemistry 4 ,21 66 81, 100
(aggregate
Average) 7 27 73 87 100
1. The number of students scoring less than 40% marks in aggregate is :
(a) 13 (b) 19 (c) 20 (d) 27 (e) 34
2. If at least 60% marks in Physics are required for pursuing higher studies in
Physics,how many students will be eligible to pursue higher studies in
Physics?
(a) 27 (b) 32 (c) 34 (d)41 (e) 68
3. What is the difference between the number of students passed with 30 as
cut-off marks in Chemistry and those passed with :JUas cut-off marks in
aggregate?
(a) 3 (b) 4 (c) 5 (d) 6 (e) 7
4. The percentage of the number of students getting at least 60% marks in
Chemistry over those getting at least 40% marks in aggregate, is
approximately:
(a) 21% (b) 27% (c) 29% (d) 31% (e) 34%
5. If it is known that at least 23 students were eligible for a Symposium on
Chemistry the minimum qualifying marks in Chemistry for eligibility to
Symposium would lie in the range:
(a) 40-50 (b) 30-40 (c) 20-30 (d) Below 20
Sol. 1. (d) : We have 40% of 50 =(40 x 50)= 20.
100
:. Required number = Number of students scoring less than 20 marks
in aggregate
= 100 - number of students scoring 20 and above
marks in aggregate = 100 - 73 = 27.
2. (b) : We have 60% of 50 =(60 x 50) = 30.
100
:. Required number = Number of students scoring 30 and above mark
in Physics = 32. .
3. (d) : Required difference = (Number of students scoring 30 and
above in mark in Chemistry) (Number of students scoring 30 and
. above marks in aggregate) = 27 - 21 = 6.
4. (c) : Number of students getting at least 60% marks in Chemistry
= Number of students getting 30 and above marks in Chemistry = 21.
Number of students getting at least 40% marks in aggregate
= Number of students getting 20 and above marks in aggregate = 73.
:. Required Percentage = (21x 100)% = 28.77% ≈29%.
73
6. (c) : Since 66 students get 20 and above marks in Chemistry and out of
these 21 students get 30 and above marks, therefore to select top 35 students
in Chemistry, the qualifying marks should lie in the range 20-30.