Inverse Matrix ma Excel. Pehea e ʻike ai i ka matrix inverse ma Excel i 2 mau ʻanuʻu

ʻO ka inverse matrix kahi manaʻo makemakika paʻakikī e koi ai i ka hana nui ma ka pepa e ʻike ai. Eia naʻe, hoʻoponopono ka polokalamu Excel i kēia pilikia i ka manawa pōkole a me ka ʻole o ka hoʻoikaika nui ʻana ma ka ʻaoʻao o ka mea hana. E ʻike pehea ʻoe e ʻike ai i ka matrix inverse i kekahi mau ʻanuʻu me ka hoʻohana ʻana i kekahi o nā laʻana.

Hoʻomaopopo akamai! ʻO kahi koi no ka loaʻa ʻana o ka matrix inverse ʻo ia ka pilina o ka ʻikepili mua i kahi matrix square, a ʻo ka mea hoʻoholo i ka ʻole.

ʻIke i ka waiwai o ka mea hoʻoholo

No ka hana ʻana i kēia hana, pono ʻoe e hoʻohana i ka hana MOPRED. Pehea e hana ʻia ai kēia, e nānā kākou i kahi laʻana:

  1. Kākau mākou i kahi matrix square ma kekahi wahi kaʻawale.
  2. Koho mākou i kahi kelepona manuahi, a laila ʻike mākou i ke pihi "fx" ("Insert function") ma ke alo o ka pahu formula a kaomi iā ia me LMB.
Inverse Matrix ma Excel. Pehea e ʻike ai i ka matrix inverse ma Excel i 2 mau ʻanuʻu
1
  1. Pono e wehe ʻia kahi puka makani, kahi ma ka laina "Category:" e kū mākou i ka "Mathematical", a ma lalo mākou e koho i ka hana MOPRED. Ua ʻae mākou i nā hana i hana ʻia ma ke kaomi ʻana i ke pihi "OK".
  2. A laila, ma ka puka aniani e wehe ai, e hoʻopiha i nā hoʻonohonoho o ka array.

'Lelo Aʻoaʻo! Hiki iā ʻoe ke hoʻopiha i ka ʻōlelo ʻana ma kekahi o nā ala ʻelua: me ka lima a i ʻole ke kaomi ʻana i ka pihi ʻiole ma kahi i hoʻokomo ʻia ai ka ʻike e pili ana i ka array a, i ka hoʻoholo ʻana i kahi o ka matrix square ma ke koho ʻana i ka ʻāpana, e kiʻi i ka helu o ka array. 'akomi.

  1. Ma hope o ka nānā ʻana i ka ʻikepili i hoʻokomo ʻia me ka lima a i ʻole, kaomi "OK".
Inverse Matrix ma Excel. Pehea e ʻike ai i ka matrix inverse ma Excel i 2 mau ʻanuʻu
2
  1. Ma hope o nā manipulations a pau, pono e hōʻike ke kelepona manuahi i ka mea hoʻoholo o ka matrix, ka waiwai o ia mea e pono ai e ʻike i ka matrix inverse. E like me kāu e ʻike ai mai ke kiʻi paʻi kiʻi, ma hope o ka helu ʻana, ua loaʻa ka helu 338, a no laila, no ka mea, ʻaʻole i like ka mea hoʻoholo me 0, a laila aia ka matrix inverse.
Inverse Matrix ma Excel. Pehea e ʻike ai i ka matrix inverse ma Excel i 2 mau ʻanuʻu
3

E hoʻoholo i ka waiwai o ka matrix inverse

Ke pau ka helu ʻana o ka mea hoʻoholo, hiki iā ʻoe ke hele i ka wehewehe ʻana o ka matrix inverse:

  1. Koho mākou i kahi o ka mea luna o ka matrix inverse, wehe i ka puka makani "Insert function".
  2. E koho i ka mahele "Math".
  3. Ma nā hana i lalo, e kaomi i ka papa inoa a ho'ōki i ka koho ma MOBR. Kaomi mākou ma ka pihi "OK".
