calculation for each observation

[hba2pd]

Hello,

Suppose I have a table which record the income for each people in each
area

area income
1 100
2 70
2 60

I would like to (1) count the number of people in each area and (2)
average income

area number of people average income
1 1 85
2 2 60

Thank you.

 

[Guest]

If you want a single table to present both the count and the average, then
use a Pivot Table. If you are not familiar with Pivot Tables, see:


http://www.contextures.com/xlPivot01.html