|
|
Dimitris Nikolaou asked: How to calculate the average for many observations?
I would like to find a way so as the spss to calculate the average for
every team.
---------------------
The example shown suggests a simple answer that demonstrates the power of SPSS (syntax).
Define zero as the missing value, and use procedure MEANS to get just the means of a variety of other summary statistics for each group. You can generate the commands via menus, but I see (in V13 at least) the MEANS menu does not indicate extra control of missing value treatment. For Dimitris's example, the default would be fine. The EDUC flag variables need collecting into one variable.
missing values lnwage(0).
compute educlevel = 0 + educ1 + 2*educ2 + 3*educ3.
means lnwage by age by sex by educlevel
/ cells=mean count.
The dependent variable (lnwage) may be replaced with a list of variables, and missing cases excluded for each variable or if any dependent variable is missing.
Allan Reese
***********************************************************************************
This email and any attachments are intended for the named recipient only. Its unauthorised use, distribution, disclosure, storage or copying is not permitted. If you have received it in error, please destroy all copies and notify the sender. In messages of a non-business nature, the views and opinions expressed are the author's own and do not necessarily reflect those of the organisation from which it is sent. All emails may be subject to monitoring.
***********************************************************************************
|
Locked
