Module 1, you completed an Airline Data Assignment. For this activity, collect
the same data for a different U.S. carrier, clean the data, and calculate the
both airlines, (recall you already collected data on one airline in Module 1
and an additional airline as part of this assignment), 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 not equal for the two airlines (use alpha of 0.05). In addition,
using the results from module 1 where you calculated the summary statistics for
the items listed, test if the mean for each airline is not equal to the mean
for the industry for monthly load factors, monthly revenue passenger miles, and
monthly available seat miles.
completing the above items, prepare a brief (one to two 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? Your write-up should
also include a brief discussion identifying where the data was obtained from.
Cite sources and format your document in accordance with the current edition of
the APA Manual.
sure to include summary tables of summary statistics and a table summarizing
the test results. Refer to the readings from Module 1 and the APA manual for
formatting issues. Turn in two files for this assignment. One should include
the write-up and the other the data and analysis.
the following convention when naming files: