SPSS Syntax

GET DATA
  /TYPE=XLSX
  /FILE='C:\path\to\yourfile.xlsx'
  /SHEET=name 'Sheet1'
  /CELLRANGE=FULL
  /READNAMES=ON.

GET DATA
  /TYPE=TXT
  /FILE='C:\path\to\yourfile.csv'
  /DELCASE=LINE
  /DELIMITERS=","
  /ARRANGEMENT=DELIMITED
  /FIRSTCASE=2
  /VARIABLES=var1 F8.2 var2 F8.2 var3 F8.2.

T-test code

T-TEST GROUPS=gender(1 2)
  /VARIABLES=math_score
  /CRITERIA=CI(.95).

Z-score code

DESCRIPTIVES VARIABLES=ALL /SAVE

Chi-square code

Below is the code for calculating the chi-square statistic.

CROSSTABS 
  /TABLES=Mjob BY internet  
  /STATISTICS=CHISQ
  /CELLS=COUNT EXPECTED.

Pearson Correlation

Below is the code for calculating the Pearson correlation.

CORRELATIONS 
  /VARIABLES=var1 var2
  /STATISTICS=DESCRIPTIVES.

Spearman Rank Correlation

NONPAR CORR 
  /VARIABLES=studytime traveltime
  /PRINT=SPEARMAN TWOTAIL NOSIG FULL
  /MISSING=PAIRWISE.

Phi-coefficient

Below is the syntax for calculating the phi-coefficient statistic.

CROSSTABS 
  /TABLES=sex BY internet 
  /FORMAT=AVALUE TABLES 
  /STATISTICS=PHI 
  /CELLS=COUNT 
  /COUNT ROUND CELL.

Partial Correlation

Below is the code for calculating the partial correlation.

PARTIAL CORR 
  /VARIABLES=hp mpg BY cyl
  /SIGNIFICANCE=TWOTAIL
  /MISSING=LISTWISE.

Scatterplot in SPSS

Below is the code for generating a scatterplot in SPSS

GRAPH 
  /SCATTERPLOT(BIVAR)=independent_variable WITH dependent_variable.

Bivariate Regression

Below is the code for performing a bivariate regression in SPSS.

REGRESSION 
  /DEPENDENT=dependent_variable
  /METHOD=ENTER independent_variable.