Statistiek
Samenvatting Dictaat Deel B: Statistiek 2 met Excel
Dominique ter Maat 15-06-2016
Bij elke toets staat het “stappenplan” per toets uitgewerkt. In elk stappenplan wordt er vanuit gegaan dat
alle gegeven waarden in Excel in een tabel genoteerd worden voordat de toets daadwerkelijk uit wordt
gevoerd.
12
,Inhoudsopgav
Stappenplan...........................................................................................................................................5
One-sample-t-toets................................................................................................................................6
1-zijdig-1-sample-t..........................................................................................................................6
2-zijdig-1-sample-t..........................................................................................................................6
F-toets, Two-sample-t en Welch-toets...................................................................................................7
F-toets............................................................................................................................................7
1-zijdig-2-sample-t..........................................................................................................................7
2-zijdig-2-sample-t..........................................................................................................................8
1-zijdig-Welch-t..............................................................................................................................8
2-zijdig-Welch-t..............................................................................................................................8
Gepaarde-t en ANOVA-toetsen..............................................................................................................9
1-zijdig-gepaarde-t..........................................................................................................................9
2-zijdig-gepaarde-t..........................................................................................................................9
1-way-ANOVA...............................................................................................................................10
LSD-toets in Excel..........................................................................................................................10
1-way ANOVA in SPSS ..................................................................................................................11
2-way ANOVA in SPSS ..................................................................................................................12
Levene’s test.................................................................................................................................13
ANCOVA........................................................................................................................................13
Blocked ANOVA............................................................................................................................14
Latin Square ANOVA.....................................................................................................................15
Methoden vergelijking (ANOVA)..................................................................................................16
1-way-Chi en 2-way-Chi........................................................................................................................17
1-way-Chi......................................................................................................................................17
2-way-Chi......................................................................................................................................17
Post-hoc toets...............................................................................................................................18
McNemar’s chi-kwadraat toets....................................................................................................18
Cohen’s kappa..............................................................................................................................19
Cramer’s-......................................................................................................................................19
Grubbs’ en Dixon’s-toets......................................................................................................................20
Grubbs’-toets................................................................................................................................20
Dixon’s-toets.................................................................................................................................21
12
One-sample-z-toets en Two-sample-z-toets.........................................................................................22
, One-sample-z-toets......................................................................................................................22
Two-sample-z-toets......................................................................................................................23
Regressie..............................................................................................................................................23
Regressie......................................................................................................................................23
Kalibratiecurve..............................................................................................................................24
Standaard additie.........................................................................................................................25
Detectie limiet..............................................................................................................................25
Methoden vergelijking (Regressie)...............................................................................................25
Uitbijters.......................................................................................................................................26
Multiple regressie.........................................................................................................................26
Niet lineaire regressie...................................................................................................................27
Bijzonderheden....................................................................................................................................27
Stappenplan...........................................................................................................................................4
One-sample-t-toets................................................................................................................................5
1-zijdig-1-sample-t..........................................................................................................................5
2-zijdig-1-sample-t..........................................................................................................................5
F-toets, Two-sample-t en Welch-toets...................................................................................................6
F-toets............................................................................................................................................6
1-zijdig-2-sample-t..........................................................................................................................6
2-zijdig-2-sample-t..........................................................................................................................6
1-zijdig-Welch-t..............................................................................................................................7
2-zijdig-Welch-t..............................................................................................................................7
Gepaarde-t en ANOVA-toetsen..............................................................................................................8
1-zijdig-gepaarde-t.........................................................................................................................8
2-zijdig-gepaarde-t.........................................................................................................................8
1-way-ANOVA.................................................................................................................................8
LSD-toets in Excel...........................................................................................................................9
1-way ANOVA in SPSS...................................................................................................................9
2-way ANOVA in SPSS.................................................................................................................10
Levene’s test.................................................................................................................................11
ANCOVA.......................................................................................................................................11
Blocked ANOVA............................................................................................................................12
Latin Square ANOVA.....................................................................................................................13
Methoden vergelijking (ANOVA)..................................................................................................14
12
1-way-Chi en 2-way-Chi........................................................................................................................15
1-way-Chi......................................................................................................................................15
Samenvatting Dictaat Deel B: Statistiek 2 met Excel
Dominique ter Maat 15-06-2016
Bij elke toets staat het “stappenplan” per toets uitgewerkt. In elk stappenplan wordt er vanuit gegaan dat
alle gegeven waarden in Excel in een tabel genoteerd worden voordat de toets daadwerkelijk uit wordt
gevoerd.
12
,Inhoudsopgav
Stappenplan...........................................................................................................................................5
One-sample-t-toets................................................................................................................................6
1-zijdig-1-sample-t..........................................................................................................................6
2-zijdig-1-sample-t..........................................................................................................................6
F-toets, Two-sample-t en Welch-toets...................................................................................................7
F-toets............................................................................................................................................7
1-zijdig-2-sample-t..........................................................................................................................7
2-zijdig-2-sample-t..........................................................................................................................8
1-zijdig-Welch-t..............................................................................................................................8
2-zijdig-Welch-t..............................................................................................................................8
Gepaarde-t en ANOVA-toetsen..............................................................................................................9
1-zijdig-gepaarde-t..........................................................................................................................9
2-zijdig-gepaarde-t..........................................................................................................................9
1-way-ANOVA...............................................................................................................................10
LSD-toets in Excel..........................................................................................................................10
1-way ANOVA in SPSS ..................................................................................................................11
2-way ANOVA in SPSS ..................................................................................................................12
Levene’s test.................................................................................................................................13
ANCOVA........................................................................................................................................13
Blocked ANOVA............................................................................................................................14
Latin Square ANOVA.....................................................................................................................15
Methoden vergelijking (ANOVA)..................................................................................................16
1-way-Chi en 2-way-Chi........................................................................................................................17
1-way-Chi......................................................................................................................................17
2-way-Chi......................................................................................................................................17
Post-hoc toets...............................................................................................................................18
McNemar’s chi-kwadraat toets....................................................................................................18
Cohen’s kappa..............................................................................................................................19
Cramer’s-......................................................................................................................................19
Grubbs’ en Dixon’s-toets......................................................................................................................20
Grubbs’-toets................................................................................................................................20
Dixon’s-toets.................................................................................................................................21
12
One-sample-z-toets en Two-sample-z-toets.........................................................................................22
, One-sample-z-toets......................................................................................................................22
Two-sample-z-toets......................................................................................................................23
Regressie..............................................................................................................................................23
Regressie......................................................................................................................................23
Kalibratiecurve..............................................................................................................................24
Standaard additie.........................................................................................................................25
Detectie limiet..............................................................................................................................25
Methoden vergelijking (Regressie)...............................................................................................25
Uitbijters.......................................................................................................................................26
Multiple regressie.........................................................................................................................26
Niet lineaire regressie...................................................................................................................27
Bijzonderheden....................................................................................................................................27
Stappenplan...........................................................................................................................................4
One-sample-t-toets................................................................................................................................5
1-zijdig-1-sample-t..........................................................................................................................5
2-zijdig-1-sample-t..........................................................................................................................5
F-toets, Two-sample-t en Welch-toets...................................................................................................6
F-toets............................................................................................................................................6
1-zijdig-2-sample-t..........................................................................................................................6
2-zijdig-2-sample-t..........................................................................................................................6
1-zijdig-Welch-t..............................................................................................................................7
2-zijdig-Welch-t..............................................................................................................................7
Gepaarde-t en ANOVA-toetsen..............................................................................................................8
1-zijdig-gepaarde-t.........................................................................................................................8
2-zijdig-gepaarde-t.........................................................................................................................8
1-way-ANOVA.................................................................................................................................8
LSD-toets in Excel...........................................................................................................................9
1-way ANOVA in SPSS...................................................................................................................9
2-way ANOVA in SPSS.................................................................................................................10
Levene’s test.................................................................................................................................11
ANCOVA.......................................................................................................................................11
Blocked ANOVA............................................................................................................................12
Latin Square ANOVA.....................................................................................................................13
Methoden vergelijking (ANOVA)..................................................................................................14
12
1-way-Chi en 2-way-Chi........................................................................................................................15
1-way-Chi......................................................................................................................................15
