Okuqukethwe
I-matrix ephambene ingumqondo wezibalo oyinkimbinkimbi odinga umsebenzi onzima ephepheni ukuze uwuthole. Kodwa-ke, uhlelo lwe-Excel luyixazulula le nkinga ngesikhathi esifushane futhi ngaphandle komzamo omkhulu ohlangothini lomculi. Ake sibone ukuthi ungayithola kanjani i-matrix ephambene ngezinyathelo ezimbalwa usebenzisa esinye sezibonelo.
Inothi lochwepheshe! Imfuneko yokuthola i-matrix ephambene ukuxhumana kwedatha yokuqala ku-matrix yesikwele, kanye nesinqumo kuya ku-zero.
Ukuthola inani le-determinant
Ukuze wenze lesi senzo, kufanele usebenzise umsebenzi we-MORED. Ukuthi lokhu kwenziwa kanjani ngempela, ake sibheke isibonelo:
- Sibhala i-matrix yesikwele kunoma iyiphi indawo yamahhala.
- Sikhetha iseli yamahhala, ngemva kwalokho sithola inkinobho ethi “fx” (“Faka umsebenzi”) ngokuphambene nebha yefomula bese uchofoza kuyo nge-LMB.
- Iwindi kufanele livuleke, lapho emgqeni othi "Isigaba:" simisa ku-"Mathematical", futhi ngezansi sikhetha umsebenzi we-MOPRED. Siyavumelana nezenzo ezenziwe ngokuchofoza inkinobho ethi "KULUNGILE".
- Okulandelayo, efasiteleni elivulayo, gcwalisa izixhumanisi zamalungu afanayo.
Iseluleko! Ungagcwalisa ikheli ngendlela eyodwa kwezimbili: ngokwenza noma ngokuchofoza inkinobho yegundane endaweni lapho ulwazi olumayelana nohlu lufakwe khona futhi, ngemva kokunquma indawo ye-matrix yesikwele ngokukhetha indawo, thola ikheli le-array. ngokuzenzakalelayo.
- Ngemva kokuhlola idatha efakwe ngesandla noma ngokuzenzakalelayo, chofoza "KULUNGILE".
- Ngemuva kwakho konke ukukhohlisa, iseli elikhululekile kufanele libonise isinqumo se-matrix, inani layo elizodingeka ukuze kutholwe i-matrix ephambene. Njengoba ungabona kusithombe-skrini, emva kokubala, inombolo engu-338 yatholwa, ngakho-ke, ngenxa yokuthi i-determinant ayilingani no-0, khona-ke i-matrix ephambene ikhona.
Nquma inani le-matrix ephambene
Ngokushesha nje lapho ukubalwa kwe-determinant sekuqediwe, ungaqhubekela encazelweni ye-matrix ephambene:
- Sikhetha indawo yesici esiphezulu se-matrix ephambene, vula iwindi elithi "Faka umsebenzi".
- Khetha isigaba "sezibalo".
- Kumisebenzi engezansi, skrola ohlwini bese umisa ukukhetha ku-MOBR. Sichofoza inkinobho ethi "OK".
- Ngokufanayo nezenzo ezenziwe ngaphambilini, lapho sithola amanani we-determinant, sifaka izixhumanisi zamalungu afanayo nge-matrix yesikwele.
- Siqinisekisa ukuthi izenzo ezenziwe zilungile bese uchofoza "KULUNGILE".
- Umphumela uzovela kuseli eliphezulu kwesokunxele elikhethiwe le-matrix ephambene yesikhathi esizayo.
- Ukuze ukopishe ifomula ukuze uthole amanani kwamanye amaseli, sebenzisa ukukhetha kwamahhala. Ukwenza lokhu, sibambe i-LMB, siyilula phezu kwayo yonke indawo ye-matrix ephambene yesikhathi esizayo.
- Cindezela inkinobho F2 kukhibhodi bese uya kusethi yenhlanganisela "Ctrl + Shift + Enter". Ilungile!
Isincomo sochwepheshe! Ukuze kube lula ukwenza izinyathelo zokuthola i-matrix ephambene kusipredishithi se-Excel, indawo yamalungu afanayo ane-matrix yesikwele kanye nendawo ekhethiwe yamaseli ane-matrix ephambene kufanele ibekwe ezingeni elifanayo ngokuphathelene namakholomu. Ngale ndlela kuzoba lula ukunquma imingcele yokukhuluma yohlu lwesibili. Isibonelo sikhonjiswe emfanekisweni ongezansi.
Izindawo ezisetshenziselwa izibalo ze-matrix ephambene
I-Economics iyindawo edinga izibalo eziqhubekayo neziyinkimbinkimbi kakhulu. Ukuze kube lula ukusetshenziswa kwesistimu ye-matrix yokubala. Ukuthola i-matrix ephambene kuyindlela esheshayo yokucubungula inani elikhulu lolwazi ngesikhathi esifushane kakhulu, umphumela wokugcina uzokwethulwa ngendlela elula kakhulu yokubona.
Enye indawo yohlelo lokusebenza ukumodela isithombe se-3D. Zonke izinhlobo zezinhlelo zinamathuluzi akhelwe ngaphakathi okwenza lolu hlobo lwezibalo, olusiza kakhulu umsebenzi wabaklami ekukhiqizeni izibalo. Uhlelo oludume kakhulu phakathi kwamamodeli we-3D yi-Compass-3D.
Kunezinye izindawo zomsebenzi lapho ungasebenzisa khona uhlelo lokubala lwe-matrix ephambene, kodwa i-Excel isengathathwa njengohlelo oluyinhloko lokwenza izibalo ze-matrix.
Isiphetho
Ukuthola i-matrix ephambene akukwazi ukubizwa ngokuthi umsebenzi ofanayo wezibalo ovamile njengokususa, ukuhlanganisa noma ukuhlukanisa, kodwa uma kunesidingo sokuyixazulula, khona-ke zonke izenzo zingenziwa kusipredishithi se-Excel. Uma isici somuntu sivame ukwenza amaphutha, uhlelo lwekhompyutha luzonikeza umphumela onembile we-100%.