Inverse Matrix a cikin Excel. Yadda ake nemo matrix inverse a cikin Excel a matakai 2

Matrix mai jujjuyawar ra'ayi ne mai rikitarwa wanda ke buƙatar aiki tuƙuru akan takarda don nemowa. Duk da haka, shirin na Excel yana magance wannan matsala a cikin gajeren lokaci kuma ba tare da ƙoƙari mai yawa daga bangaren mai yin ba. Bari mu ga yadda zaku iya samun matrix mai juzu'i a matakai da yawa ta amfani da ɗayan misalan.

Bayanin gwani! Abin da ake bukata don gano matrix mai juzu'i shine daidaiton bayanan farko zuwa matrix murabba'i, da ƙaddara zuwa sifili.

Nemo ƙimar mai ƙima

Don yin wannan aikin, dole ne ku yi amfani da aikin MOPRED. Yadda ake yin hakan daidai, bari mu kalli misali:

1. Muna rubuta matrix square a kowane sarari kyauta.
2. Za mu zaɓi tantanin halitta kyauta, bayan haka muna samun maɓallin “fx” (“Saka aikin”) a gaban mashin dabara kuma danna shi tare da LMB.

3. Ya kamata taga ta buɗe, inda a cikin layin "Kategory:" za mu tsaya a "Mathematical", kuma a ƙasa za mu zaɓi aikin MOPRED. Mun yarda da ayyukan da aka yi ta danna maɓallin "Ok".
4. Na gaba, a cikin taga da ke buɗewa, cika abubuwan daidaitawa na tsararrun.

Shawara! Kuna iya cika adireshin ta ɗaya daga cikin hanyoyi biyu: da hannu ko ta danna maɓallin linzamin kwamfuta a wurin da aka shigar da bayanai game da tsararrun kuma, bayan ƙayyade wurin matrix square ta zaɓi yankin, sami adireshin tsararru. ta atomatik.

5. Bayan duba bayanan da aka shigar da hannu ko ta atomatik, danna "Ok".

6. Bayan duk magudi, tantanin halitta ya kamata ya nuna mai ƙayyade matrix, ƙimar da za a buƙaci don nemo matrix mai juyayi. Kamar yadda kake gani daga hoton, bayan lissafin, an sami lambar 338, sabili da haka, saboda ƙayyadadden ƙididdiga ba daidai ba ne da 0, to, matrix inverse ya wanzu.

Ƙayyade ƙimar matrix juzu'i

Da zaran an gama lissafin mai ƙididdigewa, zaku iya ci gaba zuwa ma'anar matrix mai juzu'i:

1. Mun zaɓi wurin babban kashi na matrix inverse, buɗe taga "Saka aikin".
2. Zaɓi nau'in "Math".
3. A cikin ayyukan da ke ƙasa, gungura cikin jerin kuma dakatar da zaɓi akan MOBR. Muna danna maɓallin "Ok".

4. Hakazalika ga ayyukan da aka yi a baya, lokacin gano ƙimar ƙima, muna shigar da daidaitawar tsararru tare da matrix square.
5. Muna tabbatar da cewa ayyukan da aka yi daidai ne kuma danna "Ok".
6. Sakamakon zai bayyana a zaɓaɓɓen tantanin halitta na hagu na matrix inverse na gaba.
7. Don kwafi dabara don nemo ƙima a cikin wasu sel, yi amfani da zaɓi na kyauta. Don yin wannan, riƙe da LMB, za mu shimfiɗa shi a kan dukan yanki na matrix inverse na gaba.

8. Danna maɓallin F2 akan maballin kuma je zuwa saitin haɗin "Ctrl + Shift + Shigar". Shirya!

Shawarar masana! Don dacewa da aiwatar da matakan don nemo matrix mai jujjuyawar a cikin maƙunsar rubutu na Excel, wurin da ke tattare da tsararru tare da matrix murabba'i da yankin da aka zaɓa don sel tare da matrix mai juzu'i ya kamata a kasance a daidai wannan matakin dangane da ginshiƙai. Ta wannan hanyar zai zama da sauƙi don ƙayyade iyakokin magana na tsararru na biyu. An nuna misali a cikin hoton da ke ƙasa.

Wuraren da ake amfani da su don lissafin matrix juzu'i

Ilimin tattalin arziki yanki ne da ke buƙatar ƙididdiga akai-akai kuma mai sarƙaƙƙiya. Don sauƙaƙe amfani da tsarin matrix na lissafin. Neman matrix mai juzu'i hanya ce mai sauri don aiwatar da babban adadin bayanai a cikin mafi ƙarancin lokaci mai yuwuwa, sakamakon ƙarshen wanda za a gabatar da shi a cikin mafi kyawun tsari don fahimta.

Wani yanki na aikace-aikacen shine ƙirar hoto na 3D. Duk nau'ikan shirye-shirye suna da kayan aikin da aka gina don aiwatar da irin wannan ƙididdiga, wanda ke sauƙaƙe aikin masu ƙira a cikin samar da ƙididdiga. Shahararriyar shirin a tsakanin masu ƙirar 3D shine Compass-3D.

Akwai wasu wuraren aiki inda zaku iya amfani da tsarin lissafin matrix mai juzu'i, amma har yanzu ana iya ɗaukar Excel babban shirin yin lissafin matrix.

Kammalawa

Nemo matrix mai juzu'i ba za a iya kiransa aikin lissafin gama gari ɗaya kamar ragi, ƙari ko rarrabuwa ba, amma idan akwai buƙatar warware shi, ana iya aiwatar da duk ayyuka a cikin maƙunsar rubutu na Excel. Idan yanayin ɗan adam yana ƙoƙarin yin kuskure, to shirin kwamfuta zai ba da sakamako daidai 100%.