Business
Need business analytical skills for using such type of paper. Excel knowledge is necessary. For better decision maimng purpose and analyze large data.
Business Analytics
Assignment
Question 6)
Using SPSS, we divide the data into four clusters based on the input variables Percent Gross Profit, Gross Sales, Gross Profit, Industry Code, and Competitive Rating. The result of Cluster Membership as well as Dendrogram are shown below, which indicates the assignment of observations to the number of clusters indicated in the input field.
Cluster Membership
S.no
Case
4 Clusters
S.no
Case
4 Clusters
1
1:01
1
32
32:32:00
2
2
2:02
2
33
33:33:00
2
3
3:03
2
34
34:34:00
2
4
4:04
2
35
35:35:00
2
5
5:05
2
36
36:36:00
2
6
6:06
2
37
37:37:00
2
7
7:07
2
38
38:38:00
2
8
8:08
2
39
39:39:00
2
9
9:09
2
40
40:40:00
3
10
10:10
2
41
41:41:00
2
11
11:11
2
42
42:42:00
2
12
12:12
3
43
43:43:00
2
13
13:13
2
44
44:44:00
2
14
14:14
2
45
45:45:00
2
15
15:15
2
46
46:46:00
2
16
16:16
2
47
47:47:00
2
17
17:17
2
48
48:48:00
2
18
18:18
2
49
49:49:00
2
19
19:19
4
50
50:50:00
2
20
20:20
2
51
51:51:00
2
21
21:21
2
52
52:52:00
2
22
22:22
3
53
53:53:00
2
23
23:23
2
54
54:54:00
2
24
24:24:00
2
55
55:55:00
2
25
25:25:00
2
56
56:56:00
2
26
26:26:00
2
57
57:57:00
2
27
27:27:00
2
58
58:58:00
2
28
28:28:00
2
59
59:59:00
2
29
29:29:00
2
60
60: 60
2
30
30:30:00
2
31
31:31:00
2
Table 1: Cluster output (P-6)
4191018255500
Figure: Dendrogram
<
