Airline Data Assignment.
Airline Data Assignment. For . For this activity, for Southwest Airlines (just like for Alaska Airline) calculate following:
• Mean
• Median
• Mode
• Standard Deviation
• Variance
• Minimum and maximum
For both airlines (Alaska and Southwest), construct 95 percent confidence intervals (alpha would equal what in this case?) for monthly load factors, monthly revenue passenger miles, and monthly available seat miles (Domestic flights only). There is a function in Excel that will calculate the confidence interval that needs to be added and subtracted from the mean to determine the 95 percent confidence interval. Develop the appropriate null and alternate hypotheses and test if the monthly load factors, monthly revenue passenger miles, and monthly available seat miles are equal for the two airlines (use alpha of 0.05). In addition, where you calculated the summary statistics for the items listed, test if the mean for each airline is equal to the mean for the industry for monthly load factors, monthly revenue passenger miles, and monthly available seat miles.
After completing the above items, prepare a brief, one page write-up of the analysis completed above. Items to include in your write-up include how a given airline is performing relative to industry and whether the results are consistent with expectations. For example, would you expect a single airline's available seat miles to be equal to the entire industry's? Cite sources and format your document in accordance with the current edition of the APA Manual.
Note: This week, you're asked to test if the mean for each airline is equal to the mean for the industry for monthly load factors, monthly revenue passenger miles, and monthly revenue miles. You won't be able to do this by "just" calculating the mean values (relying on descriptive statistics). Instead, some t-tests are in order... These might include using t-test paired two-sample for means and two-sample assuming equal variances first, then running some more t-tests two-sample assuming unequal and equal variances...
P.S. The final product should be one page word document (don’t worry about formatting) and a single Excel files with all the data.
Attached files:
- “Data1” is Alaska Airlines data, and industry combined data.
- “Data 2” is Southwest Airlines data.
Data for Alaska Airlines (Domestic Fights)
Year Month Load Factor Revenue Passenger-Miles Available Seat-Miles Load Factor Revenue Passenger-Miles Available Seats-Miles
2006 1 67.29 1,030,286 1,531,160
2006 2 72.59 1,015,301 1,398,584 Mean 80.37011905 Mean 1476562.262 Mean 1825129.012
2006 3 78.39 1,249,308 1,593,802 Median 81.12 Median 1471640.5 Median 1826333.5
2006 4 78.51 1,215,157 1,547,705 Mode 77.14 Mode #N/A Mode #N/A
2006 5 77.14 1,294,314 1,677,858 Standard Deviation 5.508243656 Standard Deviation 268992.6244 Standard Deviation 224463.5008
2006 6 81.78 1,451,437 1,774,704 Sample Variance 30.34074818 Sample Variance 72357031976 Sample Variance 50383863197
2006 7 83.02 1,543,717 1,859,552 Minimum 65.38 Minimum 993212 Minimum 1398584
2006 8 80.86 1,512,930 1,870,952 Maximum 88.84 Maximum 2138659 Maximum 2415462
2006 9 74.33 1,242,360 1,671,371
2006 10 72.12 1,193,924 1,655,579
2006 11 75.86 1,147,487 1,512,645
2006 12 75.68 1,191,751 1,574,736
2007 1 65.38 1,016,525 1,554,778
2007 2 69.7 993,212 1,425,027
2007 3 77.07 1,239,721 1,608,476
2007 4 77.08 1,234,460 1,601,483
2007 5 77.03 1,374,728 1,784,638
2007 6 81.81 1,529,083 1,869,017
2007 7 83.87 1,622,310 1,934,333
2007 8 83.79 1,605,686 1,916,375
2007 9 72.38 1,266,186 1,749,398
2007 10 71.98 1,248,268 1,734,074
2007 11 76.86 1,235,535 1,607,424
2007 12 75.56 1,276,917 1,689,845
2008 1 67.65 1,136,603 1,680,095
2008 2 72.73 1,155,905 1,589,392
2008 3 80.52 1,391,856 1,728,567
2008 4 76.57 1,295,835 1,692,333
2008 5 77.25 1,417,675 1,835,235
2008 6 79.33 1,513,644 1,907,917
2008 7 79.41 1,613,122 2,031,343
2008 8 82.29 1,619,020 1,967,467
2008 9 76.13 1,308,626 1,718,825
2008 10 73.83 1,282,112 1,736,486
2008 11 76.23 1,203,171 1,578,398
2008 12 80.54 1,260,445 1,565,025
2009 1 70.46 1,124,778 1,596,392
2009 2 72.27 1,069,488 1,479,875
2009 3 81.37 1,331,161 1,635,883
2009 4 78.72 1,260,381 1,600,995
2009 5 77.73 1,368,136 1,760,038
2009 6 80.87 1,505,740 1,861,946
2009 7 84.19 1,670,102 1,983,765
2009 8 83.98 1,660,587 1,977,418
2009 9 77.9 1,358,088 1,743,430
2009 10 77.14 1,361,880 1,765,558
2009 11 79.89 1,295,668 1,621,791
2009 12 83.51 1,386,474 1,660,204
2010 1 76.83 1,256,227 1,635,075
2010 2 79.02 1,160,514 1,468,673
2010 3 83.96 1,438,164 1,712,942
2010 4 82.23 1,376,402 1,673,863
2010 5 80.73 1,491,844 1,847,871
2010 6 84.29 1,698,004 2,014,396
2010 7 87.12 1,851,534 2,125,380
2010 8 86.16 1,822,069 2,114,715
2010 9 81.6 1,521,578 1,864,755
2010 10 81.55 1,552,895 1,904,168
2010 11 83.96 1,525,845 1,817,432
2010 12 85.55 1,613,829 1,886,451
2011 1 79.86 1,494,244 1,871,075
2011 2 81.54 1,402,431 1,719,940
2011 3 87.53 1,725,990 1,971,951
2011 4 84.58 1,634,701 1,932,680
2011 5 84.38 1,672,044 1,981,667
2011 6 85.23 1,817,401 2,132,425
2011 7 88.13 1,942,594 2,204,353
2011 8 88.1 1,932,091 2,193,126
2011 9 84.31 1,658,962 1,967,684
2011 10 82.41 1,632,096 1,980,578
2011 11 86.47 1,634,132 1,889,756
2011 12 87.26 1,709,330 1,958,881
2012 1 83.44 1,593,394 1,909,650
2012 2 84.26 1,547,996 1,837,114
2012 3 88.84 1,815,067 2,043,057
2012 4 87.3 1,761,173 2,017,431
2012 5 86.77 1,885,045 2,172,447
2012 6 87.87 2,027,915 2,307,747
2012 7 88.54 2,138,659 2,415,462
2012 8 88.82 2,114,901 2,381,048
2012 9 84.27 1,764,585 2,093,965
2012 10 85.22 1,782,880 2,092,208
2012 11 86.23 1,825,783 2,117,331
2012 12 86.14 1,887,811 2,191,646
Note: All numbers are for scheduled services.
SOURCE: Bureau of Transportation Statistics T-100 Segment data.
Data For SouthWest Airlines (Domestic Flights)
Year Month Load Factor Revenue Passenger-Miles Available Seat-Miles
2006 1 63.39 4,759,328 7,507,719
2006 2 68.46 4,689,999 6,850,387
2006 3 75.52 5,832,625 7,723,677
2006 4 76.75 5,734,094 7,471,419
2006 5 76.78 5,959,988 7,762,000
2006 6 80.38 6,151,375 7,653,128
2006 7 79.49 6,330,623 7,963,876
2006 8 77.14 6,241,206 8,091,256
2006 9 67.2 5,196,914 7,733,114
2006 10 70.07 5,699,554 8,134,336
2006 11 71.83 5,594,810 7,788,504
2006 12 68.91 5,507,054 7,992,104
2007 1 63.79 5,179,612 8,120,276
2007 2 66.77 4,845,967 7,257,974
2007 3 73.31 6,084,978 8,299,782
2007 4 72.32 5,922,529 8,188,976
2007 5 74 6,268,874 8,471,785
2007 6 82.12 6,829,087 8,316,418
2007 7 81.49 7,049,832 8,651,642
2007 8 80.02 6,996,146 8,743,212
2007 9 67.7 5,641,492 8,332,777
2007 10 70.45 6,034,766 8,566,372
2007 11 69.27 5,743,016 8,290,441
2007 12 68.16 5,729,062 8,405,032
2008 1 64.16 5,485,755 8,549,774
2008 2 68.63 5,427,923 7,908,752
2008 3 76.45 6,679,996 8,737,757
2008 4 72.59 6,261,889 8,626,155
2008 5 74.85 6,673,213 8,914,990
2008 6 78.19 6,878,063 8,796,286
2008 7 76.26 6,885,829 9,029,153
2008 8 74.65 6,630,644 8,882,898
2008 9 63.36 5,307,897 8,377,266
2008 10 70.44 6,208,087 8,812,910
2008 11 63.22 5,263,646 8,325,997
2008 12 69.66 5,794,863 8,319,052
2009 1 62.84 5,135,786 8,173,240
2009 2 69.06 5,104,809 7,392,029
2009 3 77.28 6,652,325 8,608,468
2009 4 77.01 6,518,347 8,464,220
2009 5 74.6 6,434,844 8,625,660
2009 6 79.52 6,731,754 8,465,165
2009 7 83.19 7,241,252 8,704,363
2009 8 80.22 6,694,359 8,344,604
2009 9 74.73 5,772,446 7,724,146
2009 10 79.19 6,325,701 7,987,848
2009 11 76.49 5,879,633 7,686,684
2009 12 76.23 5,971,146 7,833,493
2010 1 72.14 5,499,522 7,623,253
2010 2 73.85 4,986,653 6,752,063
2010 3 80.97 6,676,884 8,246,141
2010 4 78.84 6,477,921 8,216,168
2010 5 77.21 6,663,190 8,629,925
2010 6 81.91 7,066,591 8,627,773
2010 7 84.86 7,487,851 8,824,147
2010 8 82.32 7,121,888 8,651,296
2010 9 75.02 6,064,743 8,084,158
2010 10 81.66 6,851,571 8,390,686
2010 11 80.06 6,507,372 8,128,186
2010 12 80.38 6,648,476 8,271,141
2011 1 75.98 6,226,692 8,194,821
2011 2 76.91 5,637,059 7,329,754
2011 3 81.64 7,333,522 8,983,040
2011 4 79.73 7,040,746 8,830,705
2011 5 82.26 7,376,736 8,967,697
2011 6 83.5 7,693,494 9,213,327
2011 7 84.24 7,959,749 9,449,179
2011 8 82.04 7,410,355 9,032,844
2011 9 78.4 6,555,140 8,361,498
2011 10 81.49 7,160,845 8,787,557
2011 11 81.98 6,722,204 8,200,277
2011 12 79.62 6,735,640 8,459,860
2012 1 75.58 6,098,636 8,069,338
2012 2 76.1 5,958,452 7,830,030
2012 3 82.01 7,456,229 9,092,279
2012 4 79.84 7,110,856 8,905,826
2012 5 81.19 7,420,748 9,140,381
2012 6 83.92 7,857,612 9,363,248
2012 7 84.02 8,213,921 9,776,175
2012 8 84.26 7,830,148 9,292,593
2012 9 77.47 6,601,592 8,520,944
2012 10 80.74 7,239,910 8,967,408
2012 11 80.11 6,880,189 8,588,630
2012 12 78.1 6,901,860 8,836,776
SOURCE: Bureau of Transportation Statistics T-100 Segment data.
11 years ago
Purchase the answer to view it
answer.zip
