You are required to prepare a report on the number of passengers through Cork Airport. Utilizing data from the Central Statistics Office (CSO) on the number of passengers through Cork Airport from Quarter 1 2012 to Quarter 4 2019, generate a report which includes the following points:

(a) A graph of the number of passengers through Cork Airport from Quarter 1 2012 to Quarter 4 2019. Calculate a centered moving average to smooth the data and include it in the graph.

(b) Based on the graph generated in part (a), describe the trend in the data and explain why this trend may be occurring. Use evidence to support your argument.

(c) Based on the graph generated in part (a), describe the seasonal pattern observed in the data and explain why this seasonal pattern may be occurring. Use evidence to support your argument.

(d) Based on your answers to the previous parts, as well as your knowledge of the Irish economy, discuss the importance of Cork airport for the local economy. Support your answer with evidence from existing literature.

Data are posted on Canvas.
Answer all parts.
All graphs are to be carried out in Microsoft Excel. The assignment is to be presented in a Microsoft Word document.
Assignments should be presented in a report format i.e. have an introduction, main body and conclusions, followed by references and appendices (appendices are optional).
This is an individual assignment. High marks are awarded for excellent (i) descriptions (including graphical and written) of the trend and seasonal pattern in the data presented and explanations as to why they may be occurring; (ii) understanding of the importance of Cork airport for the local economy (iii) use of relevant literature to support claims that are being made and (iv) professional presentation (including writing style, layout, citation/referencing).

Assignments are to be word processed (double spaced with 12cpi) and to include a word count. The maximum word count is 1500 words (excluding the reference list and appendices) – a penalty of 1% per 100 words over this limit will be applied. All assignments should include a cover page as per checklist attached. Any literature or data used must be cited and referenced correctly. See the style guide posted on Canvas for correct citation and referencing.