State Rankings by the Need for Additional Homebrew Shops

How is the Homebrew Shop Need Index Calculated?

Homebrew Shop Need Index = (21 and up population/number of homebrew shops *50) + (per capita consumption in beer in gallons * 15) + (Average Internet Search Interest *35) / the highest figure (to get an index of 1.0 and lower)

Average Search Interest is calculated by Google Trend data as an average state ranking for the following homebrew related terms (Northern Brewer, Midwest Supplies, How to Brew, Home Brew Beer, Brew Beer). Northern Brewer and Midwest Supplies are selected as terms because they ranked the highest for online homebrew shop web traffic (assumption that those without access to a homebrew shop are buying online).

Per capita consumption and population numbers are from 2012 (the latest data I have).

Sources: American Homebrewers Association, Google Trends, Beer Institute

Full Data Set

Data Summary

State	# of Shops	Adjusted for 21 + Population (pop./shops)	Per Capita Consumption in Gallons	Average Internet Interest #	Homebrew Shop Need Index	Rank (in order of need)
Mississippi	3	701910	33.9	26.8	1.000	1
Maryland	7	614106	23.2	54.4	0.875	2
Arizona	8	582988	29.5	53.8	0.831	3
Alabama	6	582565	30.2	53.8	0.830	4
Louisiana	6	548852	33.9	42	0.782	5
Hawaii	2	518656	30.4	38	0.739	6
North Dakota	0	509226	45.8	10.6	0.725	7
Kansas	4	507842	28.3	51.8	0.724	8
Nevada	4	498886	35.8	33	0.711	9
District of Columbia	1	488490	28.3	49.6	0.696	10
Texas	39	459863	34.4	44	0.655	11
Utah	4	459068	20.2	48	0.654	12
California	61	444857	25.5	55.6	0.634	13
Georgia	16	437126	25.7	44	0.623	14
South Carolina	8	429966	32.7	41	0.613	15
Florida	35	416777	27.4	42	0.594	16
Tennessee	12	392013	26.2	42.8	0.559	17
Oklahoma	7	387712	28.3	50	0.552	18
Iowa	6	368217	33.6	52.2	0.525	19
Missouri	12	363573	31	55.2	0.518	20
New Jersey	18	360896	22.4	43.8	0.514	21
Arkansas	6	353261	26.7	43.2	0.503	22
New York	42	344666	22.4	42.6	0.491	23
Illinois	28	331001	29.1	52.8	0.472	24
Kentucky	10	318661	24.4	46.4	0.454	25
North Carolina	23	306438	27.1	50	0.437	26
Massachusetts	17	290155	26.2	60.6	0.413	27
Virginia	21	284831	26.7	42.2	0.406	28
Nebraska	5	261692	35.2	39.2	0.373	29
Minnesota	16	242398	28.5	55	0.345	30
Connecticut	11	239774	22.1	54.6	0.342	31
West Virginia	6	233173	30.3	32.8	0.332	32
Indiana	20	232629	25.9	54.4	0.331	33
New Mexico	7	211990	32.4	39.2	0.302	34
Wyoming	2	208517	33	13	0.297	35
Ohio	42	199913	30.1	54.8	0.285	36
South Dakota	3	197182	38.9	23.2	0.281	37
Michigan	39	184230	26.8	54.8	0.263	38
Wisconsin	24	173350	36.2	57	0.247	39
Washington	30	168055	24.8	67	0.239	40
Pennsylvania	59	160400	28.6	63.8	0.229	41
Idaho	7	157457	27.8	45.8	0.224	42
Vermont	3	156314	35.3	56	0.223	43
Maine	7	144331	34	50.2	0.206	44
Delaware	5	134389	33.6	44.8	0.192	45
Rhode Island	6	129801	26.3	37.6	0.185	46
Colorado	32	116999	30	80.8	0.167	47
Oregon	28	103138	30.3	62.4	0.147	48
New Hampshire	10	98607	43.9	52.6	0.141	49
Montana	10	74097	41	53.2	0.106	50
Alaska	8	64154	28.7	63.2	0.091	51

State Rankings by the Need for Additional Homebrew Shops

How is the Homebrew Shop Need Index Calculated?

Data Summary

State

# of Shops

Adjusted for 21 + Population (pop./shops)

Per Capita Consumption in Gallons

Average Internet Interest #

Homebrew Shop Need Index

Rank (in order of need)

1 Comment

Submit a Comment Cancel reply

Check Out My Book!

The New IPA: Scientific Guide to Hop Aroma and Flavor

You have Successfully Subscribed!