Ad Hoc Average Power.xlsx

	A	B	C	D	E	F	G	H	I	J
1
2		Fill in the information for hypothesized paths below						Inputs		Outputs
3		Predictor	DV	t-stat	Z(1-Β)	Power
4	1	x1	m1	2.000	0.355	64%	4	Confidence	0.95
5	2	x2	m1	3.000	1.355	91%		One tailed?	Yes	Enter "Yes" for one-tailed test
6	3	x3	m1	2.000	0.355	64%		Critical z	1.644853625
7	4	x1	m2	1.000	-0.645	26%
8	5	x2	m2	2.000	0.355	64%		Notes
9	6	x3	m2	3.000	1.355	91%		This is ridiculously back-of-the envelope and last resort!
10	7	m1	y1	4.000	2.355	99%		Idea is that t = z(1-b) + z(a), so if you know t (and z(a) is trivial) then you can figure out z(1-b)
11	8	m2	y1	2.000	0.355	64%		Z(1-b) gives power through normal distribution
12	9	m1	y2	2.000	0.355	64%		Averaging out power can be a shorthand way to respond to reviewers
13	10	m2	y2	4.000	2.355	99%
14
15			Average Post-Hoc Power			73%
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100