CODEWITHSUNDEEP
meanmissing-dataspss
user37398
user37398

Reputation: 83

SPSS Means With Missing Values

I am averaging the percentages of teaching times of different types of faculty over the span of 3 years. The averaged percentages need to add up to 100%, but they don't because there are missing values. Is there a way to count missing values when I use the mean functions?

'''
    aggregate outfile=* /break car cip control
      / ncount = n
      / {5}
      = mean({0} to {1}).
'''

Upvotes: 1

Views: 89

Answers (1)

eli-k
eli-k

Reputation: 11360

Assuming you want missing values to count as Zeros, you could either recode them so before aggregating 

recode YourVar (miss=0).

Or without touching the missing values in advance you can use the aggregate command to calculate the sum and the number of rows and afterwards divide sum/n which should give you the mean without discounting the missing values.

Upvotes: 1

Related Questions