Inverse Matrix muExcel. Maitiro ekutsvaga iyo inverse matrix muexcel mumatanho maviri

Iyo inverse matrix ipfungwa yakaoma yemasvomhu inoda kushanda nesimba pabepa kuti uwane. Nekudaro, chirongwa cheExcel chinogadzirisa dambudziko iri munguva pfupi uye pasina simba rakawanda pane chikamu chemuiti. Ngatione kuti ungawana sei inverse matrix mumatanho akati wandei uchishandisa mumwe wemienzaniso.

Nyanzvi note! Chinodiwa chekutsvaga iyo inverse matrix iko kunyorerana kweiyo data yekutanga kune sikweya matrix, uye determinant kusvika zero.

Kuwana kukosha kweiyo determinant

Kuti uite chiito ichi, unofanirwa kushandisa iyo MOPRED basa. Izvi zvinoitwa sei chaizvo, ngatitarisei muenzaniso:

  1. Tinonyora square matrix mune chero nzvimbo yakasununguka.
  2. Isu tinosarudza sero yemahara, mushure mezvo tinowana bhatani "fx" ("Isa basa") rakatarisana nebhari yeformula uye tinya pairi neLMB.
Inverse Matrix muExcel. Maitiro ekutsvaga iyo inverse matrix muexcel mumatanho maviri
1
  1. Iwindo rinofanira kuzarura, apo mu "Category:" mutsetse tinomira pa "Mathematical", uye pasi tinosarudza basa reMOPRED. Isu tinobvumirana nezviito zvakaitwa nekudzvanya bhatani rekuti "OK".
  2. Tevere, muhwindo rinovhurwa, zadza macoordinates eiyo array.

Zano! Iwe unogona kuzadza kero mune imwe yenzira mbiri: nemaoko kana nekudzvanya bhatani rembeva panzvimbo inopinzwa ruzivo nezve array uye, waona nzvimbo yesquare matrix nekusarudza iyo zone, tora kero yeiyo array. automatic.

  1. Mushure mekutarisa iyo data yakapinda nemaoko kana otomatiki, tinya "OK".
Inverse Matrix muExcel. Maitiro ekutsvaga iyo inverse matrix muexcel mumatanho maviri
2
  1. Mushure mezvose zvinoshandiswa, sero yakasununguka inofanira kuratidza iyo inogadzirisa matrix, kukosha kwayo kuchadiwa kuti uwane inverse matrix. Sezvauri kuona kubva pascreenshot, mushure mekuverenga, nhamba 338 yakawanikwa, uye, saka, nekuti iyo determinant haina kuenzana ne0, ipapo inverse matrix iripo.
Inverse Matrix muExcel. Maitiro ekutsvaga iyo inverse matrix muexcel mumatanho maviri
3

Sarudza kukosha kweiyo inverse matrix

Pangopera kuverenga kweiyo determinant, unogona kuenderera kune tsananguro yeiyo inverse matrix:

  1. Isu tinosarudza nzvimbo yechinhu chepamusoro che inverse matrix, vhura hwindo re "Insert function".
  2. Sarudza chikamu che "Math".
  3. Mune mabasa ari pazasi, penya nepakati uye misa sarudzo paMOBR. Tinya bhatani "OK".
Inverse Matrix muExcel. Maitiro ekutsvaga iyo inverse matrix muexcel mumatanho maviri
4
  1. Saizvozvo kune zvakamboitwa zviito, kana tichiwana kukosha kweiyo determinant, isu tinopinda macoordha eiyo array ane sikweya matrix.
  2. Isu tinoita shuwa kuti zviito zvakaitwa ndezvechokwadi uye tinya "OK".
  3. Mhedzisiro yacho inozoonekwa musero rekumusoro kuruboshwe remangwana inverse matrix.
  4. Kukopa fomula kuti uwane kukosha mune mamwe maseru, shandisa yemahara sarudzo. Kuti tiite izvi, takabata LMB, tinoitambanudza pamusoro penzvimbo yese yeramangwana inverse matrix.
Inverse Matrix muExcel. Maitiro ekutsvaga iyo inverse matrix muexcel mumatanho maviri
5
  1. Dzvanya bhatani reF2 pane keyboard uye enda kune seti yemusanganiswa "Ctrl + Shift + Enter". Ready!
Inverse Matrix muExcel. Maitiro ekutsvaga iyo inverse matrix muexcel mumatanho maviri
6

Kurudziro yenyanzvi! Kuti zvive nyore kuita matanho ekutsvaga inverse matrix muExcel spreadsheet, nzvimbo yearray ine square matrix uye nzvimbo yakasarudzwa yemasero ane inverse matrix inofanira kunge iri pamwero wakafanana maererano nemakoramu. Nenzira iyi zvichave nyore kuziva miganhu yeadhiresi yemhando yechipiri. Muenzaniso unoratidzwa mumufananidzo uri pasi apa.

Inverse Matrix muExcel. Maitiro ekutsvaga iyo inverse matrix muexcel mumatanho maviri
7

Nzvimbo dzekushandisa kune inverse matrix kuverenga

Economics inzvimbo inoda kugara uye kuomesesa masvomhu. Kufambisa kushandiswa kwematrix system yekuverenga. Kutsvaga iyo inverse matrix inzira inokurumidza kugadzirisa huwandu hukuru hweruzivo munguva pfupi inokwanisika, mhedzisiro yacho ichaunzwa mune yakanyanya kunaka fomu yekuona.

Imwe nharaunda yekushandisa ndeye 3D mufananidzo modhi. Mhando dzese dzezvirongwa zvakavaka-mukati maturusi ekuita rudzi urwu rwekuverenga, izvo zvinofambisa zvakanyanya basa revagadziri mukugadzira masvomhu. Chirongwa chinonyanya kufarirwa pakati pevatevedzeri ve3D iCompass-3D.

Kune dzimwe nzvimbo dzekuita kwaunogona kushandisa inverse matrix calculation system, asi Excel inogona kuramba ichionekwa sechirongwa chikuru chekuita matrix kuverenga.

mhedziso

Kuwana inverse matrix haigoni kunzi yakafanana basa remasvomhu rakafanana nekubvisa, kuwedzera kana kupatsanura, asi kana pane chido chekugadzirisa, ipapo zviito zvose zvinogona kuitwa muExcel spreadsheet. Kana chinhu chemunhu chichiita zvikanganiso, ipapo chirongwa chekombuta chinopa 100% chaiyo mhedzisiro.

Leave a Reply