topic badge
AustraliaVIC
VCE 12 General 2023

4.02 Smoothing with moving means

Worksheet
Smoothing with moving means
1

Consider the Time Series graphs drawn below, along with two sets of moving means. For each graph, state which moving mean (MA) is most appropriate for this data:

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

Consider the Time Series data presented in the table:

\text{Time period}\text{Raw data}\text{3-moving mean}\text{5-moving mean}
143.6
235.337.2
332.737.538.4
444.4ab
53637.938.3
633.338.239.1
745.338.437.1
8c38.739.1
93438.939.8
10463937.7
113739.3
12d
a

Calculate the values of the following. Round your answers to one decimal place.

i

a

ii

b

iii

c

iv

d

b

Which moving mean best smooths the data?

3

Consider the Time Series data presented in the table:

\text{Time period}\text{Raw data}\text{3-moving mean}\text{5-moving mean}
143.8
246.541.2
333.439.941.7
439.7ab
545.144.343.1
648.147.444
749.14545.2
8c44.346.9
94645.748.1
1053.351.249.6
1154.354.6
1256.3
a

Calculate the values of the following in the table. Round your answers to one decimal place.

i

a

ii

b

iii

c

b

Which moving mean is most appropriate for this data?

4

Consider the Time Series data presented in the table:

\text{Time period}\text{Raw data}\text{3-point} \\ \text{moving mean}\text{4-point centred} \\ \text{moving mean}
133.1
223.622.03
39.422.624.13
434.8a21.96
524.324.7324.21
615.125.126.94
735.927.03b
8c2828.18
91830.1331.08
1042.330.7329.06
1131.930.73
12d
a

Calculate the values of the following. Round your answers to one decimal place.

i

a

ii

b

iii

c

iv

d

b

Which moving mean is most appropriate for this data?

5

Consider the Time Series data presented in the table:

\text{Time period}\text{Raw data}\text{3-point} \\ \text{moving mean}\text{4-point centred} \\ \text{moving mean}
1209.4
2201.6200.43
3190.3196.33197.64
4197.1a194.04
5193.7193.1193.06
6188.5192.6191.81
7195.6188.63b
8c183.97184.71
9174.5180.57181.86
10185.4178.6177.98
11175.9177.23
12d
a

Calculate the values of the following. Round your answers to one decimal place.

i

a

ii

b

iii

c

iv

d

b

Which moving mean is most appropriate for this data?

6

Consider the Time Series data presented in the table:

\text{Time period}\text{Raw data}\text{4-point centred} \\ \text{moving mean}\text{6-point centred} \\ \text{moving mean}
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 the following in the table. Round your answers to one decimal place.

i

a

ii

b

iii

c

iv

d

b

Which moving mean is most appropriate for this data?

7

Consider the Time Series data presented in the table:

\text{Time period}\text{Raw data}\text{4-point centred} \\ \text{moving mean}\text{6-point centred} \\ \text{moving mean}
145.5
241.5
343.551.83
474.4ab
550.354.9954.15
649.255.8657.83
748.656.4156.72
8c57.0555.18
952.858.1158.42
1051.859.79
1154.5
12d
a

Calculate the values of the following in the table. Round your answers to one decimal place.

i

a

ii

b

iii

c

iv

d

b

Which moving mean is most appropriate for this data?

8

Consider the Time Series data presented in the table:

a

Calculate the values of the following. Round your answers to one decimal place.

i

a

ii

b

iii

c

iv

d

b

Calculate the correlation coefficient for the following. Round your answers correct to four decimal places.

i

The raw data

ii

The 4-point moving mean data

c

Which set of data has the stronger correlation coefficient?

\text{Time period}\text{Raw data}\text{4-point centered} \\ \text{moving mean}
1196.2
2178.9
3211.6a
4198.9194.33
5189.9192.89
6174.9b
7204.1190.21
8197.3186.94
9c184.09
10159.4181.29
11196.8
12d
9

Consider the Time Series data presented in the table:

a

Calculate the values of the following. Round your answers to two decimal places.

i

a

ii

b

iii

c

iv

d

b

Calculate the correlation coefficient for the following. Round your answers correct to four decimal places.

i

The raw data

ii

The 4-point moving mean data

c

Which set of data has the stronger correlation coefficient?

\text{Time period}\text{Raw data}\text{4-point centered}\\ \text{moving mean}
19
221.9
323a
43724.18
514.824.49
621.9b
725.525.36
838.326.26
9c27.5
1027.228.45
1130.1
12d
10

Consider the Time Series data presented in the table:

a

Calculate the values of the following in the table. Round your answers to one decimal place.

i

a

ii

b

iii

c

iv

d

b

Calculate the correlation coefficient for the following. Round your answers to four decimal places.

i

The raw data

ii

The 3-point moving mean data

c

Which set of data has the stronger correlation coefficient?

\text{Time period}\text{Raw data}\text{3-point centered} \\ \text{moving mean}
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
11

Consider the Time Series data presented in the table:

a

Calculate the values of the following in the table. Round your answers to one decimal place.

i

a

ii

b

iii

c

iv

d

b

Calculate the correlation coefficient for the following. Round your answers to four decimal places.

i

The raw data

ii

The 3-point moving mean data

c

Which set of data has the stronger correlation coefficient?

\text{Time period}\text{Raw data}\text{3-point centered} \\ \text{moving mean}
19.5
221.711.3
32.8a
412.814.3
527.414.8
64.2b
716.716.5
828.517.3
9c18.8
1021.120.1
1132.520.1
12d
12

Consider the Time Series data displayed in the table:

a

Calculate the values of the following. Round your answers to one decimal place.

i

x

ii

y

b

Calculate the correlation coefficient for the following. Round your answers correct to 4 decimal places.

i

The raw data

ii

The 6-point centred moving mean data

c

Which set of data has the stronger correlation?

\text{Time period}\text{Raw data}\text{6-point centred} \\ \text{moving mean}
141.5
236.8
326.4
427.234.38
533.736.5
635.4x
752.140.98
851.643.01
939.844.63
1039.4
1145.8
12y
13

Consider the Time Series data displayed in the table:

a

Calculate the values of the following. Round your answers to one decimal place.

i

x

ii

y

b

Calculate the correlation coefficient for the following. Round your answers correct to 4 decimal places.

i

The raw data

ii

The 6-point centred moving mean data

c

Which set of data has the stronger correlation?

\text{Time period}\text{Raw data}\text{6-point centred} \\ \text{moving mean}
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
Sign up to access Worksheet
Get full access to our content with a Mathspace account

Outcomes

U3.AoS1.28

identify key qualitative features of a time series plot including trend (using smoothing if necessary), seasonality, irregular fluctuations and outliers, and interpret these in the context of the data

What is Mathspace

About Mathspace