topic Re: STANDARD DEVIATION in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/STANDARD-DEVIATION/m-p/27068#M3525
<P>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: </P><P> </P><P><FONT color="#FF00FF">SQRT</FONT>(<FONT color="#99CC00">POWER</FONT>(<FONT color="#0000FF"><FONT color="#FF0000">Sales -</FONT> WEEKVALUE(Sales) / WEEKVALUE(h_count)</FONT><FONT color="#008000">, <FONT color="#99CC00">2</FONT></FONT>) <FONT color="#FF6600">/ WEEKVALUE(h_count))</FONT></P><P> </P><P>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. </P><P> </P><P>Hope this helps</P>Fri, 05 Jan 2018 08:55:43 GMTwillridge2018-01-05T08:55:43ZSTANDARD DEVIATION
https://community.anaplan.com/t5/Anaplan-Platform/STANDARD-DEVIATION/m-p/830#M3524
<P>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. </P>Wed, 24 Oct 2018 18:18:33 GMThttps://community.anaplan.com/t5/Anaplan-Platform/STANDARD-DEVIATION/m-p/830#M3524PrevContributor2018-10-24T18:18:33ZRe: STANDARD DEVIATION
https://community.anaplan.com/t5/Anaplan-Platform/STANDARD-DEVIATION/m-p/27068#M3525
<P>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: </P><P> </P><P><FONT color="#FF00FF">SQRT</FONT>(<FONT color="#99CC00">POWER</FONT>(<FONT color="#0000FF"><FONT color="#FF0000">Sales -</FONT> WEEKVALUE(Sales) / WEEKVALUE(h_count)</FONT><FONT color="#008000">, <FONT color="#99CC00">2</FONT></FONT>) <FONT color="#FF6600">/ WEEKVALUE(h_count))</FONT></P><P> </P><P>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. </P><P> </P><P>Hope this helps</P>Fri, 05 Jan 2018 08:55:43 GMThttps://community.anaplan.com/t5/Anaplan-Platform/STANDARD-DEVIATION/m-p/27068#M3525willridge2018-01-05T08:55:43Z