heatmap of correlation matrix w/o varstocases

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

heatmap of correlation matrix w/o varstocases

Kirill Orlov
(This is a question of idleness)

Can SPSS produce heatmap for correlation matrix (or other rows-by-columns dataset) directly, without you having to unwrap the data into variables "row", "column" and "datum" by means of VARSTOCASES?

Any ideas?

===================== 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: heatmap of correlation matrix w/o varstocases

Andy W
So you can do the equivalent VARSTOCASES transform within GPL is one way
(although IIRC you need to spell out the individual columns to do it, you
can't do shortcuts like X1-X10)

Maybe another is to use a table instead of a graph. I bet JP did some code
to highlight cells of a table that could be adapted to do a table heatmap
instead of a graph.



-----
Andy W
[hidden email]
http://andrewpwheeler.wordpress.com/
--
Sent from: http://spssx-discussion.1045642.n5.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
Andy W
apwheele@gmail.com
http://andrewpwheeler.wordpress.com/
Reply | Threaded
Open this post in threaded view
|

Re: heatmap of correlation matrix w/o varstocases

Jon Peck
There are a few functions in the customstylefunctions.py module that is installed with the SPSSINC MODIFY TABLES extension command that do things like this.  It would be easy to write another one for that command that colored backgrounds (or foregrounds) according to the cell values.  Of course, that wouldn't affect the area though one could vary the font size by value or make other appearance modifications.

On Sun, Mar 29, 2020 at 1:36 PM Andy W <[hidden email]> wrote:
So you can do the equivalent VARSTOCASES transform within GPL is one way
(although IIRC you need to spell out the individual columns to do it, you
can't do shortcuts like X1-X10)

Maybe another is to use a table instead of a graph. I bet JP did some code
to highlight cells of a table that could be adapted to do a table heatmap
instead of a graph.



-----
Andy W
[hidden email]
http://andrewpwheeler.wordpress.com/
--
Sent from: http://spssx-discussion.1045642.n5.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


--
Jon K Peck
[hidden email]

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

analysis question

Zdaniuk, Bozena-3

hello everyone,

I am trying to figure out how to best analyze my data. I have pre-treatment, post-treatment, and two follow-up time points for two treatment groups. When I analyze just pre and post treatment points (using MIXED procedure) I find an interaction of group x time indicating that Treatment A improves more than Treatment B. But if I analyze all four points, both treatments maintain their gains but no more changes after post-treatment for either group and the interaction of group x time (all four time points) disappears.

Would it make sense to still want to report on the interaction from pre- to post-treatment? if yes, what is the best way to do it? Or I should just ignore that interaction if it does not show when all four times are in the analysis?

Any thoughts greatly appreciated!

cheers,

bozena

===================== 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: analysis question

Maguin, Eugene

When you look at the group by time means I imagine that at FU1 and FU2 that group 1-group 2 difference is about the same as at post. Would that be true? If so, you have an improvement that is sustained through the follow-up period but also no further improvement. Are you analyzing the data as a repeated measures model with or without a random intercept or as a mixed model? With respect to what you report, as the investigator you have to decide but I think the complete but full story should be told.

Gene Maguin

 

 

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Zdaniuk, Bozena
Sent: Monday, March 30, 2020 3:13 AM
To: [hidden email]
Subject: analysis question

 

hello everyone,

I am trying to figure out how to best analyze my data. I have pre-treatment, post-treatment, and two follow-up time points for two treatment groups. When I analyze just pre and post treatment points (using MIXED procedure) I find an interaction of group x time indicating that Treatment A improves more than Treatment B. But if I analyze all four points, both treatments maintain their gains but no more changes after post-treatment for either group and the interaction of group x time (all four time points) disappears.

Would it make sense to still want to report on the interaction from pre- to post-treatment? if yes, what is the best way to do it? Or I should just ignore that interaction if it does not show when all four times are in the analysis?

Any thoughts greatly appreciated!

cheers,

bozena

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

Re: analysis question

Gerónimo Maldonado
In reply to this post by Zdaniuk, Bozena-3
Interrupted time series approach?
===================== 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: analysis question

Rich Ulrich
In reply to this post by Zdaniuk, Bozena-3
What is the story that you see when you look at the
Group x Time means? What is the size of your effect and your power? 
Is this exploratory, or confirming some hypothesis?

Do the Groups reflect random assignment, or could there be
differences at Pre that have not been mentioned? That should
influence how strongly you  can assert whatever differences
appear to exist.

Having a reportable difference between two groups when they
both improve suggests at least moderate power of analysis and
a decent effect. 

This reminds me of a one-group, repeated design that I set up
which suited certain data on Depressed patients: 

Intervention (drugs) had a profound and immediate effect on most
Sleep variables. We tested that with a paired t-test, Pre to Post. 
Whatever happened after that was apt to follow a linear trend --
Continuing the same direction; falling back toward the Pre mean; or
staying the same.  "Linear Trend" on the 4 post-drug Times was the
powerful and informative test.

You could test your groups separately that way, for description.

I'm impressed by the apparent difference in immediate effect, but I
don't know the whole context. It is less useful if the "better" group
is improving from a worse baseline, so the "adjusted means" show
more difference than the raw means. 

If that test would be impressive to your audience, then it might be
appropriate to report that result as a first thing.  (Was that a Study
Question?)  If that is worth reporting alone, then look at the means
and linear trend for the 3 follow-on periods.  - If there are Pre differences,
it is also possible to use Pre as a covariate for the Repeated Measures
test on the other.  If there is a real and useful and unique treatment
effect, the groups will also show a difference across all three followups.

But (potential) differences at Pre have to complicate the description
of outcome. Does using Pre happen to increase the power? or does
it create the difference when groups end up at (approximately) the
same place?  As I started out:  Look at the plot of the means.

--
Rich Ulrich


From: SPSSX(r) Discussion <[hidden email]> on behalf of Zdaniuk, Bozena <[hidden email]>
Sent: Monday, March 30, 2020 3:13 AM
To: [hidden email] <[hidden email]>
Subject: analysis question
 

hello everyone,

I am trying to figure out how to best analyze my data. I have pre-treatment, post-treatment, and two follow-up time points for two treatment groups. When I analyze just pre and post treatment points (using MIXED procedure) I find an interaction of group x time indicating that Treatment A improves more than Treatment B. But if I analyze all four points, both treatments maintain their gains but no more changes after post-treatment for either group and the interaction of group x time (all four time points) disappears.

Would it make sense to still want to report on the interaction from pre- to post-treatment? if yes, what is the best way to do it? Or I should just ignore that interaction if it does not show when all four times are in the analysis?

Any thoughts greatly appreciated!

cheers,

bozena

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