Your airline would like to initiate service between SLC and JFK. The scheduling department has asked you
Fantastic news! We've Found the answer you've been seeking!
Question:
Your airline would like to initiate service between SLC and JFK. The scheduling department has asked you to look at the average scheduled block times (scheduled arrival - scheduled departure) used by existing carriers in the market, JetBlue (B6) and Delta (DL), to determine the optimum block duration as it relates to arrival variance (actual arrival - scheduled arrival), A0 (% of flights arriving on time or early) and A14 (% of flights arriving less than 15 minutes late). Download the data here Download Download the data here and analyze it using Microsoft Excel as required to answer the questions.
Mktcarrier | Year | Avg. Sched_Block | Avg. Arrivalvariance | A0% | A14% |
JetBlue (B6) | 2013 | 373.4 | 19.3 | 42.5% | 62.0% |
2014 | 373.0 | 14.1 | 49.4% | 76.5% | |
2015 | 372.9 | 11.7 | 48.0% | 69.7% | |
2016 | 375.1 | 23.3 | 34.6% | 55.3% | |
Delta (DL) | 2013 | 385.5 | 0.4 | 70.0% | 85.9% |
2014 | 382.7 | 5.3 | 65.1% | 81.9% | |
2015 | 383.0 | 5.6 | 59.5% | 80.3% | |
2016 | 388.3 | -1.6 | 69.2% | 86.0% |
What is the probability that scheduled block is unreliable (the null hypothesis cannot be rejected) in predicting A14?
Related Book For
Posted Date: