Kuchulukitsa matrix ndi enanso mu Microsoft Excel

Imodzi mwa ntchito zomwe zimachitika nthawi zambiri pogwira ntchito ndi matrices ndi kuchulukitsa kwa imodzi mwa imodzimodzi. Excel ndi purosesa yamphamvu yamapulogalamu, yomwe idapangidwa, kuphatikiza pochita matrices. Chifukwa chake, ali ndi zida zomwe zimawalola kuchulukana pakati pawo. Tiyeni tiwone momwe izi zingachitikire m'njira zosiyanasiyana.

Kuchulukitsa kwa Matrix

Ziyenera kunenedwa nthawi yomweyo kuti si ma matric onse omwe angachulukane pakati pawo, koma okhawo omwe amafanana ndi chikhalidwe china: kuchuluka kwa mizati imodzi ya matrix kuyenera kukhala kofanana ndi chiwerengero cha mizere ya mzake ndi mosemphanitsa. Kuphatikiza apo, kupezeka kwa zinthu zopanda kanthu mu matrices sikumaphatikizidwa. Pankhaniyi, opareshoni yofunika nawonso alephera.

Palibepo njira zochulukitsira matrices ku Excel; pali awiri okha. Ndipo onsewa ndi okhudzana ndi kugwiritsa ntchito ntchito za Excel. Tiona mwatsatanetsatane mwanjira zonsezi.

Njira 1: ntchito ya MUMNOSE

Njira yosavuta komanso yodziwika bwino pakati pa ogwiritsa ntchito ndikugwiritsa ntchito ntchitoyo MLUNGU. Wogwiritsa ntchito MLUNGU amatanthauza gulu la masamu. Ntchito yake yaposachedwa ndikupeza zinthu ziwiri za matrix. Syntax MLUNGU zikuwoneka ngati:

= MABWINO (mndandanda1; mndandanda2)

Chifukwa chake, wothandizirayu ali ndi mfundo ziwiri, zomwe zikuimira mzere wa ma matric awiri ochulukitsa.

Tsopano tiwone momwe ntchitoyo imagwiritsidwira ntchito MLUNGU pa chitsanzo cha konkriti. Pali ma matric awiri, kuchuluka kwa mizere yomwe imafanana ndi kuchuluka kwa mzati mzake ndi mosemphanitsa. Tiyenera kuchulukitsa zinthu ziwiri izi.

1. Sankhani mtundu womwe zotsatira za kuchuluka zidzawonetsedwa, kuyambira ndi khungu lakumanzere. Kukula kwa malembawa kukuyenera kufanana ndi kuchuluka kwa mizere mu matrix oyambira komanso kuchuluka kwa mizati yachiwiri. Dinani pachizindikiro "Ikani ntchito".



2. Imagwira Fotokozerani Wizard. Timasamukira kumalo "Masamu"dinani pa dzinalo MUMNOZH ndipo dinani batani "Zabwino" pansi pazenera.



3. Zenera lazokambirana lofunikira likuyambitsidwa. Pali magawo awiri pazenera ili lolowera ma adilesi a matrix arrays. Ikani wolemba m'munda "Array1"ndikugwira batani lakumanzere, ndikusankha gawo lonse la matrix oyamba pa pepalalo. Zitatha izi, maungwe ake amawonetsedwa m'munda. Ikani cholozera m'munda Array2 komanso kusankha masanjidwe achiwiri.

   Mukamaliza kukangana onse, musathamangire kukanikiza batani "Zabwino", popeza tikugwira ntchito yazosankha zambiri, zomwe zikutanthauza kuti kuti mupeze zotsatira zoyenera, njira yofananira yokwaniritsira ntchito ndi opareshoni sigwira ntchito. Wogwiritsa ntchito sanapangidwe kuti awonetse zotsatira mu khungu limodzi, chifukwa amachiwonetsa pamtundu wonse papepala. Chifukwa chake, m'malo mokanikiza batani "Zabwino" akanikizire kuphatikiza batani Ctrl + Shift + Lowani.



