New Feature: Playlist Center! Pick a topic and let our playlists guide the way—like a learning mixtape.

Start learning with our library of video tutorials taught by experts. Get started

SPSS Statistics Essential Training (2011)
Illustration by

Formatting correlations


From:

SPSS Statistics Essential Training (2011)

with Barton Poulson

Video: Formatting correlations

In the last movie, we looked at how to take a table of descriptive statistics in SPSS and then copy and paste it into a spreadsheet, and then in that spreadsheet to rearrange, delete, and modify the values in there to make them easier to communicate. In this movie, I want to show you how to take one particular kind of table, a correlation matrix, and work with that in a spreadsheet to clean it up and make it much easier to deal with, where you can go from potentially thousands of numbers to a small handful and present them in a way that makes them much, much easier to follow.
Expand all | Collapse all
  1. 2m 58s
    1. Welcome
      1m 5s
    2. Using the exercise files
      40s
    3. Using a different version of the software
      1m 13s
  2. 19m 0s
    1. Taking a first look at the interface
      11m 49s
    2. Reading data from a spreadsheet
      7m 11s
  3. 21m 54s
    1. Creating bar charts for categorical variables
      7m 18s
    2. Creating pie charts for categorical variables
      2m 54s
    3. Creating histograms for quantitative variables
      5m 45s
    4. Creating box plots for quantitative variables
      5m 57s
  4. 33m 10s
    1. Recoding variables
      5m 33s
    2. Recoding with visual binning
      5m 33s
    3. Recoding by ranking cases
      5m 26s
    4. Computing new variables
      5m 37s
    5. Combining or excluding outliers
      5m 21s
    6. Transforming outliers
      5m 40s
  5. 28m 12s
    1. Selecting cases
      6m 44s
    2. Using the Split File command
      5m 12s
    3. Merging files
      5m 33s
    4. Using the Multiple Response command
      10m 43s
  6. 22m 14s
    1. Calculating frequencies
      8m 43s
    2. Calculating descriptives
      5m 31s
    3. Using the Explore command
      8m 0s
  7. 16m 3s
    1. Calculating inferential statistics for a single proportion
      6m 6s
    2. Calculating inferential statistics for a single mean
      5m 39s
    3. Calculating inferential statistics for a single categorical variable
      4m 18s
  8. 30m 43s
    1. Creating clustered bar charts
      7m 10s
    2. Creating scatterplots
      5m 8s
    3. Creating time series
      3m 24s
    4. Creating simple bar charts of group means
      4m 17s
    5. Creating population pyramids
      3m 0s
    6. Creating simple boxplots for groups
      3m 3s
    7. Creating side-by-side boxplots
      4m 41s
  9. 45m 28s
    1. Calculating correlations
      8m 17s
    2. Computing a bivariate regression
      6m 27s
    3. Creating crosstabs for categorical variables
      6m 34s
    4. Comparing means with the Means procedure
      6m 33s
    5. Comparing means with the t-test
      6m 4s
    6. Comparing means with a one-way ANOVA
      6m 30s
    7. Comparing paired means
      5m 3s
  10. 24m 30s
    1. Creating clustered bar charts for frequencies
      6m 34s
    2. Creating clustered bar charts for means
      3m 45s
    3. Creating scatterplots by group
      4m 13s
    4. Creating 3-D scatterplots
      4m 25s
    5. Creating scatterplot matrices
      5m 33s
  11. 30m 57s
    1. Using Automatic Linear Models
      11m 52s
    2. Calculating multiple regression
      9m 3s
    3. Comparing means with a two-factor ANOVA
      10m 2s
  12. 29m 29s
    1. Formatting descriptive statistics
      6m 1s
    2. Formatting correlations
      7m 49s
    3. Formatting regression
      10m 19s
    4. Exporting charts and tables
      5m 20s
  13. 51s
    1. What's next
      51s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
SPSS Statistics Essential Training (2011)
5h 5m Beginner Aug 17, 2011

Viewers: in countries Watching now:

In this course, author Barton Poulson takes a practical, visual, and non-mathematical approach to the basics of statistical concepts and data analysis in SPSS, the statistical package for business, government, research, and academic organization. From importing spreadsheets to creating regression models to exporting presentation graphics, this course covers all the basics, with an emphasis on clarity, interpretation, communicability, and application.

Topics include:
  • Importing and entering data
  • Creating descriptive charts
  • Modifying and selecting cases
  • Calculating descriptive and inferential statistics
  • Modeling associations with correlations, contingency tables, and multiple regression
  • Formatting and exporting tables and charts
Subjects:
Business Data Analysis
Software:
SPSS
Author:
Barton Poulson

Formatting correlations

In the last movie, we looked at how to take a table of descriptive statistics in SPSS and then copy and paste it into a spreadsheet, and then in that spreadsheet to rearrange, delete, and modify the values in there to make them easier to communicate. In this movie, I want to show you how to take one particular kind of table, a correlation matrix, and work with that in a spreadsheet to clean it up and make it much easier to deal with, where you can go from potentially thousands of numbers to a small handful and present them in a way that makes them much, much easier to follow.

