Yin amfani da Nazarin Cluster a Microsoft Excel

Pin
Send
Share
Send

Ofayan kayan aikin don magance matsalolin tattalin arziƙi shine bincike na tari. Tare da taimakonsa, gungu da sauran abubuwan tattara bayanan an rarrabasu cikin kungiyoyi. Ana iya amfani da wannan dabara a Excel. Bari mu ga yadda ake yin hakan a aikace.

Yin amfani da Nazarin Cluster

Tare da taimakon bincike na gungu, yana yiwuwa a aiwatar da samfuri gwargwadon sifofin da ake yin nazarin. Babban aikinta shi ne raba wasu dabaru da yawa zuwa rukunoni daban-daban. A matsayin matsayin rarrabe rarrabuwa, ana amfani da lamunin daidaitawa ko tazara tsakanin Euclidean tsakanin abubuwa ta hanyar da aka bayar. Abubuwan da suka fi kusanci da juna an hada su wuri guda.

Kodayake ana amfani da irin wannan nau'in bincike a cikin tattalin arziki, ana iya amfani dashi a ilmin halitta (don rarrabe dabbobi), ilimin halayyar dan adam, magani, da sauran fannoni na ayyukan ɗan adam. Ana iya amfani da bincike na tari ta amfani da daidaitaccen kayan aikin Kayan aikin don waɗannan dalilai.

Misalin amfani

Muna da abubuwa guda biyar waɗanda ke wakilta sigogi biyu na karatu - x da y.

  1. Muna amfani da tsari na nisa na Euclidean ga waɗannan ƙimar, wanda aka ƙididdige shi gwargwadon samfuri:

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

  2. Ana lissafta wannan darajar tsakanin kowane ɗayan abubuwa guda biyar. Sakamakon lissafin ana sanya shi a cikin matrix ɗin nisa.
  3. Muna duban tsakanin abin da ke kimanta nisa. A cikin misalinmu, waɗannan abubuwa ne 1 da 2. Nisa tsakanin su shine 4.123106, wanda yayi kasa da tsakanin sauran bangarorin wannan jama'ar.
  4. Haɓaka wannan bayanan zuwa cikin rukuni kuma ku samar da sabon matrix wanda ƙimar 1,2 Yi abubuwa daban. Lokacin yin lissafin matrix, zamu bar mafi ƙarancin daraja daga teburin da ya gabata don haɗaɗɗen kayan haɗin. Za mu sake dubawa, tsakanin waɗanne abubuwa nisan yayi kaɗan. Wannan lokacin shine 4 da 5daidai da abu 5 da rukuni na abubuwa 1,2. Nisan shine 6,708204.
  5. Muna ƙara abubuwan da aka ƙayyade zuwa babban tari. Mun kirkiro sabon matrix bisa ga ka'ida iri ɗaya kamar lokacin da ya gabata. Wannan shine, muna neman mafi ƙarancin ƙima. Don haka, mun ga cewa za a iya raba tsarin bayananmu zuwa gungu biyu. Ungiyoyin farko sun ƙunshi abubuwa mafi kusanci da juna - 1,2,4,5. A kashi na biyu na shari'armu, an gabatar da kashi ɗaya kawai - 3. Yayi nesa da sauran abubuwan. Nisan dake tsakanin gungu shine 9.84.

Wannan ya kammala tsarin rarrabuwar jama'a zuwa ƙungiyoyi.

Kamar yadda kake gani, kodayake a cikin binciken ɓangaren jama'a na iya zama kamar tsarin rikice-rikice, a zahiri, fahimtar ƙarancin wannan hanyar ba mai wahala ba ce. Babban abu shine fahimtar yadda ake tsara rukuni.

Pin
Send
Share
Send