1.Samantha is the manager of two Bendigo Bank branches, East and West, in the central plaza. She would like to investigate complaints of long queues in both branches to improve customer experience. To analyse the waiting time, Samantha observed and recorded the waiting time of customers at the counter of each branch during peak hours. The recorded waiting time of a random sample of 50 customers for each branch can be found in the file Problem Solving Exercises (Part 3), Question 1 Data worksheet . (a) Use EXCEL to obtain a histogram for each branch. Use bin steps of size 2 starting from 2 through to 20 inclusive. EXCEL Instructions: Go to the Assignments page on the course web site and download EXCEL file (This link) for this question, called Problem Solving Exercise (Part 3). Refer to Topic 6 in the Excel Booklet for instructions on how to obtain and format a histogram; use the data and bins given in the Question 1 Data worksheet. (b) Use EXCEL to obtain Descriptive Statistics, Quartile 1 (Q1) and Quar-tile 3 (Q3) for each branch. EXCEL Instructions: Refer to Topic 7 in the Excel Booklet for instructions on how to obtain Descriptive Statistics and the two quartiles. (c) Based on the histograms in (a), brie y describe the shape (symmetry, modality and outliers) of the data for each branch. Instructions for identifying outliers: Whether an observation is an outlier is a matter of judgement. One rule commonly used for identifying outliers is the so-called 1.5 IQR rule. An observation is suspected to be an outlier if it lies more than 1.5 IQR below the first quartile Q1 or above the third quartile Q3. Apply this rule to the data from each branch. Identify suspected outliers (if any) by their exact value(s). (d) Nominate an appropriate measure of central tendency and dispersion for the distribution of waiting time for each branch. Give reason(s) for your choice. For each distribution, give and interpret the values of the summary measures you have chosen. (e) On the basis of your results of (a)-(d), which branch has a longer waiting time? Write a paragraph based on your findings to Samantha providing advice to the arrangements of tellers at the two branches. (Use EXCEL Text Box).

Name Question 1 Question 1_Data Question 2 QI 6 8 10 12 14 16 18 20 11.68 East Branch West Branch Bin 11.23 7.65 4.66 10.09 6.2 12.08 6.75 5.16 4.76 4.99 10.3 18.14 2.73 24 7.34 8.02 5.7 5.14 8.84 7.19 6.18 4.52 6.74 8.46 7.91 13.23 4.75 5.49 18,67 8,71 9.17 4.54 4.5 7.16 7.76 7.83 6.22 13.14 4.2 5.92 3.71 7.41 6,07 5.62 5.73 5.57 18.18 3.66 132 6.65 7.41 7.69 4.02 4.11 5.46 8.46 5.43 7.54 6.1 237 8.34 5.72 6.39 9.43 7.75 3.17 5.29 3.41 5.96 17.54 7.69 15.05 4.84 7.73 7.81 11.7 8.78 6.09 8.63 5.12 11.59 6.2 11.75 10,8 7.98 6.43 29.74 6.11 6.59 6.24 8.12 3.38 7.87 5.86 5.83 6.53 9.01 2.55 Name Question 1 Question 1_Data Question 2 QI 6 8 10 12 14 16 18 20 11.68 East Branch West Branch Bin 11.23 7.65 4.66 10.09 6.2 12.08 6.75 5.16 4.76 4.99 10.3 18.14 2.73 24 7.34 8.02 5.7 5.14 8.84 7.19 6.18 4.52 6.74 8.46 7.91 13.23 4.75 5.49 18,67 8,71 9.17 4.54 4.5 7.16 7.76 7.83 6.22 13.14 4.2 5.92 3.71 7.41 6,07 5.62 5.73 5.57 18.18 3.66 132 6.65 7.41 7.69 4.02 4.11 5.46 8.46 5.43 7.54 6.1 237 8.34 5.72 6.39 9.43 7.75 3.17 5.29 3.41 5.96 17.54 7.69 15.05 4.84 7.73 7.81 11.7 8.78 6.09 8.63 5.12 11.59 6.2 11.75 10,8 7.98 6.43 29.74 6.11 6.59 6.24 8.12 3.38 7.87 5.86 5.83 6.53 9.01 2.55