SPSS Ranking Syntax

Question

I have ten variables with an int value of 1-10. The 1-10 number is the rank for the corresponding variable. Now I want to get the mean rank of each variable. In Excel it would be something like this (in a simplified ranking with only three variables): v_1=((1*A1+2*A2+3*A3)/SUM(A1:A3)) The values of the ten variables are like this: 1=1, 2=2, 3=3 etc. How could I compute this in SPSS?

Answer 1

The equivalent of the EXCEL formula you state in SPSS would be:

COMPUTE v_1=(1*A1 + 2*A2 + 3*A3) / SUM(A1,A2,A3).

However, it seems you want a variable-wise mean score, for which, take a look at either MEANS or AGGREGATE.