-
19 Mar 2025
GS Paper 1
Data Interpretation
Day 15: Study the following table carefully and answer the questions given below: (50 Marks)
Following are the shares traded on NSE (National Stock Exchange), BSE (Bombay Stock Exchange), CSE (Calcutta Stock Exchange) and MSE (Mangalore Stock Exchange) in Rupees.
Name of the Company
Stock Exchanges
NSE
BSE
CSE
MSE
High
Low
High
Low
High
Low
High
Low
Adani Port
900
880
880
860
910
900
890
870
Bharti Airtel
910
890
915
895
910
895
915
900
Coal India
280
270
290
270
290
280
300
290
Dabur India
560
540
550
545
580
570
580
560
Tata Steel
200
180
190
180
210
200
200
190
(a) Find the average of the high rates of shares in all four stock exchanges for Adani Port.
(b) Name the companies with the maximum and minimum average value of low-rate shares on all stock exchanges.
(c) Find the ratio of the average of the sum of high and low rates of shares in Coal India to the average of the high rates of shares in Mangalore Stock Exchange (MSE).
(d) Which stock exchange has the greatest difference between Bharti Airtel’s high and low share rates?
(e) Find the ratio of Dabur India’s sum of high and low share from BSE and NSE to the TATA Steel’s sum of high and low share from CSE and MSE.
Answer:
The average of the high rates of shares in all four stock exchanges for Adani Port
= (900 + 880 + 910 + 890)/4 =
= 3580/4
= 895
(b) Name the companies with the maximum and minimum average value of low-rate shares on all stock exchanges.
Answer:
Adani Port,
Average of Low-rate shares,
= (880 + 860 + 900 + 870)/4
= 3510/4
= 877.5
Bharti Airtel,
Average of Low-rate shares,
= (890 + 895 + 895 + 900)/4
= 3580/4
= 895
Coal India,
Average of Low-rate shares,
= (270 + 270 + 280 + 290)/4
= 1110/4
= 277.5
Dabur India,
Average of Low-rate shares,
= (540 + 545 + 570 + 560)/4
= 2215/4
= 553.75
Tata Steel,
Average of Low-rate shares,
= (180 + 180 + 200 + 190)/4
= 750/4
= 187.5
Hence, the companies with the maximum and minimum average value of low-rate shares on all stock exchanges are Bharti Airtel and TATA Steel.
(c) Find the ratio of the average of the sum of high and low rates of shares in Coal India to the average of the high rates of shares in Mangalore Stock Exchange (MSE).
Answer:
Coal India,
Sum of high and low rates of shares are 550, 560, 570 and 590.
Average of Sum of high and low rates of shares of Coal India,
= (550 + 560 + 570 + 590)/4
= 567.5
The average of the high rates of shares in Mangalore Stock Exchange (MSE)
= (890 + 915 + 300 + 580 + 200)/5
= 2885/5
= 577
Ratio = 567.5/577 = 1135/1154
Hence, the ratio of the average of the sum of high and low rates of shares in Coal India to the average of the high rates of shares in Mangalore Stock Exchange (MSE) is 1135:1154.
(d) Which stock exchange has the greatest difference between Bharti Airtel’s high and low share rates?
Answer:
Bharti Airtel,
NSE = 910 – 890 = 20
BSE = 915 – 895 = 20
CSE = 910 – 895 = 15
MSE = 915 – 900 = 15
Hence, NSE (National Stock Exchange) and BSE (Bombay Stock Exchange) stock exchanges have the greatest difference between Bharti Airtel’s high and low share rates.
(e) Find the ratio of Dabur India’s sum of high and low share from BSE and NSE to the TATA Steel’s sum of high and low share from CSE and MSE.
Answer:
Dabur India’s,
Sum of high and low share from BSE = 550 + 545 = 1095
Sum of high and low share from NSE = 560 + 540 = 1100
Dabur India’s sum of high and low share from BSE and NSE = 1100 + 1095 = 2195
TATA Steel’s
Sum of high and low share from CSE = 210 + 200 = 410
Sum of high and low share from MSE = 200 + 190 = 390
TATA Steel’s sum of high and low share from CSE and MSE = 410 + 390 = 800
Ratio = 2195/800 = 439/160
Hence, the ratio of Dabur India’s sum of high and low share from BSE and NSE to the TATA Steel’s sum of high and low share from CSE and MSE is 439:160.
