Question

1. One of the major measures of the quality of service provided by an organization is the speed with which the organization responds to customer complaints. A large family-held department store selling furniture and flooring, including carpet, had undergone a major expansion in the past several years. In particular, the flooring department had expanded from 2 installation crews to an installation supervisor, a measurer, and 15 installation crews. A business objective of the company was to reduce the time between when the complaint is received and when it is resolved. During a recent year, the company received 50 complaints concerning carpet installation. The number of days between the receipt of the complaint and the resolution of the complaint for the 50 complaints, stored in Furniture, are:

54 5 35 137 31 27 152 2 123 81 74 27

11 19 126 110 110 29 61 35 94 31 26 5

12 4 165 32 29 28 29 26 25 1 14 13

13 10 5 27 4 52 30 22 36 26 20 23

33 68

a Construct a frequency distribution using 7 classes.

b Construct a histogram using Excel.

Answer 1

a) We have given sample of 50. the summary information for the below table is,

Construct a frequency distribution using 7 classes.

LCL	UCL	Frequency	Density
1.0	24.4	17	0.34
24.4	47.9	19	0.38
47.9	71.3	4	0.08
71.3	94.7	3	0.06
94.7	118.1	2	0.04
118.1	141.6	3	0.06
141.6	165.0	2	0.04
Total		50	1

b) Construct a histogram using Excel.

In excel,

by putting data in the column we will proceed below steps,

insert > Histogram > select data > Ok

the below graph has appeared by number of bin size making 7

This is the final histogram from Excel