(the number of current visitors is automatically updated every 4 minutes)
If you want to share information about this web page...
Reading this web site and watching the embedded videos will help you get started with using the statistical software IBM SPSS.
Recommended prereading are the pages Introduction to statistics, Observations and variables and Choosing statistical analysis.
SPSS = IBM SPSS Statistics is a statistical package to analyse observations with statistics. It’s original name “Statistical Package for the Social Sciences (SPSS)” implies that that it was initially intended for the social sciences. However it is now widely used in many other disciplines as well. The company, SPSS, developing the software was bought in 2009 by IBM. Hence, the current name is IBM SPSS Statistics.
Overview of SPSS
1 – Click to see introduction to the SPSS work space
2 – Click to see syntax, Viewer, Export and other tricks.
3 – Click to see SPSS Codebook
4 – Click to see an example of workflow in SPSS (might be daunting if you are new to SPSS)
Descriptive statistics in SPSS
Click to see – Nominal or ordinal scale (categorical data)
Click to see – Interval or ratio scale
Inferential statistics in SPSS
Click to see one sample t-test
Click to see paired t-test (before and after test)
Click to see two sample unpaired t-test
Click to see correlation in SPSS
Click to see simple standard linear regression
Click to see multivariable standard linear regression
Click to see logistic regression
Import observations from Excel to SPSS
You can easily move observations from Excel to SPSS by following these steps:
- Prepare your Excel file:
This step is done in Excel. Make sure that the first row of your Excel file contains only short column headers. If the headers are long and descriptive, shorten them and keep a separate text file explaining the short column headers. A column header must not begin with a number and must not contain spaces. Do not have sorting mechanisms in the first row. When you are finished, save the Excel file and close the Excel program. Take a look at the video below. - Importen from Excel to SPSS:
This moment is done from within SPSS and is decsribed in the video below. - Check if the import was successful and adjust any errors (create a “clean data file”):
It can be easier to correct data errors in SPSS rather than in Excel, especially if you have many observations (rows). The conversion from string variables to numeric variables (in the example below, recoding female and male as 1 and 0) can also advantageously be done in SPSS..
Click to see videos on how to import observations from Excel to SPSS
Make a “clean data file”
When the observations are in SPSS, you need to check the data and correct any errors. This is described in more detail on the page about Clean data file.