Statistical Analysis - Airlines Baggage Performances

CONTEXT Anyone who travels by air knows that occasional problems are inevitable. Flights can be delayed or cancelled due to weather conditions, mechanical problems, or labor strikes, and baggage can be lost, delayed, damaged, or pilfered. Given that many airlines are now charging for bags, issues with baggage are particularly annoying. Baggage problems can have a serious impact on customer loyalty, and can be costly to the airlines (airlines often have to deliver bags). Air carriers report flight delays, cancellations, overbookings, late arrivals, baggage complaints, and other operating statistics to the U.S. government, which compiles the data and reports it to the public. TASK AT HAND Do some airlines do a better job of handling baggage? Compare the baggage complaints for three airlines: American Eagle, Hawaiian, and United. Which airline has the best record? The worst? Are complaints getting better or worse over time? Are there other factors, such as destinations, seasonal effects or the volume of travelers that affect baggage performance? The Dataset “Complaints” The data set contains monthly observations from 2004 to 2010 for United Airlines, American Eagle, and Hawaiian Airlines. The variables in the data set include: -Baggage: The total number of passenger complaints for theft of baggage contents, or for lost, damaged, or misrouted luggage for the airline that month -Scheduled: The total number of flights scheduled by that airline that month -Cancelled: The total number of flights cancelled by that airline that month -Enplaned: The total number of passengers who boarded a plane with the airline that month STATISTICAL/GRAPHICAL TOOLS TO BE USED Summary statistics, rates calculation to carry out proper baggage-handling performance comparisons, and time series plots. Goal is to Create a Microsoft word document that analyses the three airlines with the excel information given to us and NO OUTSIDE INFORMATION. In the document, we have to have pie charts, histograms, scatter plots, time series plots, baggage performances index among all airlines comparing and contrasting them as well as showing evidence with data that proves which one will eventually be the top performer in the airline industry, particularly in the future. You MUST have rates calculation on all levels and It MUST BE MASTERS STANDARD.