Mental Health Interventions Impact Analysis Toolkit - Accompanying Spreadsheet

	A	B	C	D	E	F	G	H	I	J
1	Effect Size for Dataset 1 and Dataset 2		Dataset 1 / control	Z score / SD	Percentile	Dataset 2 / intervention	Z score / SD	Percentile
2	Hedge's g	0.9244764126	36	-2.423687347	0	34	-2.933937315	0
3	Cohen's d	0.929133754	37	-2.168562363	0.01	35	-2.678812331	0.01
4	Glass's ∆	0.8521174461	38	-1.913437379	0.02	36	-2.423687347	0.02
5	Summary Statistics Dataset 1		38	-1.913437379	0.02	36	-2.423687347	0.02	Summary Statistics Dataset 2
6	Mean	45.5	39	-1.658312395	0.04	37	-2.168562363	0.04	Mean	42.16
7	Standard Deviation	3.91964748	39	-1.658312395	0.04	37	-2.168562363	0.04	Standard Deviation	3.277471309
8	Median	45.5	40	-1.403187411	0.061	38	-1.913437379	0.061	Median	42.5
9	Mode	45	40	-1.403187411	0.061	38	-1.913437379	0.061	Mode	43
10	Sample Size	100	40	-1.403187411	0.061	38	-1.913437379	0.061	Sample Size	100
11	variance	15.36363636	40	-1.403187411	0.061	38	-1.913437379	0.061	variance	10.74181818
12	Try adding your data to Dataset 1 and 2 ->		41	-1.148062427	0.101	38	-1.913437379	0.061
13			41	-1.148062427	0.101	38	-1.913437379	0.061
14	Which scores correspond to 0,1, 2, and 3 SDs?		41	-1.148062427	0.101	38	-1.913437379	0.061	Which scores correspond to 0,1, 2, and 3 SDs?
15	Z score SD	Hypothetical data	41	-1.148062427	0.101	38	-1.913437379	0.061	Z score (SD)	Hypothetical data
16	-3	33.74105756	41	-1.148062427	0.101	38	-1.913437379	0.061	-3	33.74105756
17	-2	37.66070504	41	-1.148062427	0.101	38	-1.913437379	0.061	-2	37.66070504
18	-1	41.58035252	42	-0.8929374436	0.162	39	-1.658312395	0.162	-1	41.58035252
19	0	45.5	42	-0.8929374436	0.162	39	-1.658312395	0.162	0	45.5
20	1	49.41964748	42	-0.8929374436	0.162	39	-1.658312395	0.162	1	49.41964748
21	2	53.33929496	42	-0.8929374436	0.162	39	-1.658312395	0.162	2	53.33929496
22	3	57.25894244	42	-0.8929374436	0.162	39	-1.658312395	0.162	3	57.25894244
23			42	-0.8929374436	0.162	39	-1.658312395	0.162
24			42	-0.8929374436	0.162	39	-1.658312395	0.162
25			43	-0.6378124597	0.232	40	-1.403187411	0.232
26			43	-0.6378124597	0.232	40	-1.403187411	0.232
27			43	-0.6378124597	0.232	40	-1.403187411	0.232
28			43	-0.6378124597	0.232	40	-1.403187411	0.232
29			43	-0.6378124597	0.232	40	-1.403187411	0.232
30			43	-0.6378124597	0.232	40	-1.403187411	0.232
31			43	-0.6378124597	0.232	40	-1.403187411	0.232
32			43	-0.6378124597	0.232	40	-1.403187411	0.232
33			44	-0.3826874758	0.313	41	-1.148062427	0.313
34			44	-0.3826874758	0.313	41	-1.148062427	0.313
35			44	-0.3826874758	0.313	41	-1.148062427	0.313
36			44	-0.3826874758	0.313	41	-1.148062427	0.313
37			44	-0.3826874758	0.313	41	-1.148062427	0.313
38			44	-0.3826874758	0.313	41	-1.148062427	0.313
39			44	-0.3826874758	0.313	41	-1.148062427	0.313
40			44	-0.3826874758	0.313	41	-1.148062427	0.313
41			44	-0.3826874758	0.313	41	-1.148062427	0.313
42			45	-0.1275624919	0.404	42	-0.8929374436	0.404
43			45	-0.1275624919	0.404	42	-0.8929374436	0.404
44			45	-0.1275624919	0.404	42	-0.8929374436	0.404
45			45	-0.1275624919	0.404	42	-0.8929374436	0.404
46			45	-0.1275624919	0.404	42	-0.8929374436	0.404
47			45	-0.1275624919	0.404	42	-0.8929374436	0.404
48			45	-0.1275624919	0.404	42	-0.8929374436	0.404
49			45	-0.1275624919	0.404	42	-0.8929374436	0.404
50			45	-0.1275624919	0.404	42	-0.8929374436	0.404
51			45	-0.1275624919	0.404	42	-0.8929374436	0.404
52			46	0.1275624919	0.505	43	-0.6378124597	0.505
53			46	0.1275624919	0.505	43	-0.6378124597	0.505
54			46	0.1275624919	0.505	43	-0.6378124597	0.505
55			46	0.1275624919	0.505	43	-0.6378124597	0.505
56			46	0.1275624919	0.505	43	-0.6378124597	0.505
57			46	0.1275624919	0.505	43	-0.6378124597	0.505
58			46	0.1275624919	0.505	43	-0.6378124597	0.505
59			46	0.1275624919	0.505	43	-0.6378124597	0.505
60			46	0.1275624919	0.505	43	-0.6378124597	0.505
61			46	0.1275624919	0.505	43	-0.6378124597	0.505
62			47	0.3826874758	0.606	43	-0.6378124597	0.505
63			47	0.3826874758	0.606	43	-0.6378124597	0.505
64			47	0.3826874758	0.606	43	-0.6378124597	0.505
65			47	0.3826874758	0.606	43	-0.6378124597	0.505
66			47	0.3826874758	0.606	43	-0.6378124597	0.505
67			47	0.3826874758	0.606	43	-0.6378124597	0.505
68			47	0.3826874758	0.606	43	-0.6378124597	0.505
69			47	0.3826874758	0.606	43	-0.6378124597	0.505
70			47	0.3826874758	0.606	43	-0.6378124597	0.505
71			48	0.6378124597	0.697	44	-0.3826874758	0.697
72			48	0.6378124597	0.697	44	-0.3826874758	0.697
73			48	0.6378124597	0.697	44	-0.3826874758	0.697
74			48	0.6378124597	0.697	44	-0.3826874758	0.697
75			48	0.6378124597	0.697	44	-0.3826874758	0.697
76			48	0.6378124597	0.697	44	-0.3826874758	0.697
77			48	0.6378124597	0.697	44	-0.3826874758	0.697
78			48	0.6378124597	0.697	44	-0.3826874758	0.697
79			49	0.8929374436	0.778	45	-0.1275624919	0.778
80			49	0.8929374436	0.778	45	-0.1275624919	0.778
81			49	0.8929374436	0.778	45	-0.1275624919	0.778
82			49	0.8929374436	0.778	45	-0.1275624919	0.778
83			49	0.8929374436	0.778	45	-0.1275624919	0.778
84			49	0.8929374436	0.778	45	-0.1275624919	0.778
85			49	0.8929374436	0.778	45	-0.1275624919	0.778
86			50	1.148062427	0.848	46	0.1275624919	0.848
87			50	1.148062427	0.848	46	0.1275624919	0.848
88			50	1.148062427	0.848	46	0.1275624919	0.848
89			50	1.148062427	0.848	46	0.1275624919	0.848
90			50	1.148062427	0.848	46	0.1275624919	0.848
91			50	1.148062427	0.848	46	0.1275624919	0.848
92			51	1.403187411	0.909	47	0.3826874758	0.909
93			51	1.403187411	0.909	47	0.3826874758	0.909
94			51	1.403187411	0.909	47	0.3826874758	0.909
95			51	1.403187411	0.909	47	0.3826874758	0.909
96			52	1.658312395	0.949	48	0.6378124597	0.949
97			52	1.658312395	0.949	48	0.6378124597	0.949
98			53	1.913437379	0.97	48	0.6378124597	0.949
99			53	1.913437379	0.97	48	0.6378124597	0.949
100			54	2.168562363	0.99	49	0.8929374436	0.99