chapter 8 : Grouping

6. Group By Median

Group by Median finds the middle value after sorting the data in each group.
If there are two middle values, take their average.

Example

East Sales: 100, 200
Median = (100 + 200) รท 2 = 150

West Sales: 100, 150, 250
Median = 150 (middle value)

Result

RegionMedian Sales
East150
West150