Enye yamathuluzi okuxazulula izinkinga zezomnotho ukuhlaziywa kweqoqo. Ngalokhu, amaqoqo nezinye izinto zohlu lwedatha zihlukaniswa ngamaqembu. Le nqubo ingasetshenziswa ku-Excel. Ake sibone ukuthi lokhu kwenziwa kanjani ngokusebenza.
Ukusebenzisa ukuhlaziywa kwamaqoqo
Ngosizo lokuhlaziywa kweqoqo kungenzeka ukuthi kwenziwe isampula ngesisekelo esiphuthumayo. Umsebenzi walo oyinhloko ukuhlukanisa i-multidimensional array ibe ngamaqembu ahambelanayo. Njengesihlonzi sokuqoqa, ukulingana kokubili kokulinganisa noma ibanga le-Euclidean phakathi kwezinto ngepharamitha elinikeziwe lisetshenziswa. Amanani aseduze aqoqwe ndawonye.
Nakuba ngokuvamile lolu hlobo lokuhlaziywa lusetshenziselwa ukongiwa kwemali, lungasetshenziswa futhi kwi-biology (ngokuhlukaniswa kwezilwane), kwengqondo, imithi nakwezinye izindawo eziningi zomsebenzi wesintu. Ukuhlaziywa kweCluster kungasetshenziswa ngokusebenzisa i-Excel toolkit kule njongo.
Isibonelo sokusebenzisa
Sinezinto ezinhlanu, ezibhekene nemingcele emibili efundwayo - x futhi y.
- Faka isicelo kulezi zindinganiso i-formula ye-Euclidean ibanga, ebalwa kusukela kusifanekiso:
= INQUBO ((x2-x1) ^ 2 + (y2-y1) ^ 2) - Leli nani libalwa phakathi kwezinto eziyisihlanu. Imiphumela yokubala ifakwa ematrix ebanga.
- Sibheka, phakathi kokubaluleka ibanga okungenani. Esikhathini sethu, lezi zizinto. 1 futhi 2. Ibanga eliphakathi kwabo liyi-4,123106, elingaphansi kwezinye izici zalesi sibalo.
- Sihlanganisa le datha eqenjini bese sakha i-matrix entsha lapho amanani 1,2 ume njengento ehlukile. Uma uhlanganisa i-matrix, shiya amanani amancanyana kunawo wonke kusukela kuthebula langaphambilini lesici esihlangene. Siphinde sibheke, phakathi kweziphi izakhi ibanga elincane. Lesi yisikhathi 4 futhi 5kanye nento 5 kanye neqembu lezinto 1,2. Ibanga liyi 6,708204.
- Sengeza izinto ezicacisiwe kwiqoqo elivamile. Sakha i-matrix entsha esimisweni esifanayo nesikhathi esidlule. Okusho ukuthi, sibheka amanani amancane kakhulu. Ngakho, sibona ukuthi isethi yethu yedatha ingahlukaniswa ngamaqoqo amabili. Esigabeni sokuqala yizona zinto eziseduze - 1,2,4,5. Esikhathini sesigaba sesibili esimweni sethu kunesici esisodwa kuphela - 3. Kude kakhulu nezinye izinto. Ibanga phakathi kwamaqoqo ngu-9.84.
Lokhu kugcwalisa inqubo yokuhlukanisa abantu ngamaqembu.
Njengoba ungabona, nakuba ukuhlaziywa kweqoqo elijwayelekile kungahle kubonakale kunzima, kodwa empeleni akulula kakhulu ukuqonda ama-nuances ale ndlela. Into esemqoka ukuqonda iphethini eyisisekelo yokuhlangana ngamaqembu.
