Home › Forums › Methodspace discussion › Putting Frequency Results of Multiple Likert Scale Questions in One Table
- This topic has 3 replies, 2 voices, and was last updated 7 years, 6 months ago by
EDUAN WILSON.
-
AuthorPosts
-
27th June 2013 at 2:10 pm #1514
M Subrah
MemberHi Everyone,
Does anyone know if SPSS 20 can directly put the frequency results of multiple Likert Scale Questions into one table.
At present, when I run the frequencies, I get a separate table for each question. I’m wondering if SPSS can produce a table like the one below directly from the frequency results. a-e would be different questions related to the same topic in the survey, and each question (a-e) used the exact same likert scale (Disagree Strongly/Disagree, Niether Agree/Disagree, Agree Strongly/Agree). To get this table below, I had to copy and paste the results from 5 SPSS frequency tables into an Excel table that I created. I’m just trying to see if SPSS can do it all in one go for me, to save time.
Table 1. Attitudes Among U of T students to change their lifestyle over the next 6 months I will… Disagree Strongly/Disagree, % Niether Agree/ Disagree, % Agree Strongly/Agree, % a)…eat more fruits and vegetables 45 20 35 b)…exercise atleast 3 times a week 15 25 60 c)…sleep atleast 7-8/hours each night 54 27 19 d)…avoid going to fast-food restaurants 32 48 20 e)…stop buying sodas 12 37 51 If anyone can show me how to do this, it would be much appreciated.
MS
3rd July 2013 at 7:20 am #1517EDUAN WILSON
ParticipantHi Ms
I have been using the following procedure that has proved workable for me.
Analyse=Tables=custom tables=select variables into rows.
Customs tables window opens.
under define summary statistics enter “Row N%”
Check “custom”
Under statistics enter “Row N%”
Under Sort Categories enter “by value”
Under order enter “ascending” (I use actual likert values 1,2,3 and not categories “agree, strongly agree etc.)
Under category position enter “row labels in columns”. (NB: do not use default)
Press OK.
Kind regards
Wilson.
4th July 2013 at 12:48 pm #1516M Subrah
MemberHi Wilson,
Thank you for you instructions. This was extremely helpful.
On an added note, would you know how to do the exact same table as above, but have an added column with Missing values for each question? I added “Missing” from the “Custom Summary Statistics”, in addition to “Row N%”, yet got nothing.
Thanks for your help again.
Best,
MS
5th July 2013 at 7:39 pm #1515EDUAN WILSON
ParticipantHi
Sorry for the delay. Somehow busy with some data work. Could you please try and follow SPSS help on the menu [Help>Customs table>options>missing values].
Hope it does help.
Best regards,
Wilson.
-
AuthorPosts
- You must be logged in to reply to this topic.