Assistance with graphing multiple variables over repeated measures

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Assistance with graphing multiple variables over repeated measures

Kathy McKnight
Hi all,

I have data for 3 different variables, all on the same scale (1 to 4) for 4
schools, measured at 3 or 4 different time points (Nov, Jan, Apr and June
for one variable, and no Nov observations for the other 2). I would like to
present the data for those 3 variables with their repeated measures for the
4 schools within the same graph, if possible. I was envisioning a line
graph, with each line representing one of the 3 variables over time for each
of the schools. I cannot for the life of me figure out how to do that either
in Excel or SPSS. At best, I can put 2 graphs side-by-side. If it helps, the
data would look like this:

School A: Line 1: Global Ratings for Nov, Jan, April & June; Line 2: ILT
Environ for Jan, April & June; Line 3: Wrkgrp environ for Jan, Apr & June

Schools B - D would be the same.

Is there any way to do this in SPSS? I've just been using the graphing
function alone, not inside any analytic procedures like Repeated Meas ANOVA,
although that might work. If you have any suggestions, I'd appreciate it.

Thanks so much for your help!

Kathy McKnight

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: Assistance with graphing multiple variables over repeated measures

Garry Gelade
Hello Kathy

You can graph multiple variables using interactive graphs. It's a bit
difficult to describe, but you should be able to experiment.

Select Graphs, Interactive, Line.

The critical part is selecting the variables you need from the Right-hand
variable list - you need to select all three simultaneaoulsy (use ctrl-click
to pick them).  Then move them all together into the x-axis box (the one
with the right arrow.) SPSS will automatically create two new variables for
you, one called category_set and one called value_set. Move the category_set
variable into the colour box to have different colored lines for each
variable (or into the style box to have different styles). Move the
value_set variable into the y-axis box, and time into the x-axis box.  You
should get a plot of the three variables against time.  You could also put
the School variable into the Panel box which would give you one graph with 3
lines for each of the schools.

If that's not exactly what you need, I'm sure a bit of playing around will
work for you once you have 'got it'.

Regards
Garry Gelade



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Kathy McKnight
Sent: 29 August 2008 21:32
To: [hidden email]
Subject: Assistance with graphing multiple variables over repeated measures

Hi all,

I have data for 3 different variables, all on the same scale (1 to 4) for 4
schools, measured at 3 or 4 different time points (Nov, Jan, Apr and June
for one variable, and no Nov observations for the other 2). I would like to
present the data for those 3 variables with their repeated measures for the
4 schools within the same graph, if possible. I was envisioning a line
graph, with each line representing one of the 3 variables over time for each
of the schools. I cannot for the life of me figure out how to do that either
in Excel or SPSS. At best, I can put 2 graphs side-by-side. If it helps, the
data would look like this:

School A: Line 1: Global Ratings for Nov, Jan, April & June; Line 2: ILT
Environ for Jan, April & June; Line 3: Wrkgrp environ for Jan, Apr & June

Schools B - D would be the same.

Is there any way to do this in SPSS? I've just been using the graphing
function alone, not inside any analytic procedures like Repeated Meas ANOVA,
although that might work. If you have any suggestions, I'd appreciate it.

Thanks so much for your help!

Kathy McKnight

=====================
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

__________ NOD32 3404 (20080901) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.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
Reply | Threaded
Open this post in threaded view
|

Re: Assistance with graphing multiple variables over repeated measures

Andy Norton
In reply to this post by Kathy McKnight
Hi Kathy,

If you use different lines to represent 3 different variables for 4
schools, you will have 12 lines.  These will be difficult to distinguish
because there are only four possible Y values at each X - -there will be
many overlaps.

I think a graph with a panel for each school (or for each variable) will
be more readable.  You can do this with GPL in GGraph.

Andy Norton
SPSS Visualization Team

=====================
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