Preliminary Tract Regression Analysis
Michael Minn - 7 April 2015
Variables
Landsat Data
NDVI: Median tract residential area NDVI
Census Data
2000 Decennial census, 2009-2013 American Community Survey
SQMLAND: Tract area in square meters
SQMWATER: Tract area covered in water in square meters
MEDIANAGE: Median age
MEDHHINC: Median household income
MEANHHSIZE: Mean number of members in each household
PCLIVEALONE: Percent of households with one member
PCVACANT: Percent vacant housing units (mean?)
PCOWNEROCC: Percent housing units owner-occupied
PCCOLLEGE: Percent of residents with 4-year college degree or more
HOUSINGUNITS: Total number of housing units
PCTURNOVER: Percent residents in same house one year ago
PCBORNUSA: Percent of residents born in the USA
PCUNEMPLOYED: Percent 16 years of age or older unemployed (mean?)
MEDHOMEVALUE: Median home value
Parcel Data
Data from 2013 Maricopa County Assessor's Office ST 42030 File
SQMLAWN: Total square meters of PLA (lot_size - (home_size / floors) - pool_size)
MEDSQMHOME: Median home living area
MEDCONSTYR: Median construction year
MEDHOMEAGE: Median home age
MEDHOMEPRICE: Median 2013 home price (from county data)
PMINPET: Precipitation - potential evapotranspiration
Missing Data (NA)
Out of 453,381 rows
NDVI SQMLAND SQMWATER MEDIANAGE MEDHHINC MEANHHSIZE
87370 0 0 403 741 494
PCVACANT PCOWNEROCC HOUSINGUNITS PCTURNOVER PCBORNUSA PCUNEMPLOYED
222300 92 335481 465 465 36465
SQMLAWN MEDCONSTYR PMINPET
0 0 43200
Covariates
Excluded covariates (r >= 0.7):
- MEDHOMEAGE
- MEDHOMEPRICE
- MEDHOMEVALUE
- MEDSQMHOME
- PCCOLLEGE
- PCLIVEALONE
PCVACANT (222300) and HOUSINGUNITS (335481) excluded because of large amount of missing data (not computed from ACS?)
x y r
1 MEDCONSTYR MEDHOMEAGE 0.98
2 MEDHOMEVALUE MEDHOMEPRICE 0.839
3 MEDSQMHOME MEDHOMEPRICE 0.831
4 MEDHHINC MEDSQMHOME 0.814
5 MEDHHINC MEDHOMEVALUE 0.767
6 MEDHHINC MEDHOMEPRICE 0.752
7 MEDHHINC PCCOLLEGE 0.75
8 PCCOLLEGE MEDHOMEVALUE 0.749
9 MEANHHSIZE PCLIVEALONE -0.741
10 PCCOLLEGE MEDHOMEPRICE 0.7
11 MEDHOMEVALUE MEDSQMHOME 0.694
12 MEDIANAGE MEANHHSIZE -0.629
13 PCCOLLEGE MEDSQMHOME 0.592
14 PCOWNEROCC PCTURNOVER 0.561
15 PCCOLLEGE PCBORNUSA 0.532
16 MEDHHINC PCBORNUSA 0.517
17 SQMLAWN MEDHOMEPRICE 0.514
18 MEDSQMHOME MEDCONSTYR 0.501
19 MEDSQMHOME MEDHOMEAGE 0.492
20 MEDHHINC MEDCONSTYR 0.486
21 MEDHHINC MEDHOMEAGE 0.486
22 SQMLAND SQMWATER 0.482
23 PCBORNUSA MEDCONSTYR 0.48
24 PCBORNUSA MEDHOMEAGE 0.478
25 MEDIANAGE PCBORNUSA 0.468
26 MEDHHINC PCLIVEALONE -0.466
27 SQMLAWN MEDSQMHOME 0.462
28 MEANHHSIZE PCBORNUSA -0.458
29 PCBORNUSA MEDSQMHOME 0.458
30 PCLIVEALONE MEDSQMHOME -0.452
31 MEDHOMEVALUE SQMLAWN 0.443
32 MEDIANAGE PCVACANT 0.417
33 SQMLAND SQMLAWN 0.414
34 PCBORNUSA PCUNEMPLOYED -0.414
35 MEANHHSIZE PCCOLLEGE -0.407
36 PCBORNUSA MEDHOMEPRICE 0.4
37 MEDHHINC SQMLAWN 0.391
38 PCBORNUSA MEDHOMEVALUE 0.381
39 MEDHHINC PCUNEMPLOYED -0.378
40 PCUNEMPLOYED MEDHOMEAGE -0.366
41 MEDIANAGE PCCOLLEGE 0.363
42 MEDCONSTYR MEDHOMEPRICE 0.358
43 PCLIVEALONE MEDHOMEAGE -0.355
44 MEDHOMEAGE MEDHOMEPRICE 0.349
45 MEDIANAGE PCUNEMPLOYED -0.347
46 MEANHHSIZE PCVACANT -0.336
47 PCLIVEALONE MEDCONSTYR -0.332
48 PCCOLLEGE PCUNEMPLOYED -0.327
49 PCUNEMPLOYED MEDSQMHOME -0.325
50 MEDHOMEVALUE MEDCONSTYR 0.322
51 MEDIANAGE MEDHOMEPRICE 0.321
52 PCCOLLEGE MEDCONSTYR 0.321
53 PCUNEMPLOYED MEDHOMEPRICE -0.32
54 SQMWATER SQMLAWN 0.316
55 MEDIANAGE MEDHOMEVALUE 0.314
56 PCTURNOVER PCUNEMPLOYED 0.307
57 MEDHOMEVALUE MEDHOMEAGE 0.304
58 PCCOLLEGE MEDHOMEAGE 0.294
59 PCLIVEALONE PCVACANT 0.276
60 PCUNEMPLOYED MEDCONSTYR -0.275
61 MEDIANAGE PCOWNEROCC 0.273
62 PCUNEMPLOYED MEDHOMEVALUE -0.273
63 MEDIANAGE PCLIVEALONE 0.272
64 NDVI MEDCONSTYR -0.269
65 MEDIANAGE SQMLAWN 0.269
66 NDVI MEDHOMEAGE -0.262
67 PCCOLLEGE SQMLAWN 0.261
68 HOUSINGUNITS MEDHOMEAGE 0.26
69 MEANHHSIZE PCUNEMPLOYED 0.255
70 MEDIANAGE PCTURNOVER 0.246
71 HOUSINGUNITS MEDCONSTYR 0.244
72 NDVI PCCOLLEGE 0.243
73 PCTURNOVER MEDHOMEVALUE 0.235
74 MEDIANAGE MEDSQMHOME 0.229
75 PCBORNUSA SQMLAWN 0.229
76 PCOWNEROCC PCCOLLEGE 0.224
77 SQMWATER MEDHOMEPRICE 0.22
78 NDVI PCVACANT -0.217
79 SQMLAWN MEDCONSTYR 0.215
80 MEDIANAGE MEDHHINC 0.214
81 PCOWNEROCC SQMLAWN 0.208
82 PCLIVEALONE SQMLAWN -0.204
83 SQMLAWN MEDHOMEAGE 0.204
84 NDVI HOUSINGUNITS -0.186
85 PCLIVEALONE MEDHOMEPRICE -0.182
86 NDVI MEDHOMEVALUE 0.18
87 MEANHHSIZE MEDHOMEVALUE -0.178
88 PCTURNOVER MEDHOMEAGE -0.177
89 NDVI MEDHOMEPRICE 0.175
90 MEANHHSIZE MEDHOMEPRICE -0.175
91 PCOWNEROCC PCUNEMPLOYED 0.171
92 PCOWNEROCC MEDHOMEVALUE 0.167
93 PCOWNEROCC PCBORNUSA 0.161
94 PCUNEMPLOYED SQMLAWN -0.161
95 PCOWNEROCC MEDSQMHOME 0.154
96 MEDHHINC PCOWNEROCC 0.153
97 PCOWNEROCC MEDCONSTYR 0.152
98 PCVACANT MEDCONSTYR 0.151
99 HOUSINGUNITS MEDSQMHOME 2.148
100 PCVACANT HOUSINGUNITS 0.146
101 PCVACANT MEDHOMEAGE 0.142
102 HOUSINGUNITS PCBORNUSA 0.137
103 HOUSINGUNITS MEDHOMEVALUE 0.135
104 MEDHHINC PCVACANT -0.134
105 PCOWNEROCC MEDHOMEPRICE 0.134
106 PCLIVEALONE MEDHOMEVALUE -0.132
107 NDVI MEDHHINC 0.13
108 PCCOLLEGE PCTURNOVER 0.13
109 SQMWATER MEDSQMHOME 0.127
110 PCVACANT PCUNEMPLOYED -0.126
111 MEDIANAGE MEDCONSTYR 0.124
112 SQMWATER MEDHOMEVALUE 0.123
113 PCTURNOVER SQMLAWN 0.123
114 PCVACANT MEDHOMEVALUE 0.12
115 HOUSINGUNITS SQMLAWN 0.12
116 SQMWATER PCVACANT 0.119
117 MEDHHINC HOUSINGUNITS 0.114
118 PCLIVEALONE PCUNEMPLOYED 0.114
119 MEDHHINC PCTURNOVER 0.113
120 NDVI PCLIVEALONE 0.107
121 SQMLAND PCVACANT 0.107
122 SQMLAND MEDHOMEPRICE 0.107
123 MEDIANAGE MEDHOMEAGE 0.105
124 HOUSINGUNITS MEDHOMEPRICE 0.104
125 HOUSINGUNITS PCTURNOVER -0.097
126 NDVI MEDSQMHOME 0.096
127 PCCOLLEGE HOUSINGUNITS 0.096
128 PCVACANT SQMLAWN 0.092
129 PCOWNEROCC HOUSINGUNITS -0.088
130 MEANHHSIZE PCOWNEROCC -0.086
131 PCVACANT MEDHOMEPRICE 0.084
132 PCTURNOVER MEDSQMHOME 0.081
133 NDVI MEANHHSIZE -0.08
134 SQMWATER MEDIANAGE 0.08
135 SQMWATER MEDHHINC 0.079
136 SQMWATER PCCOLLEGE 0.071
137 SQMLAND MEDSQMHOME 0.069
138 SQMLAND MEDCONSTYR 0.066
139 PCTURNOVER MEDHOMEPRICE 0.066
140 NDVI SQMLAWN 0.065
141 SQMLAND MEDHOMEAGE 0.065
142 MEANHHSIZE MEDSQMHOME 0.065
143 SQMLAND MEDIANAGE 0.064
144 PCVACANT PCOWNEROCC -0.058
145 HOUSINGUNITS PCUNEMPLOYED -0.058
146 PCVACANT PCBORNUSA 0.057
147 MEDIANAGE HOUSINGUNITS 0.055
148 SQMLAND PCLIVEALONE -0.053
149 SQMLAND MEDHOMEVALUE 0.051
150 MEANHHSIZE PCTURNOVER 0.051
151 NDVI PCBORNUSA 0.05
152 PCLIVEALONE PCTURNOVER 0.045
153 SQMWATER MEDCONSTYR 0.043
154 SQMWATER MEDHOMEAGE 0.042
155 NDVI MEDIANAGE -0.041
156 NDVI PMINPET 0.041
157 SQMWATER MEANHHSIZE -0.041
158 PCLIVEALONE PCCOLLEGE 0.039
159 PCTURNOVER PMINPET -0.039
160 PCVACANT MEDSQMHOME -0.038
161 HOUSINGUNITS PMINPET -0.038
162 MEDHHINC MEANHHSIZE 0.036
163 MEANHHSIZE SQMLAWN -0.034
164 PCLIVEALONE HOUSINGUNITS -0.034
165 SQMWATER PCLIVEALONE -0.033
166 SQMWATER PCUNEMPLOYED -0.033
167 PCTURNOVER MEDCONSTYR -0.032
168 NDVI SQMLAND -0.03
169 SQMLAND PCUNEMPLOYED -0.03
170 SQMWATER PCOWNEROCC 0.03
171 NDVI PCTURNOVER 0.027
172 SQMWATER PCBORNUSA 0.027
173 SQMLAND PCCOLLEGE -0.025
174 SQMWATER HOUSINGUNITS 0.025
175 PCVACANT PCCOLLEGE -0.025
176 PCOWNEROCC MEDHOMEAGE 0.023
177 PCLIVEALONE PCOWNEROCC 0.022
178 PCTURNOVER PCBORNUSA 0.021
179 MEANHHSIZE HOUSINGUNITS -0.02
180 MEANHHSIZE MEDCONSTYR -0.02
181 PCVACANT PCTURNOVER -0.02
182 PCOWNEROCC PMINPET -0.02
183 PCUNEMPLOYED PMINPET -0.019
184 SQMLAND PCBORNUSA 0.018
185 MEANHHSIZE MEDHOMEAGE -0.018
186 NDVI PCUNEMPLOYED -0.017
187 NDVI PCOWNEROCC -0.016
188 SQMLAND HOUSINGUNITS 0.015
189 SQMLAND MEANHHSIZE -0.014
190 SQMLAND PCOWNEROCC 0.014
191 SQMLAND PCTURNOVER 0.013
192 MEDHOMEVALUE PMINPET -0.013
193 PCVACANT PMINPET -0.012
194 SQMLAND MEDHHINC 0.007
195 SQMWATER PCTURNOVER 0.007
196 PCLIVEALONE PMINPET -0.007
197 PCCOLLEGE PMINPET -0.005
198 MEDHOMEAGE PMINPET 0.005
199 MEANHHSIZE PMINPET -0.004
200 MEDIANAGE PMINPET -0.003
201 MEDCONSTYR PMINPET -0.003
202 NDVI SQMWATER 0.002
203 MEDHHINC PMINPET -0.002
204 PCLIVEALONE PCBORNUSA -0.002
205 SQMLAWN PMINPET -0.002
206 PCBORNUSA PMINPET 0.001
207 MEDSQMHOME PMINPET -0.001
208 MEDHOMEPRICE PMINPET -0.001
209 SQMLAND PMINPET 0
210 SQMWATER PMINPET 0
Linear Model
lm(formula = NDVI ~ SQMLAND + SQMWATER + MEDIANAGE + MEDHHINC +
MEANHHSIZE + PCOWNEROCC + PCTURNOVER + PCBORNUSA + PCUNEMPLOYED +
SQMLAWN + MEDCONSTYR + PMINPET, data = database)
Residuals:
Min 1Q Median 3Q Max
-3.9973 -0.5536 -0.1261 0.4099 12.6945
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 0.043256 0.001634 26.466 < 2e-16 ***
SQMLAND -0.018830 0.001855 -10.153 < 2e-16 ***
SQMWATER -0.011060 0.001762 -6.278 3.44e-10 ***
MEDIANAGE -0.302715 0.002520 -120.127 < 2e-16 ***
MEDHHINC 0.321074 0.002296 139.846 < 2e-16 ***
MEANHHSIZE -0.230106 0.002486 -92.566 < 2e-16 ***
PCOWNEROCC -0.059247 0.002164 -27.373 < 2e-16 ***
PCTURNOVER 0.119533 0.002256 52.981 < 2e-16 ***
PCBORNUSA 0.117465 0.002456 47.834 < 2e-16 ***
PCUNEMPLOYED -0.032852 0.002159 -15.213 < 2e-16 ***
SQMLAWN 0.091077 0.002013 45.241 < 2e-16 ***
MEDCONSTYR -0.473297 0.002026 -233.605 < 2e-16 ***
PMINPET 0.039023 0.001654 23.595 < 2e-16 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 0.8843 on 301198 degrees of freedom
(152170 observations deleted due to missingness)
Multiple R-squared: 0.2249, Adjusted R-squared: 0.2249
F-statistic: 7283 on 12 and 301198 DF, p-value: < 2.2e-16
