How to Use SPSS for Data Analysis: A Step-by-Step Tutoril for Beginners
If you are studying for a project, writing a thesis, or just starting out as a data analyst in Nigeria, there is a good chance someone has told you to "run it in SPSS". SPSS (Statistical Package for the Social Sciences) is one of the most widely used data analysis tools in Nigerian universities, research centres, and NGOs, mostly because it lets you analyse data without writing a single line of code.
The problem is that SPSS looks intimidating the first time you open it. Rows of numbers, strange tabs, and a results window full of tables can put off a beginner fast. This tutorial breaks the whole process down into 10 clear steps, using one running example throughout: a small survey of 200 Nigerian university students looking at study habits, side hustles, and CGPA. By the end, you will know how to use SPSS for data analysis from start to finish, and you will also know when it makes sense to move on to a more flexible tool like Python.
Before you start: This article connects directly to our article on 5 NumPy Functions Every Data Analyst Should Know and the 5 Best Python Libraries for Data Visualization. Reading those first will make this much easier to follow.
How To Get Access to SPSS
You can download SPSS Statistics directly from IBM's official site, but as a student in Nigeria, check your school's computer lab or library first. Most universities have an institutional license, which means you can use SPSS for free on campus instead of paying for the full version. If your school does not have a license, IBM also offers a free trial that is enough to practise with for a few weeks.
Understand the Two Main Views
When SPSS opens, you will see two tabs at the bottom of the screen: Data View and Variable View. This single idea trips up more beginners than anything else, so it is worth slowing down here.
Data View is your spreadsheet. Each row is one person or one record, for example, one student. Each column is one piece of information about that person, like their CGPA or their state of origin.
Variable View is where you describe each column before you fill it with data. Here you tell SPSS the variable's name, its type (numeric or text), and whether it is nominal (categories with no order, like Gender), ordinal (categories with an order, like Class of Degree), or scale (a real number you can do maths with, like CGPA or Weekly Study Hours).
Getting this step right early saves you from confusing errors later, because SPSS chooses which statistical tests are even available to you based on these variable types.
How To Set Up Your Variables
For our student survey, go to Variable View and create five variables: State, Gender, StudyHours, CGPA, and SideHustle (Yes/No). For Gender and SideHustle, use the Values column to label your codes, for example, 1 = Male and 2 = Female. This way SPSS displays readable labels in your output instead of confusing 1s and 2s.
How To Enter or Import Your Data
Switch to Data View and type your data in directly, the same way you would in Excel. If you already have your survey responses in a spreadsheet, it is faster to import them: go to File > Open > Data, choose your Excel or CSV file, and SPSS will map the columns automatically. For our example, this gives you 200 rows, one for each student, with their state, gender, weekly study hours, CGPA, and whether they run a side hustle.
How To Clean Your Data Before You Analyse It
This step is often skipped, and it is the one that ruins results the most. Check for empty cells, impossible values (a CGPA of 12 on a 5-point scale, for instance), and duplicate entries. Go to Analyze > Descriptive Statistics > Frequencies and run it on each variable just to scan for anything that looks wrong. Catching a typing error here takes two minutes; catching it after you have already written your conclusions takes a lot longer.
How To Run Descriptive Statistics
Now you can start answering simple questions about your data. Go to Analyze > Descriptive Statistics > Descriptives, move CGPA and StudyHours into the box, and click OK. SPSS will give you the mean, minimum, maximum, and standard deviation for both. For our students, this might show an average CGPA of 3.6 and an average of 14 study hours per week, a good first snapshot before going deeper.
If you want to see the SPSS command behind any menu action, click Paste instead of OK in the dialog box. This opens the Syntax Editor and writes the equivalent code for you, for example:
Learning to read this syntax is useful even if you never type it yourself, because it shows you exactly what SPSS is calculating.
How To Visualise Your Data
Numbers alone do not tell a full story. Go to Graphs > Chart Builder to create bar charts, histograms, or scatterplots. A histogram CGPA shows you the shape of your students' performance at a glance, while a scatterplot of StudyHours against CGPA lets you see, visually, whether students who study more tend to score higher before you even run a formal test.
Run a Statistical Test
This is usually the actual goal of the analysis: testing whether a relationship is real or just chance. Two common starting points:
To check whether study hours relate to CGPA, use Analyze > Correlate > Bivariate and select both variables. SPSS gives you a correlation coefficient between -1 and 1, plus a significance value (p-value) telling you whether the relationship is statistically meaningful.
To compare CGPA between students with a side hustle and those without, use Analyze > Compare Means > Independent-Samples T Test. This tells you whether the difference between the two groups is large enough to matter, or just normal variation.
Read the Output Viewer Correctly
Every analysis you run opens in the Output Viewer, a separate window full of tables. As a beginner, focus on two things in most tests: the actual statistic (like the correlation coefficient or the mean difference) and the Sig. column. A Sig. value below 0.05 generally means your result is statistically significant and unlikely to be due to chance. Double-click any table to edit fonts, hide rows, or clean it up before you copy it into your project or report.
Export and Report Your Results
Once you are happy with your tables and charts, go to File > Export to save them as a Word document or PDF. This is much faster than retyping every table by hand, and it preserves the formatting. For a project or thesis chapter, copy the relevant tables into your document and write a short interpretation under each one in plain language, exactly the way you would explain it to a classmate.
Quick Reference Table
| Step | Menu Path | What It Does |
|---|---|---|
| Descriptives | Analyze > Descriptive Statistics > Descriptives | Mean, min, max, standard deviation |
| Frequencies | Analyze > Descriptive Statistics > Frequencies | Counts and percentages for categories |
| Correlation | Analyze > Correlate > Bivariate | Tests relationship between two scale variables |
| T-Test | Analyze > Compare Means > Independent-Samples T Test | Compares means between two groups |
| Charts | Graphs > Chart Builder | Builds bar charts, histograms, scatterplots |
When to Move Beyond SPSS
SPSS is a solid starting point, especially for academic projects where your supervisor expects SPSS output specifically. But it has real limits: it is expensive outside a student license, it struggles with very large datasets, and you are boxed in by whatever menu options IBM decided to give you.
This is exactly the gap that Python fills. Once you are comfortable with the logic in this guide (variable types, descriptive statistics, correlation, group comparisons), the jump to Python and its pandas library is much shorter than people expect, because you already understand what the numbers mean. You just need a place to start running code, and our guide on installing Jupyter Notebook for Python is a good first stop.
Conclusion
SPSS does not have to be intimidating once you understand its two core views and the handful of menus you will use 90% of the time. Set up your variables correctly, clean your data before you analyse it, and always check the Sig. column when you run a test. Master these 10 steps and you will be able to handle most undergraduate or NGO-level data analysis tasks SPSS is asked to do.
If you found this useful and want more beginner-friendly breakdowns like this, including ones that bridge into Python, join the newsletter and get new guides as soon as they go live: Subscribe here.
Post a Comment