Ɗaya daga cikin ayyukan da ake yi a lokacin aiki tare da matrices shine haɗin ɗayan ɗayan su ta wani. Shirin Excel mai sarrafawa ne mai mahimmanci wanda aka tsara, ciki har da aiki a kan matrices. Saboda haka, yana da kayan aikin da zai ba ka damar ninka su tare. Bari mu gano yadda za a iya yin hakan a hanyoyi daban-daban.
Matrix Multiplication Process
Nan da nan dole ne in faɗi cewa ba duk matrix ba za a iya haɓaka da juna, sai dai waɗanda ke haɗuwa da wani yanayin: yawan ginshiƙai na daya matrix dole ne daidai da yawan layuka na sauran kuma vice versa. Bugu da ƙari, an cire nau'in abubuwa mara kyau a cikin matrices. A wannan yanayin, ma, yi aikin da ake buƙatar bazai aiki ba.
Babu hanyoyi da dama don ninka matrix a Excel - kawai biyu. Kuma dukansu biyu suna haɗuwa da yin amfani da aikace-aikacen Ayyukan Excel. Bari mu bincika dalla-dalla kowane irin waɗannan zaɓuɓɓuka.
Hanyar 1: aiki MUMMY
Mafi sauki kuma mafi mashahuri tsakanin masu amfani shi ne amfani da aikin. Mummy. Mai sarrafawa Mummy yana nufin ƙungiyar lissafi na ayyuka. Abinda yake aiki yanzu shi ne neman samfurin matuka guda biyu. Syntax Mummy yana da nau'i na gaba:
= MUMNAGE (array1; array2)
Sabili da haka, wannan afaretan yana da muhawara guda biyu, wanda shine nassoshin jeri na matrix biyu don a karu.
Yanzu bari mu ga yadda ake amfani da aikin. Mummy a kan wani misali. Akwai mataye biyu, yawan layuka na daya daga wanda ya dace da adadin ginshiƙai a ɗayan kuma a madadin. Muna buƙatar ninka waɗannan abubuwa guda biyu.
- Zaži kewayon inda za a nuna sakamakon ƙaddamarwa, farawa daga cikin hagu na hagu. Girman wannan kewayawa ya dace da yawan layuka a farkon matrix da lambar ginshiƙai na biyu. Muna danna kan gunkin "Saka aiki".
- Kunna Wizard aikin. Matsa zuwa toshe "Ilmin lissafi", danna sunan "MUMNOZH" kuma danna maballin "Ok" a kasan taga.
- Za a kaddamar da taga na muhawarar aikin da ake bukata. A cikin wannan taga akwai filayen biyu don shigar da adireshin matakan matrix. Sa siginan kwamfuta a filin "Array1"kuma, riƙe da maɓallin linzamin kwamfuta na hagu, zaɓi dukan sassan matrix na farko a kan takardar.Bayan haka, za'a nuna alamunta a filin. Sanya malamin a filin "Massiv2" kuma a zahiri zaɓan kewayon na biyu matrix.
Bayan an shigar da muhawara biyu, kada ka rush don latsa maballin "Ok"tun da yake muna aiki da aikin tsararraki, wanda ke nufin cewa don samun sakamako mai kyau, zabin da ya dace na kammala aikin tare da mai aiki ba zai yi aiki ba. Ba'a ƙaddamar da wannan afaretin don nuna sakamakon a cikin tantanin tantanin halitta ba, tun lokacin da yake nuna shi a cikin dukan ɗayan a kan takardar. Don haka a maimakon danna maballin "Ok" Latsa maɓallin haɗin Ctrl + Shigar + Shigar.
- Kamar yadda ka gani, bayan wannan zaɓin da aka zaba ya cika da bayanai. Wannan shi ne sakamakon ninuwar nauyin matrix. Idan ka dubi maɓallin tsari, bayan zaɓin duk wani abu na wannan zangon, zamu ga cewa dabarun kanta an nannade shi a cikin takalmin gyare-gyare. Wannan wani ɓangaren aikin aiki, wanda aka karawa bayan danna maɓallin haɗin Ctrl + Shigar + Shigar kafin fitarwa sakamakon zuwa takardar.
Darasi: Ayyukan MUMNAGE a Excel
Hanyar 2: Amfani da Formula Formula
Bugu da kari, akwai wata hanya ta ninka mataye biyu. Ya fi rikitarwa fiye da baya, amma kuma ya kamata a ambaci a matsayin madadin. Wannan hanya ta ƙunshi yin amfani da tsari mai tsafta, wanda zai kunshi aikin SUMPRODUCT kuma an rufe shi a matsayin mai shaida na mai aiki TRANSPORT.
- A wannan lokaci, zamu zaɓi kawai bangaren hagu na hagu na tsararwar kullun jaka a kan takardar, wanda muke sa ran amfani don nuna sakamakon. Danna kan gunkin "Saka aiki".
- Wizard aikin farawa Gudun zuwa ga asalin masu aiki "Ilmin lissafi"amma a wannan lokacin mun zabi sunan SUMPRODUCT. Mun danna kan maɓallin "Ok".
- Ƙarar bude gardama na aikin da ke sama yana faruwa. Ana tsara wannan afaretan don ninka nau'in nau'i daban-daban tare da juna. Sakamakonsa kamar haka:
= SUMPRODUCT (array1; array2; ...)Kamar yadda jayayya daga kungiya "Array" Magana game da ƙayyadadden ababen da za a yi amfani da shi yana amfani. Kusan kashi biyu zuwa 255 irin waɗannan muhawarar za a iya amfani. Amma a yanayinmu, tun da muna aiki da mataye biyu, zamu bukaci kawai muhawara guda biyu.
Sa siginan kwamfuta a filin "Massive1". Anan za mu buƙatar shigar da adireshin jere na farko na matrix na farko. Don yin wannan, rike maballin hagu na hagu, kawai kuna buƙatar zaɓar shi a takardar tare da siginan kwamfuta. A nan za a nuna haɓaka wannan kewayon a cikin filin dacewa ta hanyar muhawarar. Bayan haka, ya kamata ka gyara daidaitattun sakamakon mahaɗin da aka samo a kan ginshiƙai, wato, dole ne a daidaita waɗannan haɗin. Don yin wannan, kafin haruffa a cikin bayanin da aka shigar a cikin filin, saita alamar dollar ($). Kafin a ba da umarnin da aka nuna a cikin siffofi (Lines), wannan bai kamata a yi ba. A madadin, za ka iya zaɓar dukan furta a cikin filin a maimakon kuma latsa maɓallin aikin sau uku sau F4. A wannan yanayin, kawai ginshiƙan ginshiƙan zasu zama cikakke.
- Bayan haka saita siginan kwamfuta a filin "Massiv2". Da wannan hujja zai zama mafi wuya, saboda bisa ga ka'idodin jigilar matrix, matrix na biyu ya kamata a "flipped". Don yin wannan, yi amfani da aikin da aka saka TRANSPORT.
Don zuwa wurin, danna kan gunkin a cikin nau'i na triangle, wanda aka kai ta gefen ƙusa mai zurfi, wadda take a gefen hagu na tsari. Jerin sunayen da aka yi amfani da su kwanan nan ya buɗe. Idan ka sami sunan da shi "TRANSPORT"sa'an nan kuma danna kan shi. Idan kun yi amfani da wannan afaretan har dogon lokaci ko bai taɓa yin amfani dashi ba, to baza ku sami sunan da aka sanya a cikin wannan jerin ba. A wannan yanayin, danna abu. "Sauran fasali ...".
- Wurin da aka riga ya buɗe ya buɗe. Ma'aikata masu aiki. A wannan lokacin muna matsawa zuwa rukunin "Hanyoyin sadarwa da zane-zane" kuma zaɓi sunan "TRANSPORT". Danna maballin "Ok".
- An kaddamar da taga na aiki. TRANSPORT. An ƙaddamar da wannan afaretin don sauya Tables. Wato, don sanya shi kawai, shi yana suma ginshiƙai da layuka. Wannan shi ne abin da muke bukata muyi domin hujja na biyu na mai aiki. SUMPRODUCT. Haɗin aiki TRANSPORT musamman sauki:
= TRANSPORT (tsararru)Wato, kawai hujja na wannan afaretan shine mai nunawa ga tsararrakin da ya kamata a "flipped". Maimakon haka, a cikin yanayinmu, ba ma da dukan tsararru ba, amma a kan shafin farko.
Saboda haka, saita siginan kwamfuta a filin "Array" kuma zaɓi shafin farko na matrix na biyu a kan takarda tare da maɓallin linzamin kwamfuta na hagu da aka ajiye. Adireshin zai bayyana a filin. Kamar yadda a cikin akwati na baya, a nan, ma, kana buƙatar tabbatar da daidaitattun cikakkun bayanai, amma wannan lokaci ba daidaitawar ginshiƙai ba, amma adiresoshin layuka. Saboda haka, mun sanya alamar dollar a gaban lambobi a cikin haɗin da aka nuna a filin. Hakanan zaka iya zaɓar dukan furci kuma danna maballin sau biyu F4. Bayan abubuwan da suka kamata sun fara samun cikakken kaya, kada ka latsa maɓallin "Ok", da kuma a cikin hanyar da ta gabata, amfani da haɗin haɗin Ctrl + Shigar + Shigar.
- Amma a wannan lokacin, ba mu cika tsararru ba, amma kawai tantanin tantanin halitta guda ɗaya, wanda muka ƙaddamar da shi yayin da muke kira Ma'aikata masu aiki.
- Muna buƙatar cika bayanai tare da nau'ikan nau'i-nau'i kamar yadda a cikin hanyar farko. Don yin wannan, kwafa da samfurin da aka samu a cikin tantanin halitta zuwa maɗallin daidai, wanda zai daidaita da yawan layuka na farko da matrix da lambar ginshiƙai na biyu. A cikin yanayinmu na musamman, muna da layuka uku da ginshiƙai guda uku.
Don kwashe, bari mu yi amfani da alamar cika. Matsar da siginan kwamfuta a kusurwar dama na tantanin halitta inda aka samo asali. Mai siginan kwamfuta ya canza zuwa giciye. Wannan shine alamar cika. Riƙe maɓallin linzamin hagu kuma ja mai siginan kwamfuta akan dukkanin kewayo. Sautin farko tare da tsari ya kamata ya zama babban hagu na sama na tsararren.
- Kamar yadda kake gani, zabin da aka zaɓa ya cika da bayanai. Idan muka kwatanta su da sakamakon da muka samu ta hanyar amfani da mai aiki Mummy, to, zamu ga cewa dabi'un sun kasance daidai. Wannan yana nufin cewa ƙaddamar da matrix biyu daidai ne.
Darasi: Yin aiki tare da kayan aiki a Excel
Kamar yadda kake gani, duk da gaskiyar cewa an samu sakamako daidai, amfani da aikin don ninka matrices Mummy mafi sauki fiye da yin amfani da ma'anar mahaɗin masu aiki don wannan dalili SUMPRODUCT kuma TRANSPORT. Duk da haka, wannan maɓallin kuma baza'a bar shi ba tare da kula ba lokacin da yayi nazarin dukan yiwuwar ninka matrix a cikin Microsoft Excel.
