topic badge

5.02 Moving averages

Worksheet
Moving averages
1

Consider the time series graphs drawn below, along with two sets of moving averages. For each graph, explain which moving average is most appropriate for this data.

a
b
c
d
e
f
g
h
i
j
k
Tables
2

Consider the time series data displayed in the table:

a

Calculate the values of a, b, c and d, correct to one decimal place

b

Use your calculator to find the following correct to four decimal places:

i

The correlation coefficient for the raw data.

ii

The correlation coefficient for the 3 point moving average data.

c

Is the correlation coefficient stronger for the raw data or the 3 point moving average data?

\text{Time period}\text{Raw data}3 \text{ point} \\\\\ \text{moving average}
13.9
23.913
331.3a
43.813.9
56.614.9
634.4b
76.116.4
88.615.6
9c17
1010.318.1
1111.820.4
12d
3

For each of the tables below that contain time series data:

i

Calculate the values of a, b, c and d, correct to one decimal place.

ii

Determine which moving average best smooths the data.

a
\text{Time period}\text{Raw data}\text{3-moving average}\text{5-moving average}
1113.8
2109112.1
3113.4107.497.7
499.7ab
552.686.493.8
610785.391.6
796.3101.890.7
8c9889.5
995.681.488.2
1046.580.986.7
11100.578.6
12d
b
\text{Time period}\text{Raw data}\text{3-moving average}\text{5-moving average}
143.8
246.541.2
333.44142.5
443ab
545.840.539.4
632.840.341.8
742.24039.6
8c39.938.7
932.339.641.1
1041.339.539
1144.839.2
12d
c
\text{Time period}\text{Raw data}\text{3-moving average}\text{5-moving average}
143.6
235.337.2
332.739.642.6
450.8ab
550.650.845.6
65148.146.2
742.743.147
8c44.447.7
954.948.247.9
1054.153.848.2
1152.350.2
12d
4

Consider the time series data displayed in the table:

a

Calculate the values of a and b correct to two decimal places.

b

Calculate the values of c and d correct to one decimal place.

c

Use your calculator to find the following correct to four decimal places:

i

The correlation coefficient for the raw data.

ii

The correlation coefficient for 4 point moving average data.

d

Is the correlation coefficient stronger for the raw data or the 4 point moving average data?

\text{Time period}\text{Raw data}\text{4 point centred}\\\text{moving average}
129.7
214.9
39.2a
431.123.03
534.924.68
618.9b
718.426.98
834.527.99
9c28.56
1024.629.05
1117.3
12d
5

Consider the time series data displayed in the table:

a

Find the value of x in the table. Give your answer to two decimal places.

b

Find for the value of y in the table. Give your answer to one decimal place.

c

Use your calculator to find the following correct to four decimal places:

i

The correlation coefficient for the raw data.

ii

The correlation coefficient for the 6 point centred moving average data.

d

Is the correlation coefficient stronger for the raw data or the 6 point moving average data?

\text{Time period}\text{Raw data}\text{6 point centred} \\\ \text{moving average}
121.9
218.3
326.3
418.634.88
53636.71
681.3x
735.739.71
826.440.86
931.542.14
1029.6
1145.3
12y
6

Consider the time series data presented in the table:

\text{Time period}\text{Raw data}\text{4 point centred}\\\text{moving average}\text{6 point centred}\\\text{moving average}
189
2102.5
393.598.09
4111ab
581.79494.77
692.692.0993.08
787.989.9688.96
8c87.5685.93
974.484.5485.79
1080.782.48
1175.6
12d
a

Calculate the values of a and b correct to two decimal places.

b

Calculate the values of c and d correct to one decimal place.

c

Which centred moving average best smooths the data?

7

Consider the time series data presented in the table:

\text{Time period}\text{Raw data}\text{3 point centred}\\\text{moving average}\text{4 point centred}\\\text{moving average}
111
28.419.1
337.920.8719.14
416.3a23.95
516.924.7325.89
64126.2324.09
720.826.93b
8c27.8728.68
943.82825.81
1021.227.5728.65
1117.727.9
12d
a

Calculate the value of a in the table. Give your answer to two decimal places.

b

Find the value of b. Give your answer to two decimal places.

c

Calculate the values of c and d correct to one decimal place.

d

Which moving average best smooths the data?

Spreadsheet applications
8

Jack the accountant records the following data regarding company turnover from 2002 to 2016 into a spreadsheet program. He wishes to smooth the data to investigate any underlying trend in the data so he uses the spreadsheet program to calculate moving averages:

a

Write a spreadsheet formula that Jack could type into cell \text{C3} to calculate the 3 point moving average for the data set.

b

Write a spreadsheet formula that Jack could type into cell \text{D4} to calculate the 5 point moving average for the data set.

c

Write a spreadsheet formula that Jack could type into cell \text{E4} to calculate the 4 point centred moving average for the data set.

d

Which moving average smooths the data the best?

9

A supermarket records plastic bag use and decides to use a 4 point centred moving average to smooth the data in order to make predictions.

The data is shown in the following spreadsheet:

Write a spreadsheet formula the supermarket staff could type into cell \text{C4} to calculate the 4CMA.

10

Justin weighs himself every 4 months and plots his weight on the graph below:

a

What type of moving average should Justin use if he wishes to smooth the data in order to make predictions and have the moving average values plotted at each month and not between months?

b

Justin enters the following incorrect formula into cell \text{D3} in his spreadsheet in order to calculate a 4 point centred moving average:

Write the correct formula for \text{D3}.

c

Calculate the correct result for the 4CMA that will be displayed in cell \text{D3}. Give your answer to one decimal place.

11

Paul records the average hours he works per week each month and records the data below:

a

What type of moving average should Paul use if he wishes to smooth the data and have the moving average figures plotted for each month and not between each month?

b

Paul enters the following formula into cell \text{C33} in his spreadsheet in order to calculate a 4 point centred moving average:

Write the correct formula and state which cell the formula should be typed into.

c

Hence, calculate the correct value for the 4CMA. Round your answer to one decimal place.

12

The graph shows the number of visitors to Kings' Park. Data is recorded every second month from January 2015 to November 2019:

a

What type of moving average should King’s Park administrators use if they wish to smooth the data in order to make predictions using a linear regression model?

b

The administrators set up a spreadsheet and enter the following formula into cell \text{E4} to calculate a 6 point centred moving average:

Write the correct formula for this cell.

c

Calculate the value that will be displayed by the correct formula in cell \text{E4}. Round your answer to two decimal places.

Sign up to access Worksheet
Get full access to our content with a Mathspace account

Outcomes

3.2.2.1

smooth time series data by using a simple moving average, including the use of spreadsheets to implement this process

What is Mathspace

About Mathspace