Question: I would like help on how to do question D , E , F IN EXCEL PLEASE AND THANK YOU. The spreadsheeted contains data on

I would like help on how to do question D , E , F IN EXCEL PLEASE AND THANK YOU.

The spreadsheeted contains data on international air passenger traffic for a major airport in the United States for two years prior to COVID-19 pandemic. The goal in this case is to forecast the volume of international passengers for year 3. Ignore the impact of the COVID-19 pandemic on air travels answer the following questions. a) What forces seem to be at work here in terms of trend and seasonality? Explore the data and comment on the trend and seasonality patterns present in the data. (3 marks) b) Use the seasonality forecasting technique with no trend to forecast the international passenger volume for each month of year 3 in this airport. (Use the actual number of passengers as the initial value for exponential smoothing. Use smoothing constant 0.3) (10 marks) c) Create a graph comparing the actual number of passengers versus forecasted volume from part (b) and comment on how they compare. (2 marks) d) Use the seasonality forecasting technique with trend (multiplicative decomposition)" to estimate the international passenger volume for each month of year 3 in this airport. (10 marks) e) Create a graph comparing the actual versus forecasted volume from part (d) and comment on how they compare. (2 mark) f) What other variables do you expect to influence the number of international travelers? Comment on at least three variables. (3 marks) 3 Year Month . Year 1 Year 1 January February March 5 Year 1 Year 1 April May 3 Year 1 Year 1 June 0 Year 1 1 Year 1 July August September October 2 Year 1 3 Year 1 4 Year 1 November 5 Year 1 December Passengers exponetial smoothing 13,441,718 11,942,221 13,441,718 14,670,996 12392070.1 14,286,844 13987318.2 14,537,314 14196986.3 15,906,101 14435215.7 17,362,586 15464835.4 16,969,528 16793260.8 14,010,920 16916647.8 13,599,030 14882638.4 12,919,746 13984112.5 14,289,105 13239056 13,970,077 13974090.3 12,230,963 13971281 15,447,435 12753058.4 14,507,038 14639122 15,516,063 14546663.2 16,487,702 15225243.1 17,954,910 16108964.3 17,786,357 17401126.3 14,408,817 17670787.8 14,374,254 15387408.2 13,258,104 14678200.3 15,182,616 13684132.9 6 Year 2 7 Year 2 January February March 8 Year 2 9 Year 2 April May o Year 2 1 Year 2 June 2 Year 2 3 Year 2 July August September 4 Year 2 5 Year 2 October 6 Year 2 November 7 Year 2 December