Cung

Anonim

Binciken Gungures a Microsoft Excel

Ofaya daga cikin kayan aikin don warware ɗawainiyar tattalin arziki itace bincike na tari. Tare da shi, gungu da sauran bayanan da aka tsara su ƙungiyoyin. Ana iya amfani da wannan dabarar a cikin kyakkyawan shirin. Bari mu ga yadda ake yin wannan a aikace.

Ta amfani da bincike na cluster

Tare da taimakon bincike na gungu, zaku iya yin samfuri akan tushen da aka bincika. Babban aikinta shine raba jadawalin da yawa don ƙungiyoyi masu ƙarfi. A matsayin mahimmin mahangar, daidaitawa mai daidaitawa ko Euklido nesa tsakanin abubuwa bisa ga sigar da aka ƙayyade. Mafi kusantar juna an tattara juna tare.

Kodayake yawancin lokuta ana amfani da wannan nau'in bincike a cikin tattalin arziƙi, ana iya amfani dashi a cikin ilimin halitta (don rarrabuwa na dabbobi), ilimin halin mutumci, magani da sauran bangarorin ɗan adam. Za'a iya amfani da bincike na gungu ta amfani da daidaitaccen kayan aikin zaman lafiya na waɗannan dalilai.

Misalin amfani

Muna da abubuwa guda biyar waɗanda aka kwatanta su da sigogi biyu - X da y.

  1. Aiwatar da waɗannan dabi'u, da aka tsara Evklide nesa wanda aka lissafta ta samfuri:

    = Tushen (X2-X1) ^ 2 + (y2-y1) ^ 2)

  2. Abubuwan da suka koya a Microsoft Excel

  3. Ana lissafta wannan darajar tsakanin kowane ɗayan abubuwa biyar. Ana sanya sakamakon lissafin a cikin matrix na nesa.
  4. Distan Matrix a Microsoft Excel

  5. Muna kallo, tsakanin abin da dabi'un da ke nesa ke ƙarami. A cikin misalinmu, waɗannan abubuwa ne 1 da 2. Distance tsakaninsu shine 4,123106, wanda yake ƙasa da tsakanin kowane sauran abubuwa na aikin.
  6. Distance tsakanin abubuwa ne ƙanana a Microsoft Excel

  7. Mun hada wannan bayanan cikin rukunin kuma ka samar da sabon matrix, a cikin abin da dabi'u 1.2 yi wani abu daban. Lokacin yin matrix, mun bar ƙimar ƙimar daga teburin da ya gabata don kayan haɗin. Mun sake duba, tsakanin waɗanne abubuwa ne nisan da nisan yake. Wannan lokacin shine 4 da 5, da kuma abu na 5 da rukuni na abubuwa 1.2. Nesa shine 6.708204.
  8. Distance tsakanin abubuwa ne kadan a cikin matrix na biyu a Microsoft Excel

  9. Aara abubuwan da aka ƙayyade zuwa ga tari na kowa. Mun samar da sabon matrix a kan wannan ka'ida kamar lokacin da ya gabata. Wato, muna neman mafi karami. Don haka, mun ga cewa za a iya raba tsarin bayanan mu zuwa gungu biyu. Gungu na farko ya ƙunshi abubuwa mafi kusa a tsakanin juna - 1,2,4,5. A cikin tari ta biyu, a cikin lamarinmu na biyu, kashi ɗaya ne kawai an gabatar da shi - 3. Yana da za a zubar da shi daga wasu abubuwa. Nisa tsakanin gungu shine 9.84.

Darajar ƙarshe a Microsoft Excel

Wannan ya kammala aikin don raba daidaituwa zuwa kungiyoyi.

Kamar yadda kake gani, kodayake gabaɗaya, bincike na gungu kuma yana iya zama kamar tsari, amma a zahiri fahimtar abubuwan da wannan hanyar ba ta da wahala. Babban abu shine fahimtar ainihin tsarin haɗin gwiwa a cikin rukunin.

Kara karantawa