View the step-by-step solution to:

# 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...

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 office and those located on lines between the central office and the customer's equipment. The following data represent samples of 20 problems reported to two different offices of a telephone company and the time to clear those problems (in minutes).

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 ofﬁce and those located on lines between the central
ofﬁce and the customer’s equipment. The following data represent
samples of 20 problems reported to two different ofﬁces 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), brieﬂy describe the shape
(symmetry, modality and outliers) of the data for the central ofﬁce
location. [d}(5 marks) Which measures of location and dispersion should you use
to describe the data for the central ofﬁce location? What are their values? Give a brief explanation for your choice.

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents