ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Randomization SetupNumber of groupsNotes
2
5You have to "Copy and paste" the group assignment in order preserve group assignments in Google Sheets. If you're using software, you can preserve assignments by setting the randomization "seed" before doing the random assignment
3
Full sample mean2.83Average of column C below for the full population
4
Random subsample mean3.20Average of column C below for group 1
5
Mean Difference-0.37Difference in means
6
7
8
9
10
11
12
Employee EmailGroup AssignmentSample Question Value
13
employee3@companyname.com43
14
employee4@companyname.com54
15
employee5@companyname.com55
16
employee6@companyname.com31
17
employee7@companyname.com13
18
employee8@companyname.com44
19
employee9@companyname.com52
20
employee10@companyname.com44
21
employee11@companyname.com55
22
employee12@companyname.com31
23
employee13@companyname.com15
24
employee14@companyname.com53
25
employee15@companyname.com42
26
employee16@companyname.com33
27
employee17@companyname.com35
28
employee18@companyname.com51
29
employee19@companyname.com55
30
employee20@companyname.com33
31
employee21@companyname.com21
32
employee22@companyname.com22
33
employee23@companyname.com42
34
employee24@companyname.com44
35
employee25@companyname.com25
36
employee26@companyname.com22
37
employee27@companyname.com42
38
employee28@companyname.com52
39
employee29@companyname.com33
40
employee30@companyname.com32
41
employee31@companyname.com42
42
employee32@companyname.com33
43
employee33@companyname.com55
44
employee34@companyname.com12
45
employee35@companyname.com15
46
employee36@companyname.com33
47
employee37@companyname.com35
48
employee38@companyname.com44
49
employee39@companyname.com51
50
employee40@companyname.com12
51
employee41@companyname.com33
52
employee42@companyname.com51
53
employee43@companyname.com14
54
employee44@companyname.com42
55
employee45@companyname.com31
56
employee46@companyname.com21
57
employee47@companyname.com55
58
employee48@companyname.com53
59
employee49@companyname.com51
60
employee50@companyname.com51
61
employee51@companyname.com42
62
employee52@companyname.com11
63
employee53@companyname.com42
64
employee54@companyname.com35
65
employee55@companyname.com21
66
employee56@companyname.com54
67
employee57@companyname.com12
68
employee58@companyname.com41
69
employee59@companyname.com41
70
employee60@companyname.com41
71
employee61@companyname.com23
72
employee62@companyname.com24
73
employee63@companyname.com44
74
employee64@companyname.com15
75
employee65@companyname.com54
76
employee66@companyname.com51
77
employee67@companyname.com51
78
employee68@companyname.com54
79
employee69@companyname.com13
80
employee70@companyname.com35
81
employee71@companyname.com15
82
employee72@companyname.com41
83
employee73@companyname.com22
84
employee74@companyname.com31
85
employee75@companyname.com14
86
employee76@companyname.com13
87
employee77@companyname.com55
88
employee78@companyname.com13
89
employee79@companyname.com52
90
employee80@companyname.com34
91
employee81@companyname.com43
92
employee82@companyname.com11
93
employee83@companyname.com54
94
employee84@companyname.com14
95
employee85@companyname.com41
96
employee86@companyname.com24
97
employee87@companyname.com42
98
employee88@companyname.com51
99
employee89@companyname.com54
100
employee90@companyname.com41