4. Monga mukuwonera, zitatha izi, mtundu womwe udasankhidwa kale udadzaza ndi chidziwitso. Izi ndi chifukwa chochulukitsa matrix. Ngati mungayang'ane mzere wa fomula, mutasankha chilichonse mwanjira iyi, tiwona kuti mawonekedwe akewo adakutidwa ndi mabatani a curly. Ichi ndi chizindikiro cha ntchito zambiri, zomwe zimawonjezeredwa pambuyo kukanikiza njira yaying'ono Ctrl + Shift + Lowani musanatulutsire zotsatira zake pamapepala.

Phunziro: ntchito ya EXMULZE

Njira 2: gwiritsani ntchito formula yapawiri

Kuphatikiza apo, pali njira inanso yochulukitsira matric awiri. Ndizovuta kwambiri kuposa zakale, komanso ndizoyenera kutchulidwa monga njira ina. Njirayi imaphatikizapo kugwiritsa ntchito fayilo yamagulu angapo omwe amakhala ndi ntchito SUMPRONT ndi kusanja ngati mkangano kwa wothandizira KUTENGA.

1. Pakadali pano timasankha pa pepalalo chokhacho chakumanzere kwa maselo opanda kanthu, omwe tikuyembekeza kugwiritsa ntchito kuwonetsa. Dinani pachizindikiro "Ikani ntchito".



2. Fotokozerani Wizard kuyamba. Timasamukira kumalo ogwiritsira ntchito "Masamu"koma pano sankhani dzinali SUMPRONT. Dinani batani "Zabwino".



3. Yenera yotsutsa ya ntchito yomwe ili pamwambapa ikutseguka. Wogwiritsa ntchito adapangidwa kuti achulukitse magulu osiyanasiyana pakati pawo. Matchulidwe ake ndi awa:

   = SUMPRuction (arr11; arr22; ...)

   Monga zotsutsana kuchokera pagulu Menya kutanthauzira kumapangidwira ku mtundu womwewo kuti uchulukitsidwe. Zonse, ziwiri kapena 255 zotsutsana ngati izi zingagwiritsidwe ntchito. Koma m'malo mwathu, popeza tikulimbana ndi matric awiri, tidzafunika mikangano iwiri yokha.

   Ikani wolemba m'munda "Pantan1". Apa tifunikira kulowa adilesi ya mzere woyamba wa matrix oyamba. Kuti muchite izi, pogwirizira batani lakumanzere, muyenera kungosankha pa pepala ndi kaso. Ogwirizanitsa pamtunduwu awonetsedwa pomwepo pamgawo lolingana la zenera la mkangano. Zitatha izi, muyenera kukonza zigwirizano za cholumikizira chomwe chikuyendetsedwa m'makola, ndiko kuti, izi zofunikira ziyenera kukhala mtheradi. Kuti muchite izi, pamaso pa zilembo zomwe zalembedwa pamunda, ikani chikwangwani cha dollar ($) Mapulogalamu asanagwirizane manambala (mizere), izi siziyenera kuchitika. Komanso, mutha kusankha gawo lonse m'munda ndikusindikiza batani katatu F4. Poterepa, ma mgwirizano a mizati okha ndi omwe angakhale amtheradi.



4. Pambuyo pake, ikani temberero m'munda Array2. Ndi mkanganowu, zidzakhala zovuta kwambiri, chifukwa malingana ndi malamulo ochulukitsa matrix, matrix achiwiri amafunika "kuseweredwa". Kuti muchite izi, gwiritsani ntchito ntchito yochepetsedwa KUTENGA.

   Kuti mupite ku icho, dinani chizindikirocho ngati mawonekedwe a makona atatu omwe amatsogozedwa ndi ngodya yayikulu pansi, yomwe ili kumanzere kwa mzere wa njira. Mndandanda wa mafomula omwe agwiritsidwa ntchito posachedwapa akutsegulidwa. Ngati mupeza dzinalo TRANSPkenako dinani pamenepo. Ngati mwakhala mukugwiritsa ntchito pulogalamuyi kwa nthawi yayitali kapena simunagwiritse ntchito konse, ndiye kuti simupeza dzina lomwe lili patsamba lino. Pankhaniyi, dinani chinthucho "Zina ...".



