own answer

profilerobertjameson
ClusterAnalysisExample.xlsx
Home>Computer Science homework help>own answer

Data Set with Graph

Data Point # X Y
1 11.4 22
2 38.6 34.1
3 42.5 0.2
4 16.4 27.8
5 41.4 29.2
6 45.8 9.2
7 10.1 42.7
8 16 17.1
9 2.7 3.3
10 4.2 37.2
11 33.8 33.9
12 2.4 9.5
13 18.6 48.9
14 34.3 46.1
15 39.9 26.9
16 28 32.5
17 21.3 25.2
18 24.1 39.3

11.4 38.6 42.5 16.399999999999999 41.4 45.8 10.1 16 2.7 4.2 33.799999999999997 2.4 18.600000000000001 34.299999999999997 39.9 28 21.3 24.1 22 34.1 0.2 27.8 29.2 9.1999999999999993 42.7 17.100000000000001 3.3 37.200000000000003 33.9 9.5 48.9 46.1 26.9 32.5 25.2 39.299999999999997

Analysis

First round (Center Points are Guessed)
Find Distances to Center Points Find Distances to Center Points
Highlight shows nearest points to centers After Round One (Assign Groups to Points) New Center Point based on Averages After Round Two After Round Three
Center 1 Center 2 Center 3 Group 1 Group 2 Group 3 Center 1 Center 2 Center 3 Group 1 Group 2 Group 3 Center 1 Center 2 Center 3 Group 1 Group 2 Group 3 Center 1 Center 2 Center 3
10 30 25 30 40 30 9 22.8 23 36.5 39.5 25.7 8.9 19.5 22.7 39.1 38.6 23.7 10.6 20.3 23 41.9 40.3 22.3
Data Point # X Y X Y X Y X Y X Y X Y X Y X Y X Y X Y X Y X Y X Y X Y X Y X Y X Y X Y X Y X Y X Y X
1 11.4 22 8.1 15.8 29.7 11.4 22 2.5298221281 18.5690602886 28.3425475214 11.4 22 3.5355339059 20.4963411369 27.2530732212 11.4 22
2 38.6 34.1 28.9 14.2 4.3 38.6 34.1 31.6835919681 15.7835357256 8.4480767042 38.6 34.1 33.0945614867 16.6676333053 10.4 38.6 34.1
3 42.5 0.2 44.1 34.6 29.9 42.5 0.2 40.4105184327 41.2060675144 25.6758641529 42.5 0.2 38.7485483599 43.6491695225 23.8214189334 42.5 0.2
4 16.4 27.8 6.8 8.9 23.7 16.4 27.8 8.9308454247 10.9201648339 23.1952581361 16.4 27.8 11.1865991257 12.9375422705 22.5754291211 16.4 27.8
5 41.4 29.2 31.4 16.4 1.6 41.4 29.2 33.0260503239 19.7952014387 3.9824615503 41.4 29.2 33.9166625717 21.1589224678 6.1717096497 41.4 29.2
6 45.8 9.2 41.4 29.4 21.6 45.8 9.2 39.2326394728 35.5686659857 17.6618232354 45.8 9.2 38.3105729532 37.7838589877 16.1891939268 45.8 9.2
7 10.1 42.7 12.7 19.6 32.5 10.1 42.7 19.9303788223 14.3125818775 33.9611542796 10.1 42.7 23.2310137532 13.1041978007 34.2527371169 10.1 42.7
8 16 17.1 14.2 15.7 27.2 16 17.1 9.0271811769 20.6242575624 25.0241882985 16 17.1 7.494664769 22.9976085713 23.5440013592 16 17.1
9 2.7 3.3 27.7 34.8 45.9 2.7 3.3 20.4924376295 38.9143932241 43.0813184571 2.7 3.3 17.3458928856 41.0078041353 41.2912823729 2.7 3.3
10 4.2 37.2 9.2 22.0 36.5 4.2 37.2 15.1789327688 18.8130274012 37.12600167 4.2 37.2 18.3133830845 18.5973116337 36.9541607942 4.2 37.2
11 33.8 33.9 24.1 9.6 7.3 33.8 33.9 27.1707563384 11.1085552616 9.9864908752 33.8 33.9 28.76404005 12.2576506721 11.2729765368 33.8 33.9
12 2.4 9.5 21.9 30.5 42.8 2.4 9.5 14.8475587219 33.9611542796 40.4827123597 2.4 9.5 11.9268604419 35.8921997097 38.8854728658 2.4 9.5
13 18.6 48.9 20.8 20.0 28.6 18.6 48.9 27.8095307404 13.1575073627 31.2257906225 18.6 48.9 30.9588436477 10.6230880633 32.1720375482 18.6 48.9
14 34.3 46.1 29.1 18.6 17.1 34.3 46.1 34.3944763007 14.827339613 21.0523157871 34.3 46.1 36.7793420278 13.5484316436 22.8089894559 34.3 46.1
15 39.9 26.9 30.1 15.2 3.1 39.9 26.9 31.1708196877 19.4363062334 1.2649110641 39.9 26.9 31.8709899438 21.0874370183 3.4539832078 39.9 26.9
16 28 32.5 18.2 3.9 12.3 28 32.5 21.3328385359 6.4031242374 13.3600149701 28 32.5 28 32.5 23.1043285988 8.4646323015 13.7767920794 28 32.5
17 21.3 25.2 12.3 6.1 19.3 21.3 25.2 12.5319591445 11.4271606272 18.2068668364 21.3 25.2 13.647344064 13.9703256941 17.3649071406 21.3 25.2
18 24.1 39.3 16.9 9.3 18.4 24.1 39.3 22.3664927961 3.0083217913 20.5455591309 24.1 39.3 24.9615704634 1.4142135624 21.2981219829 24.1 39.3
63.2 159.6 92 145.9 276.3 179.6 53.1 116.9 136.4 234.7 270 166 74.4 142.1 115.1 209.5 242 133.5
Averages 9.0285714286 22.8 23 36.475 39.4714285714 25.6571428571 8.85 19.4833333333 22.7333333333 39.1166666667 38.5714285714 23.7142857143 10.6285714286 20.3 23.02 41.9 40.3333333333 22.25