SAMPLE sample size and budget.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	RAW DATA									PERCENTAGES
2	STATE	SEX	STATE ALL	State (18-25)	State (26-35)	State (36-45)	State (46-55)	State (55+)		STATE	SEX	18-25	26-35	36-45	46-55	55+	ALL
3	Arizona	All	5,752,015	813,862	1,004,109	913,752	848,020	2,172,272
4	Arizona	female	2,851,859	417,711	519,209	468,349	425,806	1,020,784		Arizona	female	0.34%	0.42%	0.38%	0.35%	0.83%	4.70%
5	Arizona	male	2,900,156	396,151	484,900	445,403	422,214	1,151,488		Arizona	male	0.32%	0.40%	0.36%	0.35%	0.94%	4.70%
6	California	All	30,380,758	4,130,206	5,736,715	5,292,722	4,846,409	10,374,706
7	California	female	15,059,616	2,097,730	2,946,241	2,711,516	2,449,728	4,854,401		California	female	1.72%	2.41%	2.22%	2.00%	3.97%	24.85%
8	California	male	15,321,142	2,032,476	2,790,474	2,581,206	2,396,681	5,520,305		California	male	1.66%	2.28%	2.11%	1.96%	4.51%	24.85%
9	Florida	All	17,887,513	2,089,929	2,800,836	2,754,455	2,737,293	7,505,000
10	Florida	female	8,699,282	1,059,007	1,419,337	1,384,373	1,360,345	3,476,220		Florida	female	0.87%	1.16%	1.13%	1.11%	2.84%	14.63%
11	Florida	male	9,188,231	1,030,922	1,381,499	1,370,082	1,376,948	4,028,780		Florida	male	0.84%	1.13%	1.12%	1.13%	3.29%	14.63%
12	Georgia	All	8,345,670	1,187,747	1,489,008	1,427,321	1,394,478	2,847,116
13	Georgia	female	4,002,564	595,493	729,711	692,312	683,205	1,301,843		Georgia	female	0.49%	0.60%	0.57%	0.56%	1.06%	6.83%
14	Georgia	male	4,343,106	592,254	759,297	735,009	711,273	1,545,273		Georgia	male	0.48%	0.62%	0.60%	0.58%	1.26%	6.83%
15	Illinois	All	9,843,344	1,322,908	1,695,432	1,654,396	1,555,192	3,615,416
16	Illinois	female	4,823,994	674,116	858,003	836,530	781,521	1,673,824		Illinois	female	0.55%	0.70%	0.68%	0.64%	1.37%	8.05%
17	Illinois	male	5,019,350	648,792	837,429	817,866	773,671	1,941,592		Illinois	male	0.53%	0.68%	0.67%	0.63%	1.59%	8.05%
18	Minnesota	All	4,422,386	584,840	747,291	762,155	659,171	1,668,929
19	Minnesota	female	2,208,536	298,294	384,024	391,617	338,126	796,475		Minnesota	female	0.24%	0.31%	0.32%	0.28%	0.65%	3.62%
20	Minnesota	male	2,213,850	286,546	363,267	370,538	321,045	872,454		Minnesota	male	0.23%	0.30%	0.30%	0.26%	0.71%	3.62%
21	New York	All	15,667,902	2,054,762	2,769,697	2,492,713	2,419,697	5,931,033
22	New York	female	7,565,510	1,026,448	1,388,463	1,246,396	1,195,060	2,709,143		New York	female	0.84%	1.14%	1.02%	0.98%	2.22%	12.81%
23	New York	male	8,102,392	1,028,314	1,381,234	1,246,317	1,224,637	3,221,890		New York	male	0.84%	1.13%	1.02%	1.00%	2.64%	12.81%
24	Texas	All	22,458,530	3,397,504	4,304,050	4,137,241	3,622,544	6,997,191
25	Texas	female	11,117,888	1,732,933	2,187,106	2,100,323	1,823,219	3,274,307		Texas	female	1.42%	1.79%	1.72%	1.49%	2.68%	18.37%
26	Texas	male	11,340,642	1,664,571	2,116,944	2,036,918	1,799,325	3,722,884		Texas	male	1.36%	1.73%	1.67%	1.47%	3.04%	18.37%
27	Washington	All	6,089,273	763,705	1,171,857	1,080,052	921,511	2,152,148
28	Washington	female	3,042,999	392,332	605,317	554,878	470,729	1,019,743		Washington	female	0.32%	0.50%	0.45%	0.38%	0.83%	4.98%
29	Washington	male	3,046,274	371,373	566,540	525,174	450,782	1,132,405		Washington	male	0.30%	0.46%	0.43%	0.37%	0.93%	4.98%
30	West Virginia	All	1,423,055	180,662	211,943	212,549	223,537	594,364
31	West Virginia	female	705,625	93,995	109,920	108,195	113,824	279,691		West Virginia	female	0.08%	0.09%	0.09%	0.09%	0.23%	1.16%
32	West Virginia	male	717,430	86,667	102,023	104,354	109,713	314,673		West Virginia	male	0.07%	0.08%	0.09%	0.09%	0.26%	1.16%
33	ALL STATES		122,270,446							ALL STATES							100.00%
34	OBTAINED FROM CENSUS
35	https://www.census.gov/data/tables/time-series/demo/popest/2020s-state-detail.html
36
37	TABLE 1. SAMPLE: USE THE TABLE BELOW										TABLE 2. BUDGET: USE THE TABLE BELOW
38	PUT YOUR SAMPLE SIZE HERE:		7037
39											BUDGET TABLE
40	STATE	SEX	18-25	26-35	36-45	46-55	55+	ALL1	ALL2		Put the total value of a single questionnaire on the cell of M45
41	Arizona	female	24	30	27	25	59	164	331
42	Arizona	male	23	28	26	24	66	167	331				Unit	Total
43											1	Training for Researchers	10	$50,000.00
44	California	female	121	170	156	141	279	867	1748		2	Sample Size	7037
45	California	male	117	161	149	138	318	882	1748		3	Questionnaire Price	$135.00	$949,995.00
46												Total		$999,995.00
47	Florida	female	61	82	80	78	200	501	1029
48	Florida	male	59	80	79	79	232	529	1029
49
50	Georgia	female	34	42	40	39	75	230	480
51	Georgia	male	34	44	42	41	89	250	480		EXAMPLE
52													Unit	Total
53	Illinois	female	39	49	48	45	96	278	567		1	Training for Researchers	10	$50,000.00
54	Illinois	male	37	48	47	45	112	289	567		2	Sample Size	7037
55											3	Questionnaire Price	135	$949,995.00
56	Minnesota	female	17	22	23	19	46	127	255			Total		$999,995.00
57	Minnesota	male	16	21	21	18	50	127	255
58
59	New York	female	59	80	72	69	156	435	902
60	New York	male	59	79	72	70	185	466	902
61
62	Texas	female	100	126	121	105	188	640	1293
63	Texas	male	96	122	117	104	214	653	1293
64
65	Washington	female	23	35	32	27	59	175	350
66	Washington	male	21	33	30	26	65	175	350
67
68	West Virginia	female	5	6	6	7	16	41	82
69	West Virginia	male	5	6	6	6	18	41	82
70	TOTAL		951	1262	1193	1107	2524		7037
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