Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Eco 309-Assignment 1 due by midnight on September 19, 2021(Chapters 1 and 4) Total points 125. Submit through D2L in Word/Excel format, single or multiple

Eco 309-Assignment 1 due by midnight on September 19, 2021(Chapters 1 and 4)

Total points 125. Submit through D2L in Word/Excel format, single or multiple files. Must show your work, answer all parts of the question, and write necessary explanations to earn full points. You have to use Excel to solve this numerical problem (project).

1. The following data covers 20 period (could be years or quarters) for company XYZ's sales in $millions.

Period

Sales(Y)

1

10

2

11

3

14

4

14

5

12

6

15

7

18

8

16

9

16

10

17

11

16

12

20

13

24

14

22

15

20

16

24

17

26

18

28

19

28

20

26

(i) Plot the data using Excel (insert, Chart, scatter, lines...) showing the trend line in the plot. Comment on the visible features in the plot. Does it have stationarity and/or Seasonality? Why or why not? (ii) Calculate the autocorrelation coefficients r1, r2, r3, r4, r5, r6, r7 and r8 for the above series and plot the "Correlogram" using Excel. What do the autocorrelation coefficients tell you about the time series. (iii) Create table of first differences of the series (Yt-Yt-1). Plot the first differenced series and comment on its stationarity. (iv) Run 2-periods and 3-periods moving average forecasts for the above sales data and compare the forecasts using MAD, MAPE, MSE, RMSE. Also calculate the Mean Percentage Error (MPE) for MA(2) and MA(3) forecasts and discuss the systematic bias (if any) illustrating with the plot of actual vs forecasted values for both MA(2) and MA(3) forecasts. Why did such a systematic bias occur? (v) Correct this bias by performing a Double Moving Average method with four periods and plot the errors of DMA(4). Calculate its MAD, MAPE, MSE, RMSE, and MPE and compare with simple MA(4) forecast. Make a forecast for period 21 (one period beyond the sample) using DMA(4).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introductory Econometrics A Modern Approach

Authors: Jeffrey Wooldridge

7th Edition

1337558869, 978-1337558860

More Books

Students also viewed these Economics questions