FAQ/summiss - CBU statistics Wiki

Upload page content

You can upload content for the page named below. If you change the page name, you can also upload content for another page. If the page name is empty, we derive the page name from the file name.

File to load page content from
Page name
Comment
Type the missing letters from: Lodon is th capial of nglnd

location: 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.