Using the data on the pilot (cluster-analysis-data. xsls) to do cluster analysis. You need to repeat the analysis five times in order to choose the right number of clusters (from 3 to 7) according to the sum of minimal distance (your objective function in the optimization step). Please use the following four variables in the analysis: I tend to plan things very carefully
I sometimes have trouble controlling my spending
I think it is important to purchase products that are made locally
I carefully consider the health benefits of what I eat
Which cluster should the restaurant chain to target? In answer the question, you need to compare the characteristics between each identified cluster in the first step, and the number of respondents and the percentage of customers. The percentage of customers comes from a survey item: customer(0: no 1: yes). Hint: using pivotTable to get the summary statistics.
obs customer
(0: no
1: yes) I tend to plan things very carefully I sometimes have trouble controlling my spending I think it is important to purchase products that are made locally I carefully consider the health benefits of what I eat
2 0 1 2 3 2
3 0 1 3 3 2
4 0 2 4 3 2
5 0 2 4 1 2
10 0 2 4 2 3
12 0 2 4 2 1
13 0 2 2 3 3
17 0 1 2 1 1
18 0 3 3 2 3
20 0 1 4 3 2
21 0 2 4 2 2
22 0 2 4 2 3
24 0 1 4 2 1
25 0 2 3 2 2
26 0 1 3 2 1
28 0 2 4 2 1
29 0 2 2 1 2
30 0 2 4 2 2
31 0 1 3 3 2
32 0 2 2 1 2
34 0 1 4 2 2
38 0 3 4 2 2
40 0 3 3 2 1
41 0 1 4 2 1
42 0 1 3 2 1
43 0 2 4 2 4
45 0 2 3 2 2
46 0 2 2 1 2
48 0 4 3 2 2
49 0 1 2 1 2
50 0 2 3 2