Standard Deviation of Population of a 5 sprint moving average

Hi everyone,

I have this data set:

Team Sprint Name Date Completed Storypoints 5 sprint mov average
Yoda Yoda 2022 19.3 2022-07-27T20:30 52.5 42
Yoda Yoda 2022 19.2 2022-07-13T08:01 56.5 40,1
Yoda Yoda 2022 19.1 2022-06-29T14:07 34.0 39
Yoda Yoda 2022 18.3 2022-06-15T10:37 31.0 38
Yoda Yoda 2022 18.2 2022-06-01T08:00 36.0 39,2

And I need to calculate the standard deviation (population formula) of completed storypoints and the 5 last sprints moving average.

I know that for this data set the standard devation based on the population formula should be: 10,406729

But using the math formula node and the COL_STDDEV([completed storypoints]) formula its outputing 11.635076278220096 as standard devation.

Can someone help me on this?

Thank you so much.

Solved it, the build in function in the math formula is for the sample formula, so I just adjusted the build in function with:

((Rowcount()-1)/(rowcount))^(1/2)

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.