Data Analysis (Cluster Analysis)

User Generated

ygsqyal

Business Finance

Description

check the example!

Use Excel to perform the following data analysis.

  1. Plot the data on a scatter plot.
  2. Determine the ideal number of clusters.
  3. Choose random center points (centroids) for each cluster. (Note: Each student will select a different random set of centroids.)
  4. Using a standard distance formula measure the distance from each data point to each center point.
  5. Assign each data point to an initial cluster region based on closeness.
  6. For each cluster calculate new center points.
  7. Repeat steps 4 through 6.

Unformatted Attachment Preview

Data Point # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 X Y 6,1 21,7 1,7 2,5 15,8 48,2 35,6 41 35,8 41,4 8,9 43,6 19,5 41,7 30,8 43,7 36,2 41,9 0,5 28,4 5,4 31,2 43,5 38,3 36,9 13,9 27 7,6 49,4 41,8 19,1 42 5,6 16,4 0,5 4,6 3 34,5 11 17,3 35,7 42,4 5,4 2,8 12,7 39,7 13,8 29,6 42,8 44 17,5 2,3 14,7 32,1 0,6 31,6 3,2 27,3 5,9 31,8 5,6 22,1 22,8 35 39,8 31,8 9,3 34,2 44,7 24,3 25,8 0,8 34,2 3 22,3 47,6 2,9 27,4 29,4 15,7 49,2 16,9 11,3 14,6 18,7 41,3 42,2 7,7 45 46 47 48 49 50 51 10,3 14,9 39,6 13,2 8,5 44,1 31,9 42,3 12,4 34,1 1,3 11,6 15 34,4
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Data Point #
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

X
11.4
38.6
42.5
16.4
41.4
45.8
10.1
16
2.7
4.2
33.8
2.4
18.6
34.3
39.9
28
21.3
24.1
30.1
7.2
21.6
30.5
2.1
16.7
15.3
26.5
25.8
36.3
27.4
4.5
0.3
32.7
0.7
6.9
9.8
20.1
9
13.6
46.2
6.1

Y
22
34.1
0.2
27.8
29.2
9.2
42.7
17.1
3.3
37.2
33.9
9.5
48.9
46.1
26.9
32.5
25.2
39.3
46.4
26.2
39
9
19.2
32.4
21.7
1.6
25.5
20.7
9.4
0.3
36.7
46.4
15.8
8.4
18.7
4.8
12.4
30.3
26
12.7

60
50
40
30
20
10
0
0

5

Chart Title

5

10

15

20

25

30

35

40

45

50

Data Point #
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

X
11.4
38.6
42.5
16.4
41.4
45.8
10.1
16
2.7
4.2
33.8
2.4
18.6
34.3
39.9
28
21.3
24.1
30.1
7.2
21.6
30.5
2.1
16.7
15.3
26.5
25.8
36.3
27.4
4.5
0.3
32.7
0.7
6.9
9.8
20.1
9
13.6
46.2
6.1

Y
22
34.1
0.2
27.8
29.2
9.2
42.7
17.1
3.3
37.2
33.9
9.5
48.9
46.1
26.9
32.5
25.2
39.3
46.4
26.2
39
9
19.2
32.4
21.7
1.6
25.5
20.7
9.4
0.3
36.7
46.4
15.8
8.4
18.7
4.8
12.4
30.3
26
12.7

First round (Center Points are Guessed)
Find Distances to Center Points
Highlight shows nearest points to centers
Center 1
Center 2
8
28
30
35
X
Y
...


Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags