Z.TEST - Google Drive

Z.TEST : General Usage


1	Sample Data
2	97
3	90
4	88
5	92
6	87
7	83
8	90
9	89
10	94
11	80
12
13
14	Average	Formula
15	89	=AVERAGE(A2:A11)
16
17
18	Result	Formula
19	0.2621554004	=Z.TEST(A2:A11, 88)
20	0.7378445996	=Z.TEST(A2:A11, 90)
21
22
23	Result	Formula
24	0.5243108009	=2*MIN(Z.TEST(A2:A11, 88), 1-Z.TEST(A2:A11, 88))
25	0.5243108009	=2*MIN(Z.TEST(A2:A11, 90), 1-Z.TEST(A2:A11, 90))
26
27
28	Result	Formula
29	0.2635446284	=Z.TEST(A2:A11, 88, 5)
30	0.7364553716	=Z.TEST(A2:A11, 90, 5)
31
32
33	Result	Formula
34	0.5270892569	=2*MIN(Z.TEST(A2:A11, 88, 5), 1-Z.TEST(A2:A11, 88, 5))
35	0.5270892569	=2*MIN(Z.TEST(A2:A11, 90, 5), 1-Z.TEST(A2:A11, 90, 5))
36

Published by Google Sheets–Report Abuse–Updated automatically every 5 minutes