Isesengura rya Cluster muri Excel

Anonim

Isesengura rya Cluster muri Microsoft Excel

Kimwe mubikoresho byo gukemura imirimo yubukungu ni isesengura rya cluster. Hamwe na hamwe, cluster hamwe nandi makuru array ibintu bishyirwa mumatsinda. Ubu buhanga burashobora gukoreshwa muri gahunda ya Excel. Reka turebe uko ibi bikorwa mubikorwa.

Gukoresha Isesengura rya Cluster

Hamwe nubufasha bwo gusesengura cluster, urashobora gukora icyitegererezo hashingiwe ku iperereza. Igikorwa cyayo nyamukuru nugutandukanya imikino myinshi kumatsinda yabahuriye. Nkibipimo ngenderwaho, ihuriro rifitanye isano cyangwa intera ya euklido hagati yibintu ukurikije ibipimo byagenwe byakoreshejwe. Byinshi byegereye hamwe bihujwe hamwe.

Nubwo akenshi ubu bwoko bwisesengura bukoreshwa mubukungu, birashobora kandi gukoreshwa muri biologiya (kubijyanye ninyamaswa), psychologiya, imiti nibindi bice byinshi byibikorwa byabantu. Isesengura rya Cluster irashobora gukoreshwa ukoresheje ibipimo ngenderwaho byibikoresho byiziritse kuri izo ntego.

Urugero rwo gukoresha

Dufite ibintu bitanu biranga ibipimo bibiri byiringiwe - x na y.

  1. Saba kuriyi ndangagaciro, intera ndende ya Edklide ibarwa nicyitegererezo:

    = Umuzi ((x2-x1) ^ 2 + (y2-y1)

  2. Ibintu byize muri Microsoft Excel

  3. Agaciro kabarwa hagati ya buri kintu kitanu. Ibisubizo byo kubara bishyirwa muburebure matrix.
  4. Intera ya Matrix muri Microsoft Excel

  5. Turareba, hagati yindangaba intera ni nto. Murugero rwacu, ibi nibintu 1 na 2. Intera iri hagati yabo ni 4,123106, iri munsi yibindi bintu byose bya burundu.
  6. Intera hagati yibintu ni bike muri Microsoft Excel

  7. Duhuza aya makuru mumatsinda kandi dukora matrix nshya, ni izihengagaciro 1.2 ikora ikintu cyihariye. Mugihe dukora matrix, dusiga indangagaciro ntoya uhereye kumeza yabanjirije ikintu cyahujwe. Twongeye kureba, hagati yibi bintu intera ni nto. Iki gihe ni 4 na 5, kimwe nikintu 5 nitsinda ryibintu 1.2. Intera ni 6.708204.
  8. Intera iri hagati yibintu ni bike muri Matrix ya kabiri muri Microsoft Excel

  9. Ongeraho ibintu byagenwe kuri cluster isanzwe. Dushiraho matrix nshya kumahame amwe nkigihe cyashize. Ni ukuvuga, turashaka bike. Rero, turabona ko urutonde rwacu rushobora kugabanywamo ibice bibiri. Ihuriro ryambere ririmo ibintu bya hafi hagati yabo - 1,2,4,5. Mu cluster ya kabiri, kuri gahunda yacu, ikintu kimwe gusa gitangwa - 3. ni kamwe mubindi bintu. Intera iri hagati yamashanyarazi ni 9.84.

Agaciro kanyuma muri Microsoft Excel

Ibi birangiza inzira yo gucamo ubwoko mumatsinda.

Nkuko mubibona, nubwo muri rusange, gusesengura cluster kandi birasa nkaho bigoye, ariko mubyukuri ndumva ibikoresho byubu buryo ntabwo bikomeye. Ikintu nyamukuru nukumva uburyo bwibanze bwishyirahamwe mumatsinda.

Soma byinshi