Researchers at Purdue University and Wichita State University found that airlines are doing a better job of getting passengers to their destinations on time. AirTran Airways and Southwest Airlines were among the leaders in on-time arrivals with both having 88% of their flights arriving on time. But for the 12% of flights that were delayed, how many minutes were these flights late? Sample data showing the number of minutes that delayed flights were late are provided in the Excel Online file below. Data are shown for both airlines. Construct a spreadsheet to answer the following questions.

/1 = population mean minutes late for delayed AirTran flights /2 = population mean minutes late for delayed Southwest flights Ho : /1 - #2 H1 : /1 - /2 0\f\fResearchers at Purdue University and Wichita State University found that airlines are doing a better job of getting passengers to their destinations on time. AirTran Airways and Southwest Airlines were among the leaders in on-time arrivals with both having 88% of their flights arriving on time. But for the 12% of flights that were delayed, how many minutes were these flights late? Sample data showing the number of minutes that delayed flights were late are provided in the Excel Online file below. Data are shown for both airlines. Construct a spreadsheet to answer the following questions. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak Open spreadsheet a. Formulate the hypotheses that can be used to test for a difference between the population mean minutes late for delayed flights by these two airlines. {1 = population mean minutes late for delayed AirTran flights {ta = population mean minutes late for delayed Southwest flights Hy:pp =80 H:pmm B8P0 b. What is the sample mean number of minutes late for delayed flights for each of these two airlines? AirTran 6204 () (to 2 decimals) Southwest 64.05 @' (to 2 decimals) c. Using a .05 level of significance, what is the p-value and what is your conclusion? p-value is 0.8198 0 (to 4 decimals) We cannot @ reject Hy