On Tue, 4 Jul 2023 05:39:44 -0700 (PDT), Fredrick Avuzika
<
[email protected]> wrote:
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.
--
Rich Ulrich
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)