College Town Comparisons.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1		General comment: We have already seen that the simplistic analysis of city to undergraduate student ratio doesnt tell us enough. My sense is that this would work best if we could turn it into a multi-variate analysis, and have enough key datapoints in order to get a decently high confidence interval in that analysis. I started this with major research universities which are near-peers of UC Davis, but I have been accused of bias for not including "small" college towns which are functionally dissimmilar to UCD ( Cal Poly SLO for example, has a research budget of $25k as opposed to UCD's near $1 Billion.) The way to have it both ways, I think, it to get all of the data into model that we can, and then let that data do the talking. I think that means having a seperate column for graduate and PHD student populations, another for the research dollar budget, in addition to the ones like "population within 30 miles" ( by the way.. maybe 30 miles isnt the right number?? and "average days on market" for real estate... I dont have the bandwidth to do this all myself.... and I want this to be a good analysis... so please let me know your thoughts. comment in this cell on these topics.
2									What other variables shoud we include?
3		City	University	Undergraduate Student Population	City Population	City : Student Ratio	Homeowner Vacancy	30 Mile Population	Graduate Student Body	Research Budget	Distance to nearest MSA center	Employees as share of city workforce (add Davis + UCD)	Public	Days on Market	Co located with state capital	Regional Economic Center	State population <2M

4	1	College Station + Bryan TX	Texas A&M	72,982	211,274	2.89	1.7%	23,491					Public
5	2	Gainsville Fl	University of Florida	52,367	140,398	2.68	4.0%						Public
6	3	Ann Arbor/Ypsilanti	Michigan + Eastern Michigan	51,225	121,536	2.37	0.9%	367,950					Public
7	4	East Lansing/Lansing MI	Michigan State University	50,344	112,684	2.24	2.3%						Public		X
8	5	Champagne-Urbana	University of Illinois	44,087	127,099	2.88	2.9%						Public
9	6	Lafayette (Metro)	Purdue	41,573	126,655	3.05	1.9%	43,194					Public
10	7	Davis CA	University of California Davis	35,186	66,799	1.90	0.6%	1,683,395					Public		X
11	8	Bloomington IN	Indiana University	34,253	79,968	2.33	0.9%						Public
12	9	Ames IA	University of Iowa	33,334	66,424	1.99	0.7%	195,017					Public
13	10	Corvallis	Oregon State University	33,193	95,184	2.87	1.3%						Public
14	11	Ft Collins CO	Colorado State University	32,908	168,538	5.12	0.9%	401,144					Public
15	12	Blacksburg / Christiansburg VA	Virginia Tech	30,598	67,564	2.21	1.0%						Public
16	13	Columbia MO	University of Missouri	29,866	126,853	4.25	0.9%						Public
17	14	Lawrence KS	University of Kansas	28,447	95,256	3.35	2.1%						Public
18	15	Stillwater OK	Oklahoma State University	25,594	48,394	1.89	3.4%	13,640					Public
19	16	Manhattan KS	Kansas State University	24,766	54,763	2.21	0.8%						Public		X
20	17	Ithaca NY + Lansing & Cauyga	Cornell	21,904	105,740	4.83	1.1%						U-Prv/G-Pub
21	18	Laramie WY	University of Wyoming	12,627	31,659	2.51	1.4%						Public		X		X
22					Average	2.87
23
24		List of research institutions by research budget	https://ncsesdata.nsf.gov/profiles/site?method=rankingBySource&ds=herd
25
26		From Rik's list
27		Vermillion SD	South Dakota St										Public				X
28		Orono/Old Town ME	Maine										Public				X
29		Moscow ID	Idaho										Public				X
30		Grand Forks ND	North Dakota St										Public				X
31		Burlington VT	Vermont + Champlain										Public				X
32		Bozeman MT	Montana										Public				X
33		Binghamton + 7 towns NY	Binghamton
34		Santa Cruz + Scotts Valley CA	UC Santa Cruz										Public
35		San Luis Obispo CA	Cal Poly SLO										Public
36		Pullman WA	Washington State										Public
37		Bowling Green OH	Bowling Green
38		Oxford OH	Miami
39		Oxford MS	Ole Miss										Public
40		Starkville MS	Mississippi State										Public
41		Athens OH	Ohio										Public
42		Storrs CT	Connecticut										Public
43		Clemson SC	Clemson										Public
44		Kent OH	Kent State										Public
45		Morganton WV	West Virginia										Public				X
46		Goleta + Isla Vista	UC Santa Barbara										Public
47		Charlottesville VA	Virginia										Public
48		Logan UT	Utah State										Public
49		Amherst MA	Massachussets + Amherst										Pub + Prv
50		State College +Park Village PA	Penn State										Public
51		Chapel Hll + Durham NC	North Carolina + Duke								Embedded in Raleigh MSA as others such as Cambridge, Berkeley, Palo Alto, La Jolla, Irvine, Evanston, Provo		Pub + Prv
52
53
54		Richard's list	(geographically distinct communities & college is dominant employer, >10,000 students)
55		Bellingham+Ferndale WA	Western Washington										Public
56		Eugene/Springfield OR	Oregon										Public
57		Boulder CO	Colorado										Public
58		Madison WI	Wisconsin								May not be dominant employer		Public		x
59		Ellensburg WA	Central Washington										Public
60		Mt. Pleasant MI	Central MIchigan										Public
61		Kalamazoo MI	Western Michigan										Public
62		Reno NV	Nevada Reno										Public
63		Lincoln NE	Nebraska								May not be dominant employer		Public		X		X
64		Norman OK	Oklahoma										Public
65		Tuscaloosa AL	Alabama										Public
66		Auburn AL	Auburn										Public
67		Athens GA	Georgia										Public
68		Columbia+suburbs SC	South Carolina								May not be dominant employer		Public		X
69		Tallahassee FL	Florida State								May not be dominant employer		Public		X
70		Tuscon AZ	Arizona										Public
71		Las Cruces NM	New Mexico State										Public
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