This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Time Series and Moving Averages
Q1)
Data
1
24
2
34
4pt MA
C.M.A
S.E.
3
8
4
44
5
27
6
37
7
13
8
49
9
32
10
42
11
51
12
48
Trend line:
2.043
x
+
19.799
Give answers to 4 decimal places below:
What is the mean seasonal effect for season 1?
What is the mean seasonal effect for season 2?
What is the mean seasonal effect for season 3?
What is the mean seasonal effect for season 4?
Give answers to 2 decimal places below:
What is the prediction for season 1 next year?
What is the prediction for season 1 next year?
What is the prediction for season 1 next year?
What is the prediction for season 1 next year?
Q2)
Data
1
94
2
120
4pt MA
C.M.A
S.E.
3
73
4
88
5
88
6
115
7
67
8
83
9
83
10
108
11
65
12
77
Trend line:
-1.307
x
+
96.808
Give answers to 4 decimal places below:
What is the mean seasonal effect for season 1?
What is the mean seasonal effect for season 2?
What is the mean seasonal effect for season 3?
What is the mean seasonal effect for season 4?
Give answers to 2 decimal places below:
What is the prediction for season 1 next year?
What is the prediction for season 1 next year?
What is the prediction for season 1 next year?
What is the prediction for season 1 next year?
Q3)
Data
1
18
2
34
4pt MA
C.M.A
S.E.
3
23
4
51
5
24
6
37
7
28
8
58
9
27
10
45
11
34
12
62
Trend line:
1.342
x
+
27.933
Give answers to 4 decimal places below:
What is the mean seasonal effect for season 1?
What is the mean seasonal effect for season 2?
What is the mean seasonal effect for season 3?
What is the mean seasonal effect for season 4?
Give answers to 2 decimal places below:
What is the prediction for season 1 next year?
What is the prediction for season 1 next year?
What is the prediction for season 1 next year?
What is the prediction for season 1 next year?
Q4)
Data
1
3
2
10
4pt MA
C.M.A
S.E.
3
-5
4
0
5
0
6
11
7
-8
8
-3
9
-4
10
8
11
-12
12
-8
Trend line:
-0.732
x
+
4.383
Give answers to 4 decimal places below:
What is the mean seasonal effect for season 1?
What is the mean seasonal effect for season 2?
What is the mean seasonal effect for season 3?
What is the mean seasonal effect for season 4?
Give answers to 2 decimal places below:
What is the prediction for season 1 next year?
What is the prediction for season 1 next year?
What is the prediction for season 1 next year?
What is the prediction for season 1 next year?
Reset
Print