Question

. A bank with a branch located in a commercial district of a city has the business objective of developing an improved process for serving customers during the 12-1pm lunch period. Management decided 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 until he or she reaches the teller window. Data are collected from a random sample of 15 customers and stored in Bank1. Suppose that another branch, located in a residential area, is also concerned with improving the process of serving customers in the 12-1pm lunch period. Data are collect from a random sample of 15 customers and stored in Bank2. Can we conclude the wait times are different at the two branches? (Use a 0.05 level of significance)

Please show me step by step how to do this in excel so I can better understand.

Waiting Time

4.21

5.55

3.02

5.13

4.77

2.34

3.54

3.20

4.50

6.10

0.38

5.12

6.46

6.19

3.79

Waiting Time

9.66

5.90

8.02

5.79

8.73

3.82

8.01

8.35

10.49

6.68

5.64

4.08

6.17

9.91

5.47

Answer 1