Question: I need help with the question in the pic attached. 8. PART 3: Suggested Final Submission Date: April 30, 2020. Accounts for 25% of the

I need help with the question in the pic attached.

I need help with the question in the pic attached. 8. PART

8. PART 3: Suggested Final Submission Date: April 30, 2020. Accounts for 25% of the Final Grade. By using the Enplanement.xIsx data, answer the following questions. Let us assume that Yt denotes the number of passengers who enplaned in month t. By that logic, if Y represents the data for December, 2018, then Yt-1 represents the data for November, 2018, Yt-2 represents the data for October, 2018, etc. In the data t represents time that starts at t = 0 or, the beginning of the data. 1. Present the data in a nice graph and generally describe the changes over time. 2. Derive the 3-month, 6-month, 9-month, and 12-month moving averages of the data and present those series nicely on a graph. Generally describe the changes of the moving averages over time. (Hint: Watch the moving average video avilable at https://tinyurl.com/w5f6ese and calculate the MAD, MSE, and MAPE to answer this question. It will be pretty straightforward once you watch the video.) 3. Watch the 3-part time series forecasting videos referenced above before you answer this question. Perform the following regressions and explain the resuts in a way that makes good sense. Yt = Bo + Bi(t) + E (14) Yt = Bo + B1( Y+-1) +E (15) Yt = Bo + B1( Yt-1) + B2(t) + E (16) Yt = Bo + B1(Yt-1) + B2( Yt-2) + E (17) Yt = Bo + B1 ( Yt-1) + B2( Yt-2) + B3(t) + E (18) Yt = Bo + B1(Yt-1) + B2(Yt-2) + B3(Yt-3)+e (19) Yt = Bo + B1( Yt-1) + B2( Yt-2) + B3(Yt-3) + BA(t) + E (20) Yt = Bo + B1 ( Yt-1) + B2( Yt-2) + B3(Yt-3) + BA(Yt-4) + Bs(t) + E (21)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!