I-Excel yenza izibalo ezihlukahlukene ezihlobene nedatha yamatriki. Uhlelo lubaphatha njengezinhlobo zamangqamuzana, besebenzisa amafomula amasha kubo. Enye yalezi zenzo ithola umthamo we-inverse. Ake sithole ukuthi iyiphi i-algorithm yale nqubo.
Ukwenza izibalo
Ukubalwa kwe-matrix okuphambene ku-Excel kungenzeka kuphela uma isibalo sokuqala sikwele, okungukuthi, inani lemigqa namakholomu kulo liyefana. Ngaphezu kwalokho, isinqunyiwe sayo akumele sibe yi-zero. Umsebenzi wokuhlela usetshenziselwa ukubala MOBR. Ake sicabangele ukulingana okufanayo usebenzisa isibonelo esilula.
Ukubalwa kwe-determinant
Okokuqala, ake sibone isinqununu ukuze siqonde ukuthi ibanga eliyinhloko linomthamo we-inverse noma cha. Leli nani libalwa ngokusebenzisa umsebenzi MEPRED.
- Khetha noma iyiphi iseli elingenalutho kushidi, lapho imiphumela yokubala izoboniswa khona. Sicindezela inkinobho "Faka umsebenzi"kufakwe eduze kwe-bar bar.
- Iqala Umsebenzi weWebhu. Kuloluhlu lwamarekhodi alumele, sifuna I-MOPREDkhetha le nto bese uchofoza inkinobho "Kulungile".
- Iwindi lempikiswano ivuleka. Faka i-cursor ensimini "Uhlu". Khetha lonke uhla lwamaseli lapho i-matrix ikhona khona. Ngemuva kokuthi ikheli lakhe livele ensimini, chofoza inkinobho "Kulungile".
- Uhlelo lubala inani elinqunyiwe. Njengoba sibona, ngoba icala lethu lilingana no-59, okungukuthi, alifani nhlobo. Lokhu kukuvumela ukuba usho ukuthi le matrix ine-inverse.
Ukubalwa kwe-matrix okungafani
Manje singakwazi ukuqhubeka nokubala okuqondile kwe-matrix ehlane.
- Khetha iseli, okufanele ibe iseli eliphezulu ngakwesobunxele le-matrix engenayo. Iya ku Umsebenzi weWebhungokuchofoza isithonjana ngakwesokunxele kwibha yefomula.
- Kulolu hlu oluvula, khetha umsebenzi MOBR. Sicindezela inkinobho "Kulungile".
- Ensimini "Uhlu", iwindi lempikiswano yokusebenza elivula, setha isikhombisi. Khetha lonke ibanga eliyinhloko. Ngemuva kokuvela kwekheli lakhe ensimini, chofoza inkinobho "Kulungile".
- Njengoba ubona, inani livele kuphela esitokisini esisodwa lapho kwakukhona ifomula. Kodwa sidinga ukusebenza okuphelele, ngakho kufanele sikopishe ifomula kwamanye amaseli. Sakhetha ububanzi obulinganayo ngokuzenzekelayo futhi bubukeke ku-data yasekhaya yangempela. Sicindezela ukhiye womsebenzi F2bese uthayipha inhlanganisela Ctrl + Shift + Faka. Kuyinto inhlanganisela yokugcina esetshenziselwa ukucubungula izigaba.
- Njengoba ubona, ngemuva kwalezi zenzo, i-matrix inverse ibalwa kumaseli akhethiwe.
Kulesi sibalo singacatshangwa siphelele.
Uma ubala i-matrix esinqunyiwe kanye ne-inverse kuphela ipeni nephepha, ungacabanga ngalokhu kubalwa, uma usebenza esibonelweni esiyinkimbinkimbi, isikhathi eside kakhulu. Kodwa, njengoba sibona, ohlelweni lwe-Excel, lezi zibalo zenziwa ngokushesha kakhulu, kungakhathaliseki ukuthi ziyinkimbinkimbi yomsebenzi. Ngomuntu ojwayele i-algorithm yezibalo ezinjalo kulolu hlelo lokusebenza, konke ukubalwa kuncishiswe kube yizenzo zemishini kuphela.
