Sample Segmenting for The Effects of Animal-Free Food Technologies on Animal Farming Attitudes

	A	B	C	D	E	G	H	I	J	K	L	M
1	Gender	Age	Population	Percent	Sample you need	Eligible Positly participants	Projected cost	Passed checks	Number short	Percentage short	Number to add	Projected cost of additions
2	Male	15 - 24	21236420	7.98%	120	918	$202.80	96	24	19.8	28	$47.32
3	Male	25 - 44	42726819	16.05%	241	6325	$407.29	209	32	13.2	36	$60.84
4	Male	45 - 64	41255482	15.49%	232	1659	$392.08	206	26	11.4	29	$49.01
5	Male	65+	25792172	9.69%	145	240	$245.05	115	30	20.8	37	$62.53
6	Female	15 - 24	21927035	8.23%	124	970	$209.56	92	32	25.5	40	$67.60
7	Female	25 - 44	44116309	16.57%	249	7769	$420.81	217	32	12.7	36	$60.84
8	Female	45 - 64	42597124	16.00%	240	3138	$405.60	214	26	10.8	29	$49.01
9	Female	65+	26630942	10.00%	150	463	$253.50	145	5	3.3	5	$8.45
10	TOTAL	-	266282303	100.00%	1500	21482	$2,536.69	1294	206	13.7	239	$405.60
11
12		SAMPLE SIZE:	1500
13
14		INPUT THE TARGET POPULATION BY GENDER AND AGE GROUPS HERE:
15
16			161,118,151	males total	0.492
17			166,049,288	females total	0.508
18
19			43163455	15 - 24 total	0.1620965964
20			86843128	25 - 44 total	0.3261318046
21			83852606	45 - 64 total	0.3149011596
22			52423114	65+ total	0.1968704394
23
24	US population data is from "2018: American Community Survey 1-Year Estimates Data Profile," United States Census Bureau, accessed January 29, 2020, https://data.census.gov/cedsci/table?q=United%20States&table=DP05&tid=ACSDP1Y2018.DP05&g=&lastDisplayedRow=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