Extract significant Correlation Tables

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 1
Joined: Fri Feb 15, 2008 10:34 am

Extract significant Correlation Tables

Postby markuskus » Fri Feb 15, 2008 3:29 pm

Dear Community,
I recently automatized Pearson and Spearman correlations for my datasets using syntax. However I am only interested in the significant output tables and dont always want to screen hundreds of tables to find and save them. How knows which syntax (script?) is required to filter significant correlation tables + save? Another approach would be ok too, if SPSS only prints the significant ones thus I could save the entire output.

In order to clearify: My output are pairs (A-A, B-B,...); small, but lots of correlations.

best wishes,
Posts: 14
Joined: Fri May 23, 2008 8:54 am

Postby Crittia » Tue Jul 01, 2008 4:52 am

If you use Excel 2007 you can use a couple of conditional format rules to make a template like this one that I use:


This one has only 3 rules:
1) a color scale from blue to red according to the values
2) no format for values between 0 and .1
3) no format for values between 0 and -.1

For me this is ESSENTIAL for analyzing large surveys.
Posts: 2750
Joined: Tue Jun 12, 2007 12:08 pm
Location: Florida, USA

Postby statman » Tue Jul 01, 2008 12:00 pm

Depends on SPSS version but the OMS facility can be used.
See the note below

NOTE: Please read the Posting Guidelines and always tell us your OS, the SPSS version and information about your study and data!

Statistical Services

Who is online

Users browsing this forum: No registered users and 1 guest