This is a two variable set of simultaneous equations and I have left column C blank to allow us to develop three variable examples. SOLVER solution: using the SOLVER add in to provide the values for the variables. The names indirect and direct are my own and I am classifying them as different methods although in reality they are not! this is essentially a single cell solution per variable. Indirect Method: Using the two array functions MINVERSE() and then MMULT() separately: this is essentially an entire problem or matrix solution that gives us the values of each variableĭirect Method Using the two array functions MINVERSE() and then MMULT() together in the form =MMULT(MINVERSE()). I am going to use three methods for solving simultaneous equations:
Try it yourself for equation (2) if you wish.
In this case I know that x = 5 and y = 1 and we an prove that by putting 5 where x is and 1 where 1 is in either of the two equations, such as in equation (1): For example, here are two simultaneous equations: Simultaneous equations get their name from the fact that in two or three or more equations, X has the same value for each, Y has the same value for each and so on. If you know SEs you know there are several ways of solving them and I am not a mathematician so I am not going to explain Cramer’s rule, matrix algebra or even substitution … just show you how Excel can help. I remember, however, realising what they were and how they worked years after leaving school and then I thought, why on earth does anyone have a problem with them. Simultaneous equations are usually a nightmare for the average secondary school student: they cannot or will not do them.
0 kommentar(er)
