Please use excel for showing your work and answers. Attached is the Chart needed to complete the questions.

Q1 Question 1 28 Points Download the "PS_4 - Airport Dataset.xlsx" spreadsheet from the course website (https://tinyurl.com/PS4-314). This dataset shows the number of passengers that passed through the Nashville Airport from May 2018 to February 2019. It is strongly recommended that you use Excel for all model calculations of this question. If you decide to use Excel, please present well-organized sheets of results and formulas. Q1.1 10 Points Calculate the best MOVING AVERAGE MODEL for future forecasting, using the given dataset, by following these instructions: i. Calculate forecasted values for all applicable months, under three different period values (n = 2, 3, 4). ii. For your predictions under each of these period values, calculate the MAPE. iii. State your preferred n-value for this dataset based on the MAPE for each case. Q1.2 10 Points Calculate the best EXPONENTIAL SMOOTHING MODEL for future forecasting, using the given dataset, by following these instructions: i. Calculate forecasted values for all applicable months, under three different smoothing coefficients (a = 0.2, 0.5, 0.8). Assume that the forecasted value for May-2018 is 3,250,000. ii. For your predictions under each of these smoothing coefficients (a values), calculate the MAPE. ii. State your preferred a value for this dataset based on the MAPE for each case. Save Answer Q1.3 5 Points Briefly explain 3 additional qualitative' factors you will account for, if you were a forecast analyst at the Nashville Airport (Note: Full credit will be awarded only if your answers are practical and realistic) Save Answer Q1.4 3 Points List 3 operational decisions that would be taken at an airport, based on forecasts like these. Save Answer Q1.5 O Points UPLOAD the Excel workbook(s) and any other files containing your answers to questions 1.1 - 1.4 here: Please select file(s) Select file(s) Save Answer Date May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Airport Passengers 3,173,447 3,303,720 4,681,469 4,839,957 4,130,230 5,129,393 5,109,583 5,476,002 4,787,289 4,549,199