Prof. Dr. Larry AdamsAcademic, Author & Researcher
How to Conduct Quantitative Research · Chapter 20 of 33

Part III — DATA ANALYSIS AND INTERPRETATION

Chapter 16. SPSS, R, Stata, SAS, Jamovi, JASP, Excel and Manual Checks

16.1 Software does not replace statistical reasoning

Software executes procedures; the researcher remains responsible for data coding, model selection, assumptions, interpretation and reporting. Use syntax or scripts rather than relying exclusively on point-and-click menus. A reproducible workflow makes it possible to rerun analyses after corrections and to audit exactly how results were produced.

ToolTypical strengthsCautions
IBM SPSS StatisticsAccessible menus, common in social/business sciences, broad proceduresCommercial licensing; syntax should be saved
RFree, extensive statistical ecosystem, reproducible scripts and graphicsLearning curve; package versions and code should be documented
StataStrong applied statistics, econometrics, panel and survey workflowsCommercial licensing; preserve do-files and logs
SASEnterprise analytics, regulated and large-scale workflowsCommercial ecosystem; document procedures
jamoviAccessible interface with reproducible analysis optionsCheck module capabilities and model assumptions
JASPAccessible interface, classical and Bayesian methodsCheck procedure details and version
ExcelData review, simple summaries, transparent calculationsRisk of silent formula errors; limited robust workflow for complex analyses
PythonData engineering, modelling and machine learningRequires disciplined coding, validation and environment documentation
Manual calculationUseful for understanding formulas and checking simple resultsProne to arithmetic error and impractical for complex models

16.2 SPSS project workflow

  1. Create a clearly named .sav file and preserve the original export separately.
  2. In Variable View, define name, type, label, value labels, missing values and measurement level.
  3. Run Frequencies for categorical variables and Explore/Descriptives for numeric variables.
  4. Use Data > Identify Duplicate Cases or appropriate syntax; document decisions.
  5. Use Transform > Recode into Different Variables for reverse coding; retain original items.
  6. Compute composite scores only after checking instrument scoring rules and missingness.
  7. Use Analyze menus to run the prespecified test; save syntax through Paste or a syntax window.
  8. Inspect diagnostic plots and relevant assumptions, not only the output table.
  9. Export tables carefully and verify every number against the original output.
  10. Save syntax, output (.spv), data dictionary and an analysis log.

16.3 Example SPSS syntax

Illustrative syntax only; replace variable names and values with those in the approved dataset. Verify the command options in the installed SPSS version.

FREQUENCIES VARIABLES=gender work_mode. DESCRIPTIVES VARIABLES=engagement_total support_total /STATISTICS=MEAN STDDEV MIN MAX. EXAMINE VARIABLES=engagement_total support_total /PLOT=HISTOGRAM NPPLOT /STATISTICS=DESCRIPTIVES /MISSING=LISTWISE. CORRELATIONS /VARIABLES=support_total engagement_total /PRINT=TWOTAIL SIG /MISSING=PAIRWISE. REGRESSION /DEPENDENT engagement_total /METHOD=ENTER support_total tenure_years work_mode /STATISTICS COEFF OUTS R ANOVA COLLIN TOL /PLOT=SCATTER(*ZRESID,*ZPRED) /RESIDUALS HISTOGRAM(ZRESID) NORMPROB(ZRESID).

16.4 Equivalent R illustration

# Illustrative only; verify names, missingness, coding and assumptions. summary(dat$engagement_total) table(dat$work_mode, useNA = "ifany") cor.test(dat$support_total, dat$engagement_total, use = "complete.obs", method = "pearson") fit <- lm(engagement_total ~ support_total + tenure_years + work_mode, data = dat) summary(fit) confint(fit) par(mfrow = c(2, 2)) plot(fit)

16.5 Manual checks

Manual checks are valuable for simple calculations and verification. For a mean, sum valid observations and divide by the number of valid observations. For a sample variance, sum squared deviations from the sample mean and divide by n−1; the sample standard deviation is the square root. For a simple two-group difference, calculate group means, the difference, a suitable standard error and a confidence interval using the method appropriate to the design. Do not use manual calculation as a substitute for a correct model when data are clustered, weighted, longitudinal or otherwise complex.

16.6 Reproducibility checklist

  • Raw data are retained unchanged and access-controlled.
  • Every derived variable has a documented rule.
  • Software name, version, packages/modules and operating environment are recorded.
  • Analysis syntax or scripts run from beginning to end without undocumented manual edits.
  • Random seeds are set for stochastic procedures where appropriate.
  • Outputs are linked to the reported tables and figures.
  • Corrections and exclusions are documented.
  • An appropriately de-identified analysis dataset and code can be shared when consent, law, contracts and policy permit.