Forum Discussion

clem312's avatar
clem312
Resolver I
4 years ago
Solved

Standard deviation

Hi everyone,   I am trying to calculate a standard deviation, counting the number of Code per ID : M1 is my average. D1 is the number of code for each ID. VAR M1 = DIVIDE(CALCULATE(COUNT([Code...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, clem312 ;

    You could use STDEVX.S 、STDEVX.P、 STDEV.P、STDEV.S

    to calculate the standard deviation .If not, can you share your simple data and desired results?

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, clem312 ;

You could use STDEVX.S 、STDEVX.P、 STDEV.P、STDEV.S

to calculate the standard deviation .If not, can you share your simple data and desired results?

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.