Effective Class 11 ISC Maths OP Malhotra Solutions Chapter 31 Moving Average Ex 31 can help bridge the gap between theory and application.

S Chand Class 11 ICSE Maths Solutions Chapter 31 Moving Average Ex 31

Question 1.
The table shows the number of students in a school getting at least a grade C in mathematics for the years 1994 to 2001.
(i) Represent this data as a time series.

19941995199619971998199920022001
97118115117121125111125

(ii) Calculate the 3-point moving average and plot it on the same graph.
(iii) Are the school’s maths results improving?
(iv) Explain why this is not a good way to work out whether the school’s results are improving.
Solution:
(i) The table of values is given as under :
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 2
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 3
(iii) The set of data is smoothed out and is increasing.
(iv) The number is increasing but might be because the school is getting bigger.

Question 2.
The profits of a soft drink firm in thousands of litres during each month of a year were :
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 4
Calculate 3-monthly moving averages and illustrate graphically. (ISC 1992 type)
Solution:
Calculation of 3-monthly moving arrange is given as :

MonthProfit3-monthly moving total3-monthly moving average
Jan.1.2
Feb.0.83.41.13
Mar.1.43.81.267
Apr.1.65.01.67
May2.05.61.87
June2.07.62.53
July3.610.43.47
Aug.4.811.83.93
Sep.3.410.03.33
Oct.1.85.91.97
Nov.0.73.71.23
Dec.1.2

OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 6

OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31

Question 3.
The number of traffic offences committed in a certain city over a period of 3 years is given in the following table :

Jan-MarchApril-JuneJuly-Sept.Oct-Dec.
196874564869
196983524981
197094604879

Calculate 4-quarterly moving averages and illustrate these and original figures on one graph using the same axis for both. Comment briefly on a local politician’s claim that traffic offences were on the increase.
Solution:
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 7
Thus the local politician’s claim that traffic offences were on the increase be true, it is cleared from 4-quarterly moving average centred column.
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 8

Question 4.
Find the 4-quarterly moving averages in the following table which gives the quarterly index numbers of coal production (for the years 1936-1938). Also plot on the same graph the quarterly index numbers as well as the 4-quarterly moving average. Comment on the nature of the general trend.

YearQuarters
1234
193693.381.781.589.1
193793.892.386.593.7
193897.682.379.089.3

Solution:
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 9
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 10

Question 5.
The annual incomes of a firm were recorded every quarter for 4 years. The results are shown in this table.

1999200020012002
1st quarter₹ 18,00,000₹ 20,00,000₹ 21,00,000₹ 22,50,000
2nd quarter₹ 14,50,000₹ 17,80,000₹ 19,50,000₹ 21,00,000
3rd quarter₹ 13,50,000₹ 15,00,000₹ 18,00,000₹ 19,80,000
4th quarter₹ 19,00,000₹ 18,30,000₹ 19,20,000₹ 20,50,000

(i) Work out the 4-point moving average for the data.
(ii) Plot the original data and the moving average on the same graph.
(iii) Comment on how the firm’s incomes have changed over the 4-years.
Solution:
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 11
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 12
The data has been smoothed out so there is a steady increase in Income.

OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31

Question 6.
The following table shows the daily sales of milk at a local corner shop for a month.

SunMonTueWedThuFriSat
1286941115
1177631514
1497751215
11128741419

Make a table showing the moving average using a 7-day span, and draw a graph to show the trend of milk sales over the month.
Solution:
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 13
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 14

Question 7.
The following table gives the monthly expenditure on a motor car for a period of two years.
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 15
Calculate 12-month!y moving average for the two years and display them and the original table on the same graph.
Solution:
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 16
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 17
Question 8.
A new film was shown at a theatre and ran for six w eeks. The attendances are shown in the table.

MonTueWedThuFriSat
First week243268407384348489
Second week445501623621527684
Third week602625800763728800
Fourth week800800800800800800
Fifth week721785800800800800
Sixth week647664683642608726

(i) Plot a line graph from the above data.
(ii) Calculate the 6-day moving average for the data and plot this on the same graph.
(iii) Comment on the weekly attendance.
Solution:
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 18
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 19

Question 9.
The table below given details of the electricity generated in million kilowatt hoars for public supply in each quarter of the years 1952 to 1955.

YearQuarter
1234
19528.97.16.79.3
195310.17.57.110.5
195411.77.58.310.9
195512.58.39.511.7

Draw a graph illustrating these figures.
Calculating a set of moving averages using the most suitable number of observations; give reasons of your choice. On the same diagram as before draw a graph showing the moving averages.
Solution:
We shall use 4-monthly moving average as it null eliminate the 12 monthly cycle and leave the general trend of the data.
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 20

Question 10.
The number of letters, in hundreds, posted in a certain city on each day of a fornight was as follows:

SundayMondayTuesdayWednesdayThursdayFridaySaturday
First week35703659626071
Second week39723856637175

Calculate the 7-day moving averages and display these and the original figures graphically on the same diagram, using the same scale and axes. What is the general trend ?
Solution:

