Solve Linear Equations for multiple variables
Hi - One of the business requirements will require me to solve the linear equations with multiple variables - does Anaplan has any functionality of how that can be achieved? To give more details, our client has the requirement of regression with multiple causals (Say 5). This means we need to solve for 5 independent variables and a constant. The linear equation for the dependent variable would be y = a0 + a1 x1 + a2 x2 + a3 x3 + a4 x4 + a5 x5.
To get the value of y i.e. forecast - we need to solve for the six variables in total: a0 to a6. Mathematically, this will give me six equations (say we have derived the six equations in Anaplan).
The question now is to solve all these six equations and get the values of these variables a0 to a6 so I can generate the forecast. I would like to seek help from the community how this can be done.
Regards - Guru