Overzicht handelingen SPSS en Excel Beschrijvende statistiek (SOW-MTB1002)

Handelingen in SPSS
Boxplot
Analyze  Descriptive Statistics  Explore  Paste  Run
Syntax:
EXAMINE VARIABLES=VariabeleX
/PLOT BOXPLOT STEMLEAF
/COMPARE GROUPS
/STATISTICS DESCRIPTIVES
/CINTERVAL 95
/MISSING LISTWISE
/NOTOTAL.
Of
Graphs  Legacy dialogue  Boxplot  Simple  Summaries of separate variables 
Variabele in ‘boxes represent’ zetten  Paste  Run
Syntax:
EXAMINE VARIABLES=VariabeleX
/COMPARE VARIABLE
/PLOT=BOXPLOT
/STATISTICS=NONE
/NOTOTAL
/MISSING=LISTWISE.

Centrummaten
Analyze  Descriptive statistics  Frequencies  Variabele selecteren  Statistics 
Median, mean & mode aanklikken  Continue  Paste  Run
Syntax:
FREQUENCIES VARIABLES=VariabeleX
/STATISTICS=MEAN MEDIAN MODE
/ORDER=ANALYSIS.

Chi-kwadraat:
Analyze  Descriptive statistics  Crosstabs  Rij variabele selecteren, kolom variabele
selecteren  Statistics  Chi-square aanklikken  Continue  Cells  Expected
aanklikken  Paste  Run
Daarna handmatig count en expected count vergelijken
Syntax:
CROSSTABS
/TABLES=VariabeleY BY VariabeleX
/FORMAT=AVALUE TABLES
/STATISTICS=CHISQ
/CELLS=COUNT EXPECTED COLUMN
/COUNT ROUND CELL.




1

, Cirkeldiagram
Graphs  Legacy dialogs  Pie  Summaries for groups of cases  Define  Variabele in
define slices by  Paste  Run
Syntax:
GRAPH
/PIE=COUNT BY VariabeleX.

Cohen’s d
Analyze  Compare means  Independent samples T test  Test variable is de
afhankelijke variabele (Y) en Grouping variable is onafhankelijke variabele (X) ( Als er een
vraagteken komt te staan  Define groups  Continue)  Estimate effect sizes aangevinkt
laten  Paste  Run
Syntax:
T-TEST GROUPS=VariabeleX(1 2)
/MISSING=ANALYSIS
/VARIABLES=V0033
/ES DISPLAY(TRUE)
/CRITERIA=CI(.95).

Cramér’s V
Analyze  Descriptive statistics  Crosstabs  Rij variabele selecteren, kolom variabele
selecteren  Statistics  Phi and Cramér’s V aanklikken  Paste  Run
Syntax:
CROSSTABS
/TABLES=VariabeleY BY VariabeleX
/FORMAT=AVALUE TABLES
/STATISTICS=PHI
/CELLS=COUNT COLUMN
/COUNT ROUND CELL.

Enkelvoudige regressieanalyse
Analyze  Regression  Lineair  Variabelen selecteren  Paste  Run
Syntax:
REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT VariabeleY
/METHOD=ENTER VariabeleX.




2