Excel yana yin lissafin abubuwa da yawa da suka danganci bayanan matrix. Shirin yana aiwatar da su azaman kewayon ƙwayoyin sel, suna aiwatar da dabarun tsari a kansu. Ofaya daga cikin waɗannan ayyukan shine gano matrix mai juzu'in. Bari mu bincika menene mahimmancin wannan hanyar.
Yankewa
Lissafin lissafi na ciki a cikin Excel zai yiwu ne kawai idan farkon matrix ya zama murabba'i, ma'ana, adadin layuka da ginshiƙai a ciki sun haɗu. Bugu da kari, mai kaddararsa ba zai zama daidai da sifili ba. Ana amfani da aikin tsararru don yin lissafi MOBR. Bari muyi lasafta irin wannan lissafi ta amfani da mafi saukin misalin.
Lissafin da mai ƙaddara
Da farko dai, muna lissafin mai tantancewa don fahimtar ko babban zaɓi yana da matrix mara damuwa ko a'a. Ana yin lissafin wannan darajar ta amfani da aikin MOPRED.
- Zaɓi kowane sel mara komai a kan takarda inda za a nuna sakamakon ƙididdigar. Latsa maballin "Saka aikin"an sanya shi kusa da dabarar dabara.
- Ya fara Mayan fasalin. A cikin jerin bayanan da yake wakilta, muna nema MOPRED, zaɓi wannan kashi kuma danna maballin "Ok".
- Tattaunawa ta buɗe tana buɗewa. Sanya siginan kwamfuta a cikin filin Shirya. Zaɓi duk kewayon sel waɗanda matrix ɗin take. Bayan adireshinsa ya bayyana a filin, danna maballin "Ok".
- Shirin yana kirga mai yanke hukunci. Kamar yadda kake gani, saboda yanayinmu daidai yake da - 59, wato, ba daidai yake da sifili ba. Wannan ya bamu damar cewa wannan matrix yana da akasin haka.
Lissafin matrix mai juyayi
Yanzu zaku iya ci gaba zuwa ƙididdigar lissafin kai tsaye na matrix inverse.
- Zaɓi tantanin da yakamata ya zama babbar hagu na hagu na matrix na juji. Je zuwa Mayan fasalinta danna kan gunkin zuwa hagu na dabarar dabara.
- A cikin jerin da ke buɗe, zaɓi aikin MOBR. Latsa maballin "Ok".
- A fagen Shirya, taga muhawara na ayyuka yana buɗe, saita siginan kwamfuta. Sanya dukkan babban zangon farko. Bayan bayyanar adireshinsa a cikin filin, danna maballin "Ok".
- Kamar yadda kake gani, darajar ta bayyana a sel guda daya wanda tsarin yake. Amma muna buƙatar cikakken ƙarfin aiki, saboda haka ya kamata mu kwafa dabarar ga wasu ƙwayoyin. Zaɓi kewayon da yake daidai a sararin sama da tsaye zuwa tsararrun bayanai na asali. Danna maballin aiki F2, sannan kuma buga lambar a hade Ctrl + Shift + Shigar. Nau'i na ƙarshen ne wanda aka tsara don magance arrays.
- Kamar yadda kake gani, bayan waɗannan ayyuka, ana lissafta matrix inverse a cikin sel da aka zaɓa.
A kan wannan ƙididdigar za a iya la'akari da kammala.
Idan kayi lissafin mai tantancewa da matsex na cikin kawai tare da alƙalami da takarda, to akan wannan ƙididdigar, a yanayin aiki akan hadaddun misali, zaku iya rikice-rikice na dogon lokaci. Amma, kamar yadda zaku iya gani, a cikin shirin Excel, ana yin waɗannan ƙididdigar sosai cikin sauri, ba tare da la'akari da rikitarwa na aikin ba. Ga mutumin da ya saba da lissafin irin wannan ƙididdigar a cikin wannan aikace-aikacen, lissafin gaba ɗaya yana zuwa ayyukan yau da kullun.
