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...
| 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 v-ljerr-msft the table doesn't have Year, Month, Week. Only have Name, Score, Date as shown above
Hi ask,
I don't see any Date column in your sample table above. Anyway, it doesn't matter.
1. Add [Year], [MonthName], [WeekName] column to your table if you have them yet.
Year = YEAR(data[Date])MonthName = FORMAT(data[Date],"MMMM")WeekName = FORMAT(data[Date],"DDDD")
I knew your table doesn't have Year, Month, Week. As I have mentioned in Step 1: You need to add them first!!(just use the formula I have provided above)
Regards
v-ljerr-msftMy requirement doesn't allow me to create slicer. Any way to calculate the SD by each name, by specific date?