Inverse Matrix ma Excel. Pehea e ʻike ai i ka matrix inverse ma Excel i 2 mau ʻanuʻu
4
  1. E like me nā hana i hana mua ʻia, i ka loaʻa ʻana o nā waiwai o ka mea hoʻoholo, hoʻokomo mākou i nā hoʻonohonoho o ka array me kahi matrix square.
  2. Hoʻomaopopo mākou ua pololei nā hana i hana ʻia a kaomi "OK".
  3. E ʻike ʻia ka hopena ma ka ʻaoʻao hema hema o ka matrix inverse e hiki mai ana.
  4. No ke kope ʻana i ke ʻano e ʻimi ai i nā waiwai i nā cell ʻē aʻe, e hoʻohana i ke koho manuahi. No ka hana ʻana i kēia, e hoʻopaʻa ana i ka LMB, e kau mākou iā ia ma luna o ka wahi holoʻokoʻa o ka matrix inverse e hiki mai ana.
Inverse Matrix ma Excel. Pehea e ʻike ai i ka matrix inverse ma Excel i 2 mau ʻanuʻu
5
  1. E kaomi i ka pihi F2 ma ka papa keyboard a hele i ka hoʻonohonoho o ka hui "Ctrl + Shift + Enter". Mākaukau!
Inverse Matrix ma Excel. Pehea e ʻike ai i ka matrix inverse ma Excel i 2 mau ʻanuʻu
6

Manaʻo loea! No ka ʻoluʻolu o ka hana ʻana i nā ʻanuʻu e ʻike ai i ka matrix inverse ma kahi pālahalaha Excel, ʻo ka wahi o ka array me kahi matrix square a me ka wahi i koho ʻia no nā cell me kahi matrix inverse e pono e loaʻa i ka pae like me ka mahalo i nā kolamu. Ma kēia ala e maʻalahi ka hoʻoholo ʻana i nā palena ʻōlelo o ka papa ʻelua. Hōʻike ʻia kahi laʻana ma ke kiʻi ma lalo nei.

Inverse Matrix ma Excel. Pehea e ʻike ai i ka matrix inverse ma Excel i 2 mau ʻanuʻu
7

Nā ʻāpana o ka hoʻohana ʻana no ka helu ʻana i ka matrix inverse

ʻO ka ʻoihana waiwai kahi wahi e pono ai ka helu mau a paʻakikī loa. No ka hoʻohana ʻana i kahi ʻōnaehana matrix o ka helu ʻana. ʻO ka ʻimi ʻana i ka matrix inverse kahi ala wikiwiki e hoʻoponopono ai i ka nui o ka ʻike i ka manawa pōkole loa, e hōʻike ʻia ka hopena hopena ma ke ʻano kūpono loa no ka ʻike.

ʻO kahi ʻāpana o ka noi ʻana ʻo ka hoʻohālike kiʻi 3D. Loaʻa i nā ʻano papahana āpau nā mea hana i kūkulu ʻia no ka hoʻokō ʻana i kēia ʻano helu helu, e maʻalahi loa i ka hana a nā mea hoʻolālā i ka hana ʻana i nā helu. ʻO ka papahana kaulana loa ma waena o nā mea hoʻohālike 3D ʻo Compass-3D.

Aia nā wahi ʻē aʻe o ka hana kahi e hiki ai iā ʻoe ke hoʻohana i ka ʻōnaehana helu matrix inverse, akā hiki ke manaʻo ʻia ʻo Excel ka papahana nui no ka hoʻokō ʻana i nā helu matrix.

Panina

ʻAʻole hiki ke kapa ʻia ka ʻimi ʻana i ka matrix inverse i ka hana makemakika maʻamau e like me ka unuhi ʻana, hoʻohui a mahele paha, akā inā pono e hoʻoponopono iā ia, a laila hiki ke hana ʻia nā hana āpau ma kahi pāpalapala Excel. Inā hana hewa ke kumu kanaka, a laila e hāʻawi ka polokalamu kamepiula i ka hopena pololei 100%.

Waiho i ka Reply