Ukunquma izinga lokuncika phakathi kwezinkomba eziningana, kusetshenziswa ama-coefficients amaningi wokuhlangana. Bese bencipha etafuleni elihlukile, elinegama le-matrix yokuhlangana. Amagama emigqa namakholamu we-matrix elinjalo angamagama amapharamitha, ukuncika kwakhe komunye nomunye kufakiwe. Ama-coefficients ahambelana nawo atholakala ekuxhumaneni kwemigqa namakholomu. Ake sibheke ukuthi kungenza kanjani ukubalwa okufanayo kusetshenziswa amathuluzi we-Excel.
Ngemuva kwesenzo esibekiwe, iphakethe lokuhlaziya idatha lizosebenza.
Isigaba 2: Ukubalwa kwe-coefficient
Manje usungaya ngqo ekubalweni kwe-coeffeccient yokuhlangana okuningi. Masenze isibonelo setafula lezinkomba zokusebenza kwabasebenzi, iphrojekthi yamasheya namabhizinisi ahlobene namandla kumabhizinisi ahlukahlukene, ukubala okuhlanganisiwe kokuxhumeka okuningi kwalezi zinto.
- Sithuthela kuthebhu "yedatha". Njengoba ubona, ibhlokhi entsha "yokuhlaziya" ibhlokhi yavela ku-Ribbon. Inkinobho ethi "Ukuhlaziywa Kwedatha", etholakala kuyo.
- Iwindi livula, elibizwa ngokuthi "ukuhlaziywa kwedatha". Sabela ohlwini lwamathuluzi akhiwe kuwo, igama elithi "ukuxhumeka". Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile" ngakwesokunene kwesibonisi sewindows.
- Kuvulwa iwindi le- "Collelation". Ensimini ethi "InNeccecct Stimel", ikheli lehlu letafula kufanele lenziwe, lapho idatha ezintweni ezintathu ezifundwayo ezitholakala khona: Ukuhamba kwamandla, ukudala amasheya nokusebenza. Ungenza umnikelo wezandla wezixhumanisi, kepha kulula ukumane ufake isikhombisi emkhakheni futhi ugeleze inkinobho yegundane kwesobunxele, khetha indawo efanelekayo yetafula. Ngemuva kwalokho, ikheli le-band lizokhonjiswa ewindini "lokuhlangana".
Njengoba izici zethu ziphulwe phansi ngamakholomu, hhayi izintambo, bese kuthi "iqembu" ipharamitha setha i-switch isendaweni ethi "ngamakholomu". Kodwa-ke, sekuvele kufakwe okuzenzakalelayo. Ngakho-ke, ihlala ibheka ukunemba kwendawo yayo.
Eduze nephuzu elithi "tags emugqeni wokuqala" umaki wokuhlola hhayi empeleni. Ngakho-ke, sizokweqa le pharamitha, ngoba ngeke kuthinte uhlobo oluphelele lokubalwa.
Kuzilungiselelo ze- "Output Parameter", kufanele uchaze lapho kuzokhonjiswa khona i-matrix yethu yokuhlangana, lapho umphumela wokubalwa uzokhonjiswa. Izinketho ezintathu ziyatholakala:
- Incwadi entsha (elinye ifayela);
- Ishidi elisha (uma lifisa, emkhakheni okhethekile, kungenzeka ukuyinika igama);
- Ibanga ephepheni lamanje.
Ake sikhethe inketho yokugcina. Hlela kabusha ukushintshwa kwesikhundla "sokukhipha isikhawu". Kulokhu, ensimini ehambisanayo, kufanele usho ikheli le-matrix band noma okungenani iseli yalo ephezulu kwesokunxele. Sisungula isikhombisi ensimini nasebumbeni esitokisini ephepheni esihlela ukwenza into ephezulu kwesobunxele sohlu lokukhipha idatha.
Ngemuva kokukhipha konke lokhu kubhala, kuhlala kuchofoze inkinobho ethi "KULUNGILE" ngakwesokunene sewindi "lokuhlangana".
- Ngemuva kokukhipha isenzo sokugcina, i-Excel yakha i-matrix yokuxhumanisa, ukugcwalisa idatha yayo, ebangeni elishiwo umsebenzisi.
Isigaba 3: Ukuhlaziywa komphumela
Manje ake sibheke ukuthi singawuqonda kanjani umphumela esiwutholile ngesikhathi senqubo yokucubungula "Hlunga" ithuluzi e-Excel.
Njengoba sibona etafuleni, ukuhlanganiswa kwe-cockoeflition yephrojekthi yesitoko (ikholomu 2) kanye ne-energy-ehlobene (ikholomu 1) ngu-0.92, ohambelana nobudlelwano obuqinile kakhulu. Phakathi kokukhiqizwa kwabasebenzi (ikholomu 3) kanye nokuhlobene namandla (ikholomu 1) Le nkomba ingu-0.72, okuyizinga eliphakeme lokuncika. Ukuhlanganiswa kokuhlangana phakathi kokukhiqizwa kwabasebenzi (ikholomu 3) kanye nokwakha amasheya (ikholomu 2) yi-0.88, okubuye kuhambisane nezinga eliphakeme lokuncika. Ngakho-ke, kungashiwo ukuthi ubudlelwano phakathi kwazo zonke izinto ezifundwa buqinile.
Njengoba ubona, iphakethe lokuhlaziya idatha ku-Excel liyithuluzi elilungele kakhulu futhi elingaphansi lokunquma ukubumbana kokuhlangana okuningi. Ngosizo lwayo, kungenzeka ukubala kanye nokuhlobana okujwayelekile phakathi kwezinto ezimbili.