You may need to use the appropriate technology to answer this question.Researchers at two universities found that airlines are doing a better job of getting passengers to their destinations on time. Company A and Company B Airlines were among the leaders in on-time arrivals with both having 88% of their flights arriving on time. But for the 12% of flightsthat were delayed, how many minutes were these flights late? Sample data showing the number of minutes that delayed flights were late are shown below for both airlines. Use Excel to run a two-sample t-test assuming unequal variances to answer the questions.Company ACompany B3459 43 303466541 34 653242 85 30481054628 398511050 10 267074463349625283 78 277043343263 642790 38 5276(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. (Let u, = population mean minutes late for delayed Company A flights and u, = population mean minutes late for delayed CompanyB flights.)H3: H1 - H2> 0Hn: 4 - 4, - 00 5 2H - IH :°HO Ho: H1 - H2 2 0H3i H1 - H2 < 0O Ho: H1 - H2 < 0Hai Hy - Hz = 0O Ho: H1 - H2 = oH: H1- H2 = 0(b) What is the sample mean number of minutes late for delayed flights for each of these two airlines? (Round your answers to two decimal places.)Company AminCompany Bmin(c) Calculate the test statistic. (Round your answer to three decimal places.)What is the p-value? (Round your answer to four decimal places.)p-value = Using a 0.05 level of significance, what is your conclusion?O Reject H.. There is no statistical evidence that one airline does better than the other in terms of their population mean delay time.Do not Reject H.. There is statistical evidence that one airline does better than the other in terms of their population mean delay time.O Do not reject Ho. There is no statistical evidence that one airline does better than the other in terms of their population mean delay time.O Reject H. There is statistical evidence that one airline does better than the other in terms of their population mean delay time.

Name: You may need to use the appropriate technology to answer this questio
Uploaded: 2024-03-20T07:06:27.000Z
Channel: Bartleby
Description: You may need to use the appropriate technology to answer this question.Researchers at two universities found that airlines are doing a better job of getting passengers to their destinations on time. Company A and Company B Airlines were among the le