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

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

SPSS Statistics Essential Training (2011)
Illustration by

Taking a first look at the interface


From:

SPSS Statistics Essential Training (2011)

with Barton Poulson

Video: Taking a first look at the interface

At first glance, SPSS resembles a spreadsheet. There are rows and columns of data where each column represents a variable, such as a customer ID number, a question on a survey, or a city's population, and each row typically represents a case, which could be a person, a company, an advertising campaign, or whatever. However, there's a lot more to SPSS than that. First off, SPSS has more than one window. It has two, or possibly three windows. The window we are looking at right now is the Data Editor window, or Data window, and I have a sample data set called searches.save opened.
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

Taking a first look at the interface

At first glance, SPSS resembles a spreadsheet. There are rows and columns of data where each column represents a variable, such as a customer ID number, a question on a survey, or a city's population, and each row typically represents a case, which could be a person, a company, an advertising campaign, or whatever. However, there's a lot more to SPSS than that. First off, SPSS has more than one window. It has two, or possibly three windows. The window we are looking at right now is the Data Editor window, or Data window, and I have a sample data set called searches.save opened.

This is a data set that contains information about Google searches for specific terms, such as SPSS or regression, for each of the 50 states and Washington DC, and I will be using this data set frequently as a sample during this course. If you look at the tabs on the bottom left, this is what's called the Data view. The Data view is the one that looks like a spreadsheet. However, there is also one called a Variable view. If you click on that then what you see that it has information about the variables. The first column is the variable names.

Variables in SPSS have to have a single-word names. They can be up to 64 characters, they can have underscores or dots, and they can be upper- or lowercase. Otherwise they need to be relatively short, and again they do need to be a single word. The next column is the type of the variable. A string variable for instance is a text variable, and the state codes like CA or NY are entered as text. Everything else in here is entered as numbers and they're numeric variables, even though several of them have words laid over on top of them. I will show you in a moment.

The third one is the width of the variable and the fourth one is the number of decimal places. The next one is what's called the Label. This means although the variables may have short names, like state_code, the label can be something that's a little easier to read, like State_code with capitalization. Or if you go further down to row 18, you see there is one called degree. That's the name of the variable, but the label is much longer. It is percent of population with bachelors degree or higher. So label can be much more descriptive, and since the label is what's going to show up in a chart or in a table, you want to make that long enough that it's easy to tell what it is.

The next column is Values, and I said that most of these variables are entered as numbers. Now some of them just are numbers. The Google search information is numbers. They tell you how high a particular search term rates, relatively speaking, compared to all others for a particular state. On the other hand, other variables such as 15, 16, and 17 which has NFL, has NBA, and has MLS for Major League Soccer, those are Yes/No variables. Those are called indicator variables and I enter them as 0 for no and 1 is yes.

So the numbers are what's in the dataset, but you can see that I tell SPSS in values, if I come over it and click on that, that 0 equals No and 1 equals Yes, and you can add them and change them and remove them in this dialog box. The next column is whether you want to specify explicitly any particular value to indicate missing information. Say for instance a person forgets to answer a question. You may want to indicate that's an accidental omission. Perhaps you can give that a 999 to indicate that it's accidental. Or if you didn't ask a question because it wasn't relevant, you could give a different code like 888, or whatever you want. Just make sure it doesn't overlap with the valid information.

The next column is simply how wide the column is in the data set, and I make them 11 spaces by default. Let's scroll over a little bit here. Then there is alignment within the column: Left, Center, or Right. The last two are specific statistical things. This is what's called the Level of Measurement and in SPSS a variable can either be nominal, which means it's simply indicates a different group and a string variable where you write words as nominal, but also a 01 indicator variable is nominal, or the region of the United States which has 4-- 1, 2, 3, 4--regions, that can be nominal.

A variable to also be ordinal. You can indicate, for instance, the client with the largest account, then the second largest, and the third largest. The other choice in SPSS is what's called a Scale Variable, and you see there is a little ruler next to it. These are variables that are measured as more or less in set units so you can actually calculate statistics like an average for them, whereas you can't with a nominal variable. The very last column is called the Role, and this is a relatively new feature in SPSS. And you specify, for instance, whether a particular variable is to be used as an input variable, that is, you're using it to predict values on other things.

These are sometimes called independent variables or predictor variables. A variable can also be a target variable, and that is, it's always something that you're trying to explain, like for instance spending on particular products. Or a variable can be both, sometimes an input, sometimes a target and you see them marked as both. Finally, a variable can also be marked as none. That means it's not an input or a target variable; it's simply there for a state code as an identifier or indicator. And so those are the options in the Variable View window.

