Matrix multiplication (MMULT) and a matrix inverse (MINVERSE) are used to solve a set of 5 linear equations. Matrix operations in Excel are input as a range with a result calculated by using CTRL-SHIFT-ENTER.
Пікірлер: 61
@drmirwaisamiri601510 ай бұрын
Thank you so much. You can also nest the MINVERSE formula within the MMULT to get it done in one go. =MMULT(MINVERSE(array), array2) Specifically for the cells in this sheet: =MMULT(MINVERSE(B2:F6), H2:H6)
@gregorybattis95883 жыл бұрын
For your last step you can drastically speed up the process using =sumproduct on a transposition of either the result or the input to double check. The formula is cleaner too.
@MuckRatz5 ай бұрын
Thank you so much! i finaly the whole matrix thing clicked in my head. !!!
@mohdalif5842 Жыл бұрын
sir, when i use minverse after i enter the value only at the first box only
@apm Жыл бұрын
Select the entire region where the result should be and hit Ctrl-Shift-Enter
@olisaiweanya75273 жыл бұрын
Doesn't work for my Trina do a 10 by 10 matrix but keeps showing number error.
@apm3 жыл бұрын
The matrix may be singular, meaning that there is no solution. Try using a 10x10 matrix that has random numbers to verify that you have the appropriate solution method procedure.
@olisaiweanya75273 жыл бұрын
@@apm oh ok. Will try that.
@olisaiweanya75273 жыл бұрын
@@apm oh yh I think it w as singular. I will rearrange my matrix coefficients to see if I get a result.
@UnstopableWords2 жыл бұрын
And finally I have solved, I was trying since yesterday 😅 and now I have solved 7by7 matrix! Thanks!
@ILUTutorials3 жыл бұрын
Thanks, I have a Structural Analysis paper after half an hour and I am sure it is going to help me alot
@marinstudios3984 жыл бұрын
Very useful! Thankyou for sharing. God bless you
@danielbonilla5916 Жыл бұрын
Why would the Ctrl + Shift + Enter not work? is there a workaround to this?
@apm Жыл бұрын
Make sure the target cells are highlighted before hitting that key combination. Newer versions of Excel don’t need that combination.
@hafizgaming1136 жыл бұрын
thanks! i really forgot the step for my IO analysis, luckily i watched yr video :)
@danielramdaia330219 күн бұрын
is this how to do matrix inversion by row operation on excel?
@justin2icy3 жыл бұрын
How would I be able to interpret where the intersection points are for these equations?
@apm3 жыл бұрын
They all intersect at the solution.
@rashiagrawal1783 жыл бұрын
Sir please help with this that if the RHS is the zero matrix then can the equations be solved in excel becoz i am unable to do so
@yashmehta44813 жыл бұрын
If RHS is a zero vector, solution vector will also be zero vector.
@Edward-2160-4 жыл бұрын
Thank you man ! I had to solve a 30×30 matrix !
@apm4 жыл бұрын
Nice work!
@diaryyuyu4 жыл бұрын
when i don't know about the step for leontrif matrix, i feel luckily to find your video
@mensgame-tn17503 жыл бұрын
Sir i have a problem , i have EXCEL 2019 and when i type =MMULT nothing shows up
@apm3 жыл бұрын
Try also typing the opening parenthesis.
@mensgame-tn17503 жыл бұрын
@@apm still the same problem , i only have in the functions menu : MATRICE.UNITAIRE :(
@mensgame-tn17503 жыл бұрын
@@apm I Don't know why but MMULT = PRODUITMAT and MINVERSE = INVERSEMAT and it works ! Thank you for your time
@apm3 жыл бұрын
Is it a language issue? Is your computer language set to something other than English?
@AyoLukeM3 жыл бұрын
THIS VIDEO SAVED ME
@ShivamVerma-gq2sm3 жыл бұрын
Thankyou. This was very helpful !
@batra043 жыл бұрын
Thanks, this video can hellp me finish my work...👍
@fisheatbrocoli36963 жыл бұрын
Can i solve this using matlab?
@apm3 жыл бұрын
Yes, here is the Matlab version of this material: apmonitor.com/che263/index.php/Main/MatlabSolveEquations The course has Excel, Matlab, and Python material.
@fisheatbrocoli36963 жыл бұрын
@@apm thank you
@hannahsantos29146 жыл бұрын
Hi, I am making 19x19 equations. And when i finally click the CTRL+SHIFT+ENTER command the cells will show up #VALUES!! that means error right?
@apm6 жыл бұрын
Yes, that either means that the matrix inverse isn't possible (singular matrix) or else the dimensions aren't correct. Make sure you have the inverse of the matrix (19x19) that you solve first. Then you multiply the matrix inverse by the right hand side that should be 19x1. The result should also be 19x1 so make sure that many cells are selected before you hit CTRL+SHIFT+ENTER. Here is an online condition number calculator although I haven't tried it personally. calculator.vhex.net/calculator/linear-algebra/condition-number-of-a-matrix
@hannahsantos29146 жыл бұрын
THANK YOU SO MUCH FOR YOUR RESPONSE! :)
@varcihoracio62945 жыл бұрын
@@apm i had the same problem and its solved. thank you Sir!
@syarifahmardhiah51035 жыл бұрын
I'm doing 124 x 124 matrix and similar problem coming out. The link is unavailable currently. Is there any other solution for my problem?
@omar-lb4rw2 жыл бұрын
Massage for arabic version: اذا محمل النسخة العربية لا تنسى تحط الارقام من يمين الى يسار مب نفس راعي المقطع..عكسه وبالتوفيق❤
@joshjamesmoule5 жыл бұрын
really good video. was struggling with this until i saw this video!
@apm5 жыл бұрын
Excel isn't the easiest tool for Matrix math either. Check out my other tutorials on Matlab and Python at apmonitor.com/che263
@bellayunus64294 жыл бұрын
THANK U SO MUCH !!
@LucasAmonatiKhingKliemczak6 жыл бұрын
Do you know how to calculate matrix inverse in a smartphone with excel?
@apm6 жыл бұрын
That seems like a tricky one because you don't necessarily have the keystroke combinations to select CTRL-SHIFT-ENTER. Maybe try a program other than Excel or else get a BlueTooth or USB keyboard that will connect to your smartphone.
@sukirtee18632 жыл бұрын
Thank you so much
@nadyaalin69223 жыл бұрын
Aaaa Thanks bgttttt 😍😍😍😍😍
@kristineclairesurilla35656 ай бұрын
Wow
@V1VAMORE32 жыл бұрын
you're awesome! ty!
@koashaygyi4 жыл бұрын
Thank you.
@KmJahid-yc5hr5 жыл бұрын
thanks a lot Sir
@alexeisaular34703 жыл бұрын
Easy as pie 😎
@guzmanmaciasjoseantonio50394 жыл бұрын
tHANK U
@isnaeiniadamkurniawan96745 жыл бұрын
THANKS BROO
@kristineforioquisel62613 жыл бұрын
Can you help me
@kristineforioquisel62613 жыл бұрын
what's on the top of =minverse, i can't see it clearly
@apm3 жыл бұрын
MMULT and MINVERSE are used together to find the solution. You may need to turn up your resolution.