For this example, I'm going to be using the same dataset and the same variables I did in the last one, the Google searches information and searches.sav. And the first thing I need to do is get a correlation matrix, so I'll come up to Analyze, to Correlate, to Bivariate Correlations. Now I find it helpful to take the outcome variable and put that in first so it shows up in the left column. In this case, that's the relative interest in SPSS as a Google search term. The other terms that I used were Business Intelligence and Data Visualization.

I also used an indication of education with the percentage of the state's population with a bachelor's degree or higher. I used the Median Age and then I used three indicator variables for the region of the United States. Now even though there are four regions with indicator variables, you only need one less indicator than the number of categories. So for instance, when we have the two categories of gender, we only need a single indicator variable to indicate one or the other. With four categories, we only need three because the fourth category is implied by zeros on the three variables.

But I can highlight the three of those and move them over and now I just click OK. Now I have a correlation matrix here and as far as correlation matrices go it's not huge. I've had ones with hundreds of variables on each side. But you see that we have the variables listed down this side and the same variables across the top, and we have several statistics in the cells for each one. Please note that at this point the statistically significant correlations have Asterisks next to them. What I'm going to is I'm going to right-click on this table and copy it.

Then I'm going to go to a spreadsheet. I'm using Excel in this particular case and I'm going to paste this not into cell A1 but into B1. And the reason I'm going to do that is I find it very helpful to have an index column at the beginning that allows me to restore the order of things. So I have 1, 2. I can select those and drag down and propagate the order list. Great! And now what I can do is I can start deleting and reformatting.

So for instance, you see in row one, the word Correlations is a single merged cell. That's going to make it difficult to sort things. So I'm going to simply delete that. Then you can see that in column B, the search terms are merged cells across three rows. This also causes problems. The way to deal with that is to simply delete the column. So I've lost the names of the variables but I can get those back because I have the same variables listed across the top.

However, I don't need the Pearson correlation and the probability level and the sample size. All I really want is the correlation, so I'm going to get rid of the other two. Simply click on a cell in that row and then I can sort the entire table. Now I have the Ns. They're all 51, so I don't need those in my table. Then I have the Pearson Correlations, then I have the Sig. (2-Tailed). Those are the probability levels. I don't need those. I need to indicate them in a way and I'm going to delete them for right now.

So now all I have are the correlation coefficients themselves. I'm going to sort this again to try to get the titles on the top. I'm going to cut this and then insert it back beneath the titles. Then in order to get the variable list back on the side where it says Pearson Correlation, I highlight the list here, I copy that, I come back to this first one and right-click, and I do Paste Special and Transpose.

And that switches it from horizontal to vertical. And so you see now I have the variables listed again. Now I'm going to do something else. I don't need all of these variables here. I'm mostly interested in just predicting SPSS, so I can highlight all of those and I can delete them. Also I don't need the SPSS correlated with itself. Now I can remove the borders. I can get this one flush left. I'm going to stretch this out a little bit, but this one is too long so I'm just going to call it Degree, and I'll make these other two a little shorter and center this one.

I don't need three decimal places. Two is plenty. But now I need to indicate which ones are statistically significant. I'm going to delete this column also. Unfortunately, we had asterisks in the SPSS table to indicate which correlations were statistically significant, but we lost them when we pasted into Excel. That's not a big problem though. Wwe could go back and manually check, but I know another way of doing this. I've provided a spreadsheet called Correlation-Probability-Formulas and what you can do with this one is you simply enter the sample size.

in this particular case we have 51, and it will tell you what absolute value of correlation is statistically significant. In this case, it's 276. So anything that is greater than an absolute value of 276, so negative that goes past or positive that goes past it, is statistically significant. So I can go back to my table here and I can do a quick conditional formatting. Now it's a little silly when I only have seven numbers here. But the point is this works just as well as thousands of numbers.

I highlight the numbers, I come over to Conditional Formatting, I click on that, and I'm going to create a new rule. And I want to format only cells that contain values that are not between -0.276 and positive 0.276. So the values have to be more extreme than that. Then I go to Format and I can choose Fill and maybe I'll make them yellow and I press OK.

And when I do that, I see that the top three correlations are all statistically significant because they have absolute values greater than 0.276. Now it's also helpful to create a legend and highlight it in the same color, so it's clear that that color means something. If I want to, I can put a border around this. Many of you will have training in designing graphics and you'll find ways to make this even clearer. But what I've done here is I've taken-- let's look back at the original correlation matrix.

It's huge. There's hundreds of numbers here. And I've boiled it down to seven numbers and even then I've highlighted the ones that are statistically significant to make it easier to find. So this is one way to take the output of SPSS and to transform it into a way that makes it easier to communicate and easier to understand. In the next video, I'm going to show you how to integrate the results of a regression analysis to compare this and try to make the patterns clear across the two ways of analyzing the data.

There are currently no FAQs about SPSS Statistics Essential Training (2011).

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now Upgrade now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed SPSS Statistics Essential Training (2011).

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Notes cannot be added for locked videos.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.