logo

Evaluating Airlines Frequencies and Passenger Satisfaction of Australian International Airports

This assignment involves collecting and analyzing data to answer a specific business problem related to airline services in Australia. The task requires using two datasets and applying statistical theories to solve the problem and make recommendations to improve airport services. The assignment includes displaying appropriate outputs of Excel, StatKey, or Wolfram Alpha and writing an executive summary.

10 Pages2222 Words238 Views
   

Added on  2023-04-23

About This Document

This article analyses the frequencies of airlines and passenger satisfaction in Australian airports, with a focus on Sydney, Melbourne, and Brisbane. The study uses two datasets, one consisting of flight information and the other of traveller feedback. The article includes graphical displays and hypothesis tests to draw conclusions and suggest improvements for the airports.

Evaluating Airlines Frequencies and Passenger Satisfaction of Australian International Airports

This assignment involves collecting and analyzing data to answer a specific business problem related to airline services in Australia. The task requires using two datasets and applying statistical theories to solve the problem and make recommendations to improve airport services. The assignment includes displaying appropriate outputs of Excel, StatKey, or Wolfram Alpha and writing an executive summary.

   Added on 2023-04-23

ShareRelated Documents
Evaluating Airlines frequencies and Passenger satisfaction of Australian
International Airports (Sydney, Melbourne, and Brisbane)
1
Evaluating Airlines Frequencies and Passenger Satisfaction of Australian International Airports_1
Section 1: Introduction
a. Introduction about the Assignment
The development of areas for transit development in the Australian context is hampered by a
number of obstacles. The main challenges to be addressed are the consolidation of the security
around airports and the lack of express check in mechanism to facilitate the overall experience. This
article identifies key factors that contribute to the effective comparison of three major Australian
airports. This article is based on an analysis of case studies in Melbourne, Brisbane, and Sydney.
Based on semi-targeted interviews with the travellers, the framework for commercial planning and
mechanisms to facilitate clean airport premises has been analysed. In addition, the scholar conducts
stakeholder survey to assess the results of the overall implementation process and different
standards. The study found check-in-experience, waiting facilities, options in Shopping, choices in
eateries, cleanliness of airport premises, and helpful airport staffs to be the deciding factors of
overall experience with the airport. Sydney airport was found to be the leading airport from
customer review, with maximum number of traffic.
b. Dataset 1: Short Description
The first data set consisted of the secondary information on flights from 73 airlines flying in and out
within a period of 2003 September to 2018 September for 12 Australian airports. Eight more
nominal variables were used to describe Australian city (airport), International Destination City,
Airline Route, Port Country, Port Region, Service Country, and Service Region. Three numerical
variables were used to define number of Stops, total Flights in every route, and Maximum number of
Seats in a route. The dataset was used to scrutinize the average number of flights flying in and out of
Australia. Also, flight frequency in Melbourne, Brisbane, and Sydney airports were compared for Air
New Zealand, Singapore Airlines, and Cathy Pacific Airways carriers.
c. Dataset 2: Collection of Data its Limitation
An online survey was conducted to collect primary data on travellers’ feedback about overall
satisfaction in Melbourne, Brisbane, and Sydney airports. The survey was conducted in convenience
sampling methodology with a cross-sectional approach. Choice of convenience sampling technique
generated a probable bias due to exclusion of all stakeholders in the response of 50 travellers. 15
categorical variables and one continuous variable (Number of passengers travelling) were used to
describe the dataset. The best airport was chosen based on check-in-experiences, adequate waiting
seats, options in shopping, cleanliness of Airport premises, arrival experience, and ground staffs’
behaviour.
Section 2: Analysis of single variable in Dataset 1
a. Shape of the Distribution
From Figure 1, distribution of the “All flights” variable was identified to be highly right skewed (S =
2.27) due to presence of outlier observations, which indicated heavy traffic at few airports in certain
months. From Figure 2, Sydney airport was found to be the busiest airport with 381 flight routes
(FR), followed by Melbourne (FR = 212) and Brisbane (FR = 187). Presence of outliers in the
distribution was the primary reason for a high standard deviation, where the range of the variable
varied from a single flight to 151 flights operating on a certain route.
2
Evaluating Airlines Frequencies and Passenger Satisfaction of Australian International Airports_2
Figure 1: Histogram for "All Flights" Variable
Figure 2: Histogram for "All flights" based on Australian Cities
“All Flights” was the number of flights operating in a certain month of a year on a particular air
route. The average number of flights operating in a month on a certain route for the time period of
2003 September to 2018 September was 24.53 (SD = 19.97). The scholar also wanted to find the
average number of flights operating in a month from a particular airport, as well as overall average
number of flights operating in a month in Australia. From Figure 4, average number of flights
operating for a particular Australian city was found to be 43.79 (SD = 38.46), and from Figure 5 the
overall average for flights coming in and flying out was noted to be 150.47 (SD = 82.70).
b. Average Number of total flights came in and flew out to Australia in a Month
Total number of total flights per city from 2003 (Sep) to 2018 (Sep) was found to be right skewed
with presence of numerous outlier observations. Due to sample size (n > 30) of 560 (city/month),
using Central Limit Theorem the variable was assumed to follow a normal distribution. Flights
operated between an Australian city and an International city. Hence the observations were random
and independent in nature.
3
Evaluating Airlines Frequencies and Passenger Satisfaction of Australian International Airports_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Comparison of Sydney, Brisbane and Melbourne Airports with Air New Zealand, Cathay Pacific and Singapore Airlines
|18
|2001
|490

Analysis of Australian airline data
|12
|1638
|50

Analysis of International Flights in Australia
|9
|1734
|256

Analysis of Single and Two Variables in Aviation Industry Dataset
|15
|2790
|62

HC2112 - Services Marketing & Relationship Marketing - Virgin Blue Airlines
|8
|1650
|63

Analysis of Aviation Industry in Australia
|9
|1558
|411