power demo-t test.xlsx

	B	C	D	E	F	G	H	I	J	L	M	O	P	Q	T	U	W
1			ab units
2	group	n	mean	SD	SEM							null t	null	alt-non null	x	y	Power curve demo
3	A	23	20.0	6.0	1.25		power t	0.811				-4.0	0.00036959	0.00000003	2.02	0.0
4	B	23	25.0	6.0	1.25		power	78.9%				-3.9	0.00049801	0.00000005	2.02	0.45
5												-3.8	0.00066857	0.00000007
6	difference=delta		5.0		1.77							-3.7	0.00089406	0.00000010
7	df	44						alpha	t	t > 2	p < 0.05	-3.6	0.00119070	0.00000014
8	delta (obs t) - >		2.83			critical values ->		0.05	2.02		p < 0.025	-3.5	0.00157896	0.00000019
9	p value		0.0071									-3.4	0.00208438	0.00000027
10												-3.3	0.00273861	0.00000037
11												-3.2	0.00358043	0.00000052
12												-3.1	0.00465690	0.00000073
13												-3.0	0.00602450	0.00000103
14												-2.9	0.00775014	0.00000144
15												-2.8	0.00991210	0.00000201
16												-2.7	0.01260063	0.00000280
17												-2.6	0.01591811	0.00000391
18												-2.5	0.01997866	0.00000545
19												-2.4	0.02490689	0.00000759
20												-2.3	0.03083575	0.00001054
21												-2.2	0.03790318	0.00001463
22												-2.1	0.04624753	0.00002026
23												-2.0	0.05600155	0.00002801
24												-1.9	0.06728509	0.00003863
25												-1.8	0.08019650	0.00005317
26												-1.7	0.09480313	0.00007301
27												-1.6	0.11113121	0.00010000
28												-1.5	0.12915578	0.00013659
29												-1.4	0.14879128	0.00018603
30												-1.3	0.16988376	0.00025259
31												-1.2	0.19220543	0.00034185
32												-1.1	0.21545249	0.00046106
33												-1.0	0.23924692	0.00061957
34												-0.9	0.26314291	0.00082938
35												-0.8	0.28663798	0.00110576
36												-0.7	0.30918882	0.00146799
37												-0.6	0.33023137	0.00194021
38												-0.5	0.34920402	0.00255237
39												-0.4	0.36557287	0.00334130
40												-0.3	0.37885733	0.00435180
41												-0.2	0.38865426	0.00563780
42												-0.1	0.39465910	0.00726340
43												0.0	0.39668218	0.00930386
44												0.1	0.39465910	0.01184628
45												0.2	0.38865426	0.01498991
46												0.3	0.37885733	0.01884589
47												0.4	0.36557287	0.02353629
48												0.5	0.34920402	0.02919214
49												0.6	0.33023137	0.03595050
50												0.7	0.30918882	0.04395012
51												0.8	0.28663798	0.05332585
52												0.9	0.26314291	0.06420168
53												1.0	0.23924692	0.07668242
54												1.1	0.21545249	0.09084442
55												1.2	0.19220543	0.10672559
56												1.3	0.16988376	0.12431519
57												1.4	0.14879128	0.14354424
58												1.5	0.12915578	0.16427718
59												1.6	0.11113121	0.18630576
60												1.7	0.09480313	0.20934590
61												1.8	0.08019650	0.23303845
62												1.9	0.06728509	0.25695433
63												2.0	0.05600155	0.28060442
64												2.1	0.04624753	0.30345426
65												2.2	0.03790318	0.32494304
66												2.3	0.03083575	0.34450615
67												2.4	0.02490689	0.36160002
68												2.5	0.01997866	0.37572781
69												2.6	0.01591811	0.38646407
70												2.7	0.01260063	0.39347685
71												2.8	0.00991210	0.39654539
72												2.9	0.00775014	0.39557213
73												3.0	0.00602450	0.39058808
74												3.1	0.00465690	0.38175110
75												3.2	0.00358043	0.36933727
76												3.3	0.00273861	0.35372598
77												3.4	0.00208438	0.33537994
78												3.5	0.00157896	0.31482165
79												3.6	0.00119070	0.29260797
80												3.7	0.00089406	0.26930468
81												3.8	0.00066857	0.24546254
82												3.9	0.00049801	0.22159635
83												4.0	0.00036959	0.19816792
84												4.1	0.00027333	0.17557365
85												4.2	0.00020147	0.15413698
86												4.3	0.00014804	0.13410538
87												4.4	0.00010846	0.11565158
88												4.5	0.00007925	0.09887822
89												4.6	0.00005775	0.08382514
90												4.7	0.00004198	0.07047846
91												4.8	0.00003045	0.05878053
92												4.9	0.00002204	0.04864009
93												5.0	0.00001592	0.03994202
94												5.1	0.00001148	0.03255615
95												5.2	0.00000827	0.02634496
96												5.3	0.00000594	0.02116991
97												5.4	0.00000427	0.01689638
98												5.5	0.00000306	0.01339734
99												5.6	0.00000219	0.01055579
100												5.7	0.00000157	0.00826624