Let me go back to the Data view now. The next thing to note is you can actually have a lot of variables in SPSS. It's limited only by its ability to address the variables. It can address over two billion variables in two billion cases, which you are unlikely to hit in most situations. But this is the Data window. Now, what makes this different, also, aside from the metadata and the Variable window, is it when you run a command in SPSS, unlike a spreadsheet, it doesn't show up on the same page. For instance, I am going to quickly make a chart. I'm going to make what's called a histogram for "interest in SPSS" as a search term.

I go up to Graphs, and I click on something of a Chart Builder, which I will demonstrate more fully in a later movie. I am going to pick a histogram and drag it up into what's called the Canvas, take SPSS, and put it down here. Now what's interesting is I have a lot of options about how I set this up--and we'll save that-- but I want to show you two things. One is I can click OK and go straight from that dialog box, not to the Data window but to an Output window, and in the Output Window I set it up so that it gives me the written code that can produce this chart over again.

That's the information about the commands, and there's the chart. But you see this is a separate window. We had a Data window; now we have an Output window. I am going to back to the command for just a moment and show you an optional third window. Right next to the OK button there is something called Paste, and if I click that, it opens up a window called a Syntax window, and this is just command-line code. By pasting it, it has taken the written commands for this particular chart and it's put them in a Syntax window and I can use it to either modify the commands or I can use it to recreate the command at a later time.

It's a great way of sharing information with people. So watch, I can simply highlight all of this and I can come up and press the big green Run button, the Play button. If I hit that, you will see that it's done it all over again. It's a great way of replicating analyses. For instance, you can set up an analysis when you have only part of the data, or you can run it periodically as new data comes in. It's a wonderful feature. Now let me show you a couple of other features here in SPSS. One for instance, is under the File menu and the Edit and the View.

These are common things. The Data menu allows you to do a number of procedures to modify the data-- I'll show this in a few movies--and so does the transform to create new variables. You can insert headings and titles in your output. Analyze is the actual statistical procedures menu, we will go through that. Now Direct Marketing here is a separate add-in. SPSS has a lot of add-ins that you can purchase separately to give increased functionality to SPSS, but I won't be demonstrating those. The techniques that I am going to be using in this particular course all involve the base procedures that are available in SPSS.

The next command is to make graphs, and I have a whole series of movies about those. Utilities can be a way of getting more information about the variables or about creating scripts and production jobs, which are more advance procedures which we won't be covering in this course. Add-ons gets into some of the other services that you can purchase that connect with SPSS, such as SPSS Modeler which is for data mining and SPSS Text Analytics for analyzing open-ended natural language, like customer comments on a webpage or twitter feeds--it's a great way to go.

And then finally, the Help menu here gives you a huge amount of information. Let me open up, for example, the Tutorials, and this opens up in a web browser, although it's a locally stored file. And what you see here is an entire collection of presentations that SPSS will run through to teach you how to do any of a number of procedures, and they are very useful for learning how to use SPSS in even more depth. Back in SPSS, there is also what's called the Command Syntax Reference. This is a 2500-page searchable PDF file about the command-line syntax programming that you may be able to use it at a later point in more advanced functioning.

Now there are just a couple more things I want to show you in SPSS about how to set up the program. If I come back to Edit and go down to Options, there are number of things you can do to customize the way SPSS works for you. There's a few in particular I want to point out. One is in this tab called Viewer. Down at the bottom, on the left, there's a checkbox for Display commands in the log, and that's the thing that makes it so that SPSS inserts the written code that produces each analysis, or each display, as you go through. I find it a very helpful thing to do, in addition to pasting the syntax into a syntax window to be saved separately.

The other one that I think is important is under Output Labels, the second one from the right on the bottom. Output Labels lets you show things as either the labels that you give them--you may recall for instance we had the variable called Degree, which had a much longer label about percentage of population with a bachelors degree or higher. You could either have that long labels show up in the output and in the tables and in the figures or you could have the short name, which is just degree, or you can have both of them.

Similarly, with the Value Labels, like for instance, I had whether a state had NFL team, I had 0 as No, 1 as Yes, Labels means you can have the yes's and the no's shows, but you can also do it as 0s in 1s, and you can also do it as 0, No, 1, Yes. And I use one or the other depending on the situation. It can be a good way to keep track of things. It can also be a way of making things more presentation-ready to use just the labels. And yes, those are the options, and I encourage you to search through some of those little bit more to see what else is there.

So the organization of SPSS, says there is a superficial similarity to a spreadsheet, but you can see that it has been developed with an eye towards making statistical graphing and analysis much faster and more organized. Also, with the option to Paste command syntax into its own window and save it as part of the output with each procedure, that makes it much easier to keep track of what you do to share with others and to repeat analyses. Finally, SPSS's extensive help collection can make it easy for you to get directions and walkthroughs on nearly every procedure that SPSS does.

In the next video, we will talk about one other setup process, and that is getting data from an external spreadsheet into SPSS.

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.