Question 2
a) We create a frequency table with class width =
20
Percentage Distribution = Frequency/Total
observations
Class | Frequency | Percentage Distribution |
0-20 | 15 | 0.3 |
21-40 | 21 | 0.42 |
41-60 | 2 | 0.04 |
61-80 | 3 | 0.06 |
81-100 | 2 | 0.04 |
101-120 | 2 | 0.04 |
121-140 | 3 | 0.06 |
141-160 | 1 | 0.02 |
161-180 | 1 | 0.02 |
b) Histogram
c) As can be seen from the percentage, distribution,
72% of the complaints are resolved in 40
days
We can tell the President of the company
that
Majority of the complaints are resolved within 40 days
of receiving the complaints,
So the customer should expect a complaint to be
resolved within 40 days
d) Following table gives the summary statistics and the
Excel functions used for calculating the summary
statistics
Description | Formula in Excel | Value |
Mean | AVERAGE(data) | 43.04 |
Median | MEDIAN(data) | 28.5 |
First Quartile | QUARTILE.INC(data, 1) | 15.25 |
Third Quartile | QUARTILE.INC(data, 3) | 53.5 |
e)
Description | Formula in Excel | Value |
Range | Max(data)-Min(data) | 164 |
InterQuartile Range | Third Quartile - First Quartile (=53.5-15.25) | 38.25 |
Variance | Var.s(data) | 1757.79 |
Standard Deviation | Stdev.s(data) | 41.93 |
f) Box Plot
Since bulk observations are on the lower end of the
scale
the data is skewed to the right direction
Question 2 One of the major measures of the quality of service provided by any organization...
(2.90 One of the major measures of the quality of service pro- vided by an organization is the speed with which the organi- zation responds to customer complaints. A large family-held department store selling furniture and flooring, including car- pet, had undergone a major expansion in the past several years. In particular, the flooring department had expanded from 2 in- stallation crews to an installation supervisor, a measurer, and 15 installation crews. A business objective of the company was to...
One of the major measures of the service quality of any organization is the speed with which it responds to customer complaints. A large department store is reviewing its service quality in last year. Last year, there were 30 complaints. The following data (including 30 numbers) represents the number of days between the receipt of a complaint and the resolution of the complaint: 54, 5, 35, 137, 31, 27, 152, 2, 123, 81, 74, 27, 11, 19, 126 110, 110,...
5. One of the main measures of quality of service provided by any business organization is the speed with which it responds to customer complaints. A medium family held department store, selling furniture and flooring, has been historically resolving customer complaints in 20 days on average, starting from the date the complaint was received. In an effort to improve their performance, however, they have hired an additional expert on customer care. The management is trying to evaluate the effectiveness of...
3. One of the main measures of quality of service provided by any business organization is the speed with which it responds to customer complaints. A medium family held department store, selling furniture and flooring, has been historically resolving customer complaints in 15 days on average, starting from the date the complaint was received. In an effort to improve their performance, however, they have hired an additional expert on customer care. The management is trying to evaluate the effectiveness of...