Inverse Matrix hauv Excel. Yuav ua li cas nrhiav cov inverse matrix hauv excel hauv 2 kauj ruam

Lub inverse matrix yog ib tug complex lej tswvyim uas yuav tsum tau ib tug ntau ntawm nyuaj ua hauj lwm nyob rau hauv daim ntawv mus nrhiav. Txawm li cas los xij, Excel qhov kev pab cuam daws qhov teeb meem no hauv lub sijhawm luv dua thiab tsis muaj kev siv zog ntau ntawm cov neeg ua yeeb yam. Cia wb mus saib yuav ua li cas koj tuaj yeem pom qhov hloov pauv matrix hauv ob peb kauj ruam siv ib qho piv txwv.

Lus ceeb toom! Ib qho yuav tsum tau ua ua ntej rau kev nrhiav qhov inverse matrix yog cov ntawv xov xwm ntawm thawj cov ntaub ntawv mus rau square matrix, thiab tus txiav txim siab rau xoom.

Nrhiav tus nqi ntawm tus txiav txim

Txhawm rau ua qhov no, koj yuav tsum siv MOPRED muaj nuj nqi. Yuav ua li cas raws nraim qhov no ua tiav, cia peb saib ib qho piv txwv:

  1. Peb sau ib square matrix nyob rau hauv txhua qhov chaw dawb.
  2. Peb xaiv lub xovtooj dawb, tom qab ntawd peb pom lub pob "fx" ("Ntxig ua haujlwm") tawm tsam tus qauv bar thiab nyem rau ntawm nws nrog LMB.
Inverse Matrix hauv Excel. Yuav ua li cas nrhiav cov inverse matrix hauv excel hauv 2 kauj ruam
1
  1. Lub qhov rais yuav tsum qhib, qhov twg nyob rau hauv "Category:" kab peb nres ntawm "Mathematical", thiab hauv qab no peb xaiv MOPRED muaj nuj nqi. Peb pom zoo nrog cov kev nqis tes ua los ntawm nias rau ntawm "OK" khawm.
  2. Tom ntej no, nyob rau hauv lub qhov rais uas qhib, sau nyob rau hauv lub coordinates ntawm lub array.

Tswv yim! Koj tuaj yeem sau qhov chaw nyob hauv ib qho ntawm ob txoj hauv kev: manually lossis los ntawm nias lub pob nas ntawm qhov chaw uas cov ntaub ntawv hais txog array nkag mus thiab, tau txiav txim siab qhov chaw ntawm square matrix los ntawm kev xaiv thaj chaw, tau txais qhov chaw nyob ntawm array. txiav txim.

  1. Tom qab kuaj xyuas cov ntaub ntawv nkag los ntawm manually lossis txiav, nyem "OK".
Inverse Matrix hauv Excel. Yuav ua li cas nrhiav cov inverse matrix hauv excel hauv 2 kauj ruam
2
  1. Tom qab tag nrho cov manipulations, lub cell dawb yuav tsum tso saib lub determinant ntawm lub matrix, tus nqi uas yuav tsum tau mus nrhiav tus inverse matrix. Raws li koj tuaj yeem pom los ntawm lub screenshot, tom qab kev suav, tus lej 338 tau txais, thiab, vim li ntawd, vim tias qhov ntsuas tsis sib npaug rau 0, ces qhov sib txawv matrix tshwm sim.
Inverse Matrix hauv Excel. Yuav ua li cas nrhiav cov inverse matrix hauv excel hauv 2 kauj ruam
3

Txiav txim siab tus nqi ntawm inverse matrix

Sai li qhov kev xam ntawm tus txiav txim tiav lawm, koj tuaj yeem mus rau lub ntsiab lus ntawm inverse matrix:

  1. Peb xaiv qhov chaw ntawm lub sab sauv ntawm lub inverse matrix, qhib lub "Insert function" qhov rais.
  2. Xaiv qeb " lej".
  3. Hauv cov haujlwm nyob hauv qab no, scroll los ntawm cov npe thiab nres qhov kev xaiv ntawm MOBR. Peb nyem rau ntawm lub pob "OK".
