Why might any seasonality come about? What measures could you use to quantify the seasonality in the data? Discuss why Qantas domestic RASK may increase or decrease over time? Discuss the impact of COVID-19 on the time series movements in Qantas Domestic RASK.

Individual assignment: Analysis of Qantas Group Data
Analysis of Qantas Group Data
In your AVIA 1901 UNSW Moodle site under Individual Assignment you will find the dataset in Microsoft Excel entitled “Individual Assignment Data”. This dataset consists of semi-annual observations on a variety of Qantas and Jetstar operational and financial metrics, with the definition of each variable and its units of measurement, presented in row 1 of the Excel spreadsheet. You are to use that dataset to answer the following three questions.
Calculate Qantas domestic RASK in Australian cents per ASK for the semi-annual period December 2011 to June 2021. Use this data to construct a line graph in Microsoft Excel and paste this graph into your answer word document.

You will be marked on the quality of the graph you present. Ensure you have properly labelled relevant axes. Describe the seasonality in the data.

Why might any seasonality come about? What measures could you use to quantify the seasonality in the data? Discuss why Qantas domestic RASK may increase or decrease over time? Discuss the impact of COVID-19 on the time series movements in Qantas Domestic RASK.