I-Inverse Matrix ku-Excel. Ungayithola kanjani i-matrix ephambene ku-Excel ngezinyathelo ezi-2

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:

  1. Sibhala i-matrix yesikwele kunoma iyiphi indawo yamahhala.
  2. Sikhetha iseli yamahhala, ngemva kwalokho sithola inkinobho ethi “fx” (“Faka umsebenzi”) ngokuphambene nebha yefomula bese uchofoza kuyo nge-LMB.
I-Inverse Matrix ku-Excel. Ungayithola kanjani i-matrix ephambene ku-Excel ngezinyathelo ezi-2
1
  1. Iwindi kufanele livuleke, lapho emgqeni othi "Isigaba:" simisa ku-"Mathematical", futhi ngezansi sikhetha umsebenzi we-MOPRED. Siyavumelana nezenzo ezenziwe ngokuchofoza inkinobho ethi "KULUNGILE".
  2. 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.

  1. Ngemva kokuhlola idatha efakwe ngesandla noma ngokuzenzakalelayo, chofoza "KULUNGILE".
I-Inverse Matrix ku-Excel. Ungayithola kanjani i-matrix ephambene ku-Excel ngezinyathelo ezi-2
2
  1. 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.
I-Inverse Matrix ku-Excel. Ungayithola kanjani i-matrix ephambene ku-Excel ngezinyathelo ezi-2
3

Nquma inani le-matrix ephambene

Ngokushesha nje lapho ukubalwa kwe-determinant sekuqediwe, ungaqhubekela encazelweni ye-matrix ephambene:

  1. Sikhetha indawo yesici esiphezulu se-matrix ephambene, vula iwindi elithi "Faka umsebenzi".
  2. Khetha isigaba "sezibalo".
  3. Kumisebenzi engezansi, skrola ohlwini bese umisa ukukhetha ku-MOBR. Sichofoza inkinobho ethi "OK".
I-Inverse Matrix ku-Excel. Ungayithola kanjani i-matrix ephambene ku-Excel ngezinyathelo ezi-2
4
  1. Ngokufanayo nezenzo ezenziwe ngaphambilini, lapho sithola amanani we-determinant, sifaka izixhumanisi zamalungu afanayo nge-matrix yesikwele.
  2. Siqinisekisa ukuthi izenzo ezenziwe zilungile bese uchofoza "KULUNGILE".
  3. Umphumela uzovela kuseli eliphezulu kwesokunxele elikhethiwe le-matrix ephambene yesikhathi esizayo.
  4. 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.
I-Inverse Matrix ku-Excel. Ungayithola kanjani i-matrix ephambene ku-Excel ngezinyathelo ezi-2
5
  1. Cindezela inkinobho F2 kukhibhodi bese uya kusethi yenhlanganisela "Ctrl + Shift + Enter". Ilungile!
I-Inverse Matrix ku-Excel. Ungayithola kanjani i-matrix ephambene ku-Excel ngezinyathelo ezi-2
6

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.

I-Inverse Matrix ku-Excel. Ungayithola kanjani i-matrix ephambene ku-Excel ngezinyathelo ezi-2
7

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%.

shiya impendulo