Applying Statistics to Solve Traffic Congestion in Australian Cities

<Student Name> <Student ID>
University
Apply Statistic to Technology Problem
By
Your Name
Date
Page 1 of 5
© < Your Name> 9/12/2018
Unit Code:

<Student Name> <Student ID>
Part B: Practical Activity
Part C: Written Question
Research
Over the past few years, Australia has been faced by the problem of traffic congestion within
most of its town centers. This has been attributed to the high urban population growth rate as
well as the high rate of rural to urban migration (Zmud, Munizaga and Carrasco, 2013). The
Australian government through the parliament and the ministry of transport has noted this
disaster and has requested that research be undertaken to determine the mode of transport that is
most preferred by the citizens so that in the next budget it can allocate funds to develop the
infrastructure for this mode of transport. Additionally, the government has been noted that there
is need to completely curb the traffic congestion within its cities and the only way to do so is to
develop underground railway transport from can various railway stations. Therefore, it has also
requested a research to be carried out to determine from which selected station the underground
railway should be constructed. The purpose of the research is therefore to carryout statistical
analysis on available data to provide information of the commonly used mode of transport and
the station from which the underground railways station should be constructed.
Secondary type of data obtained from the Australian transport website is used for analysis. The
sample data used is part of the “Opal Tap on and Tap Off Location” provided by the NSW open
data (Opendata.transport.nsw.gov.ac, 2016). Only three variables are used in analysis of the data
namely: mode (categorical variable indicating the mode of transport used), location (categorical
variable indicating the railway station), and count (numerical variable indicating the count for the
mode of transport). The information required from the data is the most preferred mode transport
among the citizens and the most congested railway station of the selected stations so that the
underground station can be built from there. The techniques used in the analysis will be
determination of proportion and construct a pie chart to indicate the most preferred mode of
transport and a create a bar chart to indicate the railways station that serves more people and
hence deserves the underground rail. The computation devices used are; computer with excel
software, writing material, and a calculator. The deficiencies that that were found in the data
Page 2 of 5
© < Your Name> 9/12/2018
Unit Code: