Experience of implementing LINEST in anaplan

Ravil

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

karank_*4578

May be i am missing something here but it sounds like a simple regression to me based on what you highlighted . Below i have plotted some numbers in excel and used Linest function to show regression results 

 

Here is First screen shot where you can see data i made based on scenario you just explained 

We are predicting sales based on weeks where Z a constant to mark b as 0 in case its 0 , unsure what is d?

 

you will notice on the graph that i have a simple regression line showing y=ax+ b 

 

 

Now i am doing the same workings using linest function without constant i.e z set to nothing . Notice how my a and b matches regression line 

 

 

Here is a screen shot of linest function with constant 

 

 

again values are the same as regression line . 

I showed you earlier regression is achievable in anaplan . So unless we know what data you are looking at it will be hard to know exactly what the issue is . Perhaps you could share something like what i have done above to know more about whats going on at your end . 

 

I am sure we can implement simple as well as multi(quadratic) regression in anaplan which is what i think linest function does

 

Hope this helps