Reference no: EM13626275

Collect cumulative data for all U.S. major carriers for the time period of January 2006 through December 2012. The data you collect should include monthly load factors, monthly revenue passenger miles, and monthly available seat miles (Domestic flights only).

Once you have collected the data, clean the data as necessary (i.e. sometimes monthly data will include a total for each year in the data set). If you keep the annual total in the data set it could skew some of your results. Also, remember the question asks for domestic data only. For the period in question calculate the following summary statistics for each data item collected:

• Mean
• Median
• Mode
• Standard Deviation
• Variance
• Minimum and maximum

Create a scatter plot for all of the US airline data with revenue passenger miles on the y-axis and load factor on the x-axis. Do the same for the individual airline you have selected. Make sure your scatter plot includes a title of the plot, labels the x and y-axis with appropriate titles, and uses appropriate scales for each axis (refer to your textbooks for examples).

After completing the above items, prepare a brief (three to four paragraph) discussion of the summary statistics, perceived relation between load factor and revenue passenger miles (if any), how your selected airline appears to be performing relative to the industry, and any other information you can glean from the data collected. Your write-up should also include a brief discussion identifying where the data was obtained from. Ensure sources are cited and formatted in accordance with current APA format.