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)
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.
@@apm Good sir, Thank you so much! This was my problem earlier during my exam. Although I have submitted it late, it's thanks to you I have completed it! I'm so thankful I could probably kiss you right now
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.
Yes, here is the Matlab version of this material: apmonitor.com/che263/index.php/Main/MatlabSolveEquations The course has Excel, Matlab, and Python material.
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
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.
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)
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.
Thank you so much! i finaly the whole matrix thing clicked in my head. !!!
sir, when i use minverse after i enter the value only at the first box only
Select the entire region where the result should be and hit Ctrl-Shift-Enter
@@apm Good sir, Thank you so much! This was my problem earlier during my exam. Although I have submitted it late, it's thanks to you I have completed it! I'm so thankful I could probably kiss you right now
Why would the Ctrl + Shift + Enter not work? is there a workaround to this?
Make sure the target cells are highlighted before hitting that key combination. Newer versions of Excel don’t need that combination.
Doesn't work for my Trina do a 10 by 10 matrix but keeps showing number error.
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.
@@apm oh ok. Will try that.
@@apm oh yh I think it w as singular. I will rearrange my matrix coefficients to see if I get a result.
How would I be able to interpret where the intersection points are for these equations?
They all intersect at the solution.
is this how to do matrix inversion by row operation on excel?
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
If RHS is a zero vector, solution vector will also be zero vector.
Sir i have a problem , i have EXCEL 2019 and when i type =MMULT nothing shows up
Try also typing the opening parenthesis.
@@apm still the same problem , i only have in the functions menu : MATRICE.UNITAIRE :(
@@apm I Don't know why but MMULT = PRODUITMAT and MINVERSE = INVERSEMAT and it works ! Thank you for your time
Is it a language issue? Is your computer language set to something other than English?
Thanks, I have a Structural Analysis paper after half an hour and I am sure it is going to help me alot
Can i solve this using matlab?
Yes, here is the Matlab version of this material: apmonitor.com/che263/index.php/Main/MatlabSolveEquations The course has Excel, Matlab, and Python material.
@@apm thank you
Very useful! Thankyou for sharing. God bless you
And finally I have solved, I was trying since yesterday 😅 and now I have solved 7by7 matrix! Thanks!
Thank you man ! I had to solve a 30×30 matrix !
Nice work!
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?
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
THANK YOU SO MUCH FOR YOUR RESPONSE! :)
@@apm i had the same problem and its solved. thank you Sir!
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?
Do you know how to calculate matrix inverse in a smartphone with excel?
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.
thanks! i really forgot the step for my IO analysis, luckily i watched yr video :)
when i don't know about the step for leontrif matrix, i feel luckily to find your video
Massage for arabic version:
اذا محمل النسخة العربية لا تنسى تحط الارقام من يمين الى يسار
مب نفس راعي المقطع..عكسه
وبالتوفيق❤
Can you help me
what's on the top of =minverse, i can't see it clearly
MMULT and MINVERSE are used together to find the solution. You may need to turn up your resolution.
Aaaa Thanks bgttttt 😍😍😍😍😍
THIS VIDEO SAVED ME
really good video. was struggling with this until i saw this video!
Excel isn't the easiest tool for Matrix math either. Check out my other tutorials on Matlab and Python at apmonitor.com/che263
Thankyou. This was very helpful !
thanks a lot Sir
Easy as pie 😎
Thank you so much
Wow
THANK U SO MUCH !!
tHANK U
Thank you.
I wasted two hours tryna fix this problem. WTF
Well, I hope this helped.
you're awesome! ty!
THANKS BROO
Thanks, this video can hellp me finish my work...👍