In: Statistics and Probability
Statistice inferential question
3. [] The executive is also worried that the bank is losing ground to its major competitor, the Everglades Bank. So the bank executive asked you to determine whether Everglades Bank processes mortgages faster than First National. To conduct this hypothesis test you also collect a random sample of 108 mortgage processing times from Everglades Bank. These data are also located in your Excel file. a) Should your alternative be left-sided, right-sided, or two-sided? Explain. b) State your null and alternative hypotheses using correct symbols and notation. Make sure to clearly identify the populations. c) Conduct a two-sample t-test for comparing the difference between two means. Include Excel calculations in your Word document. d) State the P-value and give the conclusion in context using a significance level of 0.05.
Data to use here :
Number of Days to Process Mortgage Applications
First National 7 8 2 5 6 7 6 4 8 2 5 9 6 3 7 6 7 9 8 8 5 8 5 6 6 9 7 10 8 9 6 6 11 5 7 4 7 6 12 7 10 5 6 6 6 5 4 4 8 9 3 3 10 5 3 11 7 5 6 2 9 13 7 7 6 4 5 9 3 9 9 8 5 7 2 5 10 11 8 10 5 7 4 14 8 4 7 6 8 5 8 2 5 5 8 6 9 6 5 11 9 6 6 8 12 8 10 6
Everglades Bank 4 8 7 4 5 4 10 10 3 9 8 4 8 9 8 9 8 3 8 4 4 7 6 7 10 9 10 3 9 3 7 7 9 9 5 7 6 9 7 5 4 7 7 10 5 8 3 8 5 5 3 6 2 4 7 2 7 3 4 8 5 5 9 5 6 5 8 7 4 7 2 6 2 6 10 6 2 8 5 8 7 10 9 5 10 4 6 3 7 12 8 5 6 6 8 8 4 4 8 6 6 6 7 11 3 7 7 4