Week daysWeek daysNo. of letters7-day moving total7-day moving average
FirstSun35
Mon70
Tue36
Wed5939356.14
Thu6239756.71
Fri6039957
Sat7140157.28
SecondSun3939856.85
Mon7239957
Tue3841058.57
Wed5641459.14
Thu63
Fri71
Sat75

OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 21
From graph and table, we observe that the general trend is that the no. of letters posted goes on increasing every day week after week.

OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31

Question 11.
In an influenza epidemic the numbers of cases diagnosed were :

Date(Marks)1234567891011121314
Numbers2051220274630311811501

On what days do the mode and upper and lower quartiles occur ?
Calculate 3-day moving averages and display them and the original figures on the same graph.
Solution:
Calculation of 3 yearly moving average
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 22

Question 12.

YearDate rate per thousand Quarter ended
MarchJuneSeptemberDecember
195313.910.38.110.6
195413.89.87.810.8
195514.210.17.810.0

Plot these figures on a graph.
Calculate the 4-quarterly moving averages and plot on the same graph.
Solution:
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 23

Question 13.
Registered unemployed (hundreds)

19571958
January638596
February602548
March509491
April462462
May359365
June295325
July290308
August322328
September377377
October392380
November480474
December542536
Average for year439432.5

Plot these monthly figures on a graph. Calculate the 12-monthly moving averages and plot these on the same graph.
Solution:
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 24
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 25

Question 14.
A Ballet Company gave a 6-weeks’ season at a large hall capable of seating 4000 people and the attendances in hundreds, at the evening performances, are recorded in the following table.
Attendance, in hundreds, to nearest hundred

MondayTuesdayWednesdayThursdayFridaySaturday
First week121320191724
Second week222531312634
Third week303140383640
Fourth week404040404040
Fifth week383940404040
Sixth week323334323036

Plot a graph of the above time-series and include on the same diagram the graph of 6-day moving averages.
Comment on the weekly cycle on attendances and state, with reasons, if you think, an extension of the season of eight weeks, would have been justified.
Solution:
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 26
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 27

Question 15.
Production of passenger cars, U.S.A. (tens of thousands)

YearQuarter
IIIIII
1927263624
1928293636
1929405243

Calculate the 4-quarterly moving averages and then draw the graphs of the given series and the moving averages. Briefly comment on the general trend.
Solution:
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 28
From table and graph it is observed that, the demand of cars was increasing year after year.

OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31

Question 16.
The aggregate number, in millions, of working days lost in strikes during each year of the period 1950-60 was

1950‘51‘52‘53‘54‘55‘56‘57‘58‘59‘60
1.41.71.82.22.53.82.18.43.55.33.0

Draw a graph to represent this information. Calculate the 3-yearly moving averages and draw the 3-yearly moving averages graph, using the same axes and scales. What is the main purpose in drawing moving average graph ? Comment on whether the purpose is achieved in this case.
Solution:

YearsWorking day lost3-yearly moving total3-yearly moving average
19501.4
19511.74.91.63
19521.85.71.9
19532.26.52.17
19542.58.52.83
19553.88.42.8
19562.114.34.77
19578.414.04.67
19583.517.25.73
19595.311.83.93
19603.0

OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 29
The main purpose in drawing moving average graph is to find the general trend. The purpose is achieved in this case, because the graph shows that the number of working lost during strike is goes on increasing.

Question 17.
The profits of a soft drink firm in thousands of rupees during each month of a year were

Jan.Feb.Mar.Apr.MayJuneJulyAug.Sept.Oct.Nov.Dec.
1.20.81.41.62.02.43.64.83.41.80.81.2

Plot these on a graph.
Calculate 4-monthly moving averages and plot these on the same graph. Comment on the general trend.
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 30
The general comment on trend is that the profits go on increasing from Jan. to August and start decreasing from Sept, to December.

Question 18.
Calculate,5-yearIy moving averages for the following data of the commercial and industrial failures in a country from 1982 to 1997.

Year198219831984198519881989199019911992199319961997
No. of families232628321210913111431

Display the actual and tend values on the same graph using the same axes for both.
Solution:

YearNo. of failures5-yearly moving total5-yearly moving average
198223
198326
19842812124.2
19853210821.6
1988129118.2
1989107615.2
199095511
1991135711.4
1992115010
199314428.4
19963
19971

OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 31

Question 19.
The table given below shows the daily attendance in thousands at a certain exhibition over a period of two weeks :

Week 152486468527072
Week 255476165587581

Calculate 7-day moving averages and illustrate these and original information on the same graph using the same scales.
Solution:
Calculation of 7-yearly moving average
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 32
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 33

Question 20.
The profit of a soft-drink firm (in thousands of rupees) during each month of the year is as given below :

Jan.Feb.Mar.Apr.MayJuneJulyAug.Sept.Oct.Nov.Dec.
3.64.34.33.44.45.43.42.43.41.80.81.2

Calculate the 4-monthly moving averages and plot these and the original data on a graph sheet.
Solution:
Calculation of 4 yearly moving average
OP Malhotra Class 11 Maths Solutions Chapter 31 Moving Average Ex 31 Img 34

Leave a Reply

Your email address will not be published. Required fields are marked *