- Saved Search (Option + Q) Excel template Draw Page Layout Formulas Data Review View Help Editing v File Home Insert 00 Arial 10 B A ap General -0 H16 fx E G B C D F AirTran Southwest Parts b&c 36 61 31 29 38 90 67 91 118 31 38 35 86 88 101 53 43 73 71 103 81 82 Part d 0.05 108 26 Significance Level (Alpha) Formula 20 59 67 Can we reject the null hypothesis? #N/A 103 Enter "Can" or "Cannot" 21 110 22 112 23 105 24 53 25 97 26 106 Data maculanon Mode: Automatic Workbook Statistics 23 2 7laysis Too Pak (Structured) 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 following questions. delayed flights were late are provided in the Excel Online file below. Data are shown for both airlines. Construct a spreadsheet to answer the X 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 #42 = population mean minutes late for delayed Southwest flights Ho : 11 - 142 =0 0 H1:1-/2 050 b. What is the sample mean number of minutes late for delayed flights for each of these two airlines? AirTran 63.8 (to 2 decimals) Sputhwest 67.6 (to 2 decimals) c. Using a .05 level of significance, what is the p-value and what is your conclusion? p-value is (to 4 decimals) We cannot @) () reject Ho. Next Autosaved at 4:25 PM Bac 23