EssoExplJoe
New Member
- Joined
- Nov 11, 2016
- Messages
- 30
I am trying to solve for 4 unknowns in 4 equations as below. I have managed to write a VBA routine to solve for 3 unknowns with 4 equations but I am getting totally lost in the weeds trying with 4 unknowns (4 cubic equations). Does any have any VBA routines that does this?
Points: (Y1,X1), (Y2,X2), (Y3,X3), (Y4,X4)
Points: (10,2), (5,4), (4,11), (4,15)
Four Equations with 4 variables:
a) Y1=a+bX1+cX12+dX13
b) Y2=a+bX2+cX22+dX23
c) Y3=a+bX3+cX32+dX33
d) Y4=a+bX4+cX42+dX43
Solve for a,b c and d :
Points: (Y1,X1), (Y2,X2), (Y3,X3), (Y4,X4)
Points: (10,2), (5,4), (4,11), (4,15)
Four Equations with 4 variables:
a) Y1=a+bX1+cX12+dX13
b) Y2=a+bX2+cX22+dX23
c) Y3=a+bX3+cX32+dX33
d) Y4=a+bX4+cX42+dX43
Solve for a,b c and d :