A branch located in a commercial district of a city has the business

A branch located in a commercial district of a city has the business objective of developing an improved process for serving customers during the noon-to-1:00 pm lunch period. Management decides to first study the waiting time in the current process. The waiting time is defined as the number of minutes that elapses from when the customer enters the line to when he or she reaches the teller window. Data are collected from a random sample of 15 customers. Suppose a competitor's branch located in a residential area is also concerned with the same business objective. Data are collected from a random sample of 15 customers.

1a. Is there evidence of a difference in the variability of the waiting time between the two branches (use α = 0.05)?

1b. Identify the appropriate test to use, explain why you use that test, and interpret your results.

2a. Is there any evidence of a difference in the mean waiting time between the two branches?

2b. Identify the appropriate test to use, explain why you use that test, and interpret your results.

Please show your work in excel using the Data Analysis function.

Commercial BankResidential Bank

4.21     9.66

5.55     5.9

3.02    8.02

5.13    5.79

4.77    8.73

2.34    3.82

3.54    8.01

3.2      8.35

4.5     10.49

6.1     6.68

0.38   5.64

5.12   4.08

6.46   6.17

6.19   9.91

3.79   5.47