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.