Reputation: 1
So I have a list of numbers for my independent variable (Species ID number) which are repeated; each Species ID number has a corresponding dependent value (count).
What I need is a list of the species with a sum of all their corresponding counts.
Is this possible in SPSS?
Upvotes: 0
Views: 45
Reputation: 2929
Look up documentation for AGGREGATE and/or CTABLES*
*Requires add-on module licence
Your code would look something like this:
AGGREGATE OUTFILE=dsAgg /BREAK=SpeciesID /TallyDV=sum(DepenVar).
CTABLES /TABLE SpeciesID[c] BY DepenVar[S][SUM].
Upvotes: 1