Ann Arbor ASA Up and Running Series SPSS

Ann Arbor ASA ‘Up and Running’ Series: SPSS Prepared by volunteers of the Ann Arbor Chapter of the American Statistical Association, in cooperation with the Department of Statistics and the Center for Statistical Consultation and Research of the University of Michigan

Content • • Introduction User interface Examining data Manipulating data Statistics Syntax Resources Ann Arbor ASA 'Up and Running Series': SPSS 2

Introduction • SPSS: ‘Statistical Package for the Social Sciences’ • Industry standard in fields such as marketing • Good data management capabilities • Large variety of statistical procedures Ann Arbor ASA 'Up and Running Series': SPSS 3

Initialize SPSS • Start All Programs SPSS Inc PASW Statistics 18 Ann Arbor ASA 'Up and Running Series': SPSS 4

SPSS User Interface Data Ann Arbor ASA 'Up and Running Series': SPSS 5

SPSS User Interface Type New Data Ann Arbor ASA 'Up and Running Series': SPSS 6

SPSS User Interface Existing Data Ann Arbor ASA 'Up and Running Series': SPSS 7

SPSS User Interface Existing Data Ann Arbor ASA 'Up and Running Series': SPSS 8

SPSS User Interface Existing Data Ann Arbor ASA 'Up and Running Series': SPSS 9

SPSS User Interface Open EXCEL Ann Arbor ASA 'Up and Running Series': SPSS 10

SPSS User Interface Open EXCEL Ann Arbor ASA 'Up and Running Series': SPSS 11

SPSS User Interface Open EXCEL • Format for ease of import: – – Variable names in first row. Each column is one variable Don’t mix text and numbers. One row per case. Ann Arbor ASA 'Up and Running Series': SPSS 12

SPSS User Interface Open EXCEL Ann Arbor ASA 'Up and Running Series': SPSS 13

SPSS User Interface Open EXCEL Ann Arbor ASA 'Up and Running Series': SPSS 14

SPSS User Interface Import EXCEL Using Database Wizard Ann Arbor ASA 'Up and Running Series': SPSS 15

SPSS User Interface Import EXCEL Using Database Wizard Ann Arbor ASA 'Up and Running Series': SPSS 16

SPSS User Interface Import EXCEL Using Database Wizard Ann Arbor ASA 'Up and Running Series': SPSS 17

SPSS User Interface Import EXCEL Using Database Wizard Change to 20 Ann Arbor ASA 'Up and Running Series': SPSS 18

SSPSS User Interface Import EXCEL Using Database Wizard Ann Arbor ASA 'Up and Running Series': SPSS 19

SPSS User Interface Import EXCEL Using Database Wizard Ann Arbor ASA 'Up and Running Series': SPSS 20

SPSS Examining Data Overview • Analyze – Reports • Case Summaries – Descriptive Statistics • Explore • File – Data File Information Ann Arbor ASA 'Up and Running Series': SPSS 21

SPSS Examining Data Case Summaries • Analyze Reports Case Summaries Ann Arbor ASA 'Up and Running Series': SPSS 22

SPSS Examining Data Case Summaries Ann Arbor ASA 'Up and Running Series': SPSS 23

SPSS Examining Data Explore • Analyze Descriptive Statistics Explore • Display: Both Ann Arbor ASA 'Up and Running Series': SPSS 24

SPSS Examining Data Explore Ann Arbor ASA 'Up and Running Series': SPSS 25

SPSS Examining Data Explore Ann Arbor ASA 'Up and Running Series': SPSS 26

SPSS Manipulating Data Overview • Sort – Cases – Variables • • Split File Select Cases Compute new variables Recode variables into: – Same Variables – Different Variables Ann Arbor ASA 'Up and Running Series': SPSS 27

SPSS Manipulating Data Sort Cases • Data Sort Cases Sort by: ‘Age’ OK Ann Arbor ASA 'Up and Running Series': SPSS 28

SPSS Manipulating Data Sort Variables • Data Sort Variables Sort Variable View – Variable View Columns: ‘Name’ • OK Ann Arbor ASA 'Up and Running Series': SPSS 29

SPSS Manipulating Data Split File • Data Split File – Compare groups • Groups Based on: ‘Sex’ • Sort file by grouping variables • OK Ann Arbor ASA 'Up and Running Series': SPSS 30

SPSS Statistics Overview • Analyze menu – Descriptive Statistics – Compare Means – General Linear Model – Correlate – Regression – … and many more! Ann Arbor ASA 'Up and Running Series': SPSS 31

SPSS Statistics Frequencies • Analyze Descriptive Statistics Frequencies – Display frequency tables Ann Arbor ASA 'Up and Running Series': SPSS 32

