Graphing Challenge / Conundrum - Likert Scales with multiple variables
Locked
Graphing Challenge / Conundrum - Likert Scales with multiple variables
 
|
I am trying to generate an SPSS chart for a Likert scale grid question from a questionnaire, I believe I can do what I want with Excel but it doesn’t provide the editing power of SPSS. The question was along the lines of asking students
to rate a number of courses and I would like to have these all on one chart; the questions were along the lines of, and I would like a single stacked bar chart that visually represents the responses in this way: Please rate the following courses: Very Good Good OK Poor Very Poor
AB1234 | 20%| 25% | 10%| 40% | 5% |
BC2345 | 5% | 45% | 2%| 25% | 25% | CD3456 DE5432 I have used the graph editing option and templates enough to change the colours to red for “Very Poor” etc., to “turn the normal graph on its side” and insert the % numbers, it is the initial creation that has me stumped where I have a
number of variables on one axis and the percentages are stacked. I can provide a data file and picture of what I want but as I have a number of these to do the ability to generate them with syntax and templates would be great. Syntax doesn’t worry me as I’ve
been using SPSS since 1975 !! I have searched the Knowledge base and the web but the solutions don’t work, I’ve tried using multiple response but again with no success so I’m hoping you might have some ideas ! Best Wishes John S. Lemon DIT ( Directorate of Information Technology ) -
Student Liaison Officer Edward Wright Building: Room
G86a
Tel: +44 1224 273350 The University of Aberdeen is a charity registered in Scotland, No SC013683. |
Re: Graphing Challenge / Conundrum - Likert Scales with multiple variables
|
|
Think about changing the data structure to long form via varstocases with each case representing a response to a single course and then it should be much simpler with course ID as one categorical variable and rating as the count variable. From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Lemon, John I am trying to generate an SPSS chart for a Likert scale grid question from a questionnaire, I believe I can do what I want with Excel but it doesn’t provide the editing power of SPSS. The question was along the lines of asking students to rate a number of courses and I would like to have these all on one chart; the questions were along the lines of, and I would like a single stacked bar chart that visually represents the responses in this way: Please rate the following courses: Very Good Good OK Poor Very Poor AB1234 | 20%| 25% | 10%| 40% | 5% | BC2345 | 5% | 45% | 2%| 25% | 25% | CD3456 DE5432 I have used the graph editing option and templates enough to change the colours to red for “Very Poor” etc., to “turn the normal graph on its side” and insert the % numbers, it is the initial creation that has me stumped where I have a number of variables on one axis and the percentages are stacked. I can provide a data file and picture of what I want but as I have a number of these to do the ability to generate them with syntax and templates would be great. Syntax doesn’t worry me as I’ve been using SPSS since 1975 !! I have searched the Knowledge base and the web but the solutions don’t work, I’ve tried using multiple response but again with no success so I’m hoping you might have some ideas ! Best Wishes John S. Lemon DIT ( Directorate of Information Technology ) - Student Liaison Officer Edward Wright Building: Room G86a Tel: +44 1224 273350
|
Re: Graphing Challenge / Conundrum - Likert Scales with multiple variables
Administrator
|
Funny how often this comes up. I was going to post this very same advice except I have already posted the VARSTOCASES/Data-Table Normalization biz to 2 other people this AM and didn't want to seem too redundant ;-)
---
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
Re: Graphing Challenge / Conundrum - Likert Scales with multiple variables
|
|
You don't have to do this using GPL, but the graph algebra gets pretty
complicated. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of David Marso Sent: Tuesday, March 22, 2011 9:36 AM To: [hidden email] Subject: Re: Graphing Challenge / Conundrum - Likert Scales with multiple variables Funny how often this comes up. I was going to post this very same advice except I have already posted the VARSTOCASES/Data-Table Normalization biz to 2 other people this AM and didn't want to seem too redundant ;-) --- ViAnn Beadle wrote: > > Think about changing the data structure to long form via varstocases > with each case representing a response to a single course and then it > should be much simpler with course ID as one categorical variable and > rating as the count variable. > > > > From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf > Of Lemon, John > Sent: Tuesday, March 22, 2011 3:01 AM > To: [hidden email] > Subject: Graphing Challenge / Conundrum - Likert Scales with multiple > variables > > > > I am trying to generate an SPSS chart for a Likert scale grid question > from a questionnaire, I believe I can do what I want with Excel but it > doesn't provide the editing power of SPSS. The question was along the > lines of asking students to rate a number of courses and I would like > to have these all on one chart; the questions were along the lines of, > and I would like a single stacked bar chart that visually represents > the responses in this > way: > > > > Please rate the following courses: > > Very Good Good OK Poor Very Poor > > AB1234 | 20%| 25% | 10%| 40% | 5% | > > BC2345 | 5% | 45% | 2%| 25% | 25% | > > CD3456 > > DE5432 > > > > I have used the graph editing option and templates enough to change > the colours to red for "Very Poor" etc., to "turn the > normal graph on its side" and insert the % numbers, it is the > initial creation that has me stumped where I have a number of > variables on one axis and the percentages are stacked. I can provide a > data file and picture of what I want but as I have a number of these > to do the ability to generate them with syntax and templates would be > great. Syntax doesn't worry me as I've been using SPSS since 1975 !! > > > > I have searched the Knowledge base and the web but the solutions don't > work, I've tried using multiple response but again with no success so > I'm hoping you might have some ideas ! > > > > Best Wishes > > > > John S. Lemon > > <http://www.abdn.ac.uk/dit/> DIT ( Directorate of Information > Technology ) > - <http://www.abdn.ac.uk/dit/slo/> Student Liaison Officer > > <http://www.abdn.ac.uk/> University of Aberdeen > > <http://www.abdn.ac.uk/maps/generic-details-2526.php> Edward > Wright > Building: Room G86a > > Tel: +44 1224 273350 > > > > DIT news for Students <http://www.abdn.ac.uk/dit/student/news/> > > > > > > The University of Aberdeen is a charity registered in Scotland, No > SC013683. > -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Graphing-Challenge-Conundrum-L ikert-Scales-with-multiple-variables-tp4250735p4257060.html Sent from the SPSSX Discussion mailing list archive at Nabble.com. ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
| Free forum by Nabble | Edit this page |