Inverse Matrix mu Excel. Momwe mungapezere matrix osinthika mu Excel mu 2 masitepe

Matrix osinthika ndi lingaliro lovuta la masamu lomwe limafunikira kulimbikira pamapepala kuti mupeze. Komabe, pulogalamu ya Excel imathetsa vutoli pakanthawi kochepa komanso popanda kuyesetsa kwakukulu kwa woimbayo. Tiyeni tiwone momwe mungapezere matrix osinthika pamasitepe angapo pogwiritsa ntchito chitsanzo chimodzi.

Chidziwitso cha akatswiri! Chofunikira kuti mupeze matrix osinthika ndi kulumikizana kwa deta yoyambira ku matrix a square, komanso chotsimikizira kuti zero.

Kupeza mtengo wa determinant

Kuti muchite izi, muyenera kugwiritsa ntchito MOPRED. Momwe izi zimachitikira ndendende, tiyeni tiwone chitsanzo:

  1. Timalemba matrix a square mu malo aliwonse aulere.
  2. Timasankha foni yaulere, kenako timapeza batani "fx" ("Ikani ntchito") moyang'anizana ndi kapamwamba ndikudina pa LMB.
Inverse Matrix mu Excel. Momwe mungapezere matrix osinthika mu Excel mu 2 masitepe
1
  1. Zenera liyenera kutsegulidwa, pomwe mzere wa "Category:" timayima pa "Masamu", ndipo pansipa timasankha ntchito ya MOPRED. Timavomereza zomwe zachitika podina batani "Chabwino".
  2. Kenako, pawindo lomwe limatsegulidwa, lembani ma coordinates a gululo.

Upangiri! Mutha kudzaza maadiresi m'njira ziwiri: pamanja kapena podina batani la mbewa pamalo pomwe zidziwitso za gululo zimalowetsedwa ndipo, mutadziwa malo a square matrix posankha chigawocho, pezani adilesi ya gululo. zokha.

  1. Pambuyo poona deta analowa pamanja kapena basi, dinani "Chabwino".
Inverse Matrix mu Excel. Momwe mungapezere matrix osinthika mu Excel mu 2 masitepe
2
  1. Pambuyo pakusintha konse, selo laulere liyenera kuwonetsa chosankha cha matrix, mtengo wake womwe udzafunike kupeza matrix osinthika. Monga mukuwonera pachithunzichi, mutatha kuwerengera, chiwerengero cha 338 chinapezedwa, chifukwa chake, chifukwa chodziwika sichifanana ndi 0, ndiye kuti matrix osinthika alipo.
Inverse Matrix mu Excel. Momwe mungapezere matrix osinthika mu Excel mu 2 masitepe
3

Dziwani kufunikira kwa matrix osintha

Kuwerengera kwa determinant kukamalizidwa, mutha kupita ku tanthauzo la matrix osinthika:

  1. Timasankha malo omwe ali pamwamba pa matrix osinthika, tsegulani zenera la "Ikani ntchito".
  2. Sankhani gulu la "Math".
  3. Pazigawo zomwe zili pansipa, pindani pamndandanda ndikuyimitsa kusankha pa MOBR. Timadina batani "Chabwino".
Inverse Matrix mu Excel. Momwe mungapezere matrix osinthika mu Excel mu 2 masitepe
4
  1. Mofananamo ndi zomwe zidachitika kale, tikapeza zofunikira za determinant, timalowetsa ma coordinates omwe ali ndi square matrix.
  2. Timaonetsetsa kuti zomwe zachitika ndi zolondola ndikudina "Chabwino".
  3. Chotsatiracho chiwonekera mu cell yosankhidwa yakumanzere kwa matrix am'tsogolo.
  4. Kuti mutengere fomula kuti mupeze ma cell ena, gwiritsani ntchito kusankha kwaulere. Kuti tichite izi, titagwira LMB, timatambasula kudera lonse la matrix osinthika amtsogolo.
Inverse Matrix mu Excel. Momwe mungapezere matrix osinthika mu Excel mu 2 masitepe
5
  1. Dinani batani F2 pa kiyibodi ndikupita ku seti ya kuphatikiza "Ctrl + Shift + Lowani". Okonzeka!
Inverse Matrix mu Excel. Momwe mungapezere matrix osinthika mu Excel mu 2 masitepe
6

Malingaliro a akatswiri! Kuti mukhale osavuta kuchita masitepe kuti mupeze matrix osinthika mu Excel spreadsheet, malo omwe ali ndi masikweya matrix ndi malo osankhidwa a ma cell okhala ndi matrix osinthika ayenera kukhala pamlingo womwewo potsata mizati. Mwanjira iyi kudzakhala kosavuta kudziwa malire a maadiresi a gulu lachiwiri. Chitsanzo chili m’chitsanzo chili m’munsichi.

Inverse Matrix mu Excel. Momwe mungapezere matrix osinthika mu Excel mu 2 masitepe
7

Magawo omwe amagwiritsidwa ntchito powerengera matrix osinthika

Economics ndi gawo lomwe limafuna kuwerengera kosalekeza komanso kovuta kwambiri. Kuthandizira kugwiritsa ntchito matrix system of calculations. Kupeza matrix osinthika ndi njira yachangu yosinthira zidziwitso zambiri munthawi yaifupi kwambiri, zomwe pamapeto pake zidzawonetsedwa mwanjira yabwino kwambiri yowonera.

Mbali ina yogwiritsira ntchito ndikujambula zithunzi za 3D. Mapulogalamu amitundu yonse ali ndi zida zopangira mawerengedwe amtunduwu, zomwe zimathandizira kwambiri ntchito ya opanga kupanga mawerengedwe. Pulogalamu yotchuka kwambiri pakati pa ojambula a 3D ndi Compass-3D.

Palinso mbali zina zomwe mungagwiritse ntchito njira yowerengera matrix, koma Excel imatha kuonedwa ngati pulogalamu yayikulu yowerengera matrix.

Kutsiliza

Kupeza matrix osinthika sikungatchulidwe kuti ndi ntchito yofananira yamasamu monga kuchotsa, kuwonjezera kapena kugawa, koma ngati pakufunika kutero, ndiye kuti zonse zitha kuchitika mu Excel spreadsheet. Ngati chinthu chaumunthu chimakonda kulakwitsa, ndiye kuti pulogalamu ya pakompyuta idzapereka zotsatira zolondola 100%.

Siyani Mumakonda