As part of the quarterly reviews, the manager of a retail store analyzes the quality of customer service based on the periodic customer satisfaction ratings (on a scale of 1 to 10 with 1 = Poor and 10 = Excellent). To understand the level of service quality, which includes the waiting times of the customers in the checkout section, he collected the data shown below on 100 customers who visited the store.
?
Customer Number
Wait Time (min)
Purchase Amount ($)
Customer Age
Customer Satisfaction Rating
1
2.3
436
42
7
2
2.8
408
33
6
3
3.2
432
38
5
4
3.4
431
40
5
5
3.4
456
29
6
6
4.2
537
46
4
7
3.2
456
42
5
8
1.4
430
40
8
9
6.4
663
24
3
10
7.8
839
37
4
11
6.5
659
52
5
12
9.8
836
43
2
13
5
543
56
4
14
1.8
419
35
8
15
6.1
700
39
6
16
3.4
432
44
7
17
7.8
845
33
5
18
2.8
467
42
6
19
1.2
425
46
8
20
9.5
848
50
4
21
8.2
808
55
3
22
7.6
674
35
3
23
5.4
547
52
4
24
6.7
691
38
5
25
9.6
847
53
4
26
11.4
826
48
2
27
2.1
426
52
7
28
5.6
535
32
7
29
3.7
521
43
8
30
4.9
513
44
6
31
6.4
645
53
5
32
9.3
846
52
4
33
10.6
730
51
3
34
6.5
786
53
3
35
5.4
523
46
5
36
7.6
654
36
6
37
3.2
443
48
7
38
2.4
409
54
8
39
1
400
39
6
40
0.2
418
51
7
41
2.4
498
30
6
42
5.7
532
32
5
43
6.4
663
44
7
44
6
681
39
8
45
3.7
543
54
5
46
8.7
800
51
5
47
6.9
673
45
5
48
9.8
856
43
4
49
10
756
44
4
50
9.5
854
43
6
51
6.3
672
50
6
52
7.4
698
47
7
53
2.3
434
43
7
54
4.6
544
40
4
55
4.9
523
53
6
56
5.7
546
55
6
57
7.4
676
42
8
58
6.8
662
36
6
59
9.6
1000
40
5
60
6.4
678
46
5
61
7.2
655
32
4
62
5.6
535
36
5
63
9.7
833
35
3
64
2.3
498
30
7
65
4.3
508
41
6
66
5.7
542
49
6
67
2.4
435
39
8
68
6.7
665
41
5
69
2.4
387
54
9
70
9.8
845
34
7
71
4.5
532
40
6
72
6.7
687
30
5
73
7.2
643
33
4
74
3.5
424
49
7
75
8.9
836
47
5
76
9.7
876
31
4
77
3.5
456
47
7
78
4.7
523
49
6
79
8.5
818
35
5
80
9.7
845
54
4
81
2.7
401
55
7
82
5.7
554
43
6
83
7.6
648
51
7
84
4.4
540
31
6
85
7.8
839
45
5
86
9.4
845
48
4
87
4.9
534
36
5
88
7.1
693
44
4
89
5.4
512
39
3
90
6.7
665
49
5
91
8.6
825
36
5
92
4.5
548
30
7
93
6.1
704
31
5
94
5.3
509
31
6
95
6.7
672
35
5
96
8.1
824
36
4
97
6.3
632
30
4
98
7.4
689
35
2
99
8.8
839
50
4
100
9.6
847
35
2
?
?
Using the data given, apply k-means clustering with k = 5 using Wait Time (min), Purchase Amount ($), Customer
Age, and Customer Satisfaction Rating as variables. Be sure to Normalize input data and specify 50 iterations and
10 random starts in Step 2 of the XLMiner k-Means Clustering procedure. Analyze the resultant clusters.
What is the smallest cluster? What is the least dense cluster (as measured by the average distance in the cluster)?
What reasons do you see for low customer satisfaction ratings?
What will be an ideal response?
We see that the size of the clusters does not vary much. Size of cluster varies from 6 to 36.
The smallest cluster has 6 customers, Cluster-4. The least dense cluster is the 36-customer cluster, Cluster-5, which includes customers with waiting time ranging from 6.1 to 11.4, purchase amount ranging from 654 to 1000, age between 31 and 55, and customer satisfaction rating ranging from 2 to 7.
?
From the below output, it appears that more waiting times and high purchase amounts are the reasons for low customer satisfaction ratings. The high purchase amounts can be attributed to high prices of the products in the store.
?
You might also like to view...
If the interest rate on three-month Treasury securities is 6 percent and the interest rate on ten-year Treasury securities is 4 percent, then
A. the economy has probably just emerged from a recession. B. the yield curve slopes upward steeply. C. a recession is likely to occur. D. the economy is probably in the middle of an economic expansion.
Name and explain three of the ABCs of marketing.
What will be an ideal response?
Fess convinces Gwyn to enter into a contract for the purchase of a Falafel Waffle Food Cart by knowingly misrepresenting a number of material features about the facility and the business. Most likely, Gwyn can rescind the contract on the basis of
A. fraudulent misrepresentation. B. negligent misrepresentation. C. innocent misrepresentation. D. none of the choices.
Which of the following acts resulting in injury would be negligence per se?
a. Joe sold fireworks from his Indiana store (a legal activity) to Steve, an Illinois resident (a state that has made owning fireworks illegal). b. June,while driving the speed limit, sideswiped the car next to her. c. A retailer sold glue containing benzene to a 14-year-old boy in violation of state law. d. Tammy accidentally dropped a heavy carton on Sasha's foot while at work.