Equations in two unknowns with Excel
- Thread starter bines53
- Start date
Somendra Misra
Excel Ninja
Hi David,
Since you are dealing with simultaneous equation, the same can be done with some basic algebra and excel functions.
So your first eqution if solved further can be written as
0.18X -Y = 0
And you next eqution is X+Y = 2
So, in general if you have two equation with two unknown i.e. X&Y you form two matrix
X1 Y1
X2 Y2
and second matrix of like
C1
C2
so in this situation your first matrix will look like
0.18 -1
1 1
and second matrix will look like
0
2
So, mathematically you can solve the unknown with below equation:
X1 Y1 X C1
* =
X2 Y2 Y C2
So,
Solving this can be easy now with Excel function like MINVERSE() & MMULT.
So, first use =MINVERSE(array) and in array pass the matris of X1,Y1;X2,Y2.
This will give you a 2x2 matrix , let say this is matrix 1 and matrix 2 is 0;2 the earlier one.
Now use MMULT(array 1, array 2) to get your result.
I am uploading a workbook to illustrate this. If you had any problem than please write back.
Regards,
Since you are dealing with simultaneous equation, the same can be done with some basic algebra and excel functions.
So your first eqution if solved further can be written as
0.18X -Y = 0
And you next eqution is X+Y = 2
So, in general if you have two equation with two unknown i.e. X&Y you form two matrix
X1 Y1
X2 Y2
and second matrix of like
C1
C2
so in this situation your first matrix will look like
0.18 -1
1 1
and second matrix will look like
0
2
So, mathematically you can solve the unknown with below equation:
X1 Y1 X C1
* =
X2 Y2 Y C2
So,
Solving this can be easy now with Excel function like MINVERSE() & MMULT.
So, first use =MINVERSE(array) and in array pass the matris of X1,Y1;X2,Y2.
This will give you a 2x2 matrix , let say this is matrix 1 and matrix 2 is 0;2 the earlier one.
Now use MMULT(array 1, array 2) to get your result.
I am uploading a workbook to illustrate this. If you had any problem than please write back.
Regards,
Somendra Misra
Excel Ninja
@bines53
I didn't got you. If there is only one equation with two variable and both unknown than there can be infinite solution. Like
when x = 0; y = 2
when x = 1; y = 1
when x = 0.5; y = 1.5
when x = 0.1; y = 1.9
when x = 0.001; y = 1.999...... and so on.
If you want to limit no. of solutions you have to put some constraints like both x and y can only be integers or like x>0.5 or like this.
Can you explain what is you point?
Regards,
I didn't got you. If there is only one equation with two variable and both unknown than there can be infinite solution. Like
when x = 0; y = 2
when x = 1; y = 1
when x = 0.5; y = 1.5
when x = 0.1; y = 1.9
when x = 0.001; y = 1.999...... and so on.
If you want to limit no. of solutions you have to put some constraints like both x and y can only be integers or like x>0.5 or like this.
Can you explain what is you point?
Regards,
Somendra Misra
Excel Ninja
David,
I think there is a confusion regarding equations, Quadratic equations are single variable equation of 2nd Order so they gave 2 solutions, but you have two equation with two unknown, so both can be satisfied with one and only one solution.
Moreover both the equations are of straight line nature, and two straight line can intersect at only one point, which is suggested by @Debraj Second solution through graphs.
and @Debraj both solution gave the same result X = 1.69 ; Y = 0.30 which is same as mine.
Regards,
I think there is a confusion regarding equations, Quadratic equations are single variable equation of 2nd Order so they gave 2 solutions, but you have two equation with two unknown, so both can be satisfied with one and only one solution.
Moreover both the equations are of straight line nature, and two straight line can intersect at only one point, which is suggested by @Debraj Second solution through graphs.
and @Debraj both solution gave the same result X = 1.69 ; Y = 0.30 which is same as mine.
Regards,