STANDARD DEVIATION

PrevContributor
PrevContributor
in Modeling

Is there any function in Anaplan to calculate Standard deviation. In excel there is a function "STDEV". Need to get the standard deviation for a product across 36months of data. 

Tagged:

Answers

  • willridge
    willridge

    I haven't seen a function for this, but you can create your own formula. The one I've done to try and work out the standard deviation of weekly sales is: 

     

    SQRT(POWER(Sales - WEEKVALUE(Sales) / WEEKVALUE(h_count), 2) / WEEKVALUE(h_count))

     

    h_count is a line item I added to show me days in the week. I've colour coded it above to show how the formula has been built up. 

     

    Hope this helps

Categories