Description
check the example!
Use Excel to perform the following data analysis.
- Plot the data on a scatter plot.
- Determine the ideal number of clusters.
- Choose random center points (centroids) for each cluster. (Note: Each student will select a different random set of centroids.)
- Using a standard distance formula measure the distance from each data point to each center point.
- Assign each data point to an initial cluster region based on closeness.
- For each cluster calculate new center points.
- Repeat steps 4 through 6.
Unformatted Attachment Preview
Purchase answer to see full attachment
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
...