5. A zenera kale kuti tidziwe Ogwira Ntchito. Pano tikupita ku gulu Malingaliro ndi Kufika ndikusankha dzinalo TRANSP. Dinani batani "Zabwino".



6. Ntchito yotsutsana ndi ntchito imayambitsidwa. KUTENGA. Wogwiritsa ntchito amapangidwira matembenuzidwe a matebulo. Ndiye kuti, ikungosinthika, imasinthanitsa mizati ndi mizere. Izi ndizomwe tiyenera kuchita pamfundo yachiwiri ya wothandizira SUMPRONT. Ntchito Syntax KUTENGA zosavuta:

   = TRANSPOSE (mndandanda)

   Ndiye kuti, kukangana kokhako kwa opaleshoniyo kukulozera pamndandanda womwe uyenera "kufafanizidwa". M'malo mwake, kwa ife, osati lonse lonse, koma yekha mzere woyamba.

   Chifukwa chake, ikani cholozera m'munda Menya ndikusankha gawo loyambirira la matrix achiwiri papepala ndi batani lakumanzere lamanzere. Adilesi iwonetsedwa m'munda. Monga momwe zinalili kale, apa mukufunikanso kupanga zina mwamtheradi, koma nthawi ino osati zogwirizanitsa ndi mizati, koma ma adilesi a mizere. Chifukwa chake, timayika chikwangwani cha dollar patsogolo pa manambala omwe amalumikizidwa m'munda. Mutha kusankha kusankha kwathunthu ndikudina kawiri pa batani F4. Zinthu zofunikira zikakhala ndi katundu wathunthu, osadina batani "Zabwino", komanso njira yapita, gwiritsani ntchito keystroke Ctrl + Shift + Lowani.



7. Koma panthawiyi, palibe gulu lomwe linadzaza ndi ife, koma khungu limodzi lokha, lomwe tidagawa kale pakubwera Ogwira Ntchito.



8. Tiyenera kudziwa zambiri zomwe zidafanana ndi njira yoyamba. Kuti muchite izi, koperani fomula yomwe idapezedwa mu cell mulingo wofanana, womwe udzakhale wofanana ndi chiwerengero cha mizere yoyamba matrix ndi kuchuluka kwa mizati yachiwiri. M'malo mwathu, timapeza mizere itatu ndi zipilala zitatu.

   Kuti tichotse, tikugwiritsa ntchito chikhomo. Sunthani cholozera kupita kumunsi chakumanja kwa foni yomwe formula ili. Temberero limasinthidwa kukhala mtanda wakuda. Ichi ndi chikhomo chodzaza. Gwirani batani lamanzere lakumanzere ndikukoka cholozera pazonsezo pamwambapa. Selo loyambirira lomwe lili ndi chida chokha liyenera kukhala chapamwamba kumanzere kwakanthawi.



9. Monga mukuwonera, mawonekedwe osankhidwa amadzazidwa ndi deta. Ngati tiwayerekezera ndi zotsatira zomwe tidapeza pogwiritsa ntchito opareshoni MLUNGU, ndiye kuti tikuwona kuti zofunikira ndizofanana. Izi zikutanthauza kuti kuchulukitsa kwa matric awiriwo ndiowona.

Phunziro: Kugwira ntchito ndi ma arrann ku Excel

Monga mukuwonera, ngakhale kuti zotsatira zofanana zidapezeka, gwiritsani ntchito ntchitoyi kuchulukitsa matrices MLUNGU zosavuta kuposa kugwiritsa ntchito fomula yamagulu opangidwira cholinga chomwecho SUMPRONT ndi KUTENGA. Komabe, njira yinayi singathenso kunyalanyazidwa mukamafufuza njira zonse zochulukitsira matrix mu Microsoft Excel.