FAQ/summiss - CBU statistics Wiki
Self: FAQ/summiss

Summing partially missing cases in SPSS

The default for obtaining sums and means in SPSS is to work them out only for cases with complete data.

To sum over cases, with at least x complete variable values in SPSS, we use the function, sum.x. Similarly to obtain the mean for cases, with at least x complete variable values, we use mean.x. e.g.

compute scoresum   =  sum.3(a,b,c).
compute scoremn     =  mean.2(a,b,c).
exe.

scoresum will return missing for cases with <3 non-missing values. Ie any non-missing a, b and c. scoremn will return missing for cases with <2 non-missing values, ie having two or three missing values of any of variables a or b or c.

None: FAQ/summiss (last edited 2013-03-08 10:17:44 by localhost)