I need help with all 4 parts of the question in the attached pic.

8. PART 3: Suggested Final Submission Date: April 30, 2020. Accounts for 25% of the Final Grade. By using the Enplanement.xlsx data, answer the following questions. Let us assume that Yt denotes the number of passengers who enplaned in month t. By that logic, if Yt 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 + B1(t) + E (14) Yt = Bo + B1( Yt-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) + 32(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) + 35(t) + E (21) 6 4. Which of the above forecasting models estimated above works best for the data that we have? (Hint: First calculate the predicted values from each of the equations. Watch the moving average video avilable at https://tinyurl.com/w5f6ede and calculate the MAD, MSE, and MAPE (for the difference between the actual and predicted values) to answer this question. It will be pretty straightforward once you watch the video.)