Group by Mean calculates the average value in each group.
Formula:
Mean = Total of values ÷ Number of values
| Region | Sales |
|---|---|
| East | 100 |
| East | 200 |
| West | 150 |
| West | 250 |
| West | 100 |
Result (Group by Mean):
| Region | Average Sales |
|---|---|
| East | 150 |
| West | 166.7 |
Explanation
East: (100 + 200) ÷ 2 = 150
West: (150 + 250 + 100) ÷ 3 = 166.7