Forum Discussion
Standard Diviation
I have a set of data for student's score for 2 years. i will get the standardard deviation of list of student on picked day. how to do that? Output will look like this. Name Score Standard...
Anonymous the column of "STANDARD DEVIATION OF WELLNESS SCORE", I use the built in function of power bi which is the simply way you mentioned.,
The column of Score STDEV.P comes from the calculation : Score SD = CALCULATE(STDEV.P(data[Score]),ALLEXCEPT(data, data[Score], data[Name]))
are they supposed to be the same?
| Name | Score | Standard deviation of Wellness Score | Score STDEV.P |
| NAME 1 | 768 | 0 | 8 |
| NAME 2 | 273 | 0 | 18 |
| NAME 3 | 190 | 0 | 38 |
| NAME 4 | 96 | 0 | 7 |
| NAME 5 | 94 | 0 | 14 |
| NAME 6 | 96 | 0 | 8 |
| NAME 7 | 98 | 0 | 1 |
| NAME 8 | 98 | 0 | 5 |
| NAME 9 | 96 | 0 | 2 |
| NAME 10 | 86 | 0 | 8 |
Hi ask,
Based on my test, the build-in standard deviation function should be similar to just using the STDEV.P function without any other filters like below. :smileyhappy:
Score SD = STDEV.P(data[Score])
Regards