Statistics Assignment - Group-based Assignment

Airline On-time Arrival Performance

ABC Airlines is an airline company operating in the Asia Pacific region. Recently, Mr. Tan has been appointed the operations manager who looks into the on-time arrival of air lines between Singapore and China. He retrieved monthly on-time arrival performance records for the period 2000-2015 for two randomly chosen lines. One is flying from Singapore to China and the other is flying from China to Singapore. Mr. Tan engaged you as a consultant to analyse the on-time arrival performance data and examine whether flights from Singapore to China have a better on-time arrival performance than flights from China to Singapore.

You are provided with the monthly record of the on-time arrival rates for two randomly chosen flights flying between Singapore and China for the year 2000-2015. Please use the Excel software and the data file "Airline_Arrival_Time_Data_for_Students.xlsx" to answer the following questions:

Question 1 -

Compare the on-time arrival rate of the two lines flying between China and Singapore. Use descriptive statistics to describe the on-time arrival rate of the two lines. Identify the measures of location and dispersion. Interpret your preliminary observations.

 Question 2 -

(a) State and interpret 95% confidence intervals for the on-time arrival rate of the two lines.

(b) State and interpret 99% confidence intervals for the on-time arrival rate of the two lines. 

(c)  Briefly describe the key assumption(s) you have made in constructing confidence intervals. Discuss if this/these assumption(s) is/are reasonable.

(d) Interpret and explain why the 99% and 95% confidence intervals are different.

(e) With the confidence intervals, state whether or not you can conclude that the on-time arrival rates of the two lines are different.

Question 3 -

Select an appropriate test of hypothesis to determine if the mean on-time arrival rate is different between the two lines.

You should include the following:

(a) State the null and alternative hypotheses and explain how you develop these two hypotheses. 

(b) Execute the hypothesis testing with α = 0.05 using Excel. Present and list the test statistic you use for this test. Explain your decision criteria.

(c) Discuss the assumptions you have made in performing the test. Are these assumptions reasonable? Please provide explanations.

Qestion 4 -

(a)  If you have a free hand on the project starting from sampling to analysis, how would you conduct the project analysis and what recommendations would you give for the problem in question? Please keep your answer within 500 words (indicate your word count).

(b) Provide an executive summary of your analysis and findings to Mr. Tan within 300 words (indicate your word count).