GET DATA /TYPE=XLSX
/FILE='C:\data\survey.xlsx'
/SHEET=name 'Sheet1'
/CELLRANGE=full
/READNAMES=on.
DATASET NAME ExcelData.
Perform analysis separately for each group (e.g., separate analysis for males and females).
* Turn on Split File.
SORT CASES BY Gender.
SPLIT FILE SEPARATE BY Gender.
* Run analysis (will output two tables, one for each gender).
DESCRIPTIVES VARIABLES=Salary.
* Turn off Split File.
SPLIT FILE OFF.
GRAPH /BAR(SIMPLE)=COUNT BY Gender.
* Independent samples t-test.
T-TEST GROUPS=gender(1 2)
/VARIABLES=test_score
/CRITERIA=CI(.95).
Getting a quick overview of your data.
Frequencies (for categorical data)
FREQUENCIES VARIABLES=Gender Ethnicity
/ORDER=ANALYSIS.
Descriptives (for continuous data)
DESCRIPTIVES VARIABLES=Age Salary
/STATISTICS=MEAN STDDEV MIN MAX.
SET PRINTBACK=OFF.
* your commands here.
SET PRINTBACK=ON.
OUTPUT NEW NAME=MyAnalysis.
FREQUENCIES Gender.
SPSS 26 improved the Syntax Editor interface. If your code looks like plain text, enable highlighting: spss 26 code