G
George
Hi.
I want to solve a linear of n X n equations system in Excel, where the
solution can be derived as follow:
Xn = ao
Xn-1 = a1 * Xn
Xn-2 = a2 * Xn-1 + a3 * Xn
Xn-3 = a4* Xn-2 + a5 * Xn-1 + a6 * Xn
e.g.
The an coefficients (a0,a1,a2,….an) are all known.
Lets simplify the above system using an example. Lets say that n=5 and:
X5=7
X4=2*X5
X3=3*X4+2*X5
X2=1*X3+3*X4+4*X5
X1=1*x2+1*x3+1*x4+2*x5
(Then the solution is: X1=210, X2=126, X3=56, X4=14 and X5=7)
Any idea how can I solve these n x n equations in general form in Excel?
(I tried with sumproduct() but I stuck in coefficients of an terms.)
Thank you.
I want to solve a linear of n X n equations system in Excel, where the
solution can be derived as follow:
Xn = ao
Xn-1 = a1 * Xn
Xn-2 = a2 * Xn-1 + a3 * Xn
Xn-3 = a4* Xn-2 + a5 * Xn-1 + a6 * Xn
e.g.
The an coefficients (a0,a1,a2,….an) are all known.
Lets simplify the above system using an example. Lets say that n=5 and:
X5=7
X4=2*X5
X3=3*X4+2*X5
X2=1*X3+3*X4+4*X5
X1=1*x2+1*x3+1*x4+2*x5
(Then the solution is: X1=210, X2=126, X3=56, X4=14 and X5=7)
Any idea how can I solve these n x n equations in general form in Excel?
(I tried with sumproduct() but I stuck in coefficients of an terms.)
Thank you.