SPSS Statistics Frequencies • Frequencies Statistics – Dispersion: Range, Minimum, Maximum • Continue Ann Arbor ASA 'Up and Running Series': SPSS 33

SPSS Statistics Frequencies Ann Arbor ASA 'Up and Running Series': SPSS 34

SPSS Statistics Descriptives • Analyze Descriptive Statistics Descriptives • NOTE: SPSS select ONLY continuous variables Ann Arbor ASA 'Up and Running Series': SPSS 35

SPSS Statistics Descriptives • Descriptives Options – Mean – Dispersion: Std. deviation, Minimum, Maximum – Display Order: Variable list • Continue Ann Arbor ASA 'Up and Running Series': SPSS 36

SPSS Statistics Descriptives Ann Arbor ASA 'Up and Running Series': SPSS 37

SPSS Statistics Correlate • Compute Pearson Correlation Coefficients • Analyze Correlate Bivariate Ann Arbor ASA 'Up and Running Series': SPSS 38

SPSS Statistics Correlate Ann Arbor ASA 'Up and Running Series': SPSS 39

SPSS Statistics Regression • Run a regression – Use options to save residuals and predicted values in an output dataset – Include a residual plot • Analyze Regression Linear Ann Arbor ASA 'Up and Running Series': SPSS 40

SPSS Statistics Regression Ann Arbor ASA 'Up and Running Series': SPSS 41

SPSS Statistics Regression • • Assess normality of residuals stored in the output dataset Linear Regression Plots – – • DEPENDNT X: *SRESD Y: Produce all partial plots Standardized Residual Plots: Normal probability plot Continue Ann Arbor ASA 'Up and Running Series': SPSS 42

SPSS Statistics Regression Ann Arbor ASA 'Up and Running Series': SPSS 43

SPSS Statistics Regression Ann Arbor ASA 'Up and Running Series': SPSS 44

SPSS Syntax Overview • Text file written in command language – Save tasks – Automate tasks – Modify as required • Syntax window – Existing: File Open Syntax – New: File New Syntax • Build syntax file – Paste command syntax from dialog boxes – Copy syntax from the output log, or notes Ann Arbor ASA 'Up and Running Series': SPSS 45

SPSS Syntax • File Open Syntax Ann Arbor ASA 'Up and Running Series': SPSS 46

SPSS Syntax From Dialog Boxes • Analyze Descriptives Crosstabs …. Paste Ann Arbor ASA 'Up and Running Series': SPSS 47

SPSS Syntax From Dialog Boxes • File Open Syntax Ann Arbor ASA 'Up and Running Series': SPSS 48

SPSS Syntax From Output Viewer ‘Notes’ • SPSS PASW Viewer double click on Notes to expand block click once on desired text Edit Copy Ann Arbor ASA 'Up and Running Series': SPSS 49

SPSS Syntax From Output Viewer ‘Notes’ • Select all the syntax statement, including the period Ann Arbor ASA 'Up and Running Series': SPSS 50

SPSS Syntax From the Output Viewer ‘Notes’ • File New Syntax • Paste syntax from SPSS PASW Viewer Ann Arbor ASA 'Up and Running Series': SPSS 51

Questions Ann Arbor ASA 'Up and Running Series': SPSS 52

Resources Training from CSCAR http: //www. umich. edu/~cscar/ • • • • Statistics: A Review Introduction to SAS Introduction to SPSS Statistical Analysis with R Regression Topics in SPSS: Data Management and Macros, and Advanced Statistical Models Randomized Controlled Trials: Scientific and Ethical Principles Data Visualization Using Tableau Public Software 6. 0 Introduction to Programming in Stata Using Arc. GIS Application of Hierarchical Linear Models Introduction to NVivo Exploring Spatial Statistics in GIS Text Mining with Common Digital Documents Ann Arbor ASA 'Up and Running Series': SPSS 53

Resources • SPSS Students Support: – http: //support. spss. com/new. Support/Studentdefault. asp • UCLA: – http: //www. ats. ucla. edu/stat/spss/ • Texas A&M: – http: //www. stat. tamu. edu/spss. php • Harvard/MIT: – http: //data. fas. harvard. edu/projects/SPSS_Tutorial/spsstut. shtml Ann Arbor ASA 'Up and Running Series': SPSS 54

Resources Ann Arbor ASA Workshops @ Angell Hall, Computer Lab D, from 7 -9 PM (also known as Mason 444 -D) • • • JMP R SAS Stata Statistics with Excel MS Access Ann Arbor ASA 'Up and Running Series': SPSS 55