Question

Corporate triple A bond interest rates for 12 consecutive months are as follows:

9.7

9.3

9.3

9.4

9.8

9.7

9.9

10.7

10.1

9.8

9.6

9.8

(a)

Choose the correct time series plot.

(i)
(ii)
(iii)
(iv)

- Select your answer -Graph (i)Graph (ii)Graph (iii)Graph (iv)Item 1

What type of pattern exists in the data?

- Select your answer -Positive trend patternHorizontal patternVertical patternNegative trend patternItem 2

(b)

Develop three-month and four-month moving averages for this time series.

If required, round your answers to two decimal places.

Month	Sales	3 Month Moving Average	4 Month Moving Average
1	9.7
2	9.3
3	9.3
4	9.4
5	9.8
6	9.7
7	9.9
8	10.7
9	10.1
10	9.8
11	9.6
12	9.8

Enter the Mean Square Errors for the three-month and the four-month moving average forecasts. If required, round your answers to three decimal digits.

	3-month moving average	4-month moving average
MSE

Does the three-month or the four-month moving average provide the better forecasts based on MSE? Explain.

- Select your answer -3-month moving average4-month moving averageItem 22

- Select your answer -Moving average with the lowest MSE provides the better forecast.Moving average with the highest MSE provides the better forecast.Item 23

(c)

What is the moving average forecast for the next month? If required, round your answer to two decimal places.

Answer 1

a.

b.

Month
10
11
12
Timp
Series
Value
9.5
9.3
9.4
9.6
9.8
9.7
9.8
10.5
9.9
9.7
9.6
9.6
Forecast
9.4
9.43
9.6
9.7
9.77
10
10.07
10.03
9.73
Totals
Forecast
Error
0.2
0.37
0.1
0.1
0.73
-0.1
-0.37
-0.43
-0.13
0.47
lute Value
of Forecast
Error
0.2
0.37
0.1
0.1
0.73
0.1
0.37
0.43
0.13
2.53
Squared
Forecast
Error
0.04
0.13
0.01
0.01
0.54
0.01
0.13
0.19
0.02
1.08