Airline Data Assignment

Airline Data Assignment 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.