Inverse Matrix hauv Excel. Yuav ua li cas nrhiav cov inverse matrix hauv excel hauv 2 kauj ruam
4
  1. Zoo ib yam li cov kev ua yav dhau los, thaum nrhiav qhov tseem ceeb ntawm tus txiav txim, peb nkag mus rau qhov kev tswj hwm ntawm cov array nrog lub square matrix.
  2. Peb xyuas kom meej tias cov kev ua tau ua yog lawm thiab nyem "OK".
  3. Qhov tshwm sim yuav tshwm sim nyob rau hauv cov xaiv sab sauv sab laug ntawm lub neej yav tom ntej inverse matrix.
  4. Txhawm rau luam cov qauv kom pom qhov tseem ceeb hauv lwm lub hlwb, siv kev xaiv dawb. Ua li no, tuav lub LMB, peb ncab nws hla tag nrho cheeb tsam ntawm lub neej yav tom ntej inverse matrix.
Inverse Matrix hauv Excel. Yuav ua li cas nrhiav cov inverse matrix hauv excel hauv 2 kauj ruam
5
  1. Nias lub khawm F2 ntawm cov keyboard thiab mus rau txheej ntawm kev sib xyaw ua ke "Ctrl + Ua haujlwm + Nkag mus". Npaj txhij!
Inverse Matrix hauv Excel. Yuav ua li cas nrhiav cov inverse matrix hauv excel hauv 2 kauj ruam
6

Cov kws tshaj lij pom zoo! Txhawm rau ua kom yooj yim ntawm kev ua cov kauj ruam txhawm rau nrhiav cov matrix inverse hauv Excel spreadsheet, qhov chaw ntawm cov array nrog square matrix thiab cov cheeb tsam xaiv rau cov hlwb nrog inverse matrix yuav tsum nyob rau tib theem nrog rau cov kab. Li no nws yuav yooj yim dua los txiav txim qhov chaw nyob ciam teb ntawm qhov thib ob array. Ib qho piv txwv muaj nyob rau hauv daim duab hauv qab no.

Inverse Matrix hauv Excel. Yuav ua li cas nrhiav cov inverse matrix hauv excel hauv 2 kauj ruam
7

Cov cheeb tsam siv rau inverse matrix xam

Kev lag luam yog ib cheeb tsam uas yuav tsum tau suav tas li thiab nyuaj heev. Txhawm rau kom yooj yim rau kev siv lub matrix system ntawm kev suav. Nrhiav qhov inverse matrix yog ib txoj hauv kev ceev ceev los ua cov ntaub ntawv ntau hauv lub sijhawm luv tshaj plaws, qhov kawg tshwm sim uas yuav nthuav tawm hauv daim ntawv yooj yim tshaj plaws rau kev nkag siab.

Lwm qhov chaw ntawm daim ntawv thov yog 3D duab qauv. Txhua yam ntawm cov kev pab cuam muaj cov cuab yeej built-in rau kev ua raws li cov kev suav no, uas pab txhawb kev ua haujlwm ntawm cov neeg tsim qauv hauv kev tsim cov kev suav. Qhov kev pabcuam nrov tshaj plaws ntawm 3D qauv yog Compass-3D.

Muaj lwm qhov chaw ntawm kev ua ub no uas koj tuaj yeem siv cov txheej txheem rov qab matrix, tab sis Excel tseem tuaj yeem suav tias yog qhov kev pabcuam tseem ceeb rau kev suav matrix.

xaus

Nrhiav qhov inverse matrix tsis tuaj yeem hu ua tib yam kev ua lej ua lej xws li rho tawm, ntxiv lossis faib, tab sis yog tias xav tau los daws nws, ces txhua qhov haujlwm tuaj yeem ua tiav hauv Excel daim ntawv nthuav qhia. Yog tias tib neeg qhov xwm txheej zoo li ua yuam kev, ces lub khoos phis tawj yuav muab 100% qhov tseeb.

Sau ntawv cia Ncua