level of satisfaction index

[Fredrick Avuzika]

hello. i have data organised as
1=disagree strongly
2=disagree
3=indifferent
4=agree
5=agree strongly

how can i have two columns to get the average for disagree strongly and disagree then agree and agree strongly

[Rich Ulrich]

On Tue, 4 Jul 2023 05:39:44 -0700 (PDT), Fredrick Avuzika

Post by Fredrick Avuzika
hello. i have data organised as
1=disagree strongly
2=disagree
3=indifferent
4=agree
5=agree strongly
how can i have two columns to get the average for disagree strongly and disagree then agree and agree strongly

Is this what you mean?

"how can i have two columns to get the average for (disagree
strongly and disagree) then (agree and agree strongly)"

I'm not sure what you REALLY want, but ...

You can use RECODE Q1 (1,2=1)(3=9)(4,5=2) INTO Q1Group.

MISSING VALLUES Q1Group(9).

If you want to compare the values of other variables for
these two groups, you could use T-TEST.

I don't know why you want columns for averages, but you
could use AGGREGATE on Q1Group to get the averages (which
would be two or three records -- I don't remember how Missing
is handled in that case), and then FLIP to switch rows to columns.