Ukunquma ubungako bokuncika phakathi kwezinkomba eziningana, kusetshenziswa ama-coefficients amaningi wokuxhumanisa. Base bencishiselwa etafuleni elihlukile, elinobizo lwe-matrix yokuhlobanisa. Amagama imigqa namakholomu we-matrix angamagama wemingcele okuncike kuyo ukuncika komunye nomunye. Ekuxhumaneni kwemigqa namakholomu kukhona ama-coefficients ahambelana nokuhambelana. Ake sibheke ukuthi ungakwenza kanjani lokhu kubalwa usebenzisa amathuluzi e-Excel.
Bheka futhi: Ukuhlaziywa kwe-Excel Correlation
Ukubalwa kwenhlanganisela yokuhlobana okuningi
Yemukelwa ngokulandelayo ukunquma inani lobudlelwano phakathi kwezinkomba ezahlukahlukene, ngokuya nge-coefflication efanelekile:
- 0 - 0,3 - akukho ukuxhumana;
- 0.3 - 0.5 - uxhumano lubuthakathaka;
- 0.5 - 0,7 - ukuxhumana okuphakathi;
- 0.7 - 0.9 - phezulu;
- 0.9 - 1 uqinile kakhulu.
Uma i-coilffeation ehambelana nayo ayisiyikho, khona-ke lokhu kusho ukuthi ubudlelwano bezinhlaka buhlukile.
Ukuze ubhale i-matrix yokuhlobanisa ku-Excel, kusetshenziswa ithuluzi elilodwa, elifakiwe kwiphakheji "Ukuhlaziywa kwedatha". Ibizwa kanjalo - Ukuhlangana. Ake sibheke ukuthi ungayisebenzisa kanjani ukubala amamethrikhi wokuxhumana amaningi.
Isigaba 1: ukusebenza kwephakeji lokuhlaziywa
Ngokushesha kudingeka ukusho ukuthi iphakheji ezenzakalelayo "Ukuhlaziywa kwedatha" inqanyuliwe. Ngakho-ke, ngaphambi kokuqhubeka nenqubo yokubala ngqo ama-coefficients wokuhlobanisa, udinga ukukusebenzisa. Ngeshwa, akuwona wonke umsebenzisi owaziyo ukuthi angakwenza kanjani lokhu. Ngakho-ke, sizogxila kulolu daba.
- Iya kuthebhu Ifayela. Kumenyu emile mpo yewindows evuleka ngemuva kwalokho, chofoza entweni "Izinketho".
- Ngemuva kokwethula iwindi lepharamitha, ngokusebenzisa imenyu yalo ebheke ngakwesobunxele, iya kusigaba "Okengezwayo". Kukhona insimu ezansi impela yohlangothi lwesokudla lwewindi "Abaphathi". Sishintsha switch kuso siyisikhundla Kengeza i-Exceluma kuboniswa enye ipharamitha. Ngemuva kwalokho chofoza inkinobho "Hambani ..."ibekwe ngakwesokunene senkambu echaziwe
- Kuqala iwindi elincane. "Okengezwayo". Setha ibhokisi lokuhlola eduze kwepharamitha Iphakheji Yokuhlaziya. Ngemuva kwengxenye yesokudla yewindi, chofoza inkinobho "Kulungile".
Ngemuva kwesenzo esibekiwe, iphakethe lamathuluzi "Ukuhlaziywa kwedatha" izosebenza.
Isigaba 2: ukubalwa ngokulingene
Manje sesingaqhubeka ngqo ekubalweni kwethala lokuhlobana okuningi. Ake sisebenzise isibonelo setafula lezinkomba zokukhiqizwa kwabasebenzi, isilinganiso sokusebenza kwabasebenzi kanye nesilinganiso sokusebenza kwabasebenzi emabhizinisini ahlukahlukene angezansi, sibala ukukwazi ukuzihlanganisa okuningi kwalezi zinto.
- Hambisa kuthebhu "Idatha". Njengoba ukwazi ukubona, ibhokisi elisha lamathuluzi livele ethepheni "Ukuhlaziywa". Chofoza inkinobho "Ukuhlaziywa kwedatha", etholakala kuyo.
- Iwindi eliqukethe igama liyavula "Ukuhlaziywa kwedatha". Khetha ohlwini lwamathuluzi akulo, igama Ukuhlangana. Ngemuva kwalokho chofoza inkinobho "Kulungile" ngakwesokunene esibonakalayo sewindi.
- Iwindi lamathuluzi liyavula Ukuhlangana. Ensimini Isikhawu sokufaka ikheli lobubanzi bethebula lapho idatha yezici ezintathu ezifundwayo zitholakala khona: isilinganiso samandla, isilinganiso se-capital, nokukhiqiza kufanele kufakwe. Ungafaka ngesandla izixhumanisi, kepha kulula ukuvele ukusetha isikhombisi esigangeni futhi, ngokubamba inkinobho yegundane kwesobunxele, khetha indawo ehambisanayo yetafula. Ngemuva kwalokho, ikheli lohlu lizokhonjiswa enkanjini yewindi Ukuhlangana.
Njengoba izinto zethu zihlukaniswe ngamakholomu kunamigqa, kunxantathu "Ukuhlanganisa amaqembu" beka inkinobho eshintshiwe Ikholomu ngekholamu. Noma kunjalo, isivele ifakwe lapho ngokuzenzakalelayo. Ngakho-ke, kuhlala kuphela ukuqinisekisa ukunemba kwendawo yayo.
Mayelana nephuzu "Amathegi kulayini wokuqala" umkhaza akudingekile. Ngakho-ke, sizokweqa le pharamitha, ngoba ngeke iphazamise imvelo ejwayelekile yokubalwa.
Ebhuthini yezilungiselelo "Ipharamitha yokuphuma" kufanele ikhonjiswe ngqo lapho i-matrix yethu yoxhumano izotholakala khona, lapho umphumela wokubala uboniswa khona. Izinketho ezintathu ziyatholakala:
- Incwadi entsha (elinye ifayela);
- Ishidi elisha (uma lifunwa, ungalinikeza igama emkhakheni okhethekile);
- Ibanga kushidi lamanje.
Ake sikhethe inketho yokugcina. Sishintshela ku "Isikhashana sokuphumayo". Kulokhu, endimeni ehambisanayo kufanele ucacise ikheli lobubanzi be-matrix, noma okungenani iseli lakhe elingaphezulu ngakwesobunxele. Sibeka isikhombisi ensimini bese sichofoza kuseli ephepheni, esihlela ukwenza into ephezulu kwesokunxele yobubanzi bokukhishwa kwedatha.
Ngemuva kokwenza konke ukusebenzisa okukhohlisiwe, kusala kuphela ukuze uchofoze inkinobho "Kulungile" ohlangothini lwesokunene lwewindi Ukuhlangana.
- Ngemuva kwesenzo sokugcina, abakwa-Excel bakha i-matrix yokuhlobanisa, beyigcwalisa ngemininingwane ebangeni elishiwo umsebenzisi.
Isigaba 3: Ukuhlaziywa komphumela
Manje ake sibheke ukuthi singawuqonda kanjani umphumela wokuthi singene enkambisweni yokusebenza kwedatha ngethuluzi Ukuhlangana e-Excel.
Njengoba ukwazi ukubona kusuka etafuleni, i-coefflication yokuhlobana yesilinganiso sokusebenza kwabasebenzi (Kholamu 2) kanye nesilinganiso samandla (Kholamu 1) ngu-0.92, ohambelana nobudlelwano obuqine kakhulu. Phakathi kokukhiqizwa kwabasebenzi (Kholamu 3) kanye nesilinganiso samandla (Kholamu 1) le nkomba ingu-0.72, okuyisilinganiso esiphakeme sokuncika. Ukuqina kokuhlangana phakathi kokukhiqizwa kwabasebenzi (Kholamu 3) kanye nesilinganiso sokusebenza kwabasebenzi (Kholamu 2) ilingana no-0.88, futhi ehambelana nezinga eliphakeme lokuncika. Ngakho-ke, singasho ukuthi ukuncika phakathi kwazo zonke izinto ezifundwayo kuqine impela.
Njengoba ubona, iphakethe "Ukuhlaziywa kwedatha" I-Excel iyithuluzi elisebenziseka kalula futhi kulula ukulisebenzisa ekunqumeni i-coefflication eminingi yokuhlobana. Ukuyisebenzisa, umuntu angakwazi nokubala ukuhlangana okujwayelekile phakathi kwezinto ezimbili.
