Experience of implementing LINEST in anaplan

Options
Ravil
Ravil Member, ALL USERS, GroupMember, Certified Model Builder Posts: 4 Occasional Contributor
in Planning & Modeling

Hello colleagues.
At the moment I am implementing statistical data analysis in anaplan, the analysis methodology was developed in an excel.

In excel, the LINEST function was used to search for the four unknowns using the least squares method.
I did not find an analogue of this function and I do not imagine how to obtain the necessary values.
Did you have experience using the function LINEST in Anaplan?

How did you solve this problem?

 

Ilya_Zhivov

Tagged:

Comments

  • Ravil
    Ravil Member, ALL USERS, GroupMember, Certified Model Builder Posts: 4 Occasional Contributor

    Thank you @karank, but I think my task is a little more difficult, the function looks like this: Y=ax^2+bx+cz+d

    Where to find: a, b, c, d

  • Ravil
    Ravil Member, ALL USERS, GroupMember, Certified Model Builder Posts: 4 Occasional Contributor

    No, i mean Y=ax^2 + bx + cz + d

     

    y - my data, let it be sales

    х - timeline, let it be the week number

    z - is it one if there was a holiday this week, or zero if it is a regular week

    a, b, c, d - unknowns computed by function

     

  • Ravil
    Ravil Member, ALL USERS, GroupMember, Certified Model Builder Posts: 4 Occasional Contributor

    Hey.
    Yes, of course, it is possible in Anaplan.
    We found a way to repeat the lineest function through the matrix system in anaplan, this solution weighs only 5MB and takes several modules and reference books, but it works very quickly.

    I'm not sure if I can describe the method in detail right now here.

    I'll try to do this later.

Categories