IET 670 Homework Number 2 You can use Excel for data analysis 1. https:/www.youtube.com/watch?v=4_9vGqQaCFk Homework No. 2 (17 points) In a branch of a bank in an area with many businesses nearby, customers often visit the bank between 11:00 AM and 2:00 PM the most. During that time, there is often a line, where the average customer waits before meeting the banker. The attached table shows the time the customer reaches the bank, meets the banker and finally leaves for a typical day. There is one banker at this branch. Find: 1. The average waiting time for the customers (2 pts) 2. The range of the waiting time the customers experience (2 pts) 3. The average time the customers spend with the banker (2 pts) The range of time the customers spend with the banker (2 pts) 5. The standard deviation of the waiting time (2 pts) 6. The standard deviation of the time spent with the banker(2 pts) 7 . Build a Histogram for both the wait time and the time spend with the banker (3 pts) 8. Based on your data analysis and histogram make recommendations for improvement (2 pts) ( Waiting time=Time reached banker-Arrival time, Time spent with banker=Time left banker-Time reached banker) Customer Arrival Time reached Time left Number time banker banker 11:00 11:00 11:05 11:02 11:05 11:08 11:03 11:08 11:20 11:07 11:20 11:22 11:15 11:22 11:25 SOOVOUAWNH 11:12 11:25 11:28 11:20 11:28 11:40 11:40 11:40 11:50 11:42 11:50 11:52 11:49 11:52 11:55 11 11:55 11:55 12:00