Question 3 (Total of 19 marks)

Question 3 (Total of 19 marks) Problems with a telephone line that prevent a customer from receiving or making calls are disconcerting to both the customer and the telephone company. These problems can be of two types: those that are located inside a central ofce and those located on lines between the central ofce and the customer's equipment. The following data represent samples of 20 problems reported to two different ofces of a telephone company and the time to clear those problems (in minutes). IE...- m-I-IEIE-I (a) (4 marks) Use EXCEL to obtain a histogram for the central office location. EXCEL Instructions: Please refer to Topic 6 in the Excel Boaktet for instructions on l'lD'W to obtain and format a histogram. Please use the bins given in 1 minute intervals. {b} (5 marks) Use EXCEL to obtain Desenptive Statistics, Quartile I and Quartile 3 for the central office location. EXCEL Instructions: Please refer to Topic T in the Excel Booklet for instructions on how to obtain Descriptive Statistics and the two quartiles. [a (5 marks) Based on the histogram in (a), briey describe the shape (symmetry, modality and outliers) of the data for the central ofce location. [d}(5 marks) Which measures of location and dispersion should you use to describe the data for the central ofce location? What are their values? Give a brief explanation for your choice