chapter 8 : Grouping

2. Group By Mean (Average)

Group by Mean calculates the average value in each group.

Formula:
Mean = Total of values ÷ Number of values

Example

RegionSales
East100
East200
West150
West250
West100

Result (Group by Mean):

RegionAverage Sales
East150
West166.7

Explanation

  • East: (100 + 200) ÷ 2 = 150

  • West: (150 + 250 + 100) ÷ 3 = 166.7