Compute the Sum of Columns in SPSS

Question

I have a lot of columns in SPSS and for a calculation, I need to get the sum of each and every one of them. Is there a way to do this in SPSS?

An example of what I mean is shown below:

age      gender     question 1     question 2
-------------------------------------------------
25         m            2              3
19         f            4              2    
20         f            3              4
                     -------        -------
                    need sum       need sum

just run the DESCRIPTIVE frequency and you will get Sum as your result — rawatdeepesh, Dec 21 '16 at 01:31

score 5 · Accepted Answer · answered Dec 11 '16 at 11:32

5

If you just need an ouput table with the results then see the DESCRIPTIVES command.

Alternatively, if you need the results in an output dataset for further processing then see the AGGREGATE command.

answered Dec 11 '16 at 11:32

Jignesh Sutar

2,909
10
13

1

`FREQUENCY` can output sums of variables as well. – Andy W Dec 11 '16 at 14:27

score 0 · Answer 2 · answered Jun 02 '22 at 09:34

0

use: Analyse > Reports > Summaries in Columns and add your columns

answered Jun 02 '22 at 09:34

Anis

11
2

Compute the Sum of Columns in SPSS

2 Answers2