Descriptive stats for subgroups

[acjennings]

Hi, I have a spreadsheet in excel and my data looks like as follows :

Gender...Education...Country...Status...Index...Income
F.........College......USA........Single....Yes.....10
F........College......USA........Single....Yes......11
F.......Master.......USA........Single....No.......12

I would like to create a series for "average Income" and another series for the "number of observations" for each subgroup.

Result:
Gender...Education...Country...Status...Index...Average Income.....# of obs
F........College.......USA.......Single....Yes.............8..................1500

My data set contains over 500,000 rows with 200 subgroups with min 1,000 observations for each subgroup.
Thank you very much

[EViews Gareth]

Open up the series, then click on View->Descriptive Statistics->Stats by classification.

[EViews Glenn]

If you want to create series with these you should look at the family of by-group statistics functions, as in @meansby and @obsby.

[acjennings]

Thank you very much,

I am quite new to EViews. Can you give me an example with @meansby and @obsby? Say, "Gender...Education...Country...Status...Index...Income" are my variables.

Thanks again

[EViews Glenn]

Code: Select all

series avgincome=@meansby(income, gender, education, country, status, index)

will compute the average INCOME in each subgroup defined by the cross of the series GENDER, EDUCATION, COUNTRY, STATUS, and INDEX, and match merge those results back into the original observations in the new series AVGINCOME.