Details of this Paper

In Module 1, you completed an Airline Data Assignm...

Description

Solution


Question

In 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 following items: Mean Median Mode Standard Deviation Variance Minimum and maximum For 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 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 equal to the mean for the industry for monthly load factors, monthly revenue passenger miles, and monthly available seat miles

 

Paper#13456 | Written in 18-Jul-2015

Price : $25
SiteLock