Thank you for a very clear and useful tutorial! I just want to join the chorus of those who are grateful to you for taking the time to help us in this way. I hope your generosity is rewarded in some way.
Hi, what if their are more than 1 solution ? How can we find all of them ? For example with that problem : x+2y+z=4 2x-z=1 x+y+z=3 (1,1,1) and (-1,1,3) are solutions
human boundaries Thanks for your kind words. Basically, this is the most direct way to solve them. A good analogy is to think of a simple equation like: 3x = 12 When we solve this for x, we actually take the multiplicative inverse of the 3 ( which is 1/3 ) and multiply that by the 12, yielding the answer: x = 4.This is why we take the inverse of the square matrix and then multiply it with the column matrix to give the results. The results here are found in another column matrix. I hope that made sense. :) Thanks again for the comment!
@@profarrington Your video brings us to a point where we have a bunch of numbers, but we still don't know the values of x, y, r, s, t, A, B, C, D, E. We are no better at the end than at the beginning. How do we get from those matrices to the solutions? Oh, I see! The last column on the right shows the values of the variables in order (left to right becomes top to bottom). For people who took linear algebra in the 70's, that might be a good thing to include.Perhaps you could mention it in the notes. :)
It certainly works for a 9x9 system. I would caution you to be careful about entering the coefficients, but it works just fine. Thanks for the question! 😀
I just tried it with a 10x10 system and it worked fine. Depending on your coefficients, it is possible to get a non-solvable (either inconsistent or dependent) system. The primary way to know this is to take the matrix inverse of the square matrix and see if there is a solution. If not (e.g. if Excel give you an error) then you either have a dependent or inconsistent system.
Hi Mr. Cortez, Sorry the music was distracting. I discontinued it during the salient portions of the presentation. It was only included at the beginning and the end portions. The music was embedded in the video before I posted it and cannot be turned off. Regards, ProfArrington
![Excel for Chemical Engineers | 10 | Basics [Solving a system of non-linear equations] (9/10)](/img/n.gif)
So what are the values of X & Y or r, s & t, etc. ?
does this work for a 9x9 matrix
Helped a lot,thanyou veryuch
I'm glad it helped!
Thank you for a very clear and useful tutorial! I just want to join the chorus of those who are grateful to you for taking the time to help us in this way. I hope your generosity is rewarded in some way.
Thank you for the tutorial. It was easy to follow along. Do you know how to include constraints that include greater than/less than restrictions?
Thanks for the comment, Kayla. Can you give a specific example of the problem you are describing?
+Kayla Capps Add-ons -> Solver
I know this video is older, but what about free variables, how can i find them using excel?
i pressed held down ctrl shift and enter but i still got 1 answer.. using excel 2013
Thank you for sharing it.Its really nice to have the video as handy procedure for solving Simultaneous Equations in Excel
Thanks, Nitin. I really takes the drudgery out of solving simeq's and even makes them FUN! :)
Hi, what if their are more than 1 solution ? How can we find all of them ?
For example with that problem :
x+2y+z=4
2x-z=1
x+y+z=3
(1,1,1) and (-1,1,3) are solutions
Very helpful. Very well presented. Thank you.
amazing video..... very handy and concise
excellento, easy and simple. But I was wondering if there was a different function that can solve without the need of inverse calculation.
human boundaries Thanks for your kind words. Basically, this is the most direct way to solve them. A good analogy is to think of a simple equation like:
3x = 12
When we solve this for x, we actually take the multiplicative inverse of the 3 ( which is 1/3 ) and multiply that by the 12, yielding the answer: x = 4.This is why we take the inverse of the square matrix and then multiply it with the column matrix to give the results. The results here are found in another column matrix. I hope that made sense. :)
Thanks again for the comment!
Vvery nice video Clap
Thank you!
?? so what is x and y??
Variables
@@profarrington Your video brings us to a point where we have a bunch of numbers, but we still don't know the values of x, y, r, s, t, A, B, C, D, E. We are no better at the end than at the beginning. How do we get from those matrices to the solutions?
Oh, I see! The last column on the right shows the values of the variables in order (left to right becomes top to bottom). For people who took linear algebra in the 70's, that might be a good thing to include.Perhaps you could mention it in the notes. :)
This is realy outstanding, many thanks
This really helped me. Thank you so much
Glad it helped, Joseph! :)
Thanks a lot ! This video was very helpful !
Glad it was helpful! Thanks for watching.
you are a good teacher, bravo
Adras and Horia Gaming Thanks very much! 😃
Thank you! Great video
You are welcome. Glad you liked it.
Thankyou!
You're very welcome! Glad you liked the video.
very helpful , thanks
I'm glad it helped!
very professional,th
Best video everrrrrrrrrrrr!!!!
It certainly works for a 9x9 system. I would caution you to be careful about entering the coefficients, but it works just fine. Thanks for the question! 😀
until which system does it work fine? like 7x7, 6x6?
I am unable to solve 10x10 matrix by using these formulas.
I just tried it with a 10x10 system and it worked fine. Depending on your coefficients, it is possible to get a non-solvable (either inconsistent or dependent) system. The primary way to know this is to take the matrix inverse of the square matrix and see if there is a solution. If not (e.g. if Excel give you an error) then you either have a dependent or inconsistent system.
This brilliant! Thank you
Thanks a lot
Thank you from a totally non-math brained person.
You are most welcome! My belief is that everyone has a math brain. It's just waiting to be uncovered. 😊
Very good and thankyou. I might also add that LibreOffice Calc has exactly the same functionality virtually word for word - and it's free!!
i just don't get it. Fuck im guna fail my mathes course work
What
Smash like pls
wow! great staff
please turn off the music so we can hear you.
Hi Mr. Cortez, Sorry the music was distracting. I discontinued it during the salient portions of the presentation. It was only included at the beginning and the end portions. The music was embedded in the video before I posted it and cannot be turned off. Regards, ProfArrington
this was painfully slow you could have explained this in half the time, very inconsiderate for crammers.
You chose to watch it.