Skip to main content
v2026.1714 entries · CC-BY 4.0
CASRAI

Guide

How to use SPSS

Using SPSS involves a structured workflow of importing data, defining variables, running statistical analyses via menus, and exporting output tables and charts.

CASRAI research-methods explainer — How to use SPSS

The step most authors miss

Doing CRediT right? Don’t stop at the statement.

A CRediT statement credits you inside one paper. The recognition CRediT was built for happens when those roles are tied to you, persistently. Sign in with your ORCID — free — and claim your CRediT contributions on casrai.org, the home of the standard. They become a verified, portable part of your identity, not a line that disappears into one PDF.

Free: claim your contributions, then export a journal-ready CRediT statement, schema.org structured data, JATS XML, CSV or BibTeX — and preview your public profile. A membership publishes that profile publicly and verifies the journals you serve.

Importing data and defining variables

The first step in SPSS is setting up your dataset. You can enter data manually in the Data View of the Data Editor, or import files from Excel (.xlsx), CSV (.csv), or text formats via 'File > Import Data'. Once imported, you must switch to the Variable View to define each column's metadata. Here, you specify the Variable Name (which cannot contain spaces), the Variable Label (a descriptive name shown in outputs), the Value Labels (e.g., mapping '0' to 'Male' and '1' to 'Female'), and the Measurement Level (Nominal, Ordinal, or Scale), which dictates which statistical tests can be run.

Running analyses and reading the viewer

All statistical tests in SPSS are accessed through the 'Analyse' drop-down menu. For example, to calculate averages, select 'Analyse > Descriptive Statistics > Frequencies' or 'Descriptives'. To compare groups, select 'Analyse > Compare Means' and choose the appropriate t-test or ANOVA. Clicking 'OK' executes the test and opens the Viewer window (.spv). The Viewer displays a sidebar index and tables containing the test statistics, degrees of freedom, and exact p-values (labelled as 'Sig.'). You can export these tables to Microsoft Word or PDF for reporting, making it easy to share results. This structured reporting makes it easy to review the outputs of multiple tests without losing track of your historical queries during a session.

Using syntax for reproducible research

Whilst clicking menus is easy, it is bad practice for serious research because it leaves no audit trail. To make your analysis reproducible, use SPSS Syntax. In any menu dialogue box, instead of clicking 'OK' to run the test, click the 'Paste' button. This copies the underlying command code into the Syntax Editor window (.sps). You can write comments in this file (starting with an asterisk and ending with a period) and save it. Running the syntax file regenerates the exact same output, allowing you or other researchers to replicate the analysis instantly, which is vital for academic integrity. By sharing this syntax file alongside your publication, you enable other scientists to verify your calculations and build directly upon your findings.

Key facts

At a glance

  • Step 1: import your raw data from Excel, CSV, or text files into the Data Editor
  • Step 2: configure variable names, labels, and measurement levels in the Variable View
  • Step 3: navigate the "Analyze" menu to select your descriptive or inferential tests
  • Step 4: review p-values and test statistics in the separate SPSS Viewer window
  • Best practice: click 'Paste' instead of 'OK' to generate reproducible syntax scripts
  • Export: right-click tables in the Viewer to export them directly to Word or Excel

Common misconceptions

What people often get wrong

Often heard: You must enter all your data manually in SPSS row by row.

Actually: SPSS can import data from almost any structured source, including spreadsheet software, text databases, and SQL databases, which prevents data entry errors.

Often heard: SPSS output tables are ready to paste directly into academic papers.

Actually: SPSS outputs require formatting to meet APA or other journal style guidelines. You must adjust decimal places, edit table headers, and remove redundant statistical output.

Common questions

FAQ

What should I do if a p-value shows as '.000' in SPSS?+

A p-value of '.000' does not mean the probability is zero. It means the p-value is less than 0.001, and SPSS has rounded it to three decimal places. In your report, you should write this as 'p < .001' rather than 'p = .000'.

How do I handle missing data in SPSS?+

In the Variable View, click on the 'Missing' cell for a variable. You can define specific 'discrete missing values' (e.g., -99) that SPSS will ignore during statistical calculations, preventing missing entries from skewing your means.

Referenced across the research world

University of Cambridge logoColumbia University logoUniversity of Edinburgh logoHarvard University logoUniversity of Oxford logoPrinceton University logoStanford School of Medicine logoUniversity College London logoORCID logoCrossref logoUniversity of Cambridge logoColumbia University logoUniversity of Edinburgh logoHarvard University logoUniversity of Oxford logoPrinceton University logoStanford School of Medicine logoUniversity College London logoORCID logoCrossref logo
  • University of Cambridge logo
  • Columbia University logo
  • University of Edinburgh logo
  • Harvard University logo
  • University of Oxford logo
  • Princeton University logo
  • Stanford School of Medicine logo
  • University College London logo
  • ORCID logo
  • Crossref logo

View CASRAI adoption →