Analysis of Australian airline data

A i r l i n e d a t a | 1
ANALSIS OF AUSTRALIAN AIRLINE DATA

A i r l i n e d a t a | 2
Executive summary
This report describes the characteristics and distribution of airline data for Australian
airports in order to provide a recommendation for Sydney Airport. Several tools such as
regression analysis, correlation, scatter plots and frequency histograms are used for the analysis.
Results of the analysis have shown that Sydney airport performs better than Melbourne and
Brisbane airports in terms of the flights coming and getting out of the airport. However, for
Sydney to outdo its competitors, it should make efforts to chatter more Air New Zealand planes
and expand the scope of operation of the airline in order to dominate in terms of the number of
flights coming and getting out of the airport.

A i r l i n e d a t a | 3
Table of Contents
Introduction.................................................................................................................................................2
Analysis of single variable in dataset 1........................................................................................................2
Analysis of two variables.............................................................................................................................4
Analysis of dataset 2....................................................................................................................................7
Discussion and conclusion...........................................................................................................................8

A i r l i n e d a t a | 4
Introduction
This report aims to describe the characteristics and distribution of flights in Australia
between the time period September 2003 to September 2018. Analysis is carried out on airline
services data of Australia and compared to the findings of (Assaf, 2010) and (Malcolm Abbott,
2012)in order to make a recommendation on improvement of airport services to the airline. The
following research questions guided the study;
i. What is the shape of the distribution of the variable All Flights?
ii. Is the average number of flights coming in and flying out to Australia in a month between
September 2003 and September 2018 more than 30?
iii. Is there association between Australian City and Airlines?
In order to answer these research questions, two datasets were used, dataset 1 and dataset 2.
Dataset 1 consists of secondary data on airline services for an Australian airline. The dataset
consists of both qualitative and quantitative data.
Dataset 2 consist of primary data on KOI student flying experience in and out through
airports in Sydney, Melbourne and Brisbane. Dataset 2 was collected through an online survey.
Both qualitative and quantitative variables were collected from the online survey. An online
survey was used because it saves on time and costs. However, a challenge that was experienced
is a slow response rate was experienced since respondents answered the questions at their own
time of will. Another limitation was the possibility of obtaining a biased sample since there was
no way of selecting the sample to participate in the study.