SPSS Thesis Data Analysis: A Complete Guide from Survey Coding to Chapter 4

A practitioner’s handbook for converting raw Google Forms and Excel datasets into APA-formatted Chapter 4 tables in IBM SPSS Statistics.

1. Setting Up the SPSS Variable View Correctly

• Errors in SPSS analysis almost always trace back to faulty variable setup. When importing data from Excel or Google Forms:
  
• Measure Column: Ensure Likert scales are assigned as Scale (or Ordinal), not Nominal.
  
• Values Column: Assign clear labels to numeric codes (e.g., 1 = Strongly Disagree to 5 = Strongly Agree, 1 = Male, 2 = Female).
  
• Naming Rules: Variable names cannot have spaces or special characters (Job_Sat_1, not Job Sat 1).

2. Screening for Missing Values & Normality

• Before running hypothesis tests, verify assumptions:
  
• Missing Value Handling: Check for respondents who skipped questions. If missing values are < 5%, mean substitution or pairwise deletion is acceptable; otherwise, use multiple imputation.
• Normality: Evaluate Skewness and Kurtosis. Values between -2.0 and +2.0 are acceptable for assuming normality in large samples (Hair et al., 2022).
• Outliers: Inspect boxplots and standardized z-scores (z > 3.29 suggests potential extreme outliers).

3. Reliability (Alpha) & Factor Analysis (EFA)

• Demonstrate scale robustness:
  
• Cronbach’s Alpha: Run Analyze > Scale > Reliability Analysis. Alpha must exceed 0.70. If below 0.70, inspect the \"Cronbach’s Alpha if Item Deleted\" column to locate poorly performing items.
  
• Exploratory Factor Analysis (EFA): Run Analyze > Dimension Reduction > Factor. Check KMO (> 0.70) and Bartlett’s Test of Sphericity (p 1 using Varimax or Promax rotation. Items should load > 0.50 on their primary construct with no cross-loadings > 0.40.

4. Testing Hypotheses (Regression, ANOVA, t-tests)

• Match your test to your hypotheses:
  
• Independent Samples t-test: Comparing means between two independent groups (e.g., Public vs. Private sector employees).
  
• One-Way ANOVA: Comparing means across 3+ groups (e.g., across 4 age brackets) with Tukey Post-Hoc tests.
  
• Multiple Linear Regression: Evaluating the impact of multiple independent variables on a continuous outcome. Inspect R-squared, F-statistic, standardized Beta ($eta$), t-values, and p-values (p < 0.05). Ensure VIF < 3.0 to rule out multicollinearity.

5. Converting SPSS Outputs to APA 7th Tables

• Never paste raw grey SPSS output screenshots into your thesis. Convert into clean APA 7th tables:
  
• Horizontal borders only (top, under headers, bottom). No vertical gridlines.
  
• Include precise p-values ($p = .014$, not $p = .000$; write $p < .001$).
• Accompany every table with clear explanatory text describing what the numbers prove.

Frequently Asked Questions

What do I do if my Cronbach’s alpha is 0.65?

Values between 0.60 and 0.70 are considered acceptable in exploratory research. You can check the \"Alpha if item deleted\" table to see if removing a problematic question raises the score above 0.70.