Week 5 Major Project Customer Relationship Management

Technology plays an important role in supporting decision-making.  This major project will focus on supporting decision-making by exploring some of the features within Microsoft Excel, including the basic filter, custom filter, conditional formatting, and pivot tables.

Let’s assume that you work for a small business and have been asked to perform the following tasks to aid in various decisions:

1. Show all information for only customers who live in the North region.

2. Show all information for only customers who (a) live in the North region, (b) own their homes, and (c) have only one household member.

3. Show all information for customers who have at least 4 household members.

4. Show all information for customers who (a) have spent less than $20 or (b) more than $100.

5. Show all information for all customers highlighting those customers who have spent more than $100.

6. Provide a two-dimensional table that counts the number of customers by the categories of REGION and RENT VS. OWN.

7. Provide a two-dimensional table that both (a) counts the number of customers and (b) sums the TOTAL PURCHASES of customers by the categories of REGION and RENT VS. OWN.

8. Provide a three-dimensional table that counts the number of customers by the categories of REGION, RENT VS. OWN, and NUM HOUSEHOLD.

First, read the attached Extended Learning Module D: Decision Analysis with Spreadsheet Software document.  Then, create the requested worksheet summaries listed above.  You will need to use Microsoft Excel in order to complete this assignment.  The attached XLMD_Customer.xlsx data file should be used to complete each exercise.

Once you have completed each request, please submit one Excel document including 8 worksheets illustrating each exercise.

BUSN 420 Major Project Assignment Instructions

Technology plays an essential role in supporting decision-making. This major project
will focus on supporting decision-making by exploring some of the features within
Microsoft Excel, including the basic filter, custom filter, conditional formatting, as well as
pivot tables.

Let’s assume that you work for a small business and have been asked to perform the
following tasks to aid in various decisions:

1. Show all information for only customers who live in the North region.

2. Show all information for only customers who (a) live in the North region, (b) own their
homes, and (c) have only one household member.

3. Show all information for customers who have at least 4 household members.

4. Show all information for customers who (a) have spent less than $20 or (b) more than
$100.

5. Show all information for all customers highlighting those customers who have spent
more than $100.

6. Provide a two-dimensional table that counts the number of customers by the
categories of REGION and RENT VS. OWN.

7. Provide a two-dimensional table that both (a) counts the number of customers and (b)
sums the TOTAL PURCHASES of customers by the categories of REGION and RENT
VS. OWN.

8. Provide a three-dimensional table that counts the number of customers by the
categories of REGION, RENT VS. OWN, and NUM HOUSEHOLD.

First, read the attached Extended Learning Module D: Decision Analysis with
Spreadsheet Software document. Then, create the requested worksheet summaries
listed above. You will need to use Microsoft Excel to complete this assignment.

Microsoft Excel is available at no cost to Regent students via the Office 365 application
listed in the Course Resources section of our Blackboard course. The attached
XLMD_Customer.xlsx data file should be used to complete the assignment.

Once you have completed each request, please submit one Excel document, including
8 worksheets illustrating each exercise.

BUSN 420 Major Project Grading Rubric

Basic Filter Possible Points Actual Points

Show all information for only
customers who live in the North
region.

5

Show all information for only
customers who (a) live in the North
region, (b) own their homes, and (c)
have only one household member.

10

Comments:

15

Custom Filter Possible Points Actual Points

Show all information for customers
who have at least 4 household
members.

10

Show all information for customers
who (a) have spent less than $20 or
(b) more than $100.

15

Comments: 25

Conditional Formatting Possible Points Actual Points

Show all information for all customers
highlighting those customers who
have spent more than $100.

10

Comments: 10

Pivot Tables Possible Points Actual Points

Provide a two-dimensional table that
counts the number of customers by
the categories of REGION and RENT
vs. OWN.

15

Provide a two-dimensional table that
both (a) counts the number of
customers and (b) sums the TOTAL
PURCHASES of customers by the
categories of REGION and RENT vs.
OWN.

15

Provide a three-dimensional table that
counts the number of customers by
the categories of REGION, RENT vs.
OWN, and NUM HOUSEHOLD.

20

Comments: 50

Late Deductions

Total Score 100

Overall Comments

XLMD_Customer

CUST ID
REGION
RENT VS. OWN
NUM HOUSEHOLD
ANNUAL INCOME
TOTAL PURCHASES
NUM PURCHASES

1
North
Own
1
10K-25K
$ 38
1

2
South
Own
4
100K+
$ 30
4

3
North
Rent
3
25K-50K
$ 19
3

4
West
Own
5
25K-50K
$ 21
6

5
East
Own
6
50K-100K
$ 35
7

6
South
Own
2
10K-25K
$ 27
5

7
East
Own
3
100K+
$ 26
3

8
West
Rent
4
25K-50K
$ 25
6

9
North
Own
5
50K-100K
$ 30
8

10
West
Rent
7
25K-50K
$ 26
2

11
North
Own
1
50K-100K
$ 21
4

12
East
Own
2
100K+
$ 29
9

13
South
Own
5
10K-25K
$ 20
7

14
South
Own
4
25K-50K
$ 27
10

15
South
Rent
3
50K-100K
$ 19
2

16
West
Own
5
25K-50K
$ 19
6

17
North
Own
6
50K-100K
$ 129
5

18
East
Rent
2
10K-25K
$ 99
7

19
West
Own
3
25K-50K
$ 99
4

20
North
Rent
1
50K-100K
$ 119
3

21
East
Own
4
50K-100K
$ 149
2

22
South
Own
3
50K-100K
$ 165
8

23
West
Rent
5
25K-50K
$ 119
6

24
North
Rent
6
10K-25K
$ 129
7

25
East
Rent
7
100K+
$ 165
5

26
South
Own
3
10K-25K
$ 99
3

27
West
Rent
2
25K-50K
$ 155
6

28
North
Own
4
50K-100K
$ 115
8

29
East
Own
5
50K-100K
$ 129
1

30
South
Rent
4
50K-100K
$ 99
8

31
West
Own
2
25K-50K
$ 169
6

32
East
Rent
3
25K-50K
$ 40
4

33
East
Own
1
50K-100K
$ 36
7

34
North
Own
6
100K+
$ 45
3

35
North
Own
5
10K-25K
$ 29
1

36
West
Rent
4
100K+
$ 28
4

37
East
Rent
1
25K-50K
$ 46
1

38
South
Rent
5
50K-100K
$ 50
4

39
East
Rent
3
50K-100K
$ 22
6

40
West
Own
6
50K-100K
$ 20
9

41
North
Own
7
25K-50K
$ 19
3

42
East
Own
3
50K-100K
$ 31
1

43
South
Rent
2
50K-100K
$ 30
10

44
West
Rent
4
25K-50K
$ 18
3

45
East
Own
5
25K-50K
$ 31
7

46
South
Own
3
10K-25K
$ 35
6

47
West
Own
7
25K-50K
$ 28
5

48
East
Rent
3
100K+
$ 29
8

49
South
Rent
2
10K-25K
$ 35
6

50
North
Own
6
25K-50K
$ 30
4

51
South
Own
5
50K-100K
$ 38
7

52
West
Own
3
50K-100K
$ 20
3

53
North
Rent
1
25K-50K
$ 40
5

54
East
Rent
5
25K-50K
$ 30
4

55
South
Own
6
25K-50K
$ 40
8

56
West
Rent
3
10K-25K
$ 62
7

57
North
Rent
4
100K+
$ 22
9

58
East
Rent
5
100K+
$ 25
1

59
West
Rent
7
10K-25K
$ 27
4

60
East
Rent
2
25K-50K
$ 22
7

61
South
Own
3
25K-50K
$ 30
4

62
East
Own
1
25K-50K
$ 31
3

63
East
Own
4
50K-100K
$ 22
8

64
South
Rent
2
50K-100K
$ 25
9

65
West
Own
3
25K-50K
$ 24
3

66
East
Own
5
50K-100K
$ 36
2

67
North
Rent
4
50K-100K
$ 123
11

68
North
Rent
6
100K+
$ 19
2

69
North
Own
5
100K+
$ 23
6

70
South
Rent
7
100K+
$ 19
8

71
West
Rent
4
25K-50K
$ 25
6

72
West
Rent
5
50K-100K
$ 129
8

73
North
Own
3
50K-100K
$ 119
9

74
East
Own
6
100K+
$ 109
3

75
North
Own
5
10K-25K
$ 179
6

76
East
Rent
4
100K+
$ 145
5

77
South
Own
2
25K-50K
$ 119
7

78
North
Rent
3
50K-100K
$ 129
2

79
East
Own
4
10K-25K
$ 189
4

80
West
Own
6
50K-100K
$ 155
6

81
North
Rent
5
25K-50K
$ 78
4

82
East
Own
4
25K-50K
$ 61
5

83
South
Rent
3
25K-50K
$ 97
7

84
North
Rent
2
50K-100K
$ 63
2

85
West
Own
4
100K+
$ 39
3

86
East
Rent
6
50K-100K
$ 95
1

87
South
Rent
4
25K-50K
$ 86
7

88
West
Own
1
50K-100K
$ 85
5

89
East
Own
2
50K-100K
$ 59
7

90
North
Rent
3
100K+
$ 84
9

91
North
Own
2
100K+
$ 144
10

92
West
Rent
3
100K+
$ 26
1

93
South
Rent
7
25K-50K
$ 31
1

94
East
Own
6
50K-100K
$ 19
1

95
South
Rent
5
50K-100K
$ 30
1

96
West
Rent
4
100K+
$ 29
11

97
West
Rent
5
10K-25K
$ 25
2

98
West
Rent
6
100K+
$ 24
6

99
East
Rent
3
25K-50K
$ 36
5

100
North
Own
4
50K-100K
$ 29
7

101
South
Own
2
10K-25K
$ 99
9

102
West
Rent
1
50K-100K
$ 169
3

103
East
Own
3
10K-25K
$ 179
1

104
North
Rent
4
100K+
$ 119
7

105
South
Own
5
25K-50K
$ 99
4

106
West
Rent
4
50K-100K
$ 179
7

107
East
Own
6
10K-25K
$ 185
6

108
North
Rent
3
50K-100K
$ 179
8

109
South
Rent
4
25K-50K
$ 145
9

110
West
Rent
5
25K-50K
$ 119
3

111
North
Own
7
25K-50K
$ 99
2

112
North
Own
2
50K-100K
$ 155
5

113
East
Own
3
100K+
$ 119
4

114
North
Rent
5
50K-100K
$ 149
7

115
East
Rent
3
25K-50K
$ 56
5

116
North
Rent
2
50K-100K
$ 50
6

117
West
Own
4
50K-100K
$ 86
3

118
South
Rent
2
100K+
$ 45
2

119
East
Rent
1
100K+
$ 95
6

120
West
Rent
3
100K+
$ 86
8

121
South
Rent
2
25K-50K
$ 97
11

122
East
Rent
4
50K-100K
$ 40
8

123
North
Rent
5
50K-100K
$ 50
5

124
East
Own
6
100K+
$ 59
3

125
North
Rent
3
10K-25K
$ 75
4

126
South
Rent
4
50K-100K
$ 68
3

127
West
Rent
6
50K-100K
$ 63
1

128
North
Own
2
25K-50K
$ 56
10

129
East
Own
4
25K-50K
$ 86
2

130
North
Rent
6
50K-100K
$ 45
6

131
West
Own
3
100K+
$ 78
8

132
South
Own
4
10K-25K
$ 68
7

133
East
Rent
7
100K+
$ 95
6

134
North
Own
4
25K-50K
$ 95
4

135
East
Rent
5
50K-100K
$ 39
7

136
East
Own
6
50K-100K
$ 56
8

137
North
Own
2
50K-100K
$ 31
9

138
South
Rent
3
25K-50K
$ 29
6

139
West
Rent
4
50K-100K
$ 41
7

140
East
Rent
5
50K-100K
$ 62
4

141
North
Rent
1
25K-50K
$ 51
3

142
South
Own
2
25K-50K
$ 37
2

143
West
Own
3
10K-25K
$ 19
6

144
East
Rent
4
25K-50K
$ 38
5

145
North
Rent
5
100K+
$ 56
7

146
East
Own
4
100K+
$ 41
5

147
West
Own
3
25K-50K
$ 51
8

148
North
Rent
6
50K-100K
$ 19
4

149
East
Rent
2
10K-25K
$ 29
3

150
North
Own
4
50K-100K
$ 41
5

151
East
Own
3
25K-50K
$ 19
6

152
West
Own
3
25K-50K
$ 30
7

153
North
Own
5
25K-50K
$ 19
8

154
South
Rent
4
50K-100K
$ 21
3

155
East
Own
6
100K+
$ 23
2

156
North
Own
7
50K-100K
$ 29
5

157
West
Own
2
25K-50K
$ 18
2

158
East
Own
3
50K-100K
$ 26
5

159
South
Own
1
50K-100K
$ 20
1

160
West
Rent
2
100K+
$ 76
11

161
East
Own
4
100K+
$ 40
4

162
South
Own
2
100K+
$ 41
3

163
North
Own
4
25K-50K
$ 24
7

164
East
Rent
5
50K-100K
$ 26
5

165
West
Rent
6
50K-100K
$ 25
8

166
South
Own
4
100K+
$ 26
6

167
East
Own
2
10K-25K
$ 23
8

168
North
Own
4
50K-100K
$ 27
5

169
East
Own
3
50K-100K
$ 25
8

170
South
Rent
5
25K-50K
$ 34
10

171
West
Rent
4
25K-50K
$ 24
7

172
West
Rent
6
50K-100K
$ 21
9

173
East
Own
4
100K+
$ 40
8

174
South
Rent
3
50K-100K
$ 19
1

175
West
Own
1
100K+
$ 30
11

176
East
Rent
2
100K+
$ 35
10

177
North
Own
4
100K+
$ 24
1

178
East
Own
7
25K-50K
$ 26
4

179
South
Own
4
50K-100K
$ 15
1

180
East
Rent
6
50K-100K
$ 18
3

181
North
Rent
3
100K+
$ 28
1

182
South
Own
7
10K-25K
$ 24
4

183
West
Rent
2
100K+
$ 30
5

184
East
Own
1
25K-50K
$ 30
4

185
West
Own
4
50K-100K
$ 23
7

186
North
Own
5
10K-25K
$ 28
5

187
East
Rent
3
50K-100K
$ 21
6

188
North
Own
2
25K-50K
$ 28
4

189
East
Rent
4
25K-50K
$ 22
2

190
West
Own
5
25K-50K
$ 28
6

191
North
Own
2
50K-100K
$ 30
8

192
South
Own
1
100K+
$ 28
9

193
East
Own
4
50K-100K
$ 25
10

194
North
Rent
2
25K-50K
$ 29
3

195
West
Own
5
50K-100K
$ 28
6

196
East
Own
3
50K-100K
$ 30
5

197
South
Rent
6
100K+
$ 19
4

198
West
Own
5
100K+
$ 30
6

199
East
Rent
7
100K+
$ 149
8

200
South
Own
4
25K-50K
$ 155
7

201
North
Own
5
50K-100K
$ 115
4

202
East
Rent
6
50K-100K
$ 119
5

203
West
Rent
3
100K+
$ 99
7

204
South
Rent
2
10K-25K
$ 119
8

205
East
Own
4
100K+
$ 149
9

206
North
Rent
5
25K-50K
$ 145
11

207
East
Own
3
25K-50K
$ 119
8

208
South
Own
5
50K-100K
$ 129
5

209
North
Rent
4
50K-100K
$ 99
7

210
East
Own
6
50K-100K
$ 119
8

211
South
Rent
4
100K+
$ 185
9

212
West
Own
5
10K-25K
$ 119
5

213
West
Own
6
50K-100K
$ 99
2

214
East
Own
7
50K-100K
$ 109
6

215
South
Rent
1
25K-50K
$ 179
8

216
West
Rent
3
25K-50K
$ 169
6

217
East
Rent
2
50K-100K
$ 179
9

218
North
Rent
5
10K-25K
$ 145
7

219
East
Own
4
100K+
$ 119
6

220
South
Own
6
100K+
$ 165
3

221
East
Own
7
10K-25K
$ 129
2

222
North
Rent
3
100K+
$ 159
11

223
South
Rent
2
50K-100K
$ 37
7

224
West
Own
4
50K-100K
$ 55
5

225
East
Own
5
25K-50K
$ 63
7

226
West
Own
4
25K-50K
$ 56
8

227
North
Rent
3
10K-25K
$ 67
6

228
East
Rent
4
50K-100K
$ 60
8

229
North
Own
6
25K-50K
$ 50
9

230
East
Own
5
50K-100K
$ 49
3

231
West
Own
4
100K+
$ 56
4

232
North
Rent
2
50K-100K
$ 60
7

233
South
Rent
3
50K-100K
$ 59
2

234
East
Own
1
50K-100K
$ 59
8

235
North
Rent
7
50K-100K
$ 60
5

236
West
Rent
3
50K-100K
$ 68
7

237
South
Rent
4
25K-50K
$ 84
9

238
South
Rent
2
25K-50K
$ 69
2

239
West
Rent
5
100K+
$ 97
5

240
North
Own
3
10K-25K
$ 61
4

241
East
Own
4
100K+
$ 75
6

242
West
Own
5
100K+
$ 76
11

243
North
Rent
6
100K+
$ 98
8

244
East
Own
4
25K-50K
$ 95
5

245
South
Own
5
25K-50K
$ 59
7

246
West
Rent
6
50K-100K
$ 44
4

247
North
Rent
7
50K-100K
$ 97
3

248
East
Own
4
100K+
$ 68
6

249
South
Rent
3
25K-50K
$ 145
10

250
West
Rent
2
50K-100K
$ 119
3

251
North
Rent
1
10K-25K
$ 129
6

252
East
Own
5
50K-100K
$ 99
8

253
South
Own
4
25K-50K
$ 119
6

254
West
Own
6
25K-50K
$ 185
8

255
East
Rent
3
25K-50K
$ 119
10

256
East
Own
2
50K-100K
$ 99
3

257
North
Rent
1
100K+
$ 60
6

258
North
Own
5
50K-100K
$ 50
5

259
West
Own
4
25K-50K
$ 49
8

260
West
Rent
6
50K-100K
$ 56
4

261
East
Own
7
50K-100K
$ 60
7

262
North
Rent
3
100K+
$ 59
3

263
East
Rent
2
100K+
$ 59
2

264
South
Own
4
100K+
$ 60
6

265
East
Rent
5
25K-50K
$ 68
5

266
North
Rent
3
50K-100K
$ 84
8

267
South
Own
2
50K-100K
$ 69
9

268
West
Own
4
100K+
$ 97
3

269
East
Rent
3
10K-25K
$ 61
2

270
West
Own
4
50K-100K
$ 75
6

271
North
Rent
3
50K-100K
$ 76
5

272
East
Rent
4
25K-50K
$ 98
7

273
North
Own
5
25K-50K
$ 95
9

274
East
Rent
4
50K-100K
$ 59
4

275
West
Rent
6
100K+
$ 44
6

276
North
Rent
5
50K-100K
$ 97
8

277
South
Rent
7
100K+
$ 68
7

278
East
Rent
1
100K+
$ 145
1

279
North
Own
2
100K+
$ 85
10

280
West
Own
3
25K-50K
$ 59
3

281
South
Rent
4
50K-100K
$ 84
7

282
South
Own
3
50K-100K
$ 28
5

283
South
Rent
5
100K+
$ 26
8

284
East
Own
3
10K-25K
$ 31
9

285
North
Rent
3
100K+
$ 19
3

286
West
Own
2
25K-50K
$ 30
2

287
East
Rent
4
50K-100K
$ 29
11

288
South
Rent
5
10K-25K
$ 25
6

289
West
Rent
6
50K-100K
$ 24
3

290
East
Own
5
25K-50K
$ 36
6

291
South
Own
4
25K-50K
$ 29
7

292
North
Own
3
25K-50K
$ 99
9

293
East
Rent
5
50K-100K
$ 169
8

294
West
Rent
4
100K+
$ 179
3

295
South
Rent
6
50K-100K
$ 119
5

296
East
Own
4
25K-50K
$ 99
4

297
North
Rent
6
50K-100K
$ 56
6

298
East
Rent
1
50K-100K
$ 50
11

299
South
Rent
2
100K+
$ 86
10

300
North
Rent
3
100K+
$ 45
3

301
East
Rent
4
100K+
$ 95
2

302
South
Rent
7
25K-50K
$ 86
10

303
West
Own
4
50K-100K
$ 97
11

304
West
Rent
3
50K-100K
$ 40
7

305
East
Rent
1
100K+
$ 50
5

306
South
Rent
4
10K-25K
$ 59
9

307
West
Own
2
100K+
$ 75
4

308
East
Own
5
25K-50K
$ 68
3

309
North
Rent
3
25K-50K
$ 26
2

310
East
Own
6
50K-100K
$ 15
6

311
South
Own
4
50K-100K
$ 18
8

312
East
Rent
7
50K-100K
$ 28
6

313
North
Own
3
100K+
$ 24
8

314
South
Rent
2
10K-25K
$ 30
9

315
West
Own
4
50K-100K
$ 30
10

316
East
Own
5
50K-100K
$ 23
3

317
West
Rent
3
25K-50K
$ 28
2

318
North
Rent
1
25K-50K
$ 21
6

319
East
Rent
4
50K-100K
$ 28
5

320
North
Rent
3
10K-25K
$ 22
8

321
East
Own
5
100K+
$ 28
7

322
West
Own
6
100K+
$ 30
9

323
North
Rent
4
10K-25K
$ 28
4

324
South
Rent
2
100K+
$ 25
6

325
East
Own
5
50K-100K
$ 29
3

326
North
Own
3
50K-100K
$ 28
5

327
West
Rent
5
25K-50K
$ 30
3

328
South
Rent
6
25K-50K
$ 19
6

329
South
Own
4
10K-25K
$ 30
5

330
West
Own
3
50K-100K
$ 149
7

331
North
Own
5
25K-50K
$ 155
9

332
East
Own
6
50K-100K
$ 115
4

333
West
Rent
4
100K+
$ 39
6

334
North
Own
6
50K-100K
$ 95
8

335
East
Own
4
50K-100K
$ 86
7

336
South
Own
7
50K-100K
$ 85
1

337
West
Own
4
50K-100K
$ 59
10

338
North
Own
3
50K-100K
$ 84
3

339
East
Rent
1
25K-50K
$ 28
7

340
South
Own
2
25K-50K
$ 26
5

341
West
Own
5
100K+
$ 31
8

342
North
Own
3
10K-25K
$ 19
9

343
East
Rent
4
100K+
$ 30
3

344
South
Rent
6
100K+
$ 29
2

345
West
Own
5
100K+
$ 25
11

346
East
Own
3
25K-50K
$ 24
6

347
East
Own
2
25K-50K
$ 36
3

348
North
Own
1
50K-100K
$ 29
6

349
North
Rent
6
50K-100K
$ 99
7

350
West
Rent
7
50K-100K
$ 169
9

351
West
Rent
2
50K-100K
$ 179
8

352
East
Own
1
10K-25K
$ 119
3

353
North
Rent
2
100K+
$ 99
5

354
East
Own
3
10K-25K
$ 179
4

355
South
Own
2
100K+
$ 185
6

356
East
Rent
1
50K-100K
$ 179
11

357
North
Own
3
50K-100K
$ 145
10

358
South
Own
4
25K-50K
$ 119
3

359
West
Own
6
25K-50K
$ 99
2

360
East
Rent
5
10K-25K
$ 155
10

361
West
Rent
4
50K-100K
$ 119
11

362
North
Own
3
25K-50K
$ 149
7

363
East
Own
5
50K-100K
$ 56
5

364
North
Own
6
100K+
$ 50
9

365
East
Own
7
50K-100K
$ 86
4

366
North
Rent
5
50K-100K
$ 45
3

367
South
Rent
6
50K-100K
$ 95
2

368
North
Rent
3
50K-100K
$ 86
6

369
West
Own
4
50K-100K
$ 97
8

370
East
Rent
5
25K-50K
$ 23
6

371
South
Own
2
25K-50K
$ 29
8

372
East
Rent
3
100K+
$ 18
9

373
West
Own
6
10K-25K
$ 26
10

374
North
Own
2
100K+
$ 20
3

375
West
Own
5
100K+
$ 15
2

376
North
Rent
4
100K+
$ 40
6

377
East
Rent
1
25K-50K
$ 41
5

378
South
Own
4
25K-50K
$ 24
8

379
South
Rent
3
50K-100K
$ 26
7

380
South
Own
5
10K-25K
$ 25
9

381
West
Own
6
25K-50K
$ 26
4

382
North
Own
4
50K-100K
$ 23
6

383
East
Rent
2
50K-100K
$ 27
7

384
West
Own
5
25K-50K
$ 25
5

385
North
Rent
3
25K-50K
$ 18
3

386
East
Own
5
25K-50K
$ 24
6

387
South
Own
6
10K-25K
$ 21
8

388
West
Own
4
100K+
$ 40
2

389
North
Own
3
100K+
$ 19
4

390
South
Rent
5
10K-25K
$ 30
9

391
West
Own
6
25K-50K
$ 35
7

392
East
Own
4
25K-50K
$ 24
10

393
East
Rent
6
25K-50K
$ 26
2

394
North
Own
4
50K-100K
$ 15
6

395
North
Rent
7
50K-100K
$ 18
5

396
West
Own
4
25K-50K
$ 28
7

397
West
Own
3
50K-100K
$ 24
4

398
East
Rent
1
50K-100K
$ 30
3

399
North
Rent
2
100K+
$ 30
2

400
East
Rent
5
25K-50K
$ 23
8

401
South
Own
3
25K-50K
$ 28
6

402
East
Rent
4
10K-25K
$ 21
7

403
North
Own
6
25K-50K
$ 28
5

404
South
Own
5
100K+
$ 22
3

405
West
Rent
3
50K-100K
$ 28
6

406
East
Own
2
50K-100K
$ 30
8

407
West
Rent
1
25K-50K
$ 28
1

408
North
Own
6
25K-50K
$ 25
8

409
East
Own
7
50K-100K
$ 29
6

410
North
Rent
2
50K-100K
$ 28
4

411
East
Rent
1
25K-50K
$ 30
7

412
North
Own
2
50K-100K
$ 19
3

413
South
Own
3
50K-100K
$ 30
1

414
North
Own
2
25K-50K
$ 149
4

415
West
Own
1
50K-100K
$ 155
1

416
East
Rent
3
10K-25K
$ 115
4

417
South
Own
4
100K+
$ 119
6

418
East
Own
6
50K-100K
$ 99
5

419
West
Own
5
50K-100K
$ 119
3

420
North
Own
4
25K-50K
$ 149
7

421
West
Own
3
25K-50K
$ 145
6

422
North
Rent
5
25K-50K
$ 119
8

423
East
Own
6
10K-25K
$ 129
9

424
West
Own
7
100K+
$ 99
10

425
North
Own
5
100K+
$ 119
2

426
East
Rent
6
10K-25K
$ 185
6

427
South
Rent
3
25K-50K
$ 119
4

428
West
Own
4
25K-50K
$ 99
7

429
North
Own
5
25K-50K
$ 109
5

430
East
Own
2
50K-100K
$ 179
8

431
South
Own
3
50K-100K
$ 169
9

432
West
Rent
5
25K-50K
$ 179
2

433
North
Rent
4
50K-100K
$ 145
5

434
East
Rent
6
50K-100K
$ 119
4

435
South
Own
7
100K+
$ 165
3

436
West
Rent
2
25K-50K
$ 129
11

437
East
Own
3
25K-50K
$ 159
7

438
East
Own
1
10K-25K
$ 37
4

439
North
Rent
3
25K-50K
$ 55
6

440
North
Own
5
25K-50K
$ 63
5

441
West
Own
4
25K-50K
$ 56
9

442
West
Own
6
50K-100K
$ 67
2

443
East
Rent
7
50K-100K
$ 60
5

444
North
Rent
2
50K-100K
$ 50
3

445
East
Own
3
25K-50K
$ 49
6

446
South
Own
4
10K-25K
$ 56
8

447
East
Own
5
25K-50K
$ 60
4

448
North
Own
3
100K+
$ 59
7

449
South
Rent
4
10K-25K
$ 59
5

450
West
Rent
1
25K-50K
$ 60
1

451
East
Rent
3
50K-100K
$ 68
10

452
South
Own
4
50K-100K
$ 84
11

453
North
Rent
5
25K-50K
$ 69
11

454
West
Own
6
25K-50K
$ 97
11

455
East
Rent
7
50K-100K
$ 61
3

456
South
Own
6
10K-25K
$ 75
6

457
East
Own
7
100K+
$ 76
4

458
West
Own
4
100K+
$ 98
7

459
North
Rent
3
100K+
$ 95
9

460
West
Rent
5
50K-100K
$ 59
3

461
North
Own
2
50K-100K
$ 44
2

462
East
Rent
3
100K+
$ 97
6

463
West
Own
4
10K-25K
$ 68
5

464
North
Own
6
100K+
$ 145
8

465
East
Own
4
25K-50K
$ 119
7

466
South
Rent
5
50K-100K
$ 129
2

467
West
Own
3
10K-25K
$ 99
4

468
North
Rent
2
50K-100K
$ 119
3

469
North
Own
6
10K-25K
$ 185
6

470
East
Own
3
100K+
$ 119
9

471
West
Own
1
25K-50K
$ 99
10

472
South
Own
4
50K-100K
$ 60
11

473
East
Rent
3
10K-25K
$ 50
4

474
West
Rent
5
50K-100K
$ 49
2

475
South
Own
6
25K-50K
$ 56
1

476
East
Own
3
25K-50K
$ 60
5

477
North
Own
2
25K-50K
$ 59
4

478
East
Own
4
50K-100K
$ 59
7

479
North
Rent
5
100K+
$ 60
8

480
West
Rent
7
50K-100K
$ 68
9

481
East
Rent
2
25K-50K
$ 84
1

482
West
Own
1
50K-100K
$ 69
7

483
South
Rent
2
50K-100K
$ 97
4

484
North
Own
1
25K-50K
$ 61
6

485
East
Rent
3
50K-100K
$ 75
5

486
East
Own
6
50K-100K
$ 76
9

487
West
Own
4
50K-100K
$ 98
2

Question 1

CUST ID
REGION
RENT VS. OWN
NUM HOUSEHOLD
ANNUAL INCOME
TOTAL PURCHASES
NUM PURCHASES

1
North
Own
1
10K-25K
$ 38
1

2
South
Own
4
100K+
$ 30
4

3
North
Rent
3
25K-50K
$ 19
3

4
West
Own
5
25K-50K
$ 21
6

5
East
Own
6
50K-100K
$ 35
7

6
South
Own
2
10K-25K
$ 27
5

7
East
Own
3
100K+
$ 26
3

8
West
Rent
4
25K-50K
$ 25
6

9
North
Own
5
50K-100K
$ 30
8

10
West
Rent
7
25K-50K
$ 26
2

11
North
Own
1
50K-100K
$ 21
4

12
East
Own
2
100K+
$ 29
9

13
South
Own
5
10K-25K
$ 20
7

14
South
Own
4
25K-50K
$ 27
10

15
South
Rent
3
50K-100K
$ 19
2

16
West
Own
5
25K-50K
$ 19
6

17
North
Own
6
50K-100K
$ 129
5

18
East
Rent
2
10K-25K
$ 99
7

19
West
Own
3
25K-50K
$ 99
4

20
North
Rent
1
50K-100K
$ 119
3

21
East
Own
4
50K-100K
$ 149
2

22
South
Own
3
50K-100K
$ 165
8

23
West
Rent
5
25K-50K
$ 119
6

24
North
Rent
6
10K-25K
$ 129
7

25
East
Rent
7
100K+
$ 165
5

26
South
Own
3
10K-25K
$ 99
3

27
West
Rent
2
25K-50K
$ 155
6

28
North
Own
4
50K-100K
$ 115
8

29
East
Own
5
50K-100K
$ 129
1

30
South
Rent
4
50K-100K
$ 99
8

31
West
Own
2
25K-50K
$ 169
6

32
East
Rent
3
25K-50K
$ 40
4

33
East
Own
1
50K-100K
$ 36
7

34
North
Own
6
100K+
$ 45
3

35
North
Own
5
10K-25K
$ 29
1

36
West
Rent
4
100K+
$ 28
4

37
East
Rent
1
25K-50K
$ 46
1

38
South
Rent
5
50K-100K
$ 50
4

39
East
Rent
3
50K-100K
$ 22
6

40
West
Own
6
50K-100K
$ 20
9

41
North
Own
7
25K-50K
$ 19
3

42
East
Own
3
50K-100K
$ 31
1

43
South
Rent
2
50K-100K
$ 30
10

44
West
Rent
4
25K-50K
$ 18
3

45
East
Own
5
25K-50K
$ 31
7

46
South
Own
3
10K-25K
$ 35
6

47
West
Own
7
25K-50K
$ 28
5

48
East
Rent
3
100K+
$ 29
8

49
South
Rent
2
10K-25K
$ 35
6

50
North
Own
6
25K-50K
$ 30
4

51
South
Own
5
50K-100K
$ 38
7

52
West
Own
3
50K-100K
$ 20
3

53
North
Rent
1
25K-50K
$ 40
5

54
East
Rent
5
25K-50K
$ 30
4

55
South
Own
6
25K-50K
$ 40
8

56
West
Rent
3
10K-25K
$ 62
7

57
North
Rent
4
100K+
$ 22
9

58
East
Rent
5
100K+
$ 25
1

59
West
Rent
7
10K-25K
$ 27
4

60
East
Rent
2
25K-50K
$ 22
7

61
South
Own
3
25K-50K
$ 30
4

62
East
Own
1
25K-50K
$ 31
3

63
East
Own
4
50K-100K
$ 22
8

64
South
Rent
2
50K-100K
$ 25
9

65
West
Own
3
25K-50K
$ 24
3

66
East
Own
5
50K-100K
$ 36
2

67
North
Rent
4
50K-100K
$ 123
11

68
North
Rent
6
100K+
$ 19
2

69
North
Own
5
100K+
$ 23
6

70
South
Rent
7
100K+
$ 19
8

71
West
Rent
4
25K-50K
$ 25
6

72
West
Rent
5
50K-100K
$ 129
8

73
North
Own
3
50K-100K
$ 119
9

74
East
Own
6
100K+
$ 109
3

75
North
Own
5
10K-25K
$ 179
6

76
East
Rent
4
100K+
$ 145
5

77
South
Own
2
25K-50K
$ 119
7

78
North
Rent
3
50K-100K
$ 129
2

79
East
Own
4
10K-25K
$ 189
4

80
West
Own
6
50K-100K
$ 155
6

81
North
Rent
5
25K-50K
$ 78
4

82
East
Own
4
25K-50K
$ 61
5

83
South
Rent
3
25K-50K
$ 97
7

84
North
Rent
2
50K-100K
$ 63
2

85
West
Own
4
100K+
$ 39
3

86
East
Rent
6
50K-100K
$ 95
1

87
South
Rent
4
25K-50K
$ 86
7

88
West
Own
1
50K-100K
$ 85
5

89
East
Own
2
50K-100K
$ 59
7

90
North
Rent
3
100K+
$ 84
9

91
North
Own
2
100K+
$ 144
10

92
West
Rent
3
100K+
$ 26
1

93
South
Rent
7
25K-50K
$ 31
1

94
East
Own
6
50K-100K
$ 19
1

95
South
Rent
5
50K-100K
$ 30
1

96
West
Rent
4
100K+
$ 29
11

97
West
Rent
5
10K-25K
$ 25
2

98
West
Rent
6
100K+
$ 24
6

99
East
Rent
3
25K-50K
$ 36
5

100
North
Own
4
50K-100K
$ 29
7

101
South
Own
2
10K-25K
$ 99
9

102
West
Rent
1
50K-100K
$ 169
3

103
East
Own
3
10K-25K
$ 179
1

104
North
Rent
4
100K+
$ 119
7

105
South
Own
5
25K-50K
$ 99
4

106
West
Rent
4
50K-100K
$ 179
7

107
East
Own
6
10K-25K
$ 185
6

108
North
Rent
3
50K-100K
$ 179
8

109
South
Rent
4
25K-50K
$ 145
9

110
West
Rent
5
25K-50K
$ 119
3

111
North
Own
7
25K-50K
$ 99
2

112
North
Own
2
50K-100K
$ 155
5

113
East
Own
3
100K+
$ 119
4

114
North
Rent
5
50K-100K
$ 149
7

115
East
Rent
3
25K-50K
$ 56
5

116
North
Rent
2
50K-100K
$ 50
6

117
West
Own
4
50K-100K
$ 86
3

118
South
Rent
2
100K+
$ 45
2

119
East
Rent
1
100K+
$ 95
6

120
West
Rent
3
100K+
$ 86
8

121
South
Rent
2
25K-50K
$ 97
11

122
East
Rent
4
50K-100K
$ 40
8

123
North
Rent
5
50K-100K
$ 50
5

124
East
Own
6
100K+
$ 59
3

125
North
Rent
3
10K-25K
$ 75
4

126
South
Rent
4
50K-100K
$ 68
3

127
West
Rent
6
50K-100K
$ 63
1

128
North
Own
2
25K-50K
$ 56
10

129
East
Own
4
25K-50K
$ 86
2

130
North
Rent
6
50K-100K
$ 45
6

131
West
Own
3
100K+
$ 78
8

132
South
Own
4
10K-25K
$ 68
7

133
East
Rent
7
100K+
$ 95
6

134
North
Own
4
25K-50K
$ 95
4

135
East
Rent
5
50K-100K
$ 39
7

136
East
Own
6
50K-100K
$ 56
8

137
North
Own
2
50K-100K
$ 31
9

138
South
Rent
3
25K-50K
$ 29
6

139
West
Rent
4
50K-100K
$ 41
7

140
East
Rent
5
50K-100K
$ 62
4

141
North
Rent
1
25K-50K
$ 51
3

142
South
Own
2
25K-50K
$ 37
2

143
West
Own
3
10K-25K
$ 19
6

144
East
Rent
4
25K-50K
$ 38
5

145
North
Rent
5
100K+
$ 56
7

146
East
Own
4
100K+
$ 41
5

147
West
Own
3
25K-50K
$ 51
8

148
North
Rent
6
50K-100K
$ 19
4

149
East
Rent
2
10K-25K
$ 29
3

150
North
Own
4
50K-100K
$ 41
5

151
East
Own
3
25K-50K
$ 19
6

152
West
Own
3
25K-50K
$ 30
7

153
North
Own
5
25K-50K
$ 19
8

154
South
Rent
4
50K-100K
$ 21
3

155
East
Own
6
100K+
$ 23
2

156
North
Own
7
50K-100K
$ 29
5

157
West
Own
2
25K-50K
$ 18
2

158
East
Own
3
50K-100K
$ 26
5

159
South
Own
1
50K-100K
$ 20
1

160
West
Rent
2
100K+
$ 76
11

161
East
Own
4
100K+
$ 40
4

162
South
Own
2
100K+
$ 41
3

163
North
Own
4
25K-50K
$ 24
7

164
East
Rent
5
50K-100K
$ 26
5

165
West
Rent
6
50K-100K
$ 25
8

166
South
Own
4
100K+
$ 26
6

167
East
Own
2
10K-25K
$ 23
8

168
North
Own
4
50K-100K
$ 27
5

169
East
Own
3
50K-100K
$ 25
8

170
South
Rent
5
25K-50K
$ 34
10

171
West
Rent
4
25K-50K
$ 24
7

172
West
Rent
6
50K-100K
$ 21
9

173
East
Own
4
100K+
$ 40
8

174
South
Rent
3
50K-100K
$ 19
1

175
West
Own
1
100K+
$ 30
11

176
East
Rent
2
100K+
$ 35
10

177
North
Own
4
100K+
$ 24
1

178
East
Own
7
25K-50K
$ 26
4

179
South
Own
4
50K-100K
$ 15
1

180
East
Rent
6
50K-100K
$ 18
3

181
North
Rent
3
100K+
$ 28
1

182
South
Own
7
10K-25K
$ 24
4

183
West
Rent
2
100K+
$ 30
5

184
East
Own
1
25K-50K
$ 30
4

185
West
Own
4
50K-100K
$ 23
7

186
North
Own
5
10K-25K
$ 28
5

187
East
Rent
3
50K-100K
$ 21
6

188
North
Own
2
25K-50K
$ 28
4

189
East
Rent
4
25K-50K
$ 22
2

190
West
Own
5
25K-50K
$ 28
6

191
North
Own
2
50K-100K
$ 30
8

192
South
Own
1
100K+
$ 28
9

193
East
Own
4
50K-100K
$ 25
10

194
North
Rent
2
25K-50K
$ 29
3

195
West
Own
5
50K-100K
$ 28
6

196
East
Own
3
50K-100K
$ 30
5

197
South
Rent
6
100K+
$ 19
4

198
West
Own
5
100K+
$ 30
6

199
East
Rent
7
100K+
$ 149
8

200
South
Own
4
25K-50K
$ 155
7

201
North
Own
5
50K-100K
$ 115
4

202
East
Rent
6
50K-100K
$ 119
5

203
West
Rent
3
100K+
$ 99
7

204
South
Rent
2
10K-25K
$ 119
8

205
East
Own
4
100K+
$ 149
9

206
North
Rent
5
25K-50K
$ 145
11

207
East
Own
3
25K-50K
$ 119
8

208
South
Own
5
50K-100K
$ 129
5

209
North
Rent
4
50K-100K
$ 99
7

210
East
Own
6
50K-100K
$ 119
8

211
South
Rent
4
100K+
$ 185
9

212
West
Own
5
10K-25K
$ 119
5

213
West
Own
6
50K-100K
$ 99
2

214
East
Own
7
50K-100K
$ 109
6

215
South
Rent
1
25K-50K
$ 179
8

216
West
Rent
3
25K-50K
$ 169
6

217
East
Rent
2
50K-100K
$ 179
9

218
North
Rent
5
10K-25K
$ 145
7

219
East
Own
4
100K+
$ 119
6

220
South
Own
6
100K+
$ 165
3

221
East
Own
7
10K-25K
$ 129
2

222
North
Rent
3
100K+
$ 159
11

223
South
Rent
2
50K-100K
$ 37
7

224
West
Own
4
50K-100K
$ 55
5

225
East
Own
5
25K-50K
$ 63
7

226
West
Own
4
25K-50K
$ 56
8

227
North
Rent
3
10K-25K
$ 67
6

228
East
Rent
4
50K-100K
$ 60
8

229
North
Own
6
25K-50K
$ 50
9

230
East
Own
5
50K-100K
$ 49
3

231
West
Own
4
100K+
$ 56
4

232
North
Rent
2
50K-100K
$ 60
7

233
South
Rent
3
50K-100K
$ 59
2

234
East
Own
1
50K-100K
$ 59
8

235
North
Rent
7
50K-100K
$ 60
5

236
West
Rent
3
50K-100K
$ 68
7

237
South
Rent
4
25K-50K
$ 84
9

238
South
Rent
2
25K-50K
$ 69
2

239
West
Rent
5
100K+
$ 97
5

240
North
Own
3
10K-25K
$ 61
4

241
East
Own
4
100K+
$ 75
6

242
West
Own
5
100K+
$ 76
11

243
North
Rent
6
100K+
$ 98
8

244
East
Own
4
25K-50K
$ 95
5

245
South
Own
5
25K-50K
$ 59
7

246
West
Rent
6
50K-100K
$ 44
4

247
North
Rent
7
50K-100K
$ 97
3

248
East
Own
4
100K+
$ 68
6

249
South
Rent
3
25K-50K
$ 145
10

250
West
Rent
2
50K-100K
$ 119
3

251
North
Rent
1
10K-25K
$ 129
6

252
East
Own
5
50K-100K
$ 99
8

253
South
Own
4
25K-50K
$ 119
6

254
West
Own
6
25K-50K
$ 185
8

255
East
Rent
3
25K-50K
$ 119
10

256
East
Own
2
50K-100K
$ 99
3

257
North
Rent
1
100K+
$ 60
6

258
North
Own
5
50K-100K
$ 50
5

259
West
Own
4
25K-50K
$ 49
8

260
West
Rent
6
50K-100K
$ 56
4

261
East
Own
7
50K-100K
$ 60
7

262
North
Rent
3
100K+
$ 59
3

263
East
Rent
2
100K+
$ 59
2

264
South
Own
4
100K+
$ 60
6

265
East
Rent
5
25K-50K
$ 68
5

266
North
Rent
3
50K-100K
$ 84
8

267
South
Own
2
50K-100K
$ 69
9

268
West
Own
4
100K+
$ 97
3

269
East
Rent
3
10K-25K
$ 61
2

270
West
Own
4
50K-100K
$ 75
6

271
North
Rent
3
50K-100K
$ 76
5

272
East
Rent
4
25K-50K
$ 98
7

273
North
Own
5
25K-50K
$ 95
9

274
East
Rent
4
50K-100K
$ 59
4

275
West
Rent
6
100K+
$ 44
6

276
North
Rent
5
50K-100K
$ 97
8

277
South
Rent
7
100K+
$ 68
7

278
East
Rent
1
100K+
$ 145
1

279
North
Own
2
100K+
$ 85
10

280
West
Own
3
25K-50K
$ 59
3

281
South
Rent
4
50K-100K
$ 84
7

282
South
Own
3
50K-100K
$ 28
5

283
South
Rent
5
100K+
$ 26
8

284
East
Own
3
10K-25K
$ 31
9

285
North
Rent
3
100K+
$ 19
3

286
West
Own
2
25K-50K
$ 30
2

287
East
Rent
4
50K-100K
$ 29
11

288
South
Rent
5
10K-25K
$ 25
6

289
West
Rent
6
50K-100K
$ 24
3

290
East
Own
5
25K-50K
$ 36
6

291
South
Own
4
25K-50K
$ 29
7

292
North
Own
3
25K-50K
$ 99
9

293
East
Rent
5
50K-100K
$ 169
8

294
West
Rent
4
100K+
$ 179
3

295
South
Rent
6
50K-100K
$ 119
5

296
East
Own
4
25K-50K
$ 99
4

297
North
Rent
6
50K-100K
$ 56
6

298
East
Rent
1
50K-100K
$ 50
11

299
South
Rent
2
100K+
$ 86
10

300
North
Rent
3
100K+
$ 45
3

301
East
Rent
4
100K+
$ 95
2

302
South
Rent
7
25K-50K
$ 86
10

303
West
Own
4
50K-100K
$ 97
11

304
West
Rent
3
50K-100K
$ 40
7

305
East
Rent
1
100K+
$ 50
5

306
South
Rent
4
10K-25K
$ 59
9

307
West
Own
2
100K+
$ 75
4

308
East
Own
5
25K-50K
$ 68
3

309
North
Rent
3
25K-50K
$ 26
2

310
East
Own
6
50K-100K
$ 15
6

311
South
Own
4
50K-100K
$ 18
8

312
East
Rent
7
50K-100K
$ 28
6

313
North
Own
3
100K+
$ 24
8

314
South
Rent
2
10K-25K
$ 30
9

315
West
Own
4
50K-100K
$ 30
10

316
East
Own
5
50K-100K
$ 23
3

317
West
Rent
3
25K-50K
$ 28
2

318
North
Rent
1
25K-50K
$ 21
6

319
East
Rent
4
50K-100K
$ 28
5

320
North
Rent
3
10K-25K
$ 22
8

321
East
Own
5
100K+
$ 28
7

322
West
Own
6
100K+
$ 30
9

323
North
Rent
4
10K-25K
$ 28
4

324
South
Rent
2
100K+
$ 25
6

325
East
Own
5
50K-100K
$ 29
3

326
North
Own
3
50K-100K
$ 28
5

327
West
Rent
5
25K-50K
$ 30
3

328
South
Rent
6
25K-50K
$ 19
6

329
South
Own
4
10K-25K
$ 30
5

330
West
Own
3
50K-100K
$ 149
7

331
North
Own
5
25K-50K
$ 155
9

332
East
Own
6
50K-100K
$ 115
4

333
West
Rent
4
100K+
$ 39
6

334
North
Own
6
50K-100K
$ 95
8

335
East
Own
4
50K-100K
$ 86
7

336
South
Own
7
50K-100K
$ 85
1

337
West
Own
4
50K-100K
$ 59
10

338
North
Own
3
50K-100K
$ 84
3

339
East
Rent
1
25K-50K
$ 28
7

340
South
Own
2
25K-50K
$ 26
5

341
West
Own
5
100K+
$ 31
8

342
North
Own
3
10K-25K
$ 19
9

343
East
Rent
4
100K+
$ 30
3

344
South
Rent
6
100K+
$ 29
2

345
West
Own
5
100K+
$ 25
11

346
East
Own
3
25K-50K
$ 24
6

347
East
Own
2
25K-50K
$ 36
3

348
North
Own
1
50K-100K
$ 29
6

349
North
Rent
6
50K-100K
$ 99
7

350
West
Rent
7
50K-100K
$ 169
9

351
West
Rent
2
50K-100K
$ 179
8

352
East
Own
1
10K-25K
$ 119
3

353
North
Rent
2
100K+
$ 99
5

354
East
Own
3
10K-25K
$ 179
4

355
South
Own
2
100K+
$ 185
6

356
East
Rent
1
50K-100K
$ 179
11

357
North
Own
3
50K-100K
$ 145
10

358
South
Own
4
25K-50K
$ 119
3

359
West
Own
6
25K-50K
$ 99
2

360
East
Rent
5
10K-25K
$ 155
10

361
West
Rent
4
50K-100K
$ 119
11

362
North
Own
3
25K-50K
$ 149
7

363
East
Own
5
50K-100K
$ 56
5

364
North
Own
6
100K+
$ 50
9

365
East
Own
7
50K-100K
$ 86
4

366
North
Rent
5
50K-100K
$ 45
3

367
South
Rent
6
50K-100K
$ 95
2

368
North
Rent
3
50K-100K
$ 86
6

369
West
Own
4
50K-100K
$ 97
8

370
East
Rent
5
25K-50K
$ 23
6

371
South
Own
2
25K-50K
$ 29
8

372
East
Rent
3
100K+
$ 18
9

373
West
Own
6
10K-25K
$ 26
10

374
North
Own
2
100K+
$ 20
3

375
West
Own
5
100K+
$ 15
2

376
North
Rent
4
100K+
$ 40
6

377
East
Rent
1
25K-50K
$ 41
5

378
South
Own
4
25K-50K
$ 24
8

379
South
Rent
3
50K-100K
$ 26
7

380
South
Own
5
10K-25K
$ 25
9

381
West
Own
6
25K-50K
$ 26
4

382
North
Own
4
50K-100K
$ 23
6

383
East
Rent
2
50K-100K
$ 27
7

384
West
Own
5
25K-50K
$ 25
5

385
North
Rent
3
25K-50K
$ 18
3

386
East
Own
5
25K-50K
$ 24
6

387
South
Own
6
10K-25K
$ 21
8

388
West
Own
4
100K+
$ 40
2

389
North
Own
3
100K+
$ 19
4

390
South
Rent
5
10K-25K
$ 30
9

391
West
Own
6
25K-50K
$ 35
7

392
East
Own
4
25K-50K
$ 24
10

393
East
Rent
6
25K-50K
$ 26
2

394
North
Own
4
50K-100K
$ 15
6

395
North
Rent
7
50K-100K
$ 18
5

396
West
Own
4
25K-50K
$ 28
7

397
West
Own
3
50K-100K
$ 24
4

398
East
Rent
1
50K-100K
$ 30
3

399
North
Rent
2
100K+
$ 30
2

400
East
Rent
5
25K-50K
$ 23
8

401
South
Own
3
25K-50K
$ 28
6

402
East
Rent
4
10K-25K
$ 21
7

403
North
Own
6
25K-50K
$ 28
5

404
South
Own
5
100K+
$ 22
3

405
West
Rent
3
50K-100K
$ 28
6

406
East
Own
2
50K-100K
$ 30
8

407
West
Rent
1
25K-50K
$ 28
1

408
North
Own
6
25K-50K
$ 25
8

409
East
Own
7
50K-100K
$ 29
6

410
North
Rent
2
50K-100K
$ 28
4

411
East
Rent
1
25K-50K
$ 30
7

412
North
Own
2
50K-100K
$ 19
3

413
South
Own
3
50K-100K
$ 30
1

414
North
Own
2
25K-50K
$ 149
4

415
West
Own
1
50K-100K
$ 155
1

416
East
Rent
3
10K-25K
$ 115
4

417
South
Own
4
100K+
$ 119
6

418
East
Own
6
50K-100K
$ 99
5

419
West
Own
5
50K-100K
$ 119
3

420
North
Own
4
25K-50K
$ 149
7

421
West
Own
3
25K-50K
$ 145
6

422
North
Rent
5
25K-50K
$ 119
8

423
East
Own
6
10K-25K
$ 129
9

424
West
Own
7
100K+
$ 99
10

425
North
Own
5
100K+
$ 119
2

426
East
Rent
6
10K-25K
$ 185
6

427
South
Rent
3
25K-50K
$ 119
4

428
West
Own
4
25K-50K
$ 99
7

429
North
Own
5
25K-50K
$ 109
5

430
East
Own
2
50K-100K
$ 179
8

431
South
Own
3
50K-100K
$ 169
9

432
West
Rent
5
25K-50K
$ 179
2

433
North
Rent
4
50K-100K
$ 145
5

434
East
Rent
6
50K-100K
$ 119
4

435
South
Own
7
100K+
$ 165
3

436
West
Rent
2
25K-50K
$ 129
11

437
East
Own
3
25K-50K
$ 159
7

438
East
Own
1
10K-25K
$ 37
4

439
North
Rent
3
25K-50K
$ 55
6

440
North
Own
5
25K-50K
$ 63
5

441
West
Own
4
25K-50K
$ 56
9

442
West
Own
6
50K-100K
$ 67
2

443
East
Rent
7
50K-100K
$ 60
5

444
North
Rent
2
50K-100K
$ 50
3

445
East
Own
3
25K-50K
$ 49
6

446
South
Own
4
10K-25K
$ 56
8

447
East
Own
5
25K-50K
$ 60
4

448
North
Own
3
100K+
$ 59
7

449
South
Rent
4
10K-25K
$ 59
5

450
West
Rent
1
25K-50K
$ 60
1

451
East
Rent
3
50K-100K
$ 68
10

452
South
Own
4
50K-100K
$ 84
11

453
North
Rent
5
25K-50K
$ 69
11

454
West
Own
6
25K-50K
$ 97
11

455
East
Rent
7
50K-100K
$ 61
3

456
South
Own
6
10K-25K
$ 75
6

457
East
Own
7
100K+
$ 76
4

458
West
Own
4
100K+
$ 98
7

459
North
Rent
3
100K+
$ 95
9

460
West
Rent
5
50K-100K
$ 59
3

461
North
Own
2
50K-100K
$ 44
2

462
East
Rent
3
100K+
$ 97
6

463
West
Own
4
10K-25K
$ 68
5

464
North
Own
6
100K+
$ 145
8

465
East
Own
4
25K-50K
$ 119
7

466
South
Rent
5
50K-100K
$ 129
2

467
West
Own
3
10K-25K
$ 99
4

468
North
Rent
2
50K-100K
$ 119
3

469
North
Own
6
10K-25K
$ 185
6

470
East
Own
3
100K+
$ 119
9

471
West
Own
1
25K-50K
$ 99
10

472
South
Own
4
50K-100K
$ 60
11

473
East
Rent
3
10K-25K
$ 50
4

474
West
Rent
5
50K-100K
$ 49
2

475
South
Own
6
25K-50K
$ 56
1

476
East
Own
3
25K-50K
$ 60
5

477
North
Own
2
25K-50K
$ 59
4

478
East
Own
4
50K-100K
$ 59
7

479
North
Rent
5
100K+
$ 60
8

480
West
Rent
7
50K-100K
$ 68
9

481
East
Rent
2
25K-50K
$ 84
1

482
West
Own
1
50K-100K
$ 69
7

483
South
Rent
2
50K-100K
$ 97
4

484
North
Own
1
25K-50K
$ 61
6

485
East
Rent
3
50K-100K
$ 75
5

486
East
Own
6
50K-100K
$ 76
9

487
West
Own
4
50K-100K
$ 98
2

Question 2

CUST ID
REGION
RENT VS. OWN
NUM HOUSEHOLD
ANNUAL INCOME
TOTAL PURCHASES
NUM PURCHASES

1
North
Own
1
10K-25K
$ 38
1

2
South
Own
4
100K+
$ 30
4

3
North
Rent
3
25K-50K
$ 19
3

4
West
Own
5
25K-50K
$ 21
6

5
East
Own
6
50K-100K
$ 35
7

6
South
Own
2
10K-25K
$ 27
5

7
East
Own
3
100K+
$ 26
3

8
West
Rent
4
25K-50K
$ 25
6

9
North
Own
5
50K-100K
$ 30
8

10
West
Rent
7
25K-50K
$ 26
2

11
North
Own
1
50K-100K
$ 21
4

12
East
Own
2
100K+
$ 29
9

13
South
Own
5
10K-25K
$ 20
7

14
South
Own
4
25K-50K
$ 27
10

15
South
Rent
3
50K-100K
$ 19
2

16
West
Own
5
25K-50K
$ 19
6

17
North
Own
6
50K-100K
$ 129
5

18
East
Rent
2
10K-25K
$ 99
7

19
West
Own
3
25K-50K
$ 99
4

20
North
Rent
1
50K-100K
$ 119
3

21
East
Own
4
50K-100K
$ 149
2

22
South
Own
3
50K-100K
$ 165
8

23
West
Rent
5
25K-50K
$ 119
6

24
North
Rent
6
10K-25K
$ 129
7

25
East
Rent
7
100K+
$ 165
5

26
South
Own
3
10K-25K
$ 99
3

27
West
Rent
2
25K-50K
$ 155
6

28
North
Own
4
50K-100K
$ 115
8

29
East
Own
5
50K-100K
$ 129
1

30
South
Rent
4
50K-100K
$ 99
8

31
West
Own
2
25K-50K
$ 169
6

32
East
Rent
3
25K-50K
$ 40
4

33
East
Own
1
50K-100K
$ 36
7

34
North
Own
6
100K+
$ 45
3

35
North
Own
5
10K-25K
$ 29
1

36
West
Rent
4
100K+
$ 28
4

37
East
Rent
1
25K-50K
$ 46
1

38
South
Rent
5
50K-100K
$ 50
4

39
East
Rent
3
50K-100K
$ 22
6

40
West
Own
6
50K-100K
$ 20
9

41
North
Own
7
25K-50K
$ 19
3

42
East
Own
3
50K-100K
$ 31
1

43
South
Rent
2
50K-100K
$ 30
10

44
West
Rent
4
25K-50K
$ 18
3

45
East
Own
5
25K-50K
$ 31
7

46
South
Own
3
10K-25K
$ 35
6

47
West
Own
7
25K-50K
$ 28
5

48
East
Rent
3
100K+
$ 29
8

49
South
Rent
2
10K-25K
$ 35
6

50
North
Own
6
25K-50K
$ 30
4

51
South
Own
5
50K-100K
$ 38
7

52
West
Own
3
50K-100K
$ 20
3

53
North
Rent
1
25K-50K
$ 40
5

54
East
Rent
5
25K-50K
$ 30
4

55
South
Own
6
25K-50K
$ 40
8

56
West
Rent
3
10K-25K
$ 62
7

57
North
Rent
4
100K+
$ 22
9

58
East
Rent
5
100K+
$ 25
1

59
West
Rent
7
10K-25K
$ 27
4

60
East
Rent
2
25K-50K
$ 22
7

61
South
Own
3
25K-50K
$ 30
4

62
East
Own
1
25K-50K
$ 31
3

63
East
Own
4
50K-100K
$ 22
8

64
South
Rent
2
50K-100K
$ 25
9

65
West
Own
3
25K-50K
$ 24
3

66
East
Own
5
50K-100K
$ 36
2

67
North
Rent
4
50K-100K
$ 123
11

68
North
Rent
6
100K+
$ 19
2

69
North
Own
5
100K+
$ 23
6

70
South
Rent
7
100K+
$ 19
8

71
West
Rent
4
25K-50K
$ 25
6

72
West
Rent
5
50K-100K
$ 129
8

73
North
Own
3
50K-100K
$ 119
9

74
East
Own
6
100K+
$ 109
3

75
North
Own
5
10K-25K
$ 179
6

76
East
Rent
4
100K+
$ 145
5

77
South
Own
2
25K-50K
$ 119
7

78
North
Rent
3
50K-100K
$ 129
2

79
East
Own
4
10K-25K
$ 189
4

80
West
Own
6
50K-100K
$ 155
6

81
North
Rent
5
25K-50K
$ 78
4

82
East
Own
4
25K-50K
$ 61
5

83
South
Rent
3
25K-50K
$ 97
7

84
North
Rent
2
50K-100K
$ 63
2

85
West
Own
4
100K+
$ 39
3

86
East
Rent
6
50K-100K
$ 95
1

87
South
Rent
4
25K-50K
$ 86
7

88
West
Own
1
50K-100K
$ 85
5

89
East
Own
2
50K-100K
$ 59
7

90
North
Rent
3
100K+
$ 84
9

91
North
Own
2
100K+
$ 144
10

92
West
Rent
3
100K+
$ 26
1

93
South
Rent
7
25K-50K
$ 31
1

94
East
Own
6
50K-100K
$ 19
1

95
South
Rent
5
50K-100K
$ 30
1

96
West
Rent
4
100K+
$ 29
11

97
West
Rent
5
10K-25K
$ 25
2

98
West
Rent
6
100K+
$ 24
6

99
East
Rent
3
25K-50K
$ 36
5

100
North
Own
4
50K-100K
$ 29
7

101
South
Own
2
10K-25K
$ 99
9

102
West
Rent
1
50K-100K
$ 169
3

103
East
Own
3
10K-25K
$ 179
1

104
North
Rent
4
100K+
$ 119
7

105
South
Own
5
25K-50K
$ 99
4

106
West
Rent
4
50K-100K
$ 179
7

107
East
Own
6
10K-25K
$ 185
6

108
North
Rent
3
50K-100K
$ 179
8

109
South
Rent
4
25K-50K
$ 145
9

110
West
Rent
5
25K-50K
$ 119
3

111
North
Own
7
25K-50K
$ 99
2

112
North
Own
2
50K-100K
$ 155
5

113
East
Own
3
100K+
$ 119
4

114
North
Rent
5
50K-100K
$ 149
7

115
East
Rent
3
25K-50K
$ 56
5

116
North
Rent
2
50K-100K
$ 50
6

117
West
Own
4
50K-100K
$ 86
3

118
South
Rent
2
100K+
$ 45
2

119
East
Rent
1
100K+
$ 95
6

120
West
Rent
3
100K+
$ 86
8

121
South
Rent
2
25K-50K
$ 97
11

122
East
Rent
4
50K-100K
$ 40
8

123
North
Rent
5
50K-100K
$ 50
5

124
East
Own
6
100K+
$ 59
3

125
North
Rent
3
10K-25K
$ 75
4

126
South
Rent
4
50K-100K
$ 68
3

127
West
Rent
6
50K-100K
$ 63
1

128
North
Own
2
25K-50K
$ 56
10

129
East
Own
4
25K-50K
$ 86
2

130
North
Rent
6
50K-100K
$ 45
6

131
West
Own
3
100K+
$ 78
8

132
South
Own
4
10K-25K
$ 68
7

133
East
Rent
7
100K+
$ 95
6

134
North
Own
4
25K-50K
$ 95
4

135
East
Rent
5
50K-100K
$ 39
7

136
East
Own
6
50K-100K
$ 56
8

137
North
Own
2
50K-100K
$ 31
9

138
South
Rent
3
25K-50K
$ 29
6

139
West
Rent
4
50K-100K
$ 41
7

140
East
Rent
5
50K-100K
$ 62
4

141
North
Rent
1
25K-50K
$ 51
3

142
South
Own
2
25K-50K
$ 37
2

143
West
Own
3
10K-25K
$ 19
6

144
East
Rent
4
25K-50K
$ 38
5

145
North
Rent
5
100K+
$ 56
7

146
East
Own
4
100K+
$ 41
5

147
West
Own
3
25K-50K
$ 51
8

148
North
Rent
6
50K-100K
$ 19
4

149
East
Rent
2
10K-25K
$ 29
3

150
North
Own
4
50K-100K
$ 41
5

151
East
Own
3
25K-50K
$ 19
6

152
West
Own
3
25K-50K
$ 30
7

153
North
Own
5
25K-50K
$ 19
8

154
South
Rent
4
50K-100K
$ 21
3

155
East
Own
6
100K+
$ 23
2

156
North
Own
7
50K-100K
$ 29
5

157
West
Own
2
25K-50K
$ 18
2

158
East
Own
3
50K-100K
$ 26
5

159
South
Own
1
50K-100K
$ 20
1

160
West
Rent
2
100K+
$ 76
11

161
East
Own
4
100K+
$ 40
4

162
South
Own
2
100K+
$ 41
3

163
North
Own
4
25K-50K
$ 24
7

164
East
Rent
5
50K-100K
$ 26
5

165
West
Rent
6
50K-100K
$ 25
8

166
South
Own
4
100K+
$ 26
6

167
East
Own
2
10K-25K
$ 23
8

168
North
Own
4
50K-100K
$ 27
5

169
East
Own
3
50K-100K
$ 25
8

170
South
Rent
5
25K-50K
$ 34
10

171
West
Rent
4
25K-50K
$ 24
7

172
West
Rent
6
50K-100K
$ 21
9

173
East
Own
4
100K+
$ 40
8

174
South
Rent
3
50K-100K
$ 19
1

175
West
Own
1
100K+
$ 30
11

176
East
Rent
2
100K+
$ 35
10

177
North
Own
4
100K+
$ 24
1

178
East
Own
7
25K-50K
$ 26
4

179
South
Own
4
50K-100K
$ 15
1

180
East
Rent
6
50K-100K
$ 18
3

181
North
Rent
3
100K+
$ 28
1

182
South
Own
7
10K-25K
$ 24
4

183
West
Rent
2
100K+
$ 30
5

184
East
Own
1
25K-50K
$ 30
4

185
West
Own
4
50K-100K
$ 23
7

186
North
Own
5
10K-25K
$ 28
5

187
East
Rent
3
50K-100K
$ 21
6

188
North
Own
2
25K-50K
$ 28
4

189
East
Rent
4
25K-50K
$ 22
2

190
West
Own
5
25K-50K
$ 28
6

191
North
Own
2
50K-100K
$ 30
8

192
South
Own
1
100K+
$ 28
9

193
East
Own
4
50K-100K
$ 25
10

194
North
Rent
2
25K-50K
$ 29
3

195
West
Own
5
50K-100K
$ 28
6

196
East
Own
3
50K-100K
$ 30
5

197
South
Rent
6
100K+
$ 19
4

198
West
Own
5
100K+
$ 30
6

199
East
Rent
7
100K+
$ 149
8

200
South
Own
4
25K-50K
$ 155
7

201
North
Own
5
50K-100K
$ 115
4

202
East
Rent
6
50K-100K
$ 119
5

203
West
Rent
3
100K+
$ 99
7

204
South
Rent
2
10K-25K
$ 119
8

205
East
Own
4
100K+
$ 149
9

206
North
Rent
5
25K-50K
$ 145
11

207
East
Own
3
25K-50K
$ 119
8

208
South
Own
5
50K-100K
$ 129
5

209
North
Rent
4
50K-100K
$ 99
7

210
East
Own
6
50K-100K
$ 119
8

211
South
Rent
4
100K+
$ 185
9

212
West
Own
5
10K-25K
$ 119
5

213
West
Own
6
50K-100K
$ 99
2

214
East
Own
7
50K-100K
$ 109
6

215
South
Rent
1
25K-50K
$ 179
8

216
West
Rent
3
25K-50K
$ 169
6

217
East
Rent
2
50K-100K
$ 179
9

218
North
Rent
5
10K-25K
$ 145
7

219
East
Own
4
100K+
$ 119
6

220
South
Own
6
100K+
$ 165
3

221
East
Own
7
10K-25K
$ 129
2

222
North
Rent
3
100K+
$ 159
11

223
South
Rent
2
50K-100K
$ 37
7

224
West
Own
4
50K-100K
$ 55
5

225
East
Own
5
25K-50K
$ 63
7

226
West
Own
4
25K-50K
$ 56
8

227
North
Rent
3
10K-25K
$ 67
6

228
East
Rent
4
50K-100K
$ 60
8

229
North
Own
6
25K-50K
$ 50
9

230
East
Own
5
50K-100K
$ 49
3

231
West
Own
4
100K+
$ 56
4

232
North
Rent
2
50K-100K
$ 60
7

233
South
Rent
3
50K-100K
$ 59
2

234
East
Own
1
50K-100K
$ 59
8

235
North
Rent
7
50K-100K
$ 60
5

236
West
Rent
3
50K-100K
$ 68
7

237
South
Rent
4
25K-50K
$ 84
9

238
South
Rent
2
25K-50K
$ 69
2

239
West
Rent
5
100K+
$ 97
5

240
North
Own
3
10K-25K
$ 61
4

241
East
Own
4
100K+
$ 75
6

242
West
Own
5
100K+
$ 76
11

243
North
Rent
6
100K+
$ 98
8

244
East
Own
4
25K-50K
$ 95
5

245
South
Own
5
25K-50K
$ 59
7

246
West
Rent
6
50K-100K
$ 44
4

247
North
Rent
7
50K-100K
$ 97
3

248
East
Own
4
100K+
$ 68
6

249
South
Rent
3
25K-50K
$ 145
10

250
West
Rent
2
50K-100K
$ 119
3

251
North
Rent
1
10K-25K
$ 129
6

252
East
Own
5
50K-100K
$ 99
8

253
South
Own
4
25K-50K
$ 119
6

254
West
Own
6
25K-50K
$ 185
8

255
East
Rent
3
25K-50K
$ 119
10

256
East
Own
2
50K-100K
$ 99
3

257
North
Rent
1
100K+
$ 60
6

258
North
Own
5
50K-100K
$ 50
5

259
West
Own
4
25K-50K
$ 49
8

260
West
Rent
6
50K-100K
$ 56
4

261
East
Own
7
50K-100K
$ 60
7

262
North
Rent
3
100K+
$ 59
3

263
East
Rent
2
100K+
$ 59
2

264
South
Own
4
100K+
$ 60
6

265
East
Rent
5
25K-50K
$ 68
5

266
North
Rent
3
50K-100K
$ 84
8

267
South
Own
2
50K-100K
$ 69
9

268
West
Own
4
100K+
$ 97
3

269
East
Rent
3
10K-25K
$ 61
2

270
West
Own
4
50K-100K
$ 75
6

271
North
Rent
3
50K-100K
$ 76
5

272
East
Rent
4
25K-50K
$ 98
7

273
North
Own
5
25K-50K
$ 95
9

274
East
Rent
4
50K-100K
$ 59
4

275
West
Rent
6
100K+
$ 44
6

276
North
Rent
5
50K-100K
$ 97
8

277
South
Rent
7
100K+
$ 68
7

278
East
Rent
1
100K+
$ 145
1

279
North
Own
2
100K+
$ 85
10

280
West
Own
3
25K-50K
$ 59
3

281
South
Rent
4
50K-100K
$ 84
7

282
South
Own
3
50K-100K
$ 28
5

283
South
Rent
5
100K+
$ 26
8

284
East
Own
3
10K-25K
$ 31
9

285
North
Rent
3
100K+
$ 19
3

286
West
Own
2
25K-50K
$ 30
2

287
East
Rent
4
50K-100K
$ 29
11

288
South
Rent
5
10K-25K
$ 25
6

289
West
Rent
6
50K-100K
$ 24
3

290
East
Own
5
25K-50K
$ 36
6

291
South
Own
4
25K-50K
$ 29
7

292
North
Own
3
25K-50K
$ 99
9

293
East
Rent
5
50K-100K
$ 169
8

294
West
Rent
4
100K+
$ 179
3

295
South
Rent
6
50K-100K
$ 119
5

296
East
Own
4
25K-50K
$ 99
4

297
North
Rent
6
50K-100K
$ 56
6

298
East
Rent
1
50K-100K
$ 50
11

299
South
Rent
2
100K+
$ 86
10

300
North
Rent
3
100K+
$ 45
3

301
East
Rent
4
100K+
$ 95
2

302
South
Rent
7
25K-50K
$ 86
10

303
West
Own
4
50K-100K
$ 97
11

304
West
Rent
3
50K-100K
$ 40
7

305
East
Rent
1
100K+
$ 50
5

306
South
Rent
4
10K-25K
$ 59
9

307
West
Own
2
100K+
$ 75
4

308
East
Own
5
25K-50K
$ 68
3

309
North
Rent
3
25K-50K
$ 26
2

310
East
Own
6
50K-100K
$ 15
6

311
South
Own
4
50K-100K
$ 18
8

312
East
Rent
7
50K-100K
$ 28
6

313
North
Own
3
100K+
$ 24
8

314
South
Rent
2
10K-25K
$ 30
9

315
West
Own
4
50K-100K
$ 30
10

316
East
Own
5
50K-100K
$ 23
3

317
West
Rent
3
25K-50K
$ 28
2

318
North
Rent
1
25K-50K
$ 21
6

319
East
Rent
4
50K-100K
$ 28
5

320
North
Rent
3
10K-25K
$ 22
8

321
East
Own
5
100K+
$ 28
7

322
West
Own
6
100K+
$ 30
9

323
North
Rent
4
10K-25K
$ 28
4

324
South
Rent
2
100K+
$ 25
6

325
East
Own
5
50K-100K
$ 29
3

326
North
Own
3
50K-100K
$ 28
5

327
West
Rent
5
25K-50K
$ 30
3

328
South
Rent
6
25K-50K
$ 19
6

329
South
Own
4
10K-25K
$ 30
5

330
West
Own
3
50K-100K
$ 149
7

331
North
Own
5
25K-50K
$ 155
9

332
East
Own
6
50K-100K
$ 115
4

333
West
Rent
4
100K+
$ 39
6

334
North
Own
6
50K-100K
$ 95
8

335
East
Own
4
50K-100K
$ 86
7

336
South
Own
7
50K-100K
$ 85
1

337
West
Own
4
50K-100K
$ 59
10

338
North
Own
3
50K-100K
$ 84
3

339
East
Rent
1
25K-50K
$ 28
7

340
South
Own
2
25K-50K
$ 26
5

341
West
Own
5
100K+
$ 31
8

342
North
Own
3
10K-25K
$ 19
9

343
East
Rent
4
100K+
$ 30
3

344
South
Rent
6
100K+
$ 29
2

345
West
Own
5
100K+
$ 25
11

346
East
Own
3
25K-50K
$ 24
6

347
East
Own
2
25K-50K
$ 36
3

348
North
Own
1
50K-100K
$ 29
6

349
North
Rent
6
50K-100K
$ 99
7

350
West
Rent
7
50K-100K
$ 169
9

351
West
Rent
2
50K-100K
$ 179
8

352
East
Own
1
10K-25K
$ 119
3

353
North
Rent
2
100K+
$ 99
5

354
East
Own
3
10K-25K
$ 179
4

355
South
Own
2
100K+
$ 185
6

356
East
Rent
1
50K-100K
$ 179
11

357
North
Own
3
50K-100K
$ 145
10

358
South
Own
4
25K-50K
$ 119
3

359
West
Own
6
25K-50K
$ 99
2

360
East
Rent
5
10K-25K
$ 155
10

361
West
Rent
4
50K-100K
$ 119
11

362
North
Own
3
25K-50K
$ 149
7

363
East
Own
5
50K-100K
$ 56
5

364
North
Own
6
100K+
$ 50
9

365
East
Own
7
50K-100K
$ 86
4

366
North
Rent
5
50K-100K
$ 45
3

367
South
Rent
6
50K-100K
$ 95
2

368
North
Rent
3
50K-100K
$ 86
6

369
West
Own
4
50K-100K
$ 97
8

370
East
Rent
5
25K-50K
$ 23
6

371
South
Own
2
25K-50K
$ 29
8

372
East
Rent
3
100K+
$ 18
9

373
West
Own
6
10K-25K
$ 26
10

374
North
Own
2
100K+
$ 20
3

375
West
Own
5
100K+
$ 15
2

376
North
Rent
4
100K+
$ 40
6

377
East
Rent
1
25K-50K
$ 41
5

378
South
Own
4
25K-50K
$ 24
8

379
South
Rent
3
50K-100K
$ 26
7

380
South
Own
5
10K-25K
$ 25
9

381
West
Own
6
25K-50K
$ 26
4

382
North
Own
4
50K-100K
$ 23
6

383
East
Rent
2
50K-100K
$ 27
7

384
West
Own
5
25K-50K
$ 25
5

385
North
Rent
3
25K-50K
$ 18
3

386
East
Own
5
25K-50K
$ 24
6

387
South
Own
6
10K-25K
$ 21
8

388
West
Own
4
100K+
$ 40
2

389
North
Own
3
100K+
$ 19
4

390
South
Rent
5
10K-25K
$ 30
9

391
West
Own
6
25K-50K
$ 35
7

392
East
Own
4
25K-50K
$ 24
10

393
East
Rent
6
25K-50K
$ 26
2

394
North
Own
4
50K-100K
$ 15
6

395
North
Rent
7
50K-100K
$ 18
5

396
West
Own
4
25K-50K
$ 28
7

397
West
Own
3
50K-100K
$ 24
4

398
East
Rent
1
50K-100K
$ 30
3

399
North
Rent
2
100K+
$ 30
2

400
East
Rent
5
25K-50K
$ 23
8

401
South
Own
3
25K-50K
$ 28
6

402
East
Rent
4
10K-25K
$ 21
7

403
North
Own
6
25K-50K
$ 28
5

404
South
Own
5
100K+
$ 22
3

405
West
Rent
3
50K-100K
$ 28
6

406
East
Own
2
50K-100K
$ 30
8

407
West
Rent
1
25K-50K
$ 28
1

408
North
Own
6
25K-50K
$ 25
8

409
East
Own
7
50K-100K
$ 29
6

410
North
Rent
2
50K-100K
$ 28
4

411
East
Rent
1
25K-50K
$ 30
7

412
North
Own
2
50K-100K
$ 19
3

413
South
Own
3
50K-100K
$ 30
1

414
North
Own
2
25K-50K
$ 149
4

415
West
Own
1
50K-100K
$ 155
1

416
East
Rent
3
10K-25K
$ 115
4

417
South
Own
4
100K+
$ 119
6

418
East
Own
6
50K-100K
$ 99
5

419
West
Own
5
50K-100K
$ 119
3

420
North
Own
4
25K-50K
$ 149
7

421
West
Own
3
25K-50K
$ 145
6

422
North
Rent
5
25K-50K
$ 119
8

423
East
Own
6
10K-25K
$ 129
9

424
West
Own
7
100K+
$ 99
10

425
North
Own
5
100K+
$ 119
2

426
East
Rent
6
10K-25K
$ 185
6

427
South
Rent
3
25K-50K
$ 119
4

428
West
Own
4
25K-50K
$ 99
7

429
North
Own
5
25K-50K
$ 109
5

430
East
Own
2
50K-100K
$ 179
8

431
South
Own
3
50K-100K
$ 169
9

432
West
Rent
5
25K-50K
$ 179
2

433
North
Rent
4
50K-100K
$ 145
5

434
East
Rent
6
50K-100K
$ 119
4

435
South
Own
7
100K+
$ 165
3

436
West
Rent
2
25K-50K
$ 129
11

437
East
Own
3
25K-50K
$ 159
7

438
East
Own
1
10K-25K
$ 37
4

439
North
Rent
3
25K-50K
$ 55
6

440
North
Own
5
25K-50K
$ 63
5

441
West
Own
4
25K-50K
$ 56
9

442
West
Own
6
50K-100K
$ 67
2

443
East
Rent
7
50K-100K
$ 60
5

444
North
Rent
2
50K-100K
$ 50
3

445
East
Own
3
25K-50K
$ 49
6

446
South
Own
4
10K-25K
$ 56
8

447
East
Own
5
25K-50K
$ 60
4

448
North
Own
3
100K+
$ 59
7

449
South
Rent
4
10K-25K
$ 59
5

450
West
Rent
1
25K-50K
$ 60
1

451
East
Rent
3
50K-100K
$ 68
10

452
South
Own
4
50K-100K
$ 84
11

453
North
Rent
5
25K-50K
$ 69
11

454
West
Own
6
25K-50K
$ 97
11

455
East
Rent
7
50K-100K
$ 61
3

456
South
Own
6
10K-25K
$ 75
6

457
East
Own
7
100K+
$ 76
4

458
West
Own
4
100K+
$ 98
7

459
North
Rent
3
100K+
$ 95
9

460
West
Rent
5
50K-100K
$ 59
3

461
North
Own
2
50K-100K
$ 44
2

462
East
Rent
3
100K+
$ 97
6

463
West
Own
4
10K-25K
$ 68
5

464
North
Own
6
100K+
$ 145
8

465
East
Own
4
25K-50K
$ 119
7

466
South
Rent
5
50K-100K
$ 129
2

467
West
Own
3
10K-25K
$ 99
4

468
North
Rent
2
50K-100K
$ 119
3

469
North
Own
6
10K-25K
$ 185
6

470
East
Own
3
100K+
$ 119
9

471
West
Own
1
25K-50K
$ 99
10

472
South
Own
4
50K-100K
$ 60
11

473
East
Rent
3
10K-25K
$ 50
4

474
West
Rent
5
50K-100K
$ 49
2

475
South
Own
6
25K-50K
$ 56
1

476
East
Own
3
25K-50K
$ 60
5

477
North
Own
2
25K-50K
$ 59
4

478
East
Own
4
50K-100K
$ 59
7

479
North
Rent
5
100K+
$ 60
8

480
West
Rent
7
50K-100K
$ 68
9

481
East
Rent
2
25K-50K
$ 84
1

482
West
Own
1
50K-100K
$ 69
7

483
South
Rent
2
50K-100K
$ 97
4

484
North
Own
1
25K-50K
$ 61
6

485
East
Rent
3
50K-100K
$ 75
5

486
East
Own
6
50K-100K
$ 76
9

487
West
Own
4
50K-100K
$ 98
2

Question 3

CUST ID
REGION
RENT VS. OWN
NUM HOUSEHOLD
ANNUAL INCOME
TOTAL PURCHASES
NUM PURCHASES

1
North
Own
1
10K-25K
$ 38
1

2
South
Own
4
100K+
$ 30
4

3
North
Rent
3
25K-50K
$ 19
3

4
West
Own
5
25K-50K
$ 21
6

5
East
Own
6
50K-100K
$ 35
7

6
South
Own
2
10K-25K
$ 27
5

7
East
Own
3
100K+
$ 26
3

8
West
Rent
4
25K-50K
$ 25
6

9
North
Own
5
50K-100K
$ 30
8

10
West
Rent
7
25K-50K
$ 26
2

11
North
Own
1
50K-100K
$ 21
4

12
East
Own
2
100K+
$ 29
9

13
South
Own
5
10K-25K
$ 20
7

14
South
Own
4
25K-50K
$ 27
10

15
South
Rent
3
50K-100K
$ 19
2

16
West
Own
5
25K-50K
$ 19
6

17
North
Own
6
50K-100K
$ 129
5

18
East
Rent
2
10K-25K
$ 99
7

19
West
Own
3
25K-50K
$ 99
4

20
North
Rent
1
50K-100K
$ 119
3

21
East
Own
4
50K-100K
$ 149
2

22
South
Own
3
50K-100K
$ 165
8

23
West
Rent
5
25K-50K
$ 119
6

24
North
Rent
6
10K-25K
$ 129
7

25
East
Rent
7
100K+
$ 165
5

26
South
Own
3
10K-25K
$ 99
3

27
West
Rent
2
25K-50K
$ 155
6

28
North
Own
4
50K-100K
$ 115
8

29
East
Own
5
50K-100K
$ 129
1

30
South
Rent
4
50K-100K
$ 99
8

31
West
Own
2
25K-50K
$ 169
6

32
East
Rent
3
25K-50K
$ 40
4

33
East
Own
1
50K-100K
$ 36
7

34
North
Own
6
100K+
$ 45
3

35
North
Own
5
10K-25K
$ 29
1

36
West
Rent
4
100K+
$ 28
4

37
East
Rent
1
25K-50K
$ 46
1

38
South
Rent
5
50K-100K
$ 50
4

39
East
Rent
3
50K-100K
$ 22
6

40
West
Own
6
50K-100K
$ 20
9

41
North
Own
7
25K-50K
$ 19
3

42
East
Own
3
50K-100K
$ 31
1

43
South
Rent
2
50K-100K
$ 30
10

44
West
Rent
4
25K-50K
$ 18
3

45
East
Own
5
25K-50K
$ 31
7

46
South
Own
3
10K-25K
$ 35
6

47
West
Own
7
25K-50K
$ 28
5

48
East
Rent
3
100K+
$ 29
8

49
South
Rent
2
10K-25K
$ 35
6

50
North
Own
6
25K-50K
$ 30
4

51
South
Own
5
50K-100K
$ 38
7

52
West
Own
3
50K-100K
$ 20
3

53
North
Rent
1
25K-50K
$ 40
5

54
East
Rent
5
25K-50K
$ 30
4

55
South
Own
6
25K-50K
$ 40
8

56
West
Rent
3
10K-25K
$ 62
7

57
North
Rent
4
100K+
$ 22
9

58
East
Rent
5
100K+
$ 25
1

59
West
Rent
7
10K-25K
$ 27
4

60
East
Rent
2
25K-50K
$ 22
7

61
South
Own
3
25K-50K
$ 30
4

62
East
Own
1
25K-50K
$ 31
3

63
East
Own
4
50K-100K
$ 22
8

64
South
Rent
2
50K-100K
$ 25
9

65
West
Own
3
25K-50K
$ 24
3

66
East
Own
5
50K-100K
$ 36
2

67
North
Rent
4
50K-100K
$ 123
11

68
North
Rent
6
100K+
$ 19
2

69
North
Own
5
100K+
$ 23
6

70
South
Rent
7
100K+
$ 19
8

71
West
Rent
4
25K-50K
$ 25
6

72
West
Rent
5
50K-100K
$ 129
8

73
North
Own
3
50K-100K
$ 119
9

74
East
Own
6
100K+
$ 109
3

75
North
Own
5
10K-25K
$ 179
6

76
East
Rent
4
100K+
$ 145
5

77
South
Own
2
25K-50K
$ 119
7

78
North
Rent
3
50K-100K
$ 129
2

79
East
Own
4
10K-25K
$ 189
4

80
West
Own
6
50K-100K
$ 155
6

81
North
Rent
5
25K-50K
$ 78
4

82
East
Own
4
25K-50K
$ 61
5

83
South
Rent
3
25K-50K
$ 97
7

84
North
Rent
2
50K-100K
$ 63
2

85
West
Own
4
100K+
$ 39
3

86
East
Rent
6
50K-100K
$ 95
1

87
South
Rent
4
25K-50K
$ 86
7

88
West
Own
1
50K-100K
$ 85
5

89
East
Own
2
50K-100K
$ 59
7

90
North
Rent
3
100K+
$ 84
9

91
North
Own
2
100K+
$ 144
10

92
West
Rent
3
100K+
$ 26
1

93
South
Rent
7
25K-50K
$ 31
1

94
East
Own
6
50K-100K
$ 19
1

95
South
Rent
5
50K-100K
$ 30
1

96
West
Rent
4
100K+
$ 29
11

97
West
Rent
5
10K-25K
$ 25
2

98
West
Rent
6
100K+
$ 24
6

99
East
Rent
3
25K-50K
$ 36
5

100
North
Own
4
50K-100K
$ 29
7

101
South
Own
2
10K-25K
$ 99
9

102
West
Rent
1
50K-100K
$ 169
3

103
East
Own
3
10K-25K
$ 179
1

104
North
Rent
4
100K+
$ 119
7

105
South
Own
5
25K-50K
$ 99
4

106
West
Rent
4
50K-100K
$ 179
7

107
East
Own
6
10K-25K
$ 185
6

108
North
Rent
3
50K-100K
$ 179
8

109
South
Rent
4
25K-50K
$ 145
9

110
West
Rent
5
25K-50K
$ 119
3

111
North
Own
7
25K-50K
$ 99
2

112
North
Own
2
50K-100K
$ 155
5

113
East
Own
3
100K+
$ 119
4

114
North
Rent
5
50K-100K
$ 149
7

115
East
Rent
3
25K-50K
$ 56
5

116
North
Rent
2
50K-100K
$ 50
6

117
West
Own
4
50K-100K
$ 86
3

118
South
Rent
2
100K+
$ 45
2

119
East
Rent
1
100K+
$ 95
6

120
West
Rent
3
100K+
$ 86
8

121
South
Rent
2
25K-50K
$ 97
11

122
East
Rent
4
50K-100K
$ 40
8

123
North
Rent
5
50K-100K
$ 50
5

124
East
Own
6
100K+
$ 59
3

125
North
Rent
3
10K-25K
$ 75
4

126
South
Rent
4
50K-100K
$ 68
3

127
West
Rent
6
50K-100K
$ 63
1

128
North
Own
2
25K-50K
$ 56
10

129
East
Own
4
25K-50K
$ 86
2

130
North
Rent
6
50K-100K
$ 45
6

131
West
Own
3
100K+
$ 78
8

132
South
Own
4
10K-25K
$ 68
7

133
East
Rent
7
100K+
$ 95
6

134
North
Own
4
25K-50K
$ 95
4

135
East
Rent
5
50K-100K
$ 39
7

136
East
Own
6
50K-100K
$ 56
8

137
North
Own
2
50K-100K
$ 31
9

138
South
Rent
3
25K-50K
$ 29
6

139
West
Rent
4
50K-100K
$ 41
7

140
East
Rent
5
50K-100K
$ 62
4

141
North
Rent
1
25K-50K
$ 51
3

142
South
Own
2
25K-50K
$ 37
2

143
West
Own
3
10K-25K
$ 19
6

144
East
Rent
4
25K-50K
$ 38
5

145
North
Rent
5
100K+
$ 56
7

146
East
Own
4
100K+
$ 41
5

147
West
Own
3
25K-50K
$ 51
8

148
North
Rent
6
50K-100K
$ 19
4

149
East
Rent
2
10K-25K
$ 29
3

150
North
Own
4
50K-100K
$ 41
5

151
East
Own
3
25K-50K
$ 19
6

152
West
Own
3
25K-50K
$ 30
7

153
North
Own
5
25K-50K
$ 19
8

154
South
Rent
4
50K-100K
$ 21
3

155
East
Own
6
100K+
$ 23
2

156
North
Own
7
50K-100K
$ 29
5

157
West
Own
2
25K-50K
$ 18
2

158
East
Own
3
50K-100K
$ 26
5

159
South
Own
1
50K-100K
$ 20
1

160
West
Rent
2
100K+
$ 76
11

161
East
Own
4
100K+
$ 40
4

162
South
Own
2
100K+
$ 41
3

163
North
Own
4
25K-50K
$ 24
7

164
East
Rent
5
50K-100K
$ 26
5

165
West
Rent
6
50K-100K
$ 25
8

166
South
Own
4
100K+
$ 26
6

167
East
Own
2
10K-25K
$ 23
8

168
North
Own
4
50K-100K
$ 27
5

169
East
Own
3
50K-100K
$ 25
8

170
South
Rent
5
25K-50K
$ 34
10

171
West
Rent
4
25K-50K
$ 24
7

172
West
Rent
6
50K-100K
$ 21
9

173
East
Own
4
100K+
$ 40
8

174
South
Rent
3
50K-100K
$ 19
1

175
West
Own
1
100K+
$ 30
11

176
East
Rent
2
100K+
$ 35
10

177
North
Own
4
100K+
$ 24
1

178
East
Own
7
25K-50K
$ 26
4

179
South
Own
4
50K-100K
$ 15
1

180
East
Rent
6
50K-100K
$ 18
3

181
North
Rent
3
100K+
$ 28
1

182
South
Own
7
10K-25K
$ 24
4

183
West
Rent
2
100K+
$ 30
5

184
East
Own
1
25K-50K
$ 30
4

185
West
Own
4
50K-100K
$ 23
7

186
North
Own
5
10K-25K
$ 28
5

187
East
Rent
3
50K-100K
$ 21
6

188
North
Own
2
25K-50K
$ 28
4

189
East
Rent
4
25K-50K
$ 22
2

190
West
Own
5
25K-50K
$ 28
6

191
North
Own
2
50K-100K
$ 30
8

192
South
Own
1
100K+
$ 28
9

193
East
Own
4
50K-100K
$ 25
10

194
North
Rent
2
25K-50K
$ 29
3

195
West
Own
5
50K-100K
$ 28
6

196
East
Own
3
50K-100K
$ 30
5

197
South
Rent
6
100K+
$ 19
4

198
West
Own
5
100K+
$ 30
6

199
East
Rent
7
100K+
$ 149
8

200
South
Own
4
25K-50K
$ 155
7

201
North
Own
5
50K-100K
$ 115
4

202
East
Rent
6
50K-100K
$ 119
5

203
West
Rent
3
100K+
$ 99
7

204
South
Rent
2
10K-25K
$ 119
8

205
East
Own
4
100K+
$ 149
9

206
North
Rent
5
25K-50K
$ 145
11

207
East
Own
3
25K-50K
$ 119
8

208
South
Own
5
50K-100K
$ 129
5

209
North
Rent
4
50K-100K
$ 99
7

210
East
Own
6
50K-100K
$ 119
8

211
South
Rent
4
100K+
$ 185
9

212
West
Own
5
10K-25K
$ 119
5

213
West
Own
6
50K-100K
$ 99
2

214
East
Own
7
50K-100K
$ 109
6

215
South
Rent
1
25K-50K
$ 179
8

216
West
Rent
3
25K-50K
$ 169
6

217
East
Rent
2
50K-100K
$ 179
9

218
North
Rent
5
10K-25K
$ 145
7

219
East
Own
4
100K+
$ 119
6

220
South
Own
6
100K+
$ 165
3

221
East
Own
7
10K-25K
$ 129
2

222
North
Rent
3
100K+
$ 159
11

223
South
Rent
2
50K-100K
$ 37
7

224
West
Own
4
50K-100K
$ 55
5

225
East
Own
5
25K-50K
$ 63
7

226
West
Own
4
25K-50K
$ 56
8

227
North
Rent
3
10K-25K
$ 67
6

228
East
Rent
4
50K-100K
$ 60
8

229
North
Own
6
25K-50K
$ 50
9

230
East
Own
5
50K-100K
$ 49
3

231
West
Own
4
100K+
$ 56
4

232
North
Rent
2
50K-100K
$ 60
7

233
South
Rent
3
50K-100K
$ 59
2

234
East
Own
1
50K-100K
$ 59
8

235
North
Rent
7
50K-100K
$ 60
5

236
West
Rent
3
50K-100K
$ 68
7

237
South
Rent
4
25K-50K
$ 84
9

238
South
Rent
2
25K-50K
$ 69
2

239
West
Rent
5
100K+
$ 97
5

240
North
Own
3
10K-25K
$ 61
4

241
East
Own
4
100K+
$ 75
6

242
West
Own
5
100K+
$ 76
11

243
North
Rent
6
100K+
$ 98
8

244
East
Own
4
25K-50K
$ 95
5

245
South
Own
5
25K-50K
$ 59
7

246
West
Rent
6
50K-100K
$ 44
4

247
North
Rent
7
50K-100K
$ 97
3

248
East
Own
4
100K+
$ 68
6

249
South
Rent
3
25K-50K
$ 145
10

250
West
Rent
2
50K-100K
$ 119
3

251
North
Rent
1
10K-25K
$ 129
6

252
East
Own
5
50K-100K
$ 99
8

253
South
Own
4
25K-50K
$ 119
6

254
West
Own
6
25K-50K
$ 185
8

255
East
Rent
3
25K-50K
$ 119
10

256
East
Own
2
50K-100K
$ 99
3

257
North
Rent
1
100K+
$ 60
6

258
North
Own
5
50K-100K
$ 50
5

259
West
Own
4
25K-50K
$ 49
8

260
West
Rent
6
50K-100K
$ 56
4

261
East
Own
7
50K-100K
$ 60
7

262
North
Rent
3
100K+
$ 59
3

263
East
Rent
2
100K+
$ 59
2

264
South
Own
4
100K+
$ 60
6

265
East
Rent
5
25K-50K
$ 68
5

266
North
Rent
3
50K-100K
$ 84
8

267
South
Own
2
50K-100K
$ 69
9

268
West
Own
4
100K+
$ 97
3

269
East
Rent
3
10K-25K
$ 61
2

270
West
Own
4
50K-100K
$ 75
6

271
North
Rent
3
50K-100K
$ 76
5

272
East
Rent
4
25K-50K
$ 98
7

273
North
Own
5
25K-50K
$ 95
9

274
East
Rent
4
50K-100K
$ 59
4

275
West
Rent
6
100K+
$ 44
6

276
North
Rent
5
50K-100K
$ 97
8

277
South
Rent
7
100K+
$ 68
7

278
East
Rent
1
100K+
$ 145
1

279
North
Own
2
100K+
$ 85
10

280
West
Own
3
25K-50K
$ 59
3

281
South
Rent
4
50K-100K
$ 84
7

282
South
Own
3
50K-100K
$ 28
5

283
South
Rent
5
100K+
$ 26
8

284
East
Own
3
10K-25K
$ 31
9

285
North
Rent
3
100K+
$ 19
3

286
West
Own
2
25K-50K
$ 30
2

287
East
Rent
4
50K-100K
$ 29
11

288
South
Rent
5
10K-25K
$ 25
6

289
West
Rent
6
50K-100K
$ 24
3

290
East
Own
5
25K-50K
$ 36
6

291
South
Own
4
25K-50K
$ 29
7

292
North
Own
3
25K-50K
$ 99
9

293
East
Rent
5
50K-100K
$ 169
8

294
West
Rent
4
100K+
$ 179
3

295
South
Rent
6
50K-100K
$ 119
5

296
East
Own
4
25K-50K
$ 99
4

297
North
Rent
6
50K-100K
$ 56
6

298
East
Rent
1
50K-100K
$ 50
11

299
South
Rent
2
100K+
$ 86
10

300
North
Rent
3
100K+
$ 45
3

301
East
Rent
4
100K+
$ 95
2

302
South
Rent
7
25K-50K
$ 86
10

303
West
Own
4
50K-100K
$ 97
11

304
West
Rent
3
50K-100K
$ 40
7

305
East
Rent
1
100K+
$ 50
5

306
South
Rent
4
10K-25K
$ 59
9

307
West
Own
2
100K+
$ 75
4

308
East
Own
5
25K-50K
$ 68
3

309
North
Rent
3
25K-50K
$ 26
2

310
East
Own
6
50K-100K
$ 15
6

311
South
Own
4
50K-100K
$ 18
8

312
East
Rent
7
50K-100K
$ 28
6

313
North
Own
3
100K+
$ 24
8

314
South
Rent
2
10K-25K
$ 30
9

315
West
Own
4
50K-100K
$ 30
10

316
East
Own
5
50K-100K
$ 23
3

317
West
Rent
3
25K-50K
$ 28
2

318
North
Rent
1
25K-50K
$ 21
6

319
East
Rent
4
50K-100K
$ 28
5

320
North
Rent
3
10K-25K
$ 22
8

321
East
Own
5
100K+
$ 28
7

322
West
Own
6
100K+
$ 30
9

323
North
Rent
4
10K-25K
$ 28
4

324
South
Rent
2
100K+
$ 25
6

325
East
Own
5
50K-100K
$ 29
3

326
North
Own
3
50K-100K
$ 28
5

327
West
Rent
5
25K-50K
$ 30
3

328
South
Rent
6
25K-50K
$ 19
6

329
South
Own
4
10K-25K
$ 30
5

330
West
Own
3
50K-100K
$ 149
7

331
North
Own
5
25K-50K
$ 155
9

332
East
Own
6
50K-100K
$ 115
4

333
West
Rent
4
100K+
$ 39
6

334
North
Own
6
50K-100K
$ 95
8

335
East
Own
4
50K-100K
$ 86
7

336
South
Own
7
50K-100K
$ 85
1

337
West
Own
4
50K-100K
$ 59
10

338
North
Own
3
50K-100K
$ 84
3

339
East
Rent
1
25K-50K
$ 28
7

340
South
Own
2
25K-50K
$ 26
5

341
West
Own
5
100K+
$ 31
8

342
North
Own
3
10K-25K
$ 19
9

343
East
Rent
4
100K+
$ 30
3

344
South
Rent
6
100K+
$ 29
2

345
West
Own
5
100K+
$ 25
11

346
East
Own
3
25K-50K
$ 24
6

347
East
Own
2
25K-50K
$ 36
3

348
North
Own
1
50K-100K
$ 29
6

349
North
Rent
6
50K-100K
$ 99
7

350
West
Rent
7
50K-100K
$ 169
9

351
West
Rent
2
50K-100K
$ 179
8

352
East
Own
1
10K-25K
$ 119
3

353
North
Rent
2
100K+
$ 99
5

354
East
Own
3
10K-25K
$ 179
4

355
South
Own
2
100K+
$ 185
6

356
East
Rent
1
50K-100K
$ 179
11

357
North
Own
3
50K-100K
$ 145
10

358
South
Own
4
25K-50K
$ 119
3

359
West
Own
6
25K-50K
$ 99
2

360
East
Rent
5
10K-25K
$ 155
10

361
West
Rent
4
50K-100K
$ 119
11

362
North
Own
3
25K-50K
$ 149
7

363
East
Own
5
50K-100K
$ 56
5

364
North
Own
6
100K+
$ 50
9

365
East
Own
7
50K-100K
$ 86
4

366
North
Rent
5
50K-100K
$ 45
3

367
South
Rent
6
50K-100K
$ 95
2

368
North
Rent
3
50K-100K
$ 86
6

369
West
Own
4
50K-100K
$ 97
8

370
East
Rent
5
25K-50K
$ 23
6

371
South
Own
2
25K-50K
$ 29
8

372
East
Rent
3
100K+
$ 18
9

373
West
Own
6
10K-25K
$ 26
10

374
North
Own
2
100K+
$ 20
3

375
West
Own
5
100K+
$ 15
2

376
North
Rent
4
100K+
$ 40
6

377
East
Rent
1
25K-50K
$ 41
5

378
South
Own
4
25K-50K
$ 24
8

379
South
Rent
3
50K-100K
$ 26
7

380
South
Own
5
10K-25K
$ 25
9

381
West
Own
6
25K-50K
$ 26
4

382
North
Own
4
50K-100K
$ 23
6

383
East
Rent
2
50K-100K
$ 27
7

384
West
Own
5
25K-50K
$ 25
5

385
North
Rent
3
25K-50K
$ 18
3

386
East
Own
5
25K-50K
$ 24
6

387
South
Own
6
10K-25K
$ 21
8

388
West
Own
4
100K+
$ 40
2

389
North
Own
3
100K+
$ 19
4

390
South
Rent
5
10K-25K
$ 30
9

391
West
Own
6
25K-50K
$ 35
7

392
East
Own
4
25K-50K
$ 24
10

393
East
Rent
6
25K-50K
$ 26
2

394
North
Own
4
50K-100K
$ 15
6

395
North
Rent
7
50K-100K
$ 18
5

396
West
Own
4
25K-50K
$ 28
7

397
West
Own
3
50K-100K
$ 24
4

398
East
Rent
1
50K-100K
$ 30
3

399
North
Rent
2
100K+
$ 30
2

400
East
Rent
5
25K-50K
$ 23
8

401
South
Own
3
25K-50K
$ 28
6

402
East
Rent
4
10K-25K
$ 21
7

403
North
Own
6
25K-50K
$ 28
5

404
South
Own
5
100K+
$ 22
3

405
West
Rent
3
50K-100K
$ 28
6

406
East
Own
2
50K-100K
$ 30
8

407
West
Rent
1
25K-50K
$ 28
1

408
North
Own
6
25K-50K
$ 25
8

409
East
Own
7
50K-100K
$ 29
6

410
North
Rent
2
50K-100K
$ 28
4

411
East
Rent
1
25K-50K
$ 30
7

412
North
Own
2
50K-100K
$ 19
3

413
South
Own
3
50K-100K
$ 30
1

414
North
Own
2
25K-50K
$ 149
4

415
West
Own
1
50K-100K
$ 155
1

416
East
Rent
3
10K-25K
$ 115
4

417
South
Own
4
100K+
$ 119
6

418
East
Own
6
50K-100K
$ 99
5

419
West
Own
5
50K-100K
$ 119
3

420
North
Own
4
25K-50K
$ 149
7

421
West
Own
3
25K-50K
$ 145
6

422
North
Rent
5
25K-50K
$ 119
8

423
East
Own
6
10K-25K
$ 129
9

424
West
Own
7
100K+
$ 99
10

425
North
Own
5
100K+
$ 119
2

426
East
Rent
6
10K-25K
$ 185
6

427
South
Rent
3
25K-50K
$ 119
4

428
West
Own
4
25K-50K
$ 99
7

429
North
Own
5
25K-50K
$ 109
5

430
East
Own
2
50K-100K
$ 179
8

431
South
Own
3
50K-100K
$ 169
9

432
West
Rent
5
25K-50K
$ 179
2

433
North
Rent
4
50K-100K
$ 145
5

434
East
Rent
6
50K-100K
$ 119
4

435
South
Own
7
100K+
$ 165
3

436
West
Rent
2
25K-50K
$ 129
11

437
East
Own
3
25K-50K
$ 159
7

438
East
Own
1
10K-25K
$ 37
4

439
North
Rent
3
25K-50K
$ 55
6

440
North
Own
5
25K-50K
$ 63
5

441
West
Own
4
25K-50K
$ 56
9

442
West
Own
6
50K-100K
$ 67
2

443
East
Rent
7
50K-100K
$ 60
5

444
North
Rent
2
50K-100K
$ 50
3

445
East
Own
3
25K-50K
$ 49
6

446
South
Own
4
10K-25K
$ 56
8

447
East
Own
5
25K-50K
$ 60
4

448
North
Own
3
100K+
$ 59
7

449
South
Rent
4
10K-25K
$ 59
5

450
West
Rent
1
25K-50K
$ 60
1

451
East
Rent
3
50K-100K
$ 68
10

452
South
Own
4
50K-100K
$ 84
11

453
North
Rent
5
25K-50K
$ 69
11

454
West
Own
6
25K-50K
$ 97
11

455
East
Rent
7
50K-100K
$ 61
3

456
South
Own
6
10K-25K
$ 75
6

457
East
Own
7
100K+
$ 76
4

458
West
Own
4
100K+
$ 98
7

459
North
Rent
3
100K+
$ 95
9

460
West
Rent
5
50K-100K
$ 59
3

461
North
Own
2
50K-100K
$ 44
2

462
East
Rent
3
100K+
$ 97
6

463
West
Own
4
10K-25K
$ 68
5

464
North
Own
6
100K+
$ 145
8

465
East
Own
4
25K-50K
$ 119
7

466
South
Rent
5
50K-100K
$ 129
2

467
West
Own
3
10K-25K
$ 99
4

468
North
Rent
2
50K-100K
$ 119
3

469
North
Own
6
10K-25K
$ 185
6

470
East
Own
3
100K+
$ 119
9

471
West
Own
1
25K-50K
$ 99
10

472
South
Own
4
50K-100K
$ 60
11

473
East
Rent
3
10K-25K
$ 50
4

474
West
Rent
5
50K-100K
$ 49
2

475
South
Own
6
25K-50K
$ 56
1

476
East
Own
3
25K-50K
$ 60
5

477
North
Own
2
25K-50K
$ 59
4

478
East
Own
4
50K-100K
$ 59
7

479
North
Rent
5
100K+
$ 60
8

480
West
Rent
7
50K-100K
$ 68
9

481
East
Rent
2
25K-50K
$ 84
1

482
West
Own
1
50K-100K
$ 69
7

483
South
Rent
2
50K-100K
$ 97
4

484
North
Own
1
25K-50K
$ 61
6

485
East
Rent
3
50K-100K
$ 75
5

486
East
Own
6
50K-100K
$ 76
9

487
West
Own
4
50K-100K
$ 98
2

Question 4

CUST ID
REGION
RENT VS. OWN
NUM HOUSEHOLD
ANNUAL INCOME
TOTAL PURCHASES
NUM PURCHASES

1
North
Own
1
10K-25K
$ 38
1

2
South
Own
4
100K+
$ 30
4

3
North
Rent
3
25K-50K
$ 19
3

4
West
Own
5
25K-50K
$ 21
6

5
East
Own
6
50K-100K
$ 35
7

6
South
Own
2
10K-25K
$ 27
5

7
East
Own
3
100K+
$ 26
3

8
West
Rent
4
25K-50K
$ 25
6

9
North
Own
5
50K-100K
$ 30
8

10
West
Rent
7
25K-50K
$ 26
2

11
North
Own
1
50K-100K
$ 21
4

12
East
Own
2
100K+
$ 29
9

13
South
Own
5
10K-25K
$ 20
7

14
South
Own
4
25K-50K
$ 27
10

15
South
Rent
3
50K-100K
$ 19
2

16
West
Own
5
25K-50K
$ 19
6

17
North
Own
6
50K-100K
$ 129
5

18
East
Rent
2
10K-25K
$ 99
7

19
West
Own
3
25K-50K
$ 99
4

20
North
Rent
1
50K-100K
$ 119
3

21
East
Own
4
50K-100K
$ 149
2

22
South
Own
3
50K-100K
$ 165
8

23
West
Rent
5
25K-50K
$ 119
6

24
North
Rent
6
10K-25K
$ 129
7

25
East
Rent
7
100K+
$ 165
5

26
South
Own
3
10K-25K
$ 99
3

27
West
Rent
2
25K-50K
$ 155
6

28
North
Own
4
50K-100K
$ 115
8

29
East
Own
5
50K-100K
$ 129
1

30
South
Rent
4
50K-100K
$ 99
8

31
West
Own
2
25K-50K
$ 169
6

32
East
Rent
3
25K-50K
$ 40
4

33
East
Own
1
50K-100K
$ 36
7

34
North
Own
6
100K+
$ 45
3

35
North
Own
5
10K-25K
$ 29
1

36
West
Rent
4
100K+
$ 28
4

37
East
Rent
1
25K-50K
$ 46
1

38
South
Rent
5
50K-100K
$ 50
4

39
East
Rent
3
50K-100K
$ 22
6

40
West
Own
6
50K-100K
$ 20
9

41
North
Own
7
25K-50K
$ 19
3

42
East
Own
3
50K-100K
$ 31
1

43
South
Rent
2
50K-100K
$ 30
10

44
West
Rent
4
25K-50K
$ 18
3

45
East
Own
5
25K-50K
$ 31
7

46
South
Own
3
10K-25K
$ 35
6

47
West
Own
7
25K-50K
$ 28
5

48
East
Rent
3
100K+
$ 29
8

49
South
Rent
2
10K-25K
$ 35
6

50
North
Own
6
25K-50K
$ 30
4

51
South
Own
5
50K-100K
$ 38
7

52
West
Own
3
50K-100K
$ 20
3

53
North
Rent
1
25K-50K
$ 40
5

54
East
Rent
5
25K-50K
$ 30
4

55
South
Own
6
25K-50K
$ 40
8

56
West
Rent
3
10K-25K
$ 62
7

57
North
Rent
4
100K+
$ 22
9

58
East
Rent
5
100K+
$ 25
1

59
West
Rent
7
10K-25K
$ 27
4

60
East
Rent
2
25K-50K
$ 22
7

61
South
Own
3
25K-50K
$ 30
4

62
East
Own
1
25K-50K
$ 31
3

63
East
Own
4
50K-100K
$ 22
8

64
South
Rent
2
50K-100K
$ 25
9

65
West
Own
3
25K-50K
$ 24
3

66
East
Own
5
50K-100K
$ 36
2

67
North
Rent
4
50K-100K
$ 123
11

68
North
Rent
6
100K+
$ 19
2

69
North
Own
5
100K+
$ 23
6

70
South
Rent
7
100K+
$ 19
8

71
West
Rent
4
25K-50K
$ 25
6

72
West
Rent
5
50K-100K
$ 129
8

73
North
Own
3
50K-100K
$ 119
9

74
East
Own
6
100K+
$ 109
3

75
North
Own
5
10K-25K
$ 179
6

76
East
Rent
4
100K+
$ 145
5

77
South
Own
2
25K-50K
$ 119
7

78
North
Rent
3
50K-100K
$ 129
2

79
East
Own
4
10K-25K
$ 189
4

80
West
Own
6
50K-100K
$ 155
6

81
North
Rent
5
25K-50K
$ 78
4

82
East
Own
4
25K-50K
$ 61
5

83
South
Rent
3
25K-50K
$ 97
7

84
North
Rent
2
50K-100K
$ 63
2

85
West
Own
4
100K+
$ 39
3

86
East
Rent
6
50K-100K
$ 95
1

87
South
Rent
4
25K-50K
$ 86
7

88
West
Own
1
50K-100K
$ 85
5

89
East
Own
2
50K-100K
$ 59
7

90
North
Rent
3
100K+
$ 84
9

91
North
Own
2
100K+
$ 144
10

92
West
Rent
3
100K+
$ 26
1

93
South
Rent
7
25K-50K
$ 31
1

94
East
Own
6
50K-100K
$ 19
1

95
South
Rent
5
50K-100K
$ 30
1

96
West
Rent
4
100K+
$ 29
11

97
West
Rent
5
10K-25K
$ 25
2

98
West
Rent
6
100K+
$ 24
6

99
East
Rent
3
25K-50K
$ 36
5

100
North
Own
4
50K-100K
$ 29
7

101
South
Own
2
10K-25K
$ 99
9

102
West
Rent
1
50K-100K
$ 169
3

103
East
Own
3
10K-25K
$ 179
1

104
North
Rent
4
100K+
$ 119
7

105
South
Own
5
25K-50K
$ 99
4

106
West
Rent
4
50K-100K
$ 179
7

107
East
Own
6
10K-25K
$ 185
6

108
North
Rent
3
50K-100K
$ 179
8

109
South
Rent
4
25K-50K
$ 145
9

110
West
Rent
5
25K-50K
$ 119
3

111
North
Own
7
25K-50K
$ 99
2

112
North
Own
2
50K-100K
$ 155
5

113
East
Own
3
100K+
$ 119
4

114
North
Rent
5
50K-100K
$ 149
7

115
East
Rent
3
25K-50K
$ 56
5

116
North
Rent
2
50K-100K
$ 50
6

117
West
Own
4
50K-100K
$ 86
3

118
South
Rent
2
100K+
$ 45
2

119
East
Rent
1
100K+
$ 95
6

120
West
Rent
3
100K+
$ 86
8

121
South
Rent
2
25K-50K
$ 97
11

122
East
Rent
4
50K-100K
$ 40
8

123
North
Rent
5
50K-100K
$ 50
5

124
East
Own
6
100K+
$ 59
3

125
North
Rent
3
10K-25K
$ 75
4

126
South
Rent
4
50K-100K
$ 68
3

127
West
Rent
6
50K-100K
$ 63
1

128
North
Own
2
25K-50K
$ 56
10

129
East
Own
4
25K-50K
$ 86
2

130
North
Rent
6
50K-100K
$ 45
6

131
West
Own
3
100K+
$ 78
8

132
South
Own
4
10K-25K
$ 68
7

133
East
Rent
7
100K+
$ 95
6

134
North
Own
4
25K-50K
$ 95
4

135
East
Rent
5
50K-100K
$ 39
7

136
East
Own
6
50K-100K
$ 56
8

137
North
Own
2
50K-100K
$ 31
9

138
South
Rent
3
25K-50K
$ 29
6

139
West
Rent
4
50K-100K
$ 41
7

140
East
Rent
5
50K-100K
$ 62
4

141
North
Rent
1
25K-50K
$ 51
3

142
South
Own
2
25K-50K
$ 37
2

143
West
Own
3
10K-25K
$ 19
6

144
East
Rent
4
25K-50K
$ 38
5

145
North
Rent
5
100K+
$ 56
7

146
East
Own
4
100K+
$ 41
5

147
West
Own
3
25K-50K
$ 51
8

148
North
Rent
6
50K-100K
$ 19
4

149
East
Rent
2
10K-25K
$ 29
3

150
North
Own
4
50K-100K
$ 41
5

151
East
Own
3
25K-50K
$ 19
6

152
West
Own
3
25K-50K
$ 30
7

153
North
Own
5
25K-50K
$ 19
8

154
South
Rent
4
50K-100K
$ 21
3

155
East
Own
6
100K+
$ 23
2

156
North
Own
7
50K-100K
$ 29
5

157
West
Own
2
25K-50K
$ 18
2

158
East
Own
3
50K-100K
$ 26
5

159
South
Own
1
50K-100K
$ 20
1

160
West
Rent
2
100K+
$ 76
11

161
East
Own
4
100K+
$ 40
4

162
South
Own
2
100K+
$ 41
3

163
North
Own
4
25K-50K
$ 24
7

164
East
Rent
5
50K-100K
$ 26
5

165
West
Rent
6
50K-100K
$ 25
8

166
South
Own
4
100K+
$ 26
6

167
East
Own
2
10K-25K
$ 23
8

168
North
Own
4
50K-100K
$ 27
5

169
East
Own
3
50K-100K
$ 25
8

170
South
Rent
5
25K-50K
$ 34
10

171
West
Rent
4
25K-50K
$ 24
7

172
West
Rent
6
50K-100K
$ 21
9

173
East
Own
4
100K+
$ 40
8

174
South
Rent
3
50K-100K
$ 19
1

175
West
Own
1
100K+
$ 30
11

176
East
Rent
2
100K+
$ 35
10

177
North
Own
4
100K+
$ 24
1

178
East
Own
7
25K-50K
$ 26
4

179
South
Own
4
50K-100K
$ 15
1

180
East
Rent
6
50K-100K
$ 18
3

181
North
Rent
3
100K+
$ 28
1

182
South
Own
7
10K-25K
$ 24
4

183
West
Rent
2
100K+
$ 30
5

184
East
Own
1
25K-50K
$ 30
4

185
West
Own
4
50K-100K
$ 23
7

186
North
Own
5
10K-25K
$ 28
5

187
East
Rent
3
50K-100K
$ 21
6

188
North
Own
2
25K-50K
$ 28
4

189
East
Rent
4
25K-50K
$ 22
2

190
West
Own
5
25K-50K
$ 28
6

191
North
Own
2
50K-100K
$ 30
8

192
South
Own
1
100K+
$ 28
9

193
East
Own
4
50K-100K
$ 25
10

194
North
Rent
2
25K-50K
$ 29
3

195
West
Own
5
50K-100K
$ 28
6

196
East
Own
3
50K-100K
$ 30
5

197
South
Rent
6
100K+
$ 19
4

198
West
Own
5
100K+
$ 30
6

199
East
Rent
7
100K+
$ 149
8

200
South
Own
4
25K-50K
$ 155
7

201
North
Own
5
50K-100K
$ 115
4

202
East
Rent
6
50K-100K
$ 119
5

203
West
Rent
3
100K+
$ 99
7

204
South
Rent
2
10K-25K
$ 119
8

205
East
Own
4
100K+
$ 149
9

206
North
Rent
5
25K-50K
$ 145
11

207
East
Own
3
25K-50K
$ 119
8

208
South
Own
5
50K-100K
$ 129
5

209
North
Rent
4
50K-100K
$ 99
7

210
East
Own
6
50K-100K
$ 119
8

211
South
Rent
4
100K+
$ 185
9

212
West
Own
5
10K-25K
$ 119
5

213
West
Own
6
50K-100K
$ 99
2

214
East
Own
7
50K-100K
$ 109
6

215
South
Rent
1
25K-50K
$ 179
8

216
West
Rent
3
25K-50K
$ 169
6

217
East
Rent
2
50K-100K
$ 179
9

218
North
Rent
5
10K-25K
$ 145
7

219
East
Own
4
100K+
$ 119
6

220
South
Own
6
100K+
$ 165
3

221
East
Own
7
10K-25K
$ 129
2

222
North
Rent
3
100K+
$ 159
11

223
South
Rent
2
50K-100K
$ 37
7

224
West
Own
4
50K-100K
$ 55
5

225
East
Own
5
25K-50K
$ 63
7

226
West
Own
4
25K-50K
$ 56
8

227
North
Rent
3
10K-25K
$ 67
6

228
East
Rent
4
50K-100K
$ 60
8

229
North
Own
6
25K-50K
$ 50
9

230
East
Own
5
50K-100K
$ 49
3

231
West
Own
4
100K+
$ 56
4

232
North
Rent
2
50K-100K
$ 60
7

233
South
Rent
3
50K-100K
$ 59
2

234
East
Own
1
50K-100K
$ 59
8

235
North
Rent
7
50K-100K
$ 60
5

236
West
Rent
3
50K-100K
$ 68
7

237
South
Rent
4
25K-50K
$ 84
9

238
South
Rent
2
25K-50K
$ 69
2

239
West
Rent
5
100K+
$ 97
5

240
North
Own
3
10K-25K
$ 61
4

241
East
Own
4
100K+
$ 75
6

242
West
Own
5
100K+
$ 76
11

243
North
Rent
6
100K+
$ 98
8

244
East
Own
4
25K-50K
$ 95
5

245
South
Own
5
25K-50K
$ 59
7

246
West
Rent
6
50K-100K
$ 44
4

247
North
Rent
7
50K-100K
$ 97
3

248
East
Own
4
100K+
$ 68
6

249
South
Rent
3
25K-50K
$ 145
10

250
West
Rent
2
50K-100K
$ 119
3

251
North
Rent
1
10K-25K
$ 129
6

252
East
Own
5
50K-100K
$ 99
8

253
South
Own
4
25K-50K
$ 119
6

254
West
Own
6
25K-50K
$ 185
8

255
East
Rent
3
25K-50K
$ 119
10

256
East
Own
2
50K-100K
$ 99
3

257
North
Rent
1
100K+
$ 60
6

258
North
Own
5
50K-100K
$ 50
5

259
West
Own
4
25K-50K
$ 49
8

260
West
Rent
6
50K-100K
$ 56
4

261
East
Own
7
50K-100K
$ 60
7

262
North
Rent
3
100K+
$ 59
3

263
East
Rent
2
100K+
$ 59
2

264
South
Own
4
100K+
$ 60
6

265
East
Rent
5
25K-50K
$ 68
5

266
North
Rent
3
50K-100K
$ 84
8

267
South
Own
2
50K-100K
$ 69
9

268
West
Own
4
100K+
$ 97
3

269
East
Rent
3
10K-25K
$ 61
2

270
West
Own
4
50K-100K
$ 75
6

271
North
Rent
3
50K-100K
$ 76
5

272
East
Rent
4
25K-50K
$ 98
7

273
North
Own
5
25K-50K
$ 95
9

274
East
Rent
4
50K-100K
$ 59
4

275
West
Rent
6
100K+
$ 44
6

276
North
Rent
5
50K-100K
$ 97
8

277
South
Rent
7
100K+
$ 68
7

278
East
Rent
1
100K+
$ 145
1

279
North
Own
2
100K+
$ 85
10

280
West
Own
3
25K-50K
$ 59
3

281
South
Rent
4
50K-100K
$ 84
7

282
South
Own
3
50K-100K
$ 28
5

283
South
Rent
5
100K+
$ 26
8

284
East
Own
3
10K-25K
$ 31
9

285
North
Rent
3
100K+
$ 19
3

286
West
Own
2
25K-50K
$ 30
2

287
East
Rent
4
50K-100K
$ 29
11

288
South
Rent
5
10K-25K
$ 25
6

289
West
Rent
6
50K-100K
$ 24
3

290
East
Own
5
25K-50K
$ 36
6

291
South
Own
4
25K-50K
$ 29
7

292
North
Own
3
25K-50K
$ 99
9

293
East
Rent
5
50K-100K
$ 169
8

294
West
Rent
4
100K+
$ 179
3

295
South
Rent
6
50K-100K
$ 119
5

296
East
Own
4
25K-50K
$ 99
4

297
North
Rent
6
50K-100K
$ 56
6

298
East
Rent
1
50K-100K
$ 50
11

299
South
Rent
2
100K+
$ 86
10

300
North
Rent
3
100K+
$ 45
3

301
East
Rent
4
100K+
$ 95
2

302
South
Rent
7
25K-50K
$ 86
10

303
West
Own
4
50K-100K
$ 97
11

304
West
Rent
3
50K-100K
$ 40
7

305
East
Rent
1
100K+
$ 50
5

306
South
Rent
4
10K-25K
$ 59
9

307
West
Own
2
100K+
$ 75
4

308
East
Own
5
25K-50K
$ 68
3

309
North
Rent
3
25K-50K
$ 26
2

310
East
Own
6
50K-100K
$ 15
6

311
South
Own
4
50K-100K
$ 18
8

312
East
Rent
7
50K-100K
$ 28
6

313
North
Own
3
100K+
$ 24
8

314
South
Rent
2
10K-25K
$ 30
9

315
West
Own
4
50K-100K
$ 30
10

316
East
Own
5
50K-100K
$ 23
3

317
West
Rent
3
25K-50K
$ 28
2

318
North
Rent
1
25K-50K
$ 21
6

319
East
Rent
4
50K-100K
$ 28
5

320
North
Rent
3
10K-25K
$ 22
8

321
East
Own
5
100K+
$ 28
7

322
West
Own
6
100K+
$ 30
9

323
North
Rent
4
10K-25K
$ 28
4

324
South
Rent
2
100K+
$ 25
6

325
East
Own
5
50K-100K
$ 29
3

326
North
Own
3
50K-100K
$ 28
5

327
West
Rent
5
25K-50K
$ 30
3

328
South
Rent
6
25K-50K
$ 19
6

329
South
Own
4
10K-25K
$ 30
5

330
West
Own
3
50K-100K
$ 149
7

331
North
Own
5
25K-50K
$ 155
9

332
East
Own
6
50K-100K
$ 115
4

333
West
Rent
4
100K+
$ 39
6

334
North
Own
6
50K-100K
$ 95
8

335
East
Own
4
50K-100K
$ 86
7

336
South
Own
7
50K-100K
$ 85
1

337
West
Own
4
50K-100K
$ 59
10

338
North
Own
3
50K-100K
$ 84
3

339
East
Rent
1
25K-50K
$ 28
7

340
South
Own
2
25K-50K
$ 26
5

341
West
Own
5
100K+
$ 31
8

342
North
Own
3
10K-25K
$ 19
9

343
East
Rent
4
100K+
$ 30
3

344
South
Rent
6
100K+
$ 29
2

345
West
Own
5
100K+
$ 25
11

346
East
Own
3
25K-50K
$ 24
6

347
East
Own
2
25K-50K
$ 36
3

348
North
Own
1
50K-100K
$ 29
6

349
North
Rent
6
50K-100K
$ 99
7

350
West
Rent
7
50K-100K
$ 169
9

351
West
Rent
2
50K-100K
$ 179
8

352
East
Own
1
10K-25K
$ 119
3

353
North
Rent
2
100K+
$ 99
5

354
East
Own
3
10K-25K
$ 179
4

355
South
Own
2
100K+
$ 185
6

356
East
Rent
1
50K-100K
$ 179
11

357
North
Own
3
50K-100K
$ 145
10

358
South
Own
4
25K-50K
$ 119
3

359
West
Own
6
25K-50K
$ 99
2

360
East
Rent
5
10K-25K
$ 155
10

361
West
Rent
4
50K-100K
$ 119
11

362
North
Own
3
25K-50K
$ 149
7

363
East
Own
5
50K-100K
$ 56
5

364
North
Own
6
100K+
$ 50
9

365
East
Own
7
50K-100K
$ 86
4

366
North
Rent
5
50K-100K
$ 45
3

367
South
Rent
6
50K-100K
$ 95
2

368
North
Rent
3
50K-100K
$ 86
6

369
West
Own
4
50K-100K
$ 97
8

370
East
Rent
5
25K-50K
$ 23
6

371
South
Own
2
25K-50K
$ 29
8

372
East
Rent
3
100K+
$ 18
9

373
West
Own
6
10K-25K
$ 26
10

374
North
Own
2
100K+
$ 20
3

375
West
Own
5
100K+
$ 15
2

376
North
Rent
4
100K+
$ 40
6

377
East
Rent
1
25K-50K
$ 41
5

378
South
Own
4
25K-50K
$ 24
8

379
South
Rent
3
50K-100K
$ 26
7

380
South
Own
5
10K-25K
$ 25
9

381
West
Own
6
25K-50K
$ 26
4

382
North
Own
4
50K-100K
$ 23
6

383
East
Rent
2
50K-100K
$ 27
7

384
West
Own
5
25K-50K
$ 25
5

385
North
Rent
3
25K-50K
$ 18
3

386
East
Own
5
25K-50K
$ 24
6

387
South
Own
6
10K-25K
$ 21
8

388
West
Own
4
100K+
$ 40
2

389
North
Own
3
100K+
$ 19
4

390
South
Rent
5
10K-25K
$ 30
9

391
West
Own
6
25K-50K
$ 35
7

392
East
Own
4
25K-50K
$ 24
10

393
East
Rent
6
25K-50K
$ 26
2

394
North
Own
4
50K-100K
$ 15
6

395
North
Rent
7
50K-100K
$ 18
5

396
West
Own
4
25K-50K
$ 28
7

397
West
Own
3
50K-100K
$ 24
4

398
East
Rent
1
50K-100K
$ 30
3

399
North
Rent
2
100K+
$ 30
2

400
East
Rent
5
25K-50K
$ 23
8

401
South
Own
3
25K-50K
$ 28
6

402
East
Rent
4
10K-25K
$ 21
7

403
North
Own
6
25K-50K
$ 28
5

404
South
Own
5
100K+
$ 22
3

405
West
Rent
3
50K-100K
$ 28
6

406
East
Own
2
50K-100K
$ 30
8

407
West
Rent
1
25K-50K
$ 28
1

408
North
Own
6
25K-50K
$ 25
8

409
East
Own
7
50K-100K
$ 29
6

410
North
Rent
2
50K-100K
$ 28
4

411
East
Rent
1
25K-50K
$ 30
7

412
North
Own
2
50K-100K
$ 19
3

413
South
Own
3
50K-100K
$ 30
1

414
North
Own
2
25K-50K
$ 149
4

415
West
Own
1
50K-100K
$ 155
1

416
East
Rent
3
10K-25K
$ 115
4

417
South
Own
4
100K+
$ 119
6

418
East
Own
6
50K-100K
$ 99
5

419
West
Own
5
50K-100K
$ 119
3

420
North
Own
4
25K-50K
$ 149
7

421
West
Own
3
25K-50K
$ 145
6

422
North
Rent
5
25K-50K
$ 119
8

423
East
Own
6
10K-25K
$ 129
9

424
West
Own
7
100K+
$ 99
10

425
North
Own
5
100K+
$ 119
2

426
East
Rent
6
10K-25K
$ 185
6

427
South
Rent
3
25K-50K
$ 119
4

428
West
Own
4
25K-50K
$ 99
7

429
North
Own
5
25K-50K
$ 109
5

430
East
Own
2
50K-100K
$ 179
8

431
South
Own
3
50K-100K
$ 169
9

432
West
Rent
5
25K-50K
$ 179
2

433
North
Rent
4
50K-100K
$ 145
5

434
East
Rent
6
50K-100K
$ 119
4

435
South
Own
7
100K+
$ 165
3

436
West
Rent
2
25K-50K
$ 129
11

437
East
Own
3
25K-50K
$ 159
7

438
East
Own
1
10K-25K
$ 37
4

439
North
Rent
3
25K-50K
$ 55
6

440
North
Own
5
25K-50K
$ 63
5

441
West
Own
4
25K-50K
$ 56
9

442
West
Own
6
50K-100K
$ 67
2

443
East
Rent
7
50K-100K
$ 60
5

444
North
Rent
2
50K-100K
$ 50
3

445
East
Own
3
25K-50K
$ 49
6

446
South
Own
4
10K-25K
$ 56
8

447
East
Own
5
25K-50K
$ 60
4

448
North
Own
3
100K+
$ 59
7

449
South
Rent
4
10K-25K
$ 59
5

450
West
Rent
1
25K-50K
$ 60
1

451
East
Rent
3
50K-100K
$ 68
10

452
South
Own
4
50K-100K
$ 84
11

453
North
Rent
5
25K-50K
$ 69
11

454
West
Own
6
25K-50K
$ 97
11

455
East
Rent
7
50K-100K
$ 61
3

456
South
Own
6
10K-25K
$ 75
6

457
East
Own
7
100K+
$ 76
4

458
West
Own
4
100K+
$ 98
7

459
North
Rent
3
100K+
$ 95
9

460
West
Rent
5
50K-100K
$ 59
3

461
North
Own
2
50K-100K
$ 44
2

462
East
Rent
3
100K+
$ 97
6

463
West
Own
4
10K-25K
$ 68
5

464
North
Own
6
100K+
$ 145
8

465
East
Own
4
25K-50K
$ 119
7

466
South
Rent
5
50K-100K
$ 129
2

467
West
Own
3
10K-25K
$ 99
4

468
North
Rent
2
50K-100K
$ 119
3

469
North
Own
6
10K-25K
$ 185
6

470
East
Own
3
100K+
$ 119
9

471
West
Own
1
25K-50K
$ 99
10

472
South
Own
4
50K-100K
$ 60
11

473
East
Rent
3
10K-25K
$ 50
4

474
West
Rent
5
50K-100K
$ 49
2

475
South
Own
6
25K-50K
$ 56
1

476
East
Own
3
25K-50K
$ 60
5

477
North
Own
2
25K-50K
$ 59
4

478
East
Own
4
50K-100K
$ 59
7

479
North
Rent
5
100K+
$ 60
8

480
West
Rent
7
50K-100K
$ 68
9

481
East
Rent
2
25K-50K
$ 84
1

482
West
Own
1
50K-100K
$ 69
7

483
South
Rent
2
50K-100K
$ 97
4

484
North
Own
1
25K-50K
$ 61
6

485
East
Rent
3
50K-100K
$ 75
5

486
East
Own
6
50K-100K
$ 76
9

487
West
Own
4
50K-100K
$ 98
2

Question 5

CUST ID
REGION
RENT VS. OWN
NUM HOUSEHOLD
ANNUAL INCOME
TOTAL PURCHASES
NUM PURCHASES

1
North
Own
1
10K-25K
$ 38
1

2
South
Own
4
100K+
$ 30
4

3
North
Rent
3
25K-50K
$ 19
3

4
West
Own
5
25K-50K
$ 21
6

5
East
Own
6
50K-100K
$ 35
7

6
South
Own
2
10K-25K
$ 27
5

7
East
Own
3
100K+
$ 26
3

8
West
Rent
4
25K-50K
$ 25
6

9
North
Own
5
50K-100K
$ 30
8

10
West
Rent
7
25K-50K
$ 26
2

11
North
Own
1
50K-100K
$ 21
4

12
East
Own
2
100K+
$ 29
9

13
South
Own
5
10K-25K
$ 20
7

14
South
Own
4
25K-50K
$ 27
10

15
South
Rent
3
50K-100K
$ 19
2

16
West
Own
5
25K-50K
$ 19
6

17
North
Own
6
50K-100K
$ 129
5

18
East
Rent
2
10K-25K
$ 99
7

19
West
Own
3
25K-50K
$ 99
4

20
North
Rent
1
50K-100K
$ 119
3

21
East
Own
4
50K-100K
$ 149
2

22
South
Own
3
50K-100K
$ 165
8

23
West
Rent
5
25K-50K
$ 119
6

24
North
Rent
6
10K-25K
$ 129
7

25
East
Rent
7
100K+
$ 165
5

26
South
Own
3
10K-25K
$ 99
3

27
West
Rent
2
25K-50K
$ 155
6

28
North
Own
4
50K-100K
$ 115
8

29
East
Own
5
50K-100K
$ 129
1

30
South
Rent
4
50K-100K
$ 99
8

31
West
Own
2
25K-50K
$ 169
6

32
East
Rent
3
25K-50K
$ 40
4

33
East
Own
1
50K-100K
$ 36
7

34
North
Own
6
100K+
$ 45
3

35
North
Own
5
10K-25K
$ 29
1

36
West
Rent
4
100K+
$ 28
4

37
East
Rent
1
25K-50K
$ 46
1

38
South
Rent
5
50K-100K
$ 50
4

39
East
Rent
3
50K-100K
$ 22
6

40
West
Own
6
50K-100K
$ 20
9

41
North
Own
7
25K-50K
$ 19
3

42
East
Own
3
50K-100K
$ 31
1

43
South
Rent
2
50K-100K
$ 30
10

44
West
Rent
4
25K-50K
$ 18
3

45
East
Own
5
25K-50K
$ 31
7

46
South
Own
3
10K-25K
$ 35
6

47
West
Own
7
25K-50K
$ 28
5

48
East
Rent
3
100K+
$ 29
8

49
South
Rent
2
10K-25K
$ 35
6

50
North
Own
6
25K-50K
$ 30
4

51
South
Own
5
50K-100K
$ 38
7

52
West
Own
3
50K-100K
$ 20
3

53
North
Rent
1
25K-50K
$ 40
5

54
East
Rent
5
25K-50K
$ 30
4

55
South
Own
6
25K-50K
$ 40
8

56
West
Rent
3
10K-25K
$ 62
7

57
North
Rent
4
100K+
$ 22
9

58
East
Rent
5
100K+
$ 25
1

59
West
Rent
7
10K-25K
$ 27
4

60
East
Rent
2
25K-50K
$ 22
7

61
South
Own
3
25K-50K
$ 30
4

62
East
Own
1
25K-50K
$ 31
3

63
East
Own
4
50K-100K
$ 22
8

64
South
Rent
2
50K-100K
$ 25
9

65
West
Own
3
25K-50K
$ 24
3

66
East
Own
5
50K-100K
$ 36
2

67
North
Rent
4
50K-100K
$ 123
11

68
North
Rent
6
100K+
$ 19
2

69
North
Own
5
100K+
$ 23
6

70
South
Rent
7
100K+
$ 19
8

71
West
Rent
4
25K-50K
$ 25
6

72
West
Rent
5
50K-100K
$ 129
8

73
North
Own
3
50K-100K
$ 119
9

74
East
Own
6
100K+
$ 109
3

75
North
Own
5
10K-25K
$ 179
6

76
East
Rent
4
100K+
$ 145
5

77
South
Own
2
25K-50K
$ 119
7

78
North
Rent
3
50K-100K
$ 129
2

79
East
Own
4
10K-25K
$ 189
4

80
West
Own
6
50K-100K
$ 155
6

81
North
Rent
5
25K-50K
$ 78
4

82
East
Own
4
25K-50K
$ 61
5

83
South
Rent
3
25K-50K
$ 97
7

84
North
Rent
2
50K-100K
$ 63
2

85
West
Own
4
100K+
$ 39
3

86
East
Rent
6
50K-100K
$ 95
1

87
South
Rent
4
25K-50K
$ 86
7

88
West
Own
1
50K-100K
$ 85
5

89
East
Own
2
50K-100K
$ 59
7

90
North
Rent
3
100K+
$ 84
9

91
North
Own
2
100K+
$ 144
10

92
West
Rent
3
100K+
$ 26
1

93
South
Rent
7
25K-50K
$ 31
1

94
East
Own
6
50K-100K
$ 19
1

95
South
Rent
5
50K-100K
$ 30
1

96
West
Rent
4
100K+
$ 29
11

97
West
Rent
5
10K-25K
$ 25
2

98
West
Rent
6
100K+
$ 24
6

99
East
Rent
3
25K-50K
$ 36
5

100
North
Own
4
50K-100K
$ 29
7

101
South
Own
2
10K-25K
$ 99
9

102
West
Rent
1
50K-100K
$ 169
3

103
East
Own
3
10K-25K
$ 179
1

104
North
Rent
4
100K+
$ 119
7

105
South
Own
5
25K-50K
$ 99
4

106
West
Rent
4
50K-100K
$ 179
7

107
East
Own
6
10K-25K
$ 185
6

108
North
Rent
3
50K-100K
$ 179
8

109
South
Rent
4
25K-50K
$ 145
9

110
West
Rent
5
25K-50K
$ 119
3

111
North
Own
7
25K-50K
$ 99
2

112
North
Own
2
50K-100K
$ 155
5

113
East
Own
3
100K+
$ 119
4

114
North
Rent
5
50K-100K
$ 149
7

115
East
Rent
3
25K-50K
$ 56
5

116
North
Rent
2
50K-100K
$ 50
6

117
West
Own
4
50K-100K
$ 86
3

118
South
Rent
2
100K+
$ 45
2

119
East
Rent
1
100K+
$ 95
6

120
West
Rent
3
100K+
$ 86
8

121
South
Rent
2
25K-50K
$ 97
11

122
East
Rent
4
50K-100K
$ 40
8

123
North
Rent
5
50K-100K
$ 50
5

124
East
Own
6
100K+
$ 59
3

125
North
Rent
3
10K-25K
$ 75
4

126
South
Rent
4
50K-100K
$ 68
3

127
West
Rent
6
50K-100K
$ 63
1

128
North
Own
2
25K-50K
$ 56
10

129
East
Own
4
25K-50K
$ 86
2

130
North
Rent
6
50K-100K
$ 45
6

131
West
Own
3
100K+
$ 78
8

132
South
Own
4
10K-25K
$ 68
7

133
East
Rent
7
100K+
$ 95
6

134
North
Own
4
25K-50K
$ 95
4

135
East
Rent
5
50K-100K
$ 39
7

136
East
Own
6
50K-100K
$ 56
8

137
North
Own
2
50K-100K
$ 31
9

138
South
Rent
3
25K-50K
$ 29
6

139
West
Rent
4
50K-100K
$ 41
7

140
East
Rent
5
50K-100K
$ 62
4

141
North
Rent
1
25K-50K
$ 51
3

142
South
Own
2
25K-50K
$ 37
2

143
West
Own
3
10K-25K
$ 19
6

144
East
Rent
4
25K-50K
$ 38
5

145
North
Rent
5
100K+
$ 56
7

146
East
Own
4
100K+
$ 41
5

147
West
Own
3
25K-50K
$ 51
8

148
North
Rent
6
50K-100K
$ 19
4

149
East
Rent
2
10K-25K
$ 29
3

150
North
Own
4
50K-100K
$ 41
5

151
East
Own
3
25K-50K
$ 19
6

152
West
Own
3
25K-50K
$ 30
7

153
North
Own
5
25K-50K
$ 19
8

154
South
Rent
4
50K-100K
$ 21
3

155
East
Own
6
100K+
$ 23
2

156
North
Own
7
50K-100K
$ 29
5

157
West
Own
2
25K-50K
$ 18
2

158
East
Own
3
50K-100K
$ 26
5

159
South
Own
1
50K-100K
$ 20
1

160
West
Rent
2
100K+
$ 76
11

161
East
Own
4
100K+
$ 40
4

162
South
Own
2
100K+
$ 41
3

163
North
Own
4
25K-50K
$ 24
7

164
East
Rent
5
50K-100K
$ 26
5

165
West
Rent
6
50K-100K
$ 25
8

166
South
Own
4
100K+
$ 26
6

167
East
Own
2
10K-25K
$ 23
8

168
North
Own
4
50K-100K
$ 27
5

169
East
Own
3
50K-100K
$ 25
8

170
South
Rent
5
25K-50K
$ 34
10

171
West
Rent
4
25K-50K
$ 24
7

172
West
Rent
6
50K-100K
$ 21
9

173
East
Own
4
100K+
$ 40
8

174
South
Rent
3
50K-100K
$ 19
1

175
West
Own
1
100K+
$ 30
11

176
East
Rent
2
100K+
$ 35
10

177
North
Own
4
100K+
$ 24
1

178
East
Own
7
25K-50K
$ 26
4

179
South
Own
4
50K-100K
$ 15
1

180
East
Rent
6
50K-100K
$ 18
3

181
North
Rent
3
100K+
$ 28
1

182
South
Own
7
10K-25K
$ 24
4

183
West
Rent
2
100K+
$ 30
5

184
East
Own
1
25K-50K
$ 30
4

185
West
Own
4
50K-100K
$ 23
7

186
North
Own
5
10K-25K
$ 28
5

187
East
Rent
3
50K-100K
$ 21
6

188
North
Own
2
25K-50K
$ 28
4

189
East
Rent
4
25K-50K
$ 22
2

190
West
Own
5
25K-50K
$ 28
6

191
North
Own
2
50K-100K
$ 30
8

192
South
Own
1
100K+
$ 28
9

193
East
Own
4
50K-100K
$ 25
10

194
North
Rent
2
25K-50K
$ 29
3

195
West
Own
5
50K-100K
$ 28
6

196
East
Own
3
50K-100K
$ 30
5

197
South
Rent
6
100K+
$ 19
4

198
West
Own
5
100K+
$ 30
6

199
East
Rent
7
100K+
$ 149
8

200
South
Own
4
25K-50K
$ 155
7

201
North
Own
5
50K-100K
$ 115
4

202
East
Rent
6
50K-100K
$ 119
5

203
West
Rent
3
100K+
$ 99
7

204
South
Rent
2
10K-25K
$ 119
8

205
East
Own
4
100K+
$ 149
9

206
North
Rent
5
25K-50K
$ 145
11

207
East
Own
3
25K-50K
$ 119
8

208
South
Own
5
50K-100K
$ 129
5

209
North
Rent
4
50K-100K
$ 99
7

210
East
Own
6
50K-100K
$ 119
8

211
South
Rent
4
100K+
$ 185
9

212
West
Own
5
10K-25K
$ 119
5

213
West
Own
6
50K-100K
$ 99
2

214
East
Own
7
50K-100K
$ 109
6

215
South
Rent
1
25K-50K
$ 179
8

216
West
Rent
3
25K-50K
$ 169
6

217
East
Rent
2
50K-100K
$ 179
9

218
North
Rent
5
10K-25K
$ 145
7

219
East
Own
4
100K+
$ 119
6

220
South
Own
6
100K+
$ 165
3

221
East
Own
7
10K-25K
$ 129
2

222
North
Rent
3
100K+
$ 159
11

223
South
Rent
2
50K-100K
$ 37
7

224
West
Own
4
50K-100K
$ 55
5

225
East
Own
5
25K-50K
$ 63
7

226
West
Own
4
25K-50K
$ 56
8

227
North
Rent
3
10K-25K
$ 67
6

228
East
Rent
4
50K-100K
$ 60
8

229
North
Own
6
25K-50K
$ 50
9

230
East
Own
5
50K-100K
$ 49
3

231
West
Own
4
100K+
$ 56
4

232
North
Rent
2
50K-100K
$ 60
7

233
South
Rent
3
50K-100K
$ 59
2

234
East
Own
1
50K-100K
$ 59
8

235
North
Rent
7
50K-100K
$ 60
5

236
West
Rent
3
50K-100K
$ 68
7

237
South
Rent
4
25K-50K
$ 84
9

238
South
Rent
2
25K-50K
$ 69
2

239
West
Rent
5
100K+
$ 97
5

240
North
Own
3
10K-25K
$ 61
4

241
East
Own
4
100K+
$ 75
6

242
West
Own
5
100K+
$ 76
11

243
North
Rent
6
100K+
$ 98
8

244
East
Own
4
25K-50K
$ 95
5

245
South
Own
5
25K-50K
$ 59
7

246
West
Rent
6
50K-100K
$ 44
4

247
North
Rent
7
50K-100K
$ 97
3

248
East
Own
4
100K+
$ 68
6

249
South
Rent
3
25K-50K
$ 145
10

250
West
Rent
2
50K-100K
$ 119
3

251
North
Rent
1
10K-25K
$ 129
6

252
East
Own
5
50K-100K
$ 99
8

253
South
Own
4
25K-50K
$ 119
6

254
West
Own
6
25K-50K
$ 185
8

255
East
Rent
3
25K-50K
$ 119
10

256
East
Own
2
50K-100K
$ 99
3

257
North
Rent
1
100K+
$ 60
6

258
North
Own
5
50K-100K
$ 50
5

259
West
Own
4
25K-50K
$ 49
8

260
West
Rent
6
50K-100K
$ 56
4

261
East
Own
7
50K-100K
$ 60
7

262
North
Rent
3
100K+
$ 59
3

263
East
Rent
2
100K+
$ 59
2

264
South
Own
4
100K+
$ 60
6

265
East
Rent
5
25K-50K
$ 68
5

266
North
Rent
3
50K-100K
$ 84
8

267
South
Own
2
50K-100K
$ 69
9

268
West
Own
4
100K+
$ 97
3

269
East
Rent
3
10K-25K
$ 61
2

270
West
Own
4
50K-100K
$ 75
6

271
North
Rent
3
50K-100K
$ 76
5

272
East
Rent
4
25K-50K
$ 98
7

273
North
Own
5
25K-50K
$ 95
9

274
East
Rent
4
50K-100K
$ 59
4

275
West
Rent
6
100K+
$ 44
6

276
North
Rent
5
50K-100K
$ 97
8

277
South
Rent
7
100K+
$ 68
7

278
East
Rent
1
100K+
$ 145
1

279
North
Own
2
100K+
$ 85
10

280
West
Own
3
25K-50K
$ 59
3

281
South
Rent
4
50K-100K
$ 84
7

282
South
Own
3
50K-100K
$ 28
5

283
South
Rent
5
100K+
$ 26
8

284
East
Own
3
10K-25K
$ 31
9

285
North
Rent
3
100K+
$ 19
3

286
West
Own
2
25K-50K
$ 30
2

287
East
Rent
4
50K-100K
$ 29
11

288
South
Rent
5
10K-25K
$ 25
6

289
West
Rent
6
50K-100K
$ 24
3

290
East
Own
5
25K-50K
$ 36
6

291
South
Own
4
25K-50K
$ 29
7

292
North
Own
3
25K-50K
$ 99
9

293
East
Rent
5
50K-100K
$ 169
8

294
West
Rent
4
100K+
$ 179
3

295
South
Rent
6
50K-100K
$ 119
5

296
East
Own
4
25K-50K
$ 99
4

297
North
Rent
6
50K-100K
$ 56
6

298
East
Rent
1
50K-100K
$ 50
11

299
South
Rent
2
100K+
$ 86
10

300
North
Rent
3
100K+
$ 45
3

301
East
Rent
4
100K+
$ 95
2

302
South
Rent
7
25K-50K
$ 86
10

303
West
Own
4
50K-100K
$ 97
11

304
West
Rent
3
50K-100K
$ 40
7

305
East
Rent
1
100K+
$ 50
5

306
South
Rent
4
10K-25K
$ 59
9

307
West
Own
2
100K+
$ 75
4

308
East
Own
5
25K-50K
$ 68
3

309
North
Rent
3
25K-50K
$ 26
2

310
East
Own
6
50K-100K
$ 15
6

311
South
Own
4
50K-100K
$ 18
8

312
East
Rent
7
50K-100K
$ 28
6

313
North
Own
3
100K+
$ 24
8

314
South
Rent
2
10K-25K
$ 30
9

315
West
Own
4
50K-100K
$ 30
10

316
East
Own
5
50K-100K
$ 23
3

317
West
Rent
3
25K-50K
$ 28
2

318
North
Rent
1
25K-50K
$ 21
6

319
East
Rent
4
50K-100K
$ 28
5

320
North
Rent
3
10K-25K
$ 22
8

321
East
Own
5
100K+
$ 28
7

322
West
Own
6
100K+
$ 30
9

323
North
Rent
4
10K-25K
$ 28
4

324
South
Rent
2
100K+
$ 25
6

325
East
Own
5
50K-100K
$ 29
3

326
North
Own
3
50K-100K
$ 28
5

327
West
Rent
5
25K-50K
$ 30
3

328
South
Rent
6
25K-50K
$ 19
6

329
South
Own
4
10K-25K
$ 30
5

330
West
Own
3
50K-100K
$ 149
7

331
North
Own
5
25K-50K
$ 155
9

332
East
Own
6
50K-100K
$ 115
4

333
West
Rent
4
100K+
$ 39
6

334
North
Own
6
50K-100K
$ 95
8

335
East
Own
4
50K-100K
$ 86
7

336
South
Own
7
50K-100K
$ 85
1

337
West
Own
4
50K-100K
$ 59
10

338
North
Own
3
50K-100K
$ 84
3

339
East
Rent
1
25K-50K
$ 28
7

340
South
Own
2
25K-50K
$ 26
5

341
West
Own
5
100K+
$ 31
8

342
North
Own
3
10K-25K
$ 19
9

343
East
Rent
4
100K+
$ 30
3

344
South
Rent
6
100K+
$ 29
2

345
West
Own
5
100K+
$ 25
11

346
East
Own
3
25K-50K
$ 24
6

347
East
Own
2
25K-50K
$ 36
3

348
North
Own
1
50K-100K
$ 29
6

349
North
Rent
6
50K-100K
$ 99
7

350
West
Rent
7
50K-100K
$ 169
9

351
West
Rent
2
50K-100K
$ 179
8

352
East
Own
1
10K-25K
$ 119
3

353
North
Rent
2
100K+
$ 99
5

354
East
Own
3
10K-25K
$ 179
4

355
South
Own
2
100K+
$ 185
6

356
East
Rent
1
50K-100K
$ 179
11

357
North
Own
3
50K-100K
$ 145
10

358
South
Own
4
25K-50K
$ 119
3

359
West
Own
6
25K-50K
$ 99
2

360
East
Rent
5
10K-25K
$ 155
10

361
West
Rent
4
50K-100K
$ 119
11

362
North
Own
3
25K-50K
$ 149
7

363
East
Own
5
50K-100K
$ 56
5

364
North
Own
6
100K+
$ 50
9

365
East
Own
7
50K-100K
$ 86
4

366
North
Rent
5
50K-100K
$ 45
3

367
South
Rent
6
50K-100K
$ 95
2

368
North
Rent
3
50K-100K
$ 86
6

369
West
Own
4
50K-100K
$ 97
8

370
East
Rent
5
25K-50K
$ 23
6

371
South
Own
2
25K-50K
$ 29
8

372
East
Rent
3
100K+
$ 18
9

373
West
Own
6
10K-25K
$ 26
10

374
North
Own
2
100K+
$ 20
3

375
West
Own
5
100K+
$ 15
2

376
North
Rent
4
100K+
$ 40
6

377
East
Rent
1
25K-50K
$ 41
5

378
South
Own
4
25K-50K
$ 24
8

379
South
Rent
3
50K-100K
$ 26
7

380
South
Own
5
10K-25K
$ 25
9

381
West
Own
6
25K-50K
$ 26
4

382
North
Own
4
50K-100K
$ 23
6

383
East
Rent
2
50K-100K
$ 27
7

384
West
Own
5
25K-50K
$ 25
5

385
North
Rent
3
25K-50K
$ 18
3

386
East
Own
5
25K-50K
$ 24
6

387
South
Own
6
10K-25K
$ 21
8

388
West
Own
4
100K+
$ 40
2

389
North
Own
3
100K+
$ 19
4

390
South
Rent
5
10K-25K
$ 30
9

391
West
Own
6
25K-50K
$ 35
7

392
East
Own
4
25K-50K
$ 24
10

393
East
Rent
6
25K-50K
$ 26
2

394
North
Own
4
50K-100K
$ 15
6

395
North
Rent
7
50K-100K
$ 18
5

396
West
Own
4
25K-50K
$ 28
7

397
West
Own
3
50K-100K
$ 24
4

398
East
Rent
1
50K-100K
$ 30
3

399
North
Rent
2
100K+
$ 30
2

400
East
Rent
5
25K-50K
$ 23
8

401
South
Own
3
25K-50K
$ 28
6

402
East
Rent
4
10K-25K
$ 21
7

403
North
Own
6
25K-50K
$ 28
5

404
South
Own
5
100K+
$ 22
3

405
West
Rent
3
50K-100K
$ 28
6

406
East
Own
2
50K-100K
$ 30
8

407
West
Rent
1
25K-50K
$ 28
1

408
North
Own
6
25K-50K
$ 25
8

409
East
Own
7
50K-100K
$ 29
6

410
North
Rent
2
50K-100K
$ 28
4

411
East
Rent
1
25K-50K
$ 30
7

412
North
Own
2
50K-100K
$ 19
3

413
South
Own
3
50K-100K
$ 30
1

414
North
Own
2
25K-50K
$ 149
4

415
West
Own
1
50K-100K
$ 155
1

416
East
Rent
3
10K-25K
$ 115
4

417
South
Own
4
100K+
$ 119
6

418
East
Own
6
50K-100K
$ 99
5

419
West
Own
5
50K-100K
$ 119
3

420
North
Own
4
25K-50K
$ 149
7

421
West
Own
3
25K-50K
$ 145
6

422
North
Rent
5
25K-50K
$ 119
8

423
East
Own
6
10K-25K
$ 129
9

424
West
Own
7
100K+
$ 99
10

425
North
Own
5
100K+
$ 119
2

426
East
Rent
6
10K-25K
$ 185
6

427
South
Rent
3
25K-50K
$ 119
4

428
West
Own
4
25K-50K
$ 99
7

429
North
Own
5
25K-50K
$ 109
5

430
East
Own
2
50K-100K
$ 179
8

431
South
Own
3
50K-100K
$ 169
9

432
West
Rent
5
25K-50K
$ 179
2

433
North
Rent
4
50K-100K
$ 145
5

434
East
Rent
6
50K-100K
$ 119
4

435
South
Own
7
100K+
$ 165
3

436
West
Rent
2
25K-50K
$ 129
11

437
East
Own
3
25K-50K
$ 159
7

438
East
Own
1
10K-25K
$ 37
4

439
North
Rent
3
25K-50K
$ 55
6

440
North
Own
5
25K-50K
$ 63
5

441
West
Own
4
25K-50K
$ 56
9

442
West
Own
6
50K-100K
$ 67
2

443
East
Rent
7
50K-100K
$ 60
5

444
North
Rent
2
50K-100K
$ 50
3

445
East
Own
3
25K-50K
$ 49
6

446
South
Own
4
10K-25K
$ 56
8

447
East
Own
5
25K-50K
$ 60
4

448
North
Own
3
100K+
$ 59
7

449
South
Rent
4
10K-25K
$ 59
5

450
West
Rent
1
25K-50K
$ 60
1

451
East
Rent
3
50K-100K
$ 68
10

452
South
Own
4
50K-100K
$ 84
11

453
North
Rent
5
25K-50K
$ 69
11

454
West
Own
6
25K-50K
$ 97
11

455
East
Rent
7
50K-100K
$ 61
3

456
South
Own
6
10K-25K
$ 75
6

457
East
Own
7
100K+
$ 76
4

458
West
Own
4
100K+
$ 98
7

459
North
Rent
3
100K+
$ 95
9

460
West
Rent
5
50K-100K
$ 59
3

461
North
Own
2
50K-100K
$ 44
2

462
East
Rent
3
100K+
$ 97
6

463
West
Own
4
10K-25K
$ 68
5

464
North
Own
6
100K+
$ 145
8

465
East
Own
4
25K-50K
$ 119
7

466
South
Rent
5
50K-100K
$ 129
2

467
West
Own
3
10K-25K
$ 99
4

468
North
Rent
2
50K-100K
$ 119
3

469
North
Own
6
10K-25K
$ 185
6

470
East
Own
3
100K+
$ 119
9

471
West
Own
1
25K-50K
$ 99
10

472
South
Own
4
50K-100K
$ 60
11

473
East
Rent
3
10K-25K
$ 50
4

474
West
Rent
5
50K-100K
$ 49
2

475
South
Own
6
25K-50K
$ 56
1

476
East
Own
3
25K-50K
$ 60
5

477
North
Own
2
25K-50K
$ 59
4

478
East
Own
4
50K-100K
$ 59
7

479
North
Rent
5
100K+
$ 60
8

480
West
Rent
7
50K-100K
$ 68
9

481
East
Rent
2
25K-50K
$ 84
1

482
West
Own
1
50K-100K
$ 69
7

483
South
Rent
2
50K-100K
$ 97
4

484
North
Own
1
25K-50K
$ 61
6

485
East
Rent
3
50K-100K
$ 75
5

486
East
Own
6
50K-100K
$ 76
9

487
West
Own
4
50K-100K
$ 98
2

Question 6

CUST ID
REGION
RENT VS. OWN
NUM HOUSEHOLD
ANNUAL INCOME
TOTAL PURCHASES
NUM PURCHASES

1
North
Own
1
10K-25K
$ 38
1

2
South
Own
4
100K+
$ 30
4

3
North
Rent
3
25K-50K
$ 19
3

4
West
Own
5
25K-50K
$ 21
6

5
East
Own
6
50K-100K
$ 35
7

6
South
Own
2
10K-25K
$ 27
5

7
East
Own
3
100K+
$ 26
3

8
West
Rent
4
25K-50K
$ 25
6

9
North
Own
5
50K-100K
$ 30
8

10
West
Rent
7
25K-50K
$ 26
2

11
North
Own
1
50K-100K
$ 21
4

12
East
Own
2
100K+
$ 29
9

13
South
Own
5
10K-25K
$ 20
7

14
South
Own
4
25K-50K
$ 27
10

15
South
Rent
3
50K-100K
$ 19
2

16
West
Own
5
25K-50K
$ 19
6

17
North
Own
6
50K-100K
$ 129
5

18
East
Rent
2
10K-25K
$ 99
7

19
West
Own
3
25K-50K
$ 99
4

20
North
Rent
1
50K-100K
$ 119
3

21
East
Own
4
50K-100K
$ 149
2

22
South
Own
3
50K-100K
$ 165
8

23
West
Rent
5
25K-50K
$ 119
6

24
North
Rent
6
10K-25K
$ 129
7

25
East
Rent
7
100K+
$ 165
5

26
South
Own
3
10K-25K
$ 99
3

27
West
Rent
2
25K-50K
$ 155
6

28
North
Own
4
50K-100K
$ 115
8

29
East
Own
5
50K-100K
$ 129
1

30
South
Rent
4
50K-100K
$ 99
8

31
West
Own
2
25K-50K
$ 169
6

32
East
Rent
3
25K-50K
$ 40
4

33
East
Own
1
50K-100K
$ 36
7

34
North
Own
6
100K+
$ 45
3

35
North
Own
5
10K-25K
$ 29
1

36
West
Rent
4
100K+
$ 28
4

37
East
Rent
1
25K-50K
$ 46
1

38
South
Rent
5
50K-100K
$ 50
4

39
East
Rent
3
50K-100K
$ 22
6

40
West
Own
6
50K-100K
$ 20
9

41
North
Own
7
25K-50K
$ 19
3

42
East
Own
3
50K-100K
$ 31
1

43
South
Rent
2
50K-100K
$ 30
10

44
West
Rent
4
25K-50K
$ 18
3

45
East
Own
5
25K-50K
$ 31
7

46
South
Own
3
10K-25K
$ 35
6

47
West
Own
7
25K-50K
$ 28
5

48
East
Rent
3
100K+
$ 29
8

49
South
Rent
2
10K-25K
$ 35
6

50
North
Own
6
25K-50K
$ 30
4

51
South
Own
5
50K-100K
$ 38
7

52
West
Own
3
50K-100K
$ 20
3

53
North
Rent
1
25K-50K
$ 40
5

54
East
Rent
5
25K-50K
$ 30
4

55
South
Own
6
25K-50K
$ 40
8

56
West
Rent
3
10K-25K
$ 62
7

57
North
Rent
4
100K+
$ 22
9

58
East
Rent
5
100K+
$ 25
1

59
West
Rent
7
10K-25K
$ 27
4

60
East
Rent
2
25K-50K
$ 22
7

61
South
Own
3
25K-50K
$ 30
4

62
East
Own
1
25K-50K
$ 31
3

63
East
Own
4
50K-100K
$ 22
8

64
South
Rent
2
50K-100K
$ 25
9

65
West
Own
3
25K-50K
$ 24
3

66
East
Own
5
50K-100K
$ 36
2

67
North
Rent
4
50K-100K
$ 123
11

68
North
Rent
6
100K+
$ 19
2

69
North
Own
5
100K+
$ 23
6

70
South
Rent
7
100K+
$ 19
8

71
West
Rent
4
25K-50K
$ 25
6

72
West
Rent
5
50K-100K
$ 129
8

73
North
Own
3
50K-100K
$ 119
9

74
East
Own
6
100K+
$ 109
3

75
North
Own
5
10K-25K
$ 179
6

76
East
Rent
4
100K+
$ 145
5

77
South
Own
2
25K-50K
$ 119
7

78
North
Rent
3
50K-100K
$ 129
2

79
East
Own
4
10K-25K
$ 189
4

80
West
Own
6
50K-100K
$ 155
6

81
North
Rent
5
25K-50K
$ 78
4

82
East
Own
4
25K-50K
$ 61
5

83
South
Rent
3
25K-50K
$ 97
7

84
North
Rent
2
50K-100K
$ 63
2

85
West
Own
4
100K+
$ 39
3

86
East
Rent
6
50K-100K
$ 95
1

87
South
Rent
4
25K-50K
$ 86
7

88
West
Own
1
50K-100K
$ 85
5

89
East
Own
2
50K-100K
$ 59
7

90
North
Rent
3
100K+
$ 84
9

91
North
Own
2
100K+
$ 144
10

92
West
Rent
3
100K+
$ 26
1

93
South
Rent
7
25K-50K
$ 31
1

94
East
Own
6
50K-100K
$ 19
1

95
South
Rent
5
50K-100K
$ 30
1

96
West
Rent
4
100K+
$ 29
11

97
West
Rent
5
10K-25K
$ 25
2

98
West
Rent
6
100K+
$ 24
6

99
East
Rent
3
25K-50K
$ 36
5

100
North
Own
4
50K-100K
$ 29
7

101
South
Own
2
10K-25K
$ 99
9

102
West
Rent
1
50K-100K
$ 169
3

103
East
Own
3
10K-25K
$ 179
1

104
North
Rent
4
100K+
$ 119
7

105
South
Own
5
25K-50K
$ 99
4

106
West
Rent
4
50K-100K
$ 179
7

107
East
Own
6
10K-25K
$ 185
6

108
North
Rent
3
50K-100K
$ 179
8

109
South
Rent
4
25K-50K
$ 145
9

110
West
Rent
5
25K-50K
$ 119
3

111
North
Own
7
25K-50K
$ 99
2

112
North
Own
2
50K-100K
$ 155
5

113
East
Own
3
100K+
$ 119
4

114
North
Rent
5
50K-100K
$ 149
7

115
East
Rent
3
25K-50K
$ 56
5

116
North
Rent
2
50K-100K
$ 50
6

117
West
Own
4
50K-100K
$ 86
3

118
South
Rent
2
100K+
$ 45
2

119
East
Rent
1
100K+
$ 95
6

120
West
Rent
3
100K+
$ 86
8

121
South
Rent
2
25K-50K
$ 97
11

122
East
Rent
4
50K-100K
$ 40
8

123
North
Rent
5
50K-100K
$ 50
5

124
East
Own
6
100K+
$ 59
3

125
North
Rent
3
10K-25K
$ 75
4

126
South
Rent
4
50K-100K
$ 68
3

127
West
Rent
6
50K-100K
$ 63
1

128
North
Own
2
25K-50K
$ 56
10

129
East
Own
4
25K-50K
$ 86
2

130
North
Rent
6
50K-100K
$ 45
6

131
West
Own
3
100K+
$ 78
8

132
South
Own
4
10K-25K
$ 68
7

133
East
Rent
7
100K+
$ 95
6

134
North
Own
4
25K-50K
$ 95
4

135
East
Rent
5
50K-100K
$ 39
7

136
East
Own
6
50K-100K
$ 56
8

137
North
Own
2
50K-100K
$ 31
9

138
South
Rent
3
25K-50K
$ 29
6

139
West
Rent
4
50K-100K
$ 41
7

140
East
Rent
5
50K-100K
$ 62
4

141
North
Rent
1
25K-50K
$ 51
3

142
South
Own
2
25K-50K
$ 37
2

143
West
Own
3
10K-25K
$ 19
6

144
East
Rent
4
25K-50K
$ 38
5

145
North
Rent
5
100K+
$ 56
7

146
East
Own
4
100K+
$ 41
5

147
West
Own
3
25K-50K
$ 51
8

148
North
Rent
6
50K-100K
$ 19
4

149
East
Rent
2
10K-25K
$ 29
3

150
North
Own
4
50K-100K
$ 41
5

151
East
Own
3
25K-50K
$ 19
6

152
West
Own
3
25K-50K
$ 30
7

153
North
Own
5
25K-50K
$ 19
8

154
South
Rent
4
50K-100K
$ 21
3

155
East
Own
6
100K+
$ 23
2

156
North
Own
7
50K-100K
$ 29
5

157
West
Own
2
25K-50K
$ 18
2

158
East
Own
3
50K-100K
$ 26
5

159
South
Own
1
50K-100K
$ 20
1

160
West
Rent
2
100K+
$ 76
11

161
East
Own
4
100K+
$ 40
4

162
South
Own
2
100K+
$ 41
3

163
North
Own
4
25K-50K
$ 24
7

164
East
Rent
5
50K-100K
$ 26
5

165
West
Rent
6
50K-100K
$ 25
8

166
South
Own
4
100K+
$ 26
6

167
East
Own
2
10K-25K
$ 23
8

168
North
Own
4
50K-100K
$ 27
5

169
East
Own
3
50K-100K
$ 25
8

170
South
Rent
5
25K-50K
$ 34
10

171
West
Rent
4
25K-50K
$ 24
7

172
West
Rent
6
50K-100K
$ 21
9

173
East
Own
4
100K+
$ 40
8

174
South
Rent
3
50K-100K
$ 19
1

175
West
Own
1
100K+
$ 30
11

176
East
Rent
2
100K+
$ 35
10

177
North
Own
4
100K+
$ 24
1

178
East
Own
7
25K-50K
$ 26
4

179
South
Own
4
50K-100K
$ 15
1

180
East
Rent
6
50K-100K
$ 18
3

181
North
Rent
3
100K+
$ 28
1

182
South
Own
7
10K-25K
$ 24
4

183
West
Rent
2
100K+
$ 30
5

184
East
Own
1
25K-50K
$ 30
4

185
West
Own
4
50K-100K
$ 23
7

186
North
Own
5
10K-25K
$ 28
5

187
East
Rent
3
50K-100K
$ 21
6

188
North
Own
2
25K-50K
$ 28
4

189
East
Rent
4
25K-50K
$ 22
2

190
West
Own
5
25K-50K
$ 28
6

191
North
Own
2
50K-100K
$ 30
8

192
South
Own
1
100K+
$ 28
9

193
East
Own
4
50K-100K
$ 25
10

194
North
Rent
2
25K-50K
$ 29
3

195
West
Own
5
50K-100K
$ 28
6

196
East
Own
3
50K-100K
$ 30
5

197
South
Rent
6
100K+
$ 19
4

198
West
Own
5
100K+
$ 30
6

199
East
Rent
7
100K+
$ 149
8

200
South
Own
4
25K-50K
$ 155
7

201
North
Own
5
50K-100K
$ 115
4

202
East
Rent
6
50K-100K
$ 119
5

203
West
Rent
3
100K+
$ 99
7

204
South
Rent
2
10K-25K
$ 119
8

205
East
Own
4
100K+
$ 149
9

206
North
Rent
5
25K-50K
$ 145
11

207
East
Own
3
25K-50K
$ 119
8

208
South
Own
5
50K-100K
$ 129
5

209
North
Rent
4
50K-100K
$ 99
7

210
East
Own
6
50K-100K
$ 119
8

211
South
Rent
4
100K+
$ 185
9

212
West
Own
5
10K-25K
$ 119
5

213
West
Own
6
50K-100K
$ 99
2

214
East
Own
7
50K-100K
$ 109
6

215
South
Rent
1
25K-50K
$ 179
8

216
West
Rent
3
25K-50K
$ 169
6

217
East
Rent
2
50K-100K
$ 179
9

218
North
Rent
5
10K-25K
$ 145
7

219
East
Own
4
100K+
$ 119
6

220
South
Own
6
100K+
$ 165
3

221
East
Own
7
10K-25K
$ 129
2

222
North
Rent
3
100K+
$ 159
11

223
South
Rent
2
50K-100K
$ 37
7

224
West
Own
4
50K-100K
$ 55
5

225
East
Own
5
25K-50K
$ 63
7

226
West
Own
4
25K-50K
$ 56
8

227
North
Rent
3
10K-25K
$ 67
6

228
East
Rent
4
50K-100K
$ 60
8

229
North
Own
6
25K-50K
$ 50
9

230
East
Own
5
50K-100K
$ 49
3

231
West
Own
4
100K+
$ 56
4

232
North
Rent
2
50K-100K
$ 60
7

233
South
Rent
3
50K-100K
$ 59
2

234
East
Own
1
50K-100K
$ 59
8

235
North
Rent
7
50K-100K
$ 60
5

236
West
Rent
3
50K-100K
$ 68
7

237
South
Rent
4
25K-50K
$ 84
9

238
South
Rent
2
25K-50K
$ 69
2

239
West
Rent
5
100K+
$ 97
5

240
North
Own
3
10K-25K
$ 61
4

241
East
Own
4
100K+
$ 75
6

242
West
Own
5
100K+
$ 76
11

243
North
Rent
6
100K+
$ 98
8

244
East
Own
4
25K-50K
$ 95
5

245
South
Own
5
25K-50K
$ 59
7

246
West
Rent
6
50K-100K
$ 44
4

247
North
Rent
7
50K-100K
$ 97
3

248
East
Own
4
100K+
$ 68
6

249
South
Rent
3
25K-50K
$ 145
10

250
West
Rent
2
50K-100K
$ 119
3

251
North
Rent
1
10K-25K
$ 129
6

252
East
Own
5
50K-100K
$ 99
8

253
South
Own
4
25K-50K
$ 119
6

254
West
Own
6
25K-50K
$ 185
8

255
East
Rent
3
25K-50K
$ 119
10

256
East
Own
2
50K-100K
$ 99
3

257
North
Rent
1
100K+
$ 60
6

258
North
Own
5
50K-100K
$ 50
5

259
West
Own
4
25K-50K
$ 49
8

260
West
Rent
6
50K-100K
$ 56
4

261
East
Own
7
50K-100K
$ 60
7

262
North
Rent
3
100K+
$ 59
3

263
East
Rent
2
100K+
$ 59
2

264
South
Own
4
100K+
$ 60
6

265
East
Rent
5
25K-50K
$ 68
5

266
North
Rent
3
50K-100K
$ 84
8

267
South
Own
2
50K-100K
$ 69
9

268
West
Own
4
100K+
$ 97
3

269
East
Rent
3
10K-25K
$ 61
2

270
West
Own
4
50K-100K
$ 75
6

271
North
Rent
3
50K-100K
$ 76
5

272
East
Rent
4
25K-50K
$ 98
7

273
North
Own
5
25K-50K
$ 95
9

274
East
Rent
4
50K-100K
$ 59
4

275
West
Rent
6
100K+
$ 44
6

276
North
Rent
5
50K-100K
$ 97
8

277
South
Rent
7
100K+
$ 68
7

278
East
Rent
1
100K+
$ 145
1

279
North
Own
2
100K+
$ 85
10

280
West
Own
3
25K-50K
$ 59
3

281
South
Rent
4
50K-100K
$ 84
7

282
South
Own
3
50K-100K
$ 28
5

283
South
Rent
5
100K+
$ 26
8

284
East
Own
3
10K-25K
$ 31
9

285
North
Rent
3
100K+
$ 19
3

286
West
Own
2
25K-50K
$ 30
2

287
East
Rent
4
50K-100K
$ 29
11

288
South
Rent
5
10K-25K
$ 25
6

289
West
Rent
6
50K-100K
$ 24
3

290
East
Own
5
25K-50K
$ 36
6

291
South
Own
4
25K-50K
$ 29
7

292
North
Own
3
25K-50K
$ 99
9

293
East
Rent
5
50K-100K
$ 169
8

294
West
Rent
4
100K+
$ 179
3

295
South
Rent
6
50K-100K
$ 119
5

296
East
Own
4
25K-50K
$ 99
4

297
North
Rent
6
50K-100K
$ 56
6

298
East
Rent
1
50K-100K
$ 50
11

299
South
Rent
2
100K+
$ 86
10

300
North
Rent
3
100K+
$ 45
3

301
East
Rent
4
100K+
$ 95
2

302
South
Rent
7
25K-50K
$ 86
10

303
West
Own
4
50K-100K
$ 97
11

304
West
Rent
3
50K-100K
$ 40
7

305
East
Rent
1
100K+
$ 50
5

306
South
Rent
4
10K-25K
$ 59
9

307
West
Own
2
100K+
$ 75
4

308
East
Own
5
25K-50K
$ 68
3

309
North
Rent
3
25K-50K
$ 26
2

310
East
Own
6
50K-100K
$ 15
6

311
South
Own
4
50K-100K
$ 18
8

312
East
Rent
7
50K-100K
$ 28
6

313
North
Own
3
100K+
$ 24
8

314
South
Rent
2
10K-25K
$ 30
9

315
West
Own
4
50K-100K
$ 30
10

316
East
Own
5
50K-100K
$ 23
3

317
West
Rent
3
25K-50K
$ 28
2

318
North
Rent
1
25K-50K
$ 21
6

319
East
Rent
4
50K-100K
$ 28
5

320
North
Rent
3
10K-25K
$ 22
8

321
East
Own
5
100K+
$ 28
7

322
West
Own
6
100K+
$ 30
9

323
North
Rent
4
10K-25K
$ 28
4

324
South
Rent
2
100K+
$ 25
6

325
East
Own
5
50K-100K
$ 29
3

326
North
Own
3
50K-100K
$ 28
5

327
West
Rent
5
25K-50K
$ 30
3

328
South
Rent
6
25K-50K
$ 19
6

329
South
Own
4
10K-25K
$ 30
5

330
West
Own
3
50K-100K
$ 149
7

331
North
Own
5
25K-50K
$ 155
9

332
East
Own
6
50K-100K
$ 115
4

333
West
Rent
4
100K+
$ 39
6

334
North
Own
6
50K-100K
$ 95
8

335
East
Own
4
50K-100K
$ 86
7

336
South
Own
7
50K-100K
$ 85
1

337
West
Own
4
50K-100K
$ 59
10

338
North
Own
3
50K-100K
$ 84
3

339
East
Rent
1
25K-50K
$ 28
7

340
South
Own
2
25K-50K
$ 26
5

341
West
Own
5
100K+
$ 31
8

342
North
Own
3
10K-25K
$ 19
9

343
East
Rent
4
100K+
$ 30
3

344
South
Rent
6
100K+
$ 29
2

345
West
Own
5
100K+
$ 25
11

346
East
Own
3
25K-50K
$ 24
6

347
East
Own
2
25K-50K
$ 36
3

348
North
Own
1
50K-100K
$ 29
6

349
North
Rent
6
50K-100K
$ 99
7

350
West
Rent
7
50K-100K
$ 169
9

351
West
Rent
2
50K-100K
$ 179
8

352
East
Own
1
10K-25K
$ 119
3

353
North
Rent
2
100K+
$ 99
5

354
East
Own
3
10K-25K
$ 179
4

355
South
Own
2
100K+
$ 185
6

356
East
Rent
1
50K-100K
$ 179
11

357
North
Own
3
50K-100K
$ 145
10

358
South
Own
4
25K-50K
$ 119
3

359
West
Own
6
25K-50K
$ 99
2

360
East
Rent
5
10K-25K
$ 155
10

361
West
Rent
4
50K-100K
$ 119
11

362
North
Own
3
25K-50K
$ 149
7

363
East
Own
5
50K-100K
$ 56
5

364
North
Own
6
100K+
$ 50
9

365
East
Own
7
50K-100K
$ 86
4

366
North
Rent
5
50K-100K
$ 45
3

367
South
Rent
6
50K-100K
$ 95
2

368
North
Rent
3
50K-100K
$ 86
6

369
West
Own
4
50K-100K
$ 97
8

370
East
Rent
5
25K-50K
$ 23
6

371
South
Own
2
25K-50K
$ 29
8

372
East
Rent
3
100K+
$ 18
9

373
West
Own
6
10K-25K
$ 26
10

374
North
Own
2
100K+
$ 20
3

375
West
Own
5
100K+
$ 15
2

376
North
Rent
4
100K+
$ 40
6

377
East
Rent
1
25K-50K
$ 41
5

378
South
Own
4
25K-50K
$ 24
8

379
South
Rent
3
50K-100K
$ 26
7

380
South
Own
5
10K-25K
$ 25
9

381
West
Own
6
25K-50K
$ 26
4

382
North
Own
4
50K-100K
$ 23
6

383
East
Rent
2
50K-100K
$ 27
7

384
West
Own
5
25K-50K
$ 25
5

385
North
Rent
3
25K-50K
$ 18
3

386
East
Own
5
25K-50K
$ 24
6

387
South
Own
6
10K-25K
$ 21
8

388
West
Own
4
100K+
$ 40
2

389
North
Own
3
100K+
$ 19
4

390
South
Rent
5
10K-25K
$ 30
9

391
West
Own
6
25K-50K
$ 35
7

392
East
Own
4
25K-50K
$ 24
10

393
East
Rent
6
25K-50K
$ 26
2

394
North
Own
4
50K-100K
$ 15
6

395
North
Rent
7
50K-100K
$ 18
5

396
West
Own
4
25K-50K
$ 28
7

397
West
Own
3
50K-100K
$ 24
4

398
East
Rent
1
50K-100K
$ 30
3

399
North
Rent
2
100K+
$ 30
2

400
East
Rent
5
25K-50K
$ 23
8

401
South
Own
3
25K-50K
$ 28
6

402
East
Rent
4
10K-25K
$ 21
7

403
North
Own
6
25K-50K
$ 28
5

404
South
Own
5
100K+
$ 22
3

405
West
Rent
3
50K-100K
$ 28
6

406
East
Own
2
50K-100K
$ 30
8

407
West
Rent
1
25K-50K
$ 28
1

408
North
Own
6
25K-50K
$ 25
8

409
East
Own
7
50K-100K
$ 29
6

410
North
Rent
2
50K-100K
$ 28
4

411
East
Rent
1
25K-50K
$ 30
7

412
North
Own
2
50K-100K
$ 19
3

413
South
Own
3
50K-100K
$ 30
1

414
North
Own
2
25K-50K
$ 149
4

415
West
Own
1
50K-100K
$ 155
1

416
East
Rent
3
10K-25K
$ 115
4

417
South
Own
4
100K+
$ 119
6

418
East
Own
6
50K-100K
$ 99
5

419
West
Own
5
50K-100K
$ 119
3

420
North
Own
4
25K-50K
$ 149
7

421
West
Own
3
25K-50K
$ 145
6

422
North
Rent
5
25K-50K
$ 119
8

423
East
Own
6
10K-25K
$ 129
9

424
West
Own
7
100K+
$ 99
10

425
North
Own
5
100K+
$ 119
2

426
East
Rent
6
10K-25K
$ 185
6

427
South
Rent
3
25K-50K
$ 119
4

428
West
Own
4
25K-50K
$ 99
7

429
North
Own
5
25K-50K
$ 109
5

430
East
Own
2
50K-100K
$ 179
8

431
South
Own
3
50K-100K
$ 169
9

432
West
Rent
5
25K-50K
$ 179
2

433
North
Rent
4
50K-100K
$ 145
5

434
East
Rent
6
50K-100K
$ 119
4

435
South
Own
7
100K+
$ 165
3

436
West
Rent
2
25K-50K
$ 129
11

437
East
Own
3
25K-50K
$ 159
7

438
East
Own
1
10K-25K
$ 37
4

439
North
Rent
3
25K-50K
$ 55
6

440
North
Own
5
25K-50K
$ 63
5

441
West
Own
4
25K-50K
$ 56
9

442
West
Own
6
50K-100K
$ 67
2

443
East
Rent
7
50K-100K
$ 60
5

444
North
Rent
2
50K-100K
$ 50
3

445
East
Own
3
25K-50K
$ 49
6

446
South
Own
4
10K-25K
$ 56
8

447
East
Own
5
25K-50K
$ 60
4

448
North
Own
3
100K+
$ 59
7

449
South
Rent
4
10K-25K
$ 59
5

450
West
Rent
1
25K-50K
$ 60
1

451
East
Rent
3
50K-100K
$ 68
10

452
South
Own
4
50K-100K
$ 84
11

453
North
Rent
5
25K-50K
$ 69
11

454
West
Own
6
25K-50K
$ 97
11

455
East
Rent
7
50K-100K
$ 61
3

456
South
Own
6
10K-25K
$ 75
6

457
East
Own
7
100K+
$ 76
4

458
West
Own
4
100K+
$ 98
7

459
North
Rent
3
100K+
$ 95
9

460
West
Rent
5
50K-100K
$ 59
3

461
North
Own
2
50K-100K
$ 44
2

462
East
Rent
3
100K+
$ 97
6

463
West
Own
4
10K-25K
$ 68
5

464
North
Own
6
100K+
$ 145
8

465
East
Own
4
25K-50K
$ 119
7

466
South
Rent
5
50K-100K
$ 129
2

467
West
Own
3
10K-25K
$ 99
4

468
North
Rent
2
50K-100K
$ 119
3

469
North
Own
6
10K-25K
$ 185
6

470
East
Own
3
100K+
$ 119
9

471
West
Own
1
25K-50K
$ 99
10

472
South
Own
4
50K-100K
$ 60
11

473
East
Rent
3
10K-25K
$ 50
4

474
West
Rent
5
50K-100K
$ 49
2

475
South
Own
6
25K-50K
$ 56
1

476
East
Own
3
25K-50K
$ 60
5

477
North
Own
2
25K-50K
$ 59
4

478
East
Own
4
50K-100K
$ 59
7

479
North
Rent
5
100K+
$ 60
8

480
West
Rent
7
50K-100K
$ 68
9

481
East
Rent
2
25K-50K
$ 84
1

482
West
Own
1
50K-100K
$ 69
7

483
South
Rent
2
50K-100K
$ 97
4

484
North
Own
1
25K-50K
$ 61
6

485
East
Rent
3
50K-100K
$ 75
5

486
East
Own
6
50K-100K
$ 76
9

487
West
Own
4
50K-100K
$ 98
2

Question 7

CUST ID
REGION
RENT VS. OWN
NUM HOUSEHOLD
ANNUAL INCOME
TOTAL PURCHASES
NUM PURCHASES

1
North
Own
1
10K-25K
$ 38
1

2
South
Own
4
100K+
$ 30
4

3
North
Rent
3
25K-50K
$ 19
3

4
West
Own
5
25K-50K
$ 21
6

5
East
Own
6
50K-100K
$ 35
7

6
South
Own
2
10K-25K
$ 27
5

7
East
Own
3
100K+
$ 26
3

8
West
Rent
4
25K-50K
$ 25
6

9
North
Own
5
50K-100K
$ 30
8

10
West
Rent
7
25K-50K
$ 26
2

11
North
Own
1
50K-100K
$ 21
4

12
East
Own
2
100K+
$ 29
9

13
South
Own
5
10K-25K
$ 20
7

14
South
Own
4
25K-50K
$ 27
10

15
South
Rent
3
50K-100K
$ 19
2

16
West
Own
5
25K-50K
$ 19
6

17
North
Own
6
50K-100K
$ 129
5

18
East
Rent
2
10K-25K
$ 99
7

19
West
Own
3
25K-50K
$ 99
4

20
North
Rent
1
50K-100K
$ 119
3

21
East
Own
4
50K-100K
$ 149
2

22
South
Own
3
50K-100K
$ 165
8

23
West
Rent
5
25K-50K
$ 119
6

24
North
Rent
6
10K-25K
$ 129
7

25
East
Rent
7
100K+
$ 165
5

26
South
Own
3
10K-25K
$ 99
3

27
West
Rent
2
25K-50K
$ 155
6

28
North
Own
4
50K-100K
$ 115
8

29
East
Own
5
50K-100K
$ 129
1

30
South
Rent
4
50K-100K
$ 99
8

31
West
Own
2
25K-50K
$ 169
6

32
East
Rent
3
25K-50K
$ 40
4

33
East
Own
1
50K-100K
$ 36
7

34
North
Own
6
100K+
$ 45
3

35
North
Own
5
10K-25K
$ 29
1

36
West
Rent
4
100K+
$ 28
4

37
East
Rent
1
25K-50K
$ 46
1

38
South
Rent
5
50K-100K
$ 50
4

39
East
Rent
3
50K-100K
$ 22
6

40
West
Own
6
50K-100K
$ 20
9

41
North
Own
7
25K-50K
$ 19
3

42
East
Own
3
50K-100K
$ 31
1

43
South
Rent
2
50K-100K
$ 30
10

44
West
Rent
4
25K-50K
$ 18
3

45
East
Own
5
25K-50K
$ 31
7

46
South
Own
3
10K-25K
$ 35
6

47
West
Own
7
25K-50K
$ 28
5

48
East
Rent
3
100K+
$ 29
8

49
South
Rent
2
10K-25K
$ 35
6

50
North
Own
6
25K-50K
$ 30
4

51
South
Own
5
50K-100K
$ 38
7

52
West
Own
3
50K-100K
$ 20
3

53
North
Rent
1
25K-50K
$ 40
5

54
East
Rent
5
25K-50K
$ 30
4

55
South
Own
6
25K-50K
$ 40
8

56
West
Rent
3
10K-25K
$ 62
7

57
North
Rent
4
100K+
$ 22
9

58
East
Rent
5
100K+
$ 25
1

59
West
Rent
7
10K-25K
$ 27
4

60
East
Rent
2
25K-50K
$ 22
7

61
South
Own
3
25K-50K
$ 30
4

62
East
Own
1
25K-50K
$ 31
3

63
East
Own
4
50K-100K
$ 22
8

64
South
Rent
2
50K-100K
$ 25
9

65
West
Own
3
25K-50K
$ 24
3

66
East
Own
5
50K-100K
$ 36
2

67
North
Rent
4
50K-100K
$ 123
11

68
North
Rent
6
100K+
$ 19
2

69
North
Own
5
100K+
$ 23
6

70
South
Rent
7
100K+
$ 19
8

71
West
Rent
4
25K-50K
$ 25
6

72
West
Rent
5
50K-100K
$ 129
8

73
North
Own
3
50K-100K
$ 119
9

74
East
Own
6
100K+
$ 109
3

75
North
Own
5
10K-25K
$ 179
6

76
East
Rent
4
100K+
$ 145
5

77
South
Own
2
25K-50K
$ 119
7

78
North
Rent
3
50K-100K
$ 129
2

79
East
Own
4
10K-25K
$ 189
4

80
West
Own
6
50K-100K
$ 155
6

81
North
Rent
5
25K-50K
$ 78
4

82
East
Own
4
25K-50K
$ 61
5

83
South
Rent
3
25K-50K
$ 97
7

84
North
Rent
2
50K-100K
$ 63
2

85
West
Own
4
100K+
$ 39
3

86
East
Rent
6
50K-100K
$ 95
1

87
South
Rent
4
25K-50K
$ 86
7

88
West
Own
1
50K-100K
$ 85
5

89
East
Own
2
50K-100K
$ 59
7

90
North
Rent
3
100K+
$ 84
9

91
North
Own
2
100K+
$ 144
10

92
West
Rent
3
100K+
$ 26
1

93
South
Rent
7
25K-50K
$ 31
1

94
East
Own
6
50K-100K
$ 19
1

95
South
Rent
5
50K-100K
$ 30
1

96
West
Rent
4
100K+
$ 29
11

97
West
Rent
5
10K-25K
$ 25
2

98
West
Rent
6
100K+
$ 24
6

99
East
Rent
3
25K-50K
$ 36
5

100
North
Own
4
50K-100K
$ 29
7

101
South
Own
2
10K-25K
$ 99
9

102
West
Rent
1
50K-100K
$ 169
3

103
East
Own
3
10K-25K
$ 179
1

104
North
Rent
4
100K+
$ 119
7

105
South
Own
5
25K-50K
$ 99
4

106
West
Rent
4
50K-100K
$ 179
7

107
East
Own
6
10K-25K
$ 185
6

108
North
Rent
3
50K-100K
$ 179
8

109
South
Rent
4
25K-50K
$ 145
9

110
West
Rent
5
25K-50K
$ 119
3

111
North
Own
7
25K-50K
$ 99
2

112
North
Own
2
50K-100K
$ 155
5

113
East
Own
3
100K+
$ 119
4

114
North
Rent
5
50K-100K
$ 149
7

115
East
Rent
3
25K-50K
$ 56
5

116
North
Rent
2
50K-100K
$ 50
6

117
West
Own
4
50K-100K
$ 86
3

118
South
Rent
2
100K+
$ 45
2

119
East
Rent
1
100K+
$ 95
6

120
West
Rent
3
100K+
$ 86
8

121
South
Rent
2
25K-50K
$ 97
11

122
East
Rent
4
50K-100K
$ 40
8

123
North
Rent
5
50K-100K
$ 50
5

124
East
Own
6
100K+
$ 59
3

125
North
Rent
3
10K-25K
$ 75
4

126
South
Rent
4
50K-100K
$ 68
3

127
West
Rent
6
50K-100K
$ 63
1

128
North
Own
2
25K-50K
$ 56
10

129
East
Own
4
25K-50K
$ 86
2

130
North
Rent
6
50K-100K
$ 45
6

131
West
Own
3
100K+
$ 78
8

132
South
Own
4
10K-25K
$ 68
7

133
East
Rent
7
100K+
$ 95
6

134
North
Own
4
25K-50K
$ 95
4

135
East
Rent
5
50K-100K
$ 39
7

136
East
Own
6
50K-100K
$ 56
8

137
North
Own
2
50K-100K
$ 31
9

138
South
Rent
3
25K-50K
$ 29
6

139
West
Rent
4
50K-100K
$ 41
7

140
East
Rent
5
50K-100K
$ 62
4

141
North
Rent
1
25K-50K
$ 51
3

142
South
Own
2
25K-50K
$ 37
2

143
West
Own
3
10K-25K
$ 19
6

144
East
Rent
4
25K-50K
$ 38
5

145
North
Rent
5
100K+
$ 56
7

146
East
Own
4
100K+
$ 41
5

147
West
Own
3
25K-50K
$ 51
8

148
North
Rent
6
50K-100K
$ 19
4

149
East
Rent
2
10K-25K
$ 29
3

150
North
Own
4
50K-100K
$ 41
5

151
East
Own
3
25K-50K
$ 19
6

152
West
Own
3
25K-50K
$ 30
7

153
North
Own
5
25K-50K
$ 19
8

154
South
Rent
4
50K-100K
$ 21
3

155
East
Own
6
100K+
$ 23
2

156
North
Own
7
50K-100K
$ 29
5

157
West
Own
2
25K-50K
$ 18
2

158
East
Own
3
50K-100K
$ 26
5

159
South
Own
1
50K-100K
$ 20
1

160
West
Rent
2
100K+
$ 76
11

161
East
Own
4
100K+
$ 40
4

162
South
Own
2
100K+
$ 41
3

163
North
Own
4
25K-50K
$ 24
7

164
East
Rent
5
50K-100K
$ 26
5

165
West
Rent
6
50K-100K
$ 25
8

166
South
Own
4
100K+
$ 26
6

167
East
Own
2
10K-25K
$ 23
8

168
North
Own
4
50K-100K
$ 27
5

169
East
Own
3
50K-100K
$ 25
8

170
South
Rent
5
25K-50K
$ 34
10

171
West
Rent
4
25K-50K
$ 24
7

172
West
Rent
6
50K-100K
$ 21
9

173
East
Own
4
100K+
$ 40
8

174
South
Rent
3
50K-100K
$ 19
1

175
West
Own
1
100K+
$ 30
11

176
East
Rent
2
100K+
$ 35
10

177
North
Own
4
100K+
$ 24
1

178
East
Own
7
25K-50K
$ 26
4

179
South
Own
4
50K-100K
$ 15
1

180
East
Rent
6
50K-100K
$ 18
3

181
North
Rent
3
100K+
$ 28
1

182
South
Own
7
10K-25K
$ 24
4

183
West
Rent
2
100K+
$ 30
5

184
East
Own
1
25K-50K
$ 30
4

185
West
Own
4
50K-100K
$ 23
7

186
North
Own
5
10K-25K
$ 28
5

187
East
Rent
3
50K-100K
$ 21
6

188
North
Own
2
25K-50K
$ 28
4

189
East
Rent
4
25K-50K
$ 22
2

190
West
Own
5
25K-50K
$ 28
6

191
North
Own
2
50K-100K
$ 30
8

192
South
Own
1
100K+
$ 28
9

193
East
Own
4
50K-100K
$ 25
10

194
North
Rent
2
25K-50K
$ 29
3

195
West
Own
5
50K-100K
$ 28
6

196
East
Own
3
50K-100K
$ 30
5

197
South
Rent
6
100K+
$ 19
4

198
West
Own
5
100K+
$ 30
6

199
East
Rent
7
100K+
$ 149
8

200
South
Own
4
25K-50K
$ 155
7

201
North
Own
5
50K-100K
$ 115
4

202
East
Rent
6
50K-100K
$ 119
5

203
West
Rent
3
100K+
$ 99
7

204
South
Rent
2
10K-25K
$ 119
8

205
East
Own
4
100K+
$ 149
9

206
North
Rent
5
25K-50K
$ 145
11

207
East
Own
3
25K-50K
$ 119
8

208
South
Own
5
50K-100K
$ 129
5

209
North
Rent
4
50K-100K
$ 99
7

210
East
Own
6
50K-100K
$ 119
8

211
South
Rent
4
100K+
$ 185
9

212
West
Own
5
10K-25K
$ 119
5

213
West
Own
6
50K-100K
$ 99
2

214
East
Own
7
50K-100K
$ 109
6

215
South
Rent
1
25K-50K
$ 179
8

216
West
Rent
3
25K-50K
$ 169
6

217
East
Rent
2
50K-100K
$ 179
9

218
North
Rent
5
10K-25K
$ 145
7

219
East
Own
4
100K+
$ 119
6

220
South
Own
6
100K+
$ 165
3

221
East
Own
7
10K-25K
$ 129
2

222
North
Rent
3
100K+
$ 159
11

223
South
Rent
2
50K-100K
$ 37
7

224
West
Own
4
50K-100K
$ 55
5

225
East
Own
5
25K-50K
$ 63
7

226
West
Own
4
25K-50K
$ 56
8

227
North
Rent
3
10K-25K
$ 67
6

228
East
Rent
4
50K-100K
$ 60
8

229
North
Own
6
25K-50K
$ 50
9

230
East
Own
5
50K-100K
$ 49
3

231
West
Own
4
100K+
$ 56
4

232
North
Rent
2
50K-100K
$ 60
7

233
South
Rent
3
50K-100K
$ 59
2

234
East
Own
1
50K-100K
$ 59
8

235
North
Rent
7
50K-100K
$ 60
5

236
West
Rent
3
50K-100K
$ 68
7

237
South
Rent
4
25K-50K
$ 84
9

238
South
Rent
2
25K-50K
$ 69
2

239
West
Rent
5
100K+
$ 97
5

240
North
Own
3
10K-25K
$ 61
4

241
East
Own
4
100K+
$ 75
6

242
West
Own
5
100K+
$ 76
11

243
North
Rent
6
100K+
$ 98
8

244
East
Own
4
25K-50K
$ 95
5

245
South
Own
5
25K-50K
$ 59
7

246
West
Rent
6
50K-100K
$ 44
4

247
North
Rent
7
50K-100K
$ 97
3

248
East
Own
4
100K+
$ 68
6

249
South
Rent
3
25K-50K
$ 145
10

250
West
Rent
2
50K-100K
$ 119
3

251
North
Rent
1
10K-25K
$ 129
6

252
East
Own
5
50K-100K
$ 99
8

253
South
Own
4
25K-50K
$ 119
6

254
West
Own
6
25K-50K
$ 185
8

255
East
Rent
3
25K-50K
$ 119
10

256
East
Own
2
50K-100K
$ 99
3

257
North
Rent
1
100K+
$ 60
6

258
North
Own
5
50K-100K
$ 50
5

259
West
Own
4
25K-50K
$ 49
8

260
West
Rent
6
50K-100K
$ 56
4

261
East
Own
7
50K-100K
$ 60
7

262
North
Rent
3
100K+
$ 59
3

263
East
Rent
2
100K+
$ 59
2

264
South
Own
4
100K+
$ 60
6

265
East
Rent
5
25K-50K
$ 68
5

266
North
Rent
3
50K-100K
$ 84
8

267
South
Own
2
50K-100K
$ 69
9

268
West
Own
4
100K+
$ 97
3

269
East
Rent
3
10K-25K
$ 61
2

270
West
Own
4
50K-100K
$ 75
6

271
North
Rent
3
50K-100K
$ 76
5

272
East
Rent
4
25K-50K
$ 98
7

273
North
Own
5
25K-50K
$ 95
9

274
East
Rent
4
50K-100K
$ 59
4

275
West
Rent
6
100K+
$ 44
6

276
North
Rent
5
50K-100K
$ 97
8

277
South
Rent
7
100K+
$ 68
7

278
East
Rent
1
100K+
$ 145
1

279
North
Own
2
100K+
$ 85
10

280
West
Own
3
25K-50K
$ 59
3

281
South
Rent
4
50K-100K
$ 84
7

282
South
Own
3
50K-100K
$ 28
5

283
South
Rent
5
100K+
$ 26
8

284
East
Own
3
10K-25K
$ 31
9

285
North
Rent
3
100K+
$ 19
3

286
West
Own
2
25K-50K
$ 30
2

287
East
Rent
4
50K-100K
$ 29
11

288
South
Rent
5
10K-25K
$ 25
6

289
West
Rent
6
50K-100K
$ 24
3

290
East
Own
5
25K-50K
$ 36
6

291
South
Own
4
25K-50K
$ 29
7

292
North
Own
3
25K-50K
$ 99
9

293
East
Rent
5
50K-100K
$ 169
8

294
West
Rent
4
100K+
$ 179
3

295
South
Rent
6
50K-100K
$ 119
5

296
East
Own
4
25K-50K
$ 99
4

297
North
Rent
6
50K-100K
$ 56
6

298
East
Rent
1
50K-100K
$ 50
11

299
South
Rent
2
100K+
$ 86
10

300
North
Rent
3
100K+
$ 45
3

301
East
Rent
4
100K+
$ 95
2

302
South
Rent
7
25K-50K
$ 86
10

303
West
Own
4
50K-100K
$ 97
11

304
West
Rent
3
50K-100K
$ 40
7

305
East
Rent
1
100K+
$ 50
5

306
South
Rent
4
10K-25K
$ 59
9

307
West
Own
2
100K+
$ 75
4

308
East
Own
5
25K-50K
$ 68
3

309
North
Rent
3
25K-50K
$ 26
2

310
East
Own
6
50K-100K
$ 15
6

311
South
Own
4
50K-100K
$ 18
8

312
East
Rent
7
50K-100K
$ 28
6

313
North
Own
3
100K+
$ 24
8

314
South
Rent
2
10K-25K
$ 30
9

315
West
Own
4
50K-100K
$ 30
10

316
East
Own
5
50K-100K
$ 23
3

317
West
Rent
3
25K-50K
$ 28
2

318
North
Rent
1
25K-50K
$ 21
6

319
East
Rent
4
50K-100K
$ 28
5

320
North
Rent
3
10K-25K
$ 22
8

321
East
Own
5
100K+
$ 28
7

322
West
Own
6
100K+
$ 30
9

323
North
Rent
4
10K-25K
$ 28
4

324
South
Rent
2
100K+
$ 25
6

325
East
Own
5
50K-100K
$ 29
3

326
North
Own
3
50K-100K
$ 28
5

327
West
Rent
5
25K-50K
$ 30
3

328
South
Rent
6
25K-50K
$ 19
6

329
South
Own
4
10K-25K
$ 30
5

330
West
Own
3
50K-100K
$ 149
7

331
North
Own
5
25K-50K
$ 155
9

332
East
Own
6
50K-100K
$ 115
4

333
West
Rent
4
100K+
$ 39
6

334
North
Own
6
50K-100K
$ 95
8

335
East
Own
4
50K-100K
$ 86
7

336
South
Own
7
50K-100K
$ 85
1

337
West
Own
4
50K-100K
$ 59
10

338
North
Own
3
50K-100K
$ 84
3

339
East
Rent
1
25K-50K
$ 28
7

340
South
Own
2
25K-50K
$ 26
5

341
West
Own
5
100K+
$ 31
8

342
North
Own
3
10K-25K
$ 19
9

343
East
Rent
4
100K+
$ 30
3

344
South
Rent
6
100K+
$ 29
2

345
West
Own
5
100K+
$ 25
11

346
East
Own
3
25K-50K
$ 24
6

347
East
Own
2
25K-50K
$ 36
3

348
North
Own
1
50K-100K
$ 29
6

349
North
Rent
6
50K-100K
$ 99
7

350
West
Rent
7
50K-100K
$ 169
9

351
West
Rent
2
50K-100K
$ 179
8

352
East
Own
1
10K-25K
$ 119
3

353
North
Rent
2
100K+
$ 99
5

354
East
Own
3
10K-25K
$ 179
4

355
South
Own
2
100K+
$ 185
6

356
East
Rent
1
50K-100K
$ 179
11

357
North
Own
3
50K-100K
$ 145
10

358
South
Own
4
25K-50K
$ 119
3

359
West
Own
6
25K-50K
$ 99
2

360
East
Rent
5
10K-25K
$ 155
10

361
West
Rent
4
50K-100K
$ 119
11

362
North
Own
3
25K-50K
$ 149
7

363
East
Own
5
50K-100K
$ 56
5

364
North
Own
6
100K+
$ 50
9

365
East
Own
7
50K-100K
$ 86
4

366
North
Rent
5
50K-100K
$ 45
3

367
South
Rent
6
50K-100K
$ 95
2

368
North
Rent
3
50K-100K
$ 86
6

369
West
Own
4
50K-100K
$ 97
8

370
East
Rent
5
25K-50K
$ 23
6

371
South
Own
2
25K-50K
$ 29
8

372
East
Rent
3
100K+
$ 18
9

373
West
Own
6
10K-25K
$ 26
10

374
North
Own
2
100K+
$ 20
3

375
West
Own
5
100K+
$ 15
2

376
North
Rent
4
100K+
$ 40
6

377
East
Rent
1
25K-50K
$ 41
5

378
South
Own
4
25K-50K
$ 24
8

379
South
Rent
3
50K-100K
$ 26
7

380
South
Own
5
10K-25K
$ 25
9

381
West
Own
6
25K-50K
$ 26
4

382
North
Own
4
50K-100K
$ 23
6

383
East
Rent
2
50K-100K
$ 27
7

384
West
Own
5
25K-50K
$ 25
5

385
North
Rent
3
25K-50K
$ 18
3

386
East
Own
5
25K-50K
$ 24
6

387
South
Own
6
10K-25K
$ 21
8

388
West
Own
4
100K+
$ 40
2

389
North
Own
3
100K+
$ 19
4

390
South
Rent
5
10K-25K
$ 30
9

391
West
Own
6
25K-50K
$ 35
7

392
East
Own
4
25K-50K
$ 24
10

393
East
Rent
6
25K-50K
$ 26
2

394
North
Own
4
50K-100K
$ 15
6

395
North
Rent
7
50K-100K
$ 18
5

396
West
Own
4
25K-50K
$ 28
7

397
West
Own
3
50K-100K
$ 24
4

398
East
Rent
1
50K-100K
$ 30
3

399
North
Rent
2
100K+
$ 30
2

400
East
Rent
5
25K-50K
$ 23
8

401
South
Own
3
25K-50K
$ 28
6

402
East
Rent
4
10K-25K
$ 21
7

403
North
Own
6
25K-50K
$ 28
5

404
South
Own
5
100K+
$ 22
3

405
West
Rent
3
50K-100K
$ 28
6

406
East
Own
2
50K-100K
$ 30
8

407
West
Rent
1
25K-50K
$ 28
1

408
North
Own
6
25K-50K
$ 25
8

409
East
Own
7
50K-100K
$ 29
6

410
North
Rent
2
50K-100K
$ 28
4

411
East
Rent
1
25K-50K
$ 30
7

412
North
Own
2
50K-100K
$ 19
3

413
South
Own
3
50K-100K
$ 30
1

414
North
Own
2
25K-50K
$ 149
4

415
West
Own
1
50K-100K
$ 155
1

416
East
Rent
3
10K-25K
$ 115
4

417
South
Own
4
100K+
$ 119
6

418
East
Own
6
50K-100K
$ 99
5

419
West
Own
5
50K-100K
$ 119
3

420
North
Own
4
25K-50K
$ 149
7

421
West
Own
3
25K-50K
$ 145
6

422
North
Rent
5
25K-50K
$ 119
8

423
East
Own
6
10K-25K
$ 129
9

424
West
Own
7
100K+
$ 99
10

425
North
Own
5
100K+
$ 119
2

426
East
Rent
6
10K-25K
$ 185
6

427
South
Rent
3
25K-50K
$ 119
4

428
West
Own
4
25K-50K
$ 99
7

429
North
Own
5
25K-50K
$ 109
5

430
East
Own
2
50K-100K
$ 179
8

431
South
Own
3
50K-100K
$ 169
9

432
West
Rent
5
25K-50K
$ 179
2

433
North
Rent
4
50K-100K
$ 145
5

434
East
Rent
6
50K-100K
$ 119
4

435
South
Own
7
100K+
$ 165
3

436
West
Rent
2
25K-50K
$ 129
11

437
East
Own
3
25K-50K
$ 159
7

438
East
Own
1
10K-25K
$ 37
4

439
North
Rent
3
25K-50K
$ 55
6

440
North
Own
5
25K-50K
$ 63
5

441
West
Own
4
25K-50K
$ 56
9

442
West
Own
6
50K-100K
$ 67
2

443
East
Rent
7
50K-100K
$ 60
5

444
North
Rent
2
50K-100K
$ 50
3

445
East
Own
3
25K-50K
$ 49
6

446
South
Own
4
10K-25K
$ 56
8

447
East
Own
5
25K-50K
$ 60
4

448
North
Own
3
100K+
$ 59
7

449
South
Rent
4
10K-25K
$ 59
5

450
West
Rent
1
25K-50K
$ 60
1

451
East
Rent
3
50K-100K
$ 68
10

452
South
Own
4
50K-100K
$ 84
11

453
North
Rent
5
25K-50K
$ 69
11

454
West
Own
6
25K-50K
$ 97
11

455
East
Rent
7
50K-100K
$ 61
3

456
South
Own
6
10K-25K
$ 75
6

457
East
Own
7
100K+
$ 76
4

458
West
Own
4
100K+
$ 98
7

459
North
Rent
3
100K+
$ 95
9

460
West
Rent
5
50K-100K
$ 59
3

461
North
Own
2
50K-100K
$ 44
2

462
East
Rent
3
100K+
$ 97
6

463
West
Own
4
10K-25K
$ 68
5

464
North
Own
6
100K+
$ 145
8

465
East
Own
4
25K-50K
$ 119
7

466
South
Rent
5
50K-100K
$ 129
2

467
West
Own
3
10K-25K
$ 99
4

468
North
Rent
2
50K-100K
$ 119
3

469
North
Own
6
10K-25K
$ 185
6

470
East
Own
3
100K+
$ 119
9

471
West
Own
1
25K-50K
$ 99
10

472
South
Own
4
50K-100K
$ 60
11

473
East
Rent
3
10K-25K
$ 50
4

474
West
Rent
5
50K-100K
$ 49
2

475
South
Own
6
25K-50K
$ 56
1

476
East
Own
3
25K-50K
$ 60
5

477
North
Own
2
25K-50K
$ 59
4

478
East
Own
4
50K-100K
$ 59
7

479
North
Rent
5
100K+
$ 60
8

480
West
Rent
7
50K-100K
$ 68
9

481
East
Rent
2
25K-50K
$ 84
1

482
West
Own
1
50K-100K
$ 69
7

483
South
Rent
2
50K-100K
$ 97
4

484
North
Own
1
25K-50K
$ 61
6

485
East
Rent
3
50K-100K
$ 75
5

486
East
Own
6
50K-100K
$ 76
9

487
West
Own
4
50K-100K
$ 98
2

Question 8

CUST ID
REGION
RENT VS. OWN
NUM HOUSEHOLD
ANNUAL INCOME
TOTAL PURCHASES
NUM PURCHASES

1
North
Own
1
10K-25K
$ 38
1

2
South
Own
4
100K+
$ 30
4

3
North
Rent
3
25K-50K
$ 19
3

4
West
Own
5
25K-50K
$ 21
6

5
East
Own
6
50K-100K
$ 35
7

6
South
Own
2
10K-25K
$ 27
5

7
East
Own
3
100K+
$ 26
3

8
West
Rent
4
25K-50K
$ 25
6

9
North
Own
5
50K-100K
$ 30
8

10
West
Rent
7
25K-50K
$ 26
2

11
North
Own
1
50K-100K
$ 21
4

12
East
Own
2
100K+
$ 29
9

13
South
Own
5
10K-25K
$ 20
7

14
South
Own
4
25K-50K
$ 27
10

15
South
Rent
3
50K-100K
$ 19
2

16
West
Own
5
25K-50K
$ 19
6

17
North
Own
6
50K-100K
$ 129
5

18
East
Rent
2
10K-25K
$ 99
7

19
West
Own
3
25K-50K
$ 99
4

20
North
Rent
1
50K-100K
$ 119
3

21
East
Own
4
50K-100K
$ 149
2

22
South
Own
3
50K-100K
$ 165
8

23
West
Rent
5
25K-50K
$ 119
6

24
North
Rent
6
10K-25K
$ 129
7

25
East
Rent
7
100K+
$ 165
5

26
South
Own
3
10K-25K
$ 99
3

27
West
Rent
2
25K-50K
$ 155
6

28
North
Own
4
50K-100K
$ 115
8

29
East
Own
5
50K-100K
$ 129
1

30
South
Rent
4
50K-100K
$ 99
8

31
West
Own
2
25K-50K
$ 169
6

32
East
Rent
3
25K-50K
$ 40
4

33
East
Own
1
50K-100K
$ 36
7

34
North
Own
6
100K+
$ 45
3

35
North
Own
5
10K-25K
$ 29
1

36
West
Rent
4
100K+
$ 28
4

37
East
Rent
1
25K-50K
$ 46
1

38
South
Rent
5
50K-100K
$ 50
4

39
East
Rent
3
50K-100K
$ 22
6

40
West
Own
6
50K-100K
$ 20
9

41
North
Own
7
25K-50K
$ 19
3

42
East
Own
3
50K-100K
$ 31
1

43
South
Rent
2
50K-100K
$ 30
10

44
West
Rent
4
25K-50K
$ 18
3

45
East
Own
5
25K-50K
$ 31
7

46
South
Own
3
10K-25K
$ 35
6

47
West
Own
7
25K-50K
$ 28
5

48
East
Rent
3
100K+
$ 29
8

49
South
Rent
2
10K-25K
$ 35
6

50
North
Own
6
25K-50K
$ 30
4

51
South
Own
5
50K-100K
$ 38
7

52
West
Own
3
50K-100K
$ 20
3

53
North
Rent
1
25K-50K
$ 40
5

54
East
Rent
5
25K-50K
$ 30
4

55
South
Own
6
25K-50K
$ 40
8

56
West
Rent
3
10K-25K
$ 62
7

57
North
Rent
4
100K+
$ 22
9

58
East
Rent
5
100K+
$ 25
1

59
West
Rent
7
10K-25K
$ 27
4

60
East
Rent
2
25K-50K
$ 22
7

61
South
Own
3
25K-50K
$ 30
4

62
East
Own
1
25K-50K
$ 31
3

63
East
Own
4
50K-100K
$ 22
8

64
South
Rent
2
50K-100K
$ 25
9

65
West
Own
3
25K-50K
$ 24
3

66
East
Own
5
50K-100K
$ 36
2

67
North
Rent
4
50K-100K
$ 123
11

68
North
Rent
6
100K+
$ 19
2

69
North
Own
5
100K+
$ 23
6

70
South
Rent
7
100K+
$ 19
8

71
West
Rent
4
25K-50K
$ 25
6

72
West
Rent
5
50K-100K
$ 129
8

73
North
Own
3
50K-100K
$ 119
9

74
East
Own
6
100K+
$ 109
3

75
North
Own
5
10K-25K
$ 179
6

76
East
Rent
4
100K+
$ 145
5

77
South
Own
2
25K-50K
$ 119
7

78
North
Rent
3
50K-100K
$ 129
2

79
East
Own
4
10K-25K
$ 189
4

80
West
Own
6
50K-100K
$ 155
6

81
North
Rent
5
25K-50K
$ 78
4

82
East
Own
4
25K-50K
$ 61
5

83
South
Rent
3
25K-50K
$ 97
7

84
North
Rent
2
50K-100K
$ 63
2

85
West
Own
4
100K+
$ 39
3

86
East
Rent
6
50K-100K
$ 95
1

87
South
Rent
4
25K-50K
$ 86
7

88
West
Own
1
50K-100K
$ 85
5

89
East
Own
2
50K-100K
$ 59
7

90
North
Rent
3
100K+
$ 84
9

91
North
Own
2
100K+
$ 144
10

92
West
Rent
3
100K+
$ 26
1

93
South
Rent
7
25K-50K
$ 31
1

94
East
Own
6
50K-100K
$ 19
1

95
South
Rent
5
50K-100K
$ 30
1

96
West
Rent
4
100K+
$ 29
11

97
West
Rent
5
10K-25K
$ 25
2

98
West
Rent
6
100K+
$ 24
6

99
East
Rent
3
25K-50K
$ 36
5

100
North
Own
4
50K-100K
$ 29
7

101
South
Own
2
10K-25K
$ 99
9

102
West
Rent
1
50K-100K
$ 169
3

103
East
Own
3
10K-25K
$ 179
1

104
North
Rent
4
100K+
$ 119
7

105
South
Own
5
25K-50K
$ 99
4

106
West
Rent
4
50K-100K
$ 179
7

107
East
Own
6
10K-25K
$ 185
6

108
North
Rent
3
50K-100K
$ 179
8

109
South
Rent
4
25K-50K
$ 145
9

110
West
Rent
5
25K-50K
$ 119
3

111
North
Own
7
25K-50K
$ 99
2

112
North
Own
2
50K-100K
$ 155
5

113
East
Own
3
100K+
$ 119
4

114
North
Rent
5
50K-100K
$ 149
7

115
East
Rent
3
25K-50K
$ 56
5

116
North
Rent
2
50K-100K
$ 50
6

117
West
Own
4
50K-100K
$ 86
3

118
South
Rent
2
100K+
$ 45
2

119
East
Rent
1
100K+
$ 95
6

120
West
Rent
3
100K+
$ 86
8

121
South
Rent
2
25K-50K
$ 97
11

122
East
Rent
4
50K-100K
$ 40
8

123
North
Rent
5
50K-100K
$ 50
5

124
East
Own
6
100K+
$ 59
3

125
North
Rent
3
10K-25K
$ 75
4

126
South
Rent
4
50K-100K
$ 68
3

127
West
Rent
6
50K-100K
$ 63
1

128
North
Own
2
25K-50K
$ 56
10

129
East
Own
4
25K-50K
$ 86
2

130
North
Rent
6
50K-100K
$ 45
6

131
West
Own
3
100K+
$ 78
8

132
South
Own
4
10K-25K
$ 68
7

133
East
Rent
7
100K+
$ 95
6

134
North
Own
4
25K-50K
$ 95
4

135
East
Rent
5
50K-100K
$ 39
7

136
East
Own
6
50K-100K
$ 56
8

137
North
Own
2
50K-100K
$ 31
9

138
South
Rent
3
25K-50K
$ 29
6

139
West
Rent
4
50K-100K
$ 41
7

140
East
Rent
5
50K-100K
$ 62
4

141
North
Rent
1
25K-50K
$ 51
3

142
South
Own
2
25K-50K
$ 37
2

143
West
Own
3
10K-25K
$ 19
6

144
East
Rent
4
25K-50K
$ 38
5

145
North
Rent
5
100K+
$ 56
7

146
East
Own
4
100K+
$ 41
5

147
West
Own
3
25K-50K
$ 51
8

148
North
Rent
6
50K-100K
$ 19
4

149
East
Rent
2
10K-25K
$ 29
3

150
North
Own
4
50K-100K
$ 41
5

151
East
Own
3
25K-50K
$ 19
6

152
West
Own
3
25K-50K
$ 30
7

153
North
Own
5
25K-50K
$ 19
8

154
South
Rent
4
50K-100K
$ 21
3

155
East
Own
6
100K+
$ 23
2

156
North
Own
7
50K-100K
$ 29
5

157
West
Own
2
25K-50K
$ 18
2

158
East
Own
3
50K-100K
$ 26
5

159
South
Own
1
50K-100K
$ 20
1

160
West
Rent
2
100K+
$ 76
11

161
East
Own
4
100K+
$ 40
4

162
South
Own
2
100K+
$ 41
3

163
North
Own
4
25K-50K
$ 24
7

164
East
Rent
5
50K-100K
$ 26
5

165
West
Rent
6
50K-100K
$ 25
8

166
South
Own
4
100K+
$ 26
6

167
East
Own
2
10K-25K
$ 23
8

168
North
Own
4
50K-100K
$ 27
5

169
East
Own
3
50K-100K
$ 25
8

170
South
Rent
5
25K-50K
$ 34
10

171
West
Rent
4
25K-50K
$ 24
7

172
West
Rent
6
50K-100K
$ 21
9

173
East
Own
4
100K+
$ 40
8

174
South
Rent
3
50K-100K
$ 19
1

175
West
Own
1
100K+
$ 30
11

176
East
Rent
2
100K+
$ 35
10

177
North
Own
4
100K+
$ 24
1

178
East
Own
7
25K-50K
$ 26
4

179
South
Own
4
50K-100K
$ 15
1

180
East
Rent
6
50K-100K
$ 18
3

181
North
Rent
3
100K+
$ 28
1

182
South
Own
7
10K-25K
$ 24
4

183
West
Rent
2
100K+
$ 30
5

184
East
Own
1
25K-50K
$ 30
4

185
West
Own
4
50K-100K
$ 23
7

186
North
Own
5
10K-25K
$ 28
5

187
East
Rent
3
50K-100K
$ 21
6

188
North
Own
2
25K-50K
$ 28
4

189
East
Rent
4
25K-50K
$ 22
2

190
West
Own
5
25K-50K
$ 28
6

191
North
Own
2
50K-100K
$ 30
8

192
South
Own
1
100K+
$ 28
9

193
East
Own
4
50K-100K
$ 25
10

194
North
Rent
2
25K-50K
$ 29
3

195
West
Own
5
50K-100K
$ 28
6

196
East
Own
3
50K-100K
$ 30
5

197
South
Rent
6
100K+
$ 19
4

198
West
Own
5
100K+
$ 30
6

199
East
Rent
7
100K+
$ 149
8

200
South
Own
4
25K-50K
$ 155
7

201
North
Own
5
50K-100K
$ 115
4

202
East
Rent
6
50K-100K
$ 119
5

203
West
Rent
3
100K+
$ 99
7

204
South
Rent
2
10K-25K
$ 119
8

205
East
Own
4
100K+
$ 149
9

206
North
Rent
5
25K-50K
$ 145
11

207
East
Own
3
25K-50K
$ 119
8

208
South
Own
5
50K-100K
$ 129
5

209
North
Rent
4
50K-100K
$ 99
7

210
East
Own
6
50K-100K
$ 119
8

211
South
Rent
4
100K+
$ 185
9

212
West
Own
5
10K-25K
$ 119
5

213
West
Own
6
50K-100K
$ 99
2

214
East
Own
7
50K-100K
$ 109
6

215
South
Rent
1
25K-50K
$ 179
8

216
West
Rent
3
25K-50K
$ 169
6

217
East
Rent
2
50K-100K
$ 179
9

218
North
Rent
5
10K-25K
$ 145
7

219
East
Own
4
100K+
$ 119
6

220
South
Own
6
100K+
$ 165
3

221
East
Own
7
10K-25K
$ 129
2

222
North
Rent
3
100K+
$ 159
11

223
South
Rent
2
50K-100K
$ 37
7

224
West
Own
4
50K-100K
$ 55
5

225
East
Own
5
25K-50K
$ 63
7

226
West
Own
4
25K-50K
$ 56
8

227
North
Rent
3
10K-25K
$ 67
6

228
East
Rent
4
50K-100K
$ 60
8

229
North
Own
6
25K-50K
$ 50
9

230
East
Own
5
50K-100K
$ 49
3

231
West
Own
4
100K+
$ 56
4

232
North
Rent
2
50K-100K
$ 60
7

233
South
Rent
3
50K-100K
$ 59
2

234
East
Own
1
50K-100K
$ 59
8

235
North
Rent
7
50K-100K
$ 60
5

236
West
Rent
3
50K-100K
$ 68
7

237
South
Rent
4
25K-50K
$ 84
9

238
South
Rent
2
25K-50K
$ 69
2

239
West
Rent
5
100K+
$ 97
5

240
North
Own
3
10K-25K
$ 61
4

241
East
Own
4
100K+
$ 75
6

242
West
Own
5
100K+
$ 76
11

243
North
Rent
6
100K+
$ 98
8

244
East
Own
4
25K-50K
$ 95
5

245
South
Own
5
25K-50K
$ 59
7

246
West
Rent
6
50K-100K
$ 44
4

247
North
Rent
7
50K-100K
$ 97
3

248
East
Own
4
100K+
$ 68
6

249
South
Rent
3
25K-50K
$ 145
10

250
West
Rent
2
50K-100K
$ 119
3

251
North
Rent
1
10K-25K
$ 129
6

252
East
Own
5
50K-100K
$ 99
8

253
South
Own
4
25K-50K
$ 119
6

254
West
Own
6
25K-50K
$ 185
8

255
East
Rent
3
25K-50K
$ 119
10

256
East
Own
2
50K-100K
$ 99
3

257
North
Rent
1
100K+
$ 60
6

258
North
Own
5
50K-100K
$ 50
5

259
West
Own
4
25K-50K
$ 49
8

260
West
Rent
6
50K-100K
$ 56
4

261
East
Own
7
50K-100K
$ 60
7

262
North
Rent
3
100K+
$ 59
3

263
East
Rent
2
100K+
$ 59
2

264
South
Own
4
100K+
$ 60
6

265
East
Rent
5
25K-50K
$ 68
5

266
North
Rent
3
50K-100K
$ 84
8

267
South
Own
2
50K-100K
$ 69
9

268
West
Own
4
100K+
$ 97
3

269
East
Rent
3
10K-25K
$ 61
2

270
West
Own
4
50K-100K
$ 75
6

271
North
Rent
3
50K-100K
$ 76
5

272
East
Rent
4
25K-50K
$ 98
7

273
North
Own
5
25K-50K
$ 95
9

274
East
Rent
4
50K-100K
$ 59
4

275
West
Rent
6
100K+
$ 44
6

276
North
Rent
5
50K-100K
$ 97
8

277
South
Rent
7
100K+
$ 68
7

278
East
Rent
1
100K+
$ 145
1

279
North
Own
2
100K+
$ 85
10

280
West
Own
3
25K-50K
$ 59
3

281
South
Rent
4
50K-100K
$ 84
7

282
South
Own
3
50K-100K
$ 28
5

283
South
Rent
5
100K+
$ 26
8

284
East
Own
3
10K-25K
$ 31
9

285
North
Rent
3
100K+
$ 19
3

286
West
Own
2
25K-50K
$ 30
2

287
East
Rent
4
50K-100K
$ 29
11

288
South
Rent
5
10K-25K
$ 25
6

289
West
Rent
6
50K-100K
$ 24
3

290
East
Own
5
25K-50K
$ 36
6

291
South
Own
4
25K-50K
$ 29
7

292
North
Own
3
25K-50K
$ 99
9

293
East
Rent
5
50K-100K
$ 169
8

294
West
Rent
4
100K+
$ 179
3

295
South
Rent
6
50K-100K
$ 119
5

296
East
Own
4
25K-50K
$ 99
4

297
North
Rent
6
50K-100K
$ 56
6

298
East
Rent
1
50K-100K
$ 50
11

299
South
Rent
2
100K+
$ 86
10

300
North
Rent
3
100K+
$ 45
3

301
East
Rent
4
100K+
$ 95
2

302
South
Rent
7
25K-50K
$ 86
10

303
West
Own
4
50K-100K
$ 97
11

304
West
Rent
3
50K-100K
$ 40
7

305
East
Rent
1
100K+
$ 50
5

306
South
Rent
4
10K-25K
$ 59
9

307
West
Own
2
100K+
$ 75
4

308
East
Own
5
25K-50K
$ 68
3

309
North
Rent
3
25K-50K
$ 26
2

310
East
Own
6
50K-100K
$ 15
6

311
South
Own
4
50K-100K
$ 18
8

312
East
Rent
7
50K-100K
$ 28
6

313
North
Own
3
100K+
$ 24
8

314
South
Rent
2
10K-25K
$ 30
9

315
West
Own
4
50K-100K
$ 30
10

316
East
Own
5
50K-100K
$ 23
3

317
West
Rent
3
25K-50K
$ 28
2

318
North
Rent
1
25K-50K
$ 21
6

319
East
Rent
4
50K-100K
$ 28
5

320
North
Rent
3
10K-25K
$ 22
8

321
East
Own
5
100K+
$ 28
7

322
West
Own
6
100K+
$ 30
9

323
North
Rent
4
10K-25K
$ 28
4

324
South
Rent
2
100K+
$ 25
6

325
East
Own
5
50K-100K
$ 29
3

326
North
Own
3
50K-100K
$ 28
5

327
West
Rent
5
25K-50K
$ 30
3

328
South
Rent
6
25K-50K
$ 19
6

329
South
Own
4
10K-25K
$ 30
5

330
West
Own
3
50K-100K
$ 149
7

331
North
Own
5
25K-50K
$ 155
9

332
East
Own
6
50K-100K
$ 115
4

333
West
Rent
4
100K+
$ 39
6

334
North
Own
6
50K-100K
$ 95
8

335
East
Own
4
50K-100K
$ 86
7

336
South
Own
7
50K-100K
$ 85
1

337
West
Own
4
50K-100K
$ 59
10

338
North
Own
3
50K-100K
$ 84
3

339
East
Rent
1
25K-50K
$ 28
7

340
South
Own
2
25K-50K
$ 26
5

341
West
Own
5
100K+
$ 31
8

342
North
Own
3
10K-25K
$ 19
9

343
East
Rent
4
100K+
$ 30
3

344
South
Rent
6
100K+
$ 29
2

345
West
Own
5
100K+
$ 25
11

346
East
Own
3
25K-50K
$ 24
6

347
East
Own
2
25K-50K
$ 36
3

348
North
Own
1
50K-100K
$ 29
6

349
North
Rent
6
50K-100K
$ 99
7

350
West
Rent
7
50K-100K
$ 169
9

351
West
Rent
2
50K-100K
$ 179
8

352
East
Own
1
10K-25K
$ 119
3

353
North
Rent
2
100K+
$ 99
5

354
East
Own
3
10K-25K
$ 179
4

355
South
Own
2
100K+
$ 185
6

356
East
Rent
1
50K-100K
$ 179
11

357
North
Own
3
50K-100K
$ 145
10

358
South
Own
4
25K-50K
$ 119
3

359
West
Own
6
25K-50K
$ 99
2

360
East
Rent
5
10K-25K
$ 155
10

361
West
Rent
4
50K-100K
$ 119
11

362
North
Own
3
25K-50K
$ 149
7

363
East
Own
5
50K-100K
$ 56
5

364
North
Own
6
100K+
$ 50
9

365
East
Own
7
50K-100K
$ 86
4

366
North
Rent
5
50K-100K
$ 45
3

367
South
Rent
6
50K-100K
$ 95
2

368
North
Rent
3
50K-100K
$ 86
6

369
West
Own
4
50K-100K
$ 97
8

370
East
Rent
5
25K-50K
$ 23
6

371
South
Own
2
25K-50K
$ 29
8

372
East
Rent
3
100K+
$ 18
9

373
West
Own
6
10K-25K
$ 26
10

374
North
Own
2
100K+
$ 20
3

375
West
Own
5
100K+
$ 15
2

376
North
Rent
4
100K+
$ 40
6

377
East
Rent
1
25K-50K
$ 41
5

378
South
Own
4
25K-50K
$ 24
8

379
South
Rent
3
50K-100K
$ 26
7

380
South
Own
5
10K-25K
$ 25
9

381
West
Own
6
25K-50K
$ 26
4

382
North
Own
4
50K-100K
$ 23
6

383
East
Rent
2
50K-100K
$ 27
7

384
West
Own
5
25K-50K
$ 25
5

385
North
Rent
3
25K-50K
$ 18
3

386
East
Own
5
25K-50K
$ 24
6

387
South
Own
6
10K-25K
$ 21
8

388
West
Own
4
100K+
$ 40
2

389
North
Own
3
100K+
$ 19
4

390
South
Rent
5
10K-25K
$ 30
9

391
West
Own
6
25K-50K
$ 35
7

392
East
Own
4
25K-50K
$ 24
10

393
East
Rent
6
25K-50K
$ 26
2

394
North
Own
4
50K-100K
$ 15
6

395
North
Rent
7
50K-100K
$ 18
5

396
West
Own
4
25K-50K
$ 28
7

397
West
Own
3
50K-100K
$ 24
4

398
East
Rent
1
50K-100K
$ 30
3

399
North
Rent
2
100K+
$ 30
2

400
East
Rent
5
25K-50K
$ 23
8

401
South
Own
3
25K-50K
$ 28
6

402
East
Rent
4
10K-25K
$ 21
7

403
North
Own
6
25K-50K
$ 28
5

404
South
Own
5
100K+
$ 22
3

405
West
Rent
3
50K-100K
$ 28
6

406
East
Own
2
50K-100K
$ 30
8

407
West
Rent
1
25K-50K
$ 28
1

408
North
Own
6
25K-50K
$ 25
8

409
East
Own
7
50K-100K
$ 29
6

410
North
Rent
2
50K-100K
$ 28
4

411
East
Rent
1
25K-50K
$ 30
7

412
North
Own
2
50K-100K
$ 19
3

413
South
Own
3
50K-100K
$ 30
1

414
North
Own
2
25K-50K
$ 149
4

415
West
Own
1
50K-100K
$ 155
1

416
East
Rent
3
10K-25K
$ 115
4

417
South
Own
4
100K+
$ 119
6

418
East
Own
6
50K-100K
$ 99
5

419
West
Own
5
50K-100K
$ 119
3

420
North
Own
4
25K-50K
$ 149
7

421
West
Own
3
25K-50K
$ 145
6

422
North
Rent
5
25K-50K
$ 119
8

423
East
Own
6
10K-25K
$ 129
9

424
West
Own
7
100K+
$ 99
10

425
North
Own
5
100K+
$ 119
2

426
East
Rent
6
10K-25K
$ 185
6

427
South
Rent
3
25K-50K
$ 119
4

428
West
Own
4
25K-50K
$ 99
7

429
North
Own
5
25K-50K
$ 109
5

430
East
Own
2
50K-100K
$ 179
8

431
South
Own
3
50K-100K
$ 169
9

432
West
Rent
5
25K-50K
$ 179
2

433
North
Rent
4
50K-100K
$ 145
5

434
East
Rent
6
50K-100K
$ 119
4

435
South
Own
7
100K+
$ 165
3

436
West
Rent
2
25K-50K
$ 129
11

437
East
Own
3
25K-50K
$ 159
7

438
East
Own
1
10K-25K
$ 37
4

439
North
Rent
3
25K-50K
$ 55
6

440
North
Own
5
25K-50K
$ 63
5

441
West
Own
4
25K-50K
$ 56
9

442
West
Own
6
50K-100K
$ 67
2

443
East
Rent
7
50K-100K
$ 60
5

444
North
Rent
2
50K-100K
$ 50
3

445
East
Own
3
25K-50K
$ 49
6

446
South
Own
4
10K-25K
$ 56
8

447
East
Own
5
25K-50K
$ 60
4

448
North
Own
3
100K+
$ 59
7

449
South
Rent
4
10K-25K
$ 59
5

450
West
Rent
1
25K-50K
$ 60
1

451
East
Rent
3
50K-100K
$ 68
10

452
South
Own
4
50K-100K
$ 84
11

453
North
Rent
5
25K-50K
$ 69
11

454
West
Own
6
25K-50K
$ 97
11

455
East
Rent
7
50K-100K
$ 61
3

456
South
Own
6
10K-25K
$ 75
6

457
East
Own
7
100K+
$ 76
4

458
West
Own
4
100K+
$ 98
7

459
North
Rent
3
100K+
$ 95
9

460
West
Rent
5
50K-100K
$ 59
3

461
North
Own
2
50K-100K
$ 44
2

462
East
Rent
3
100K+
$ 97
6

463
West
Own
4
10K-25K
$ 68
5

464
North
Own
6
100K+
$ 145
8

465
East
Own
4
25K-50K
$ 119
7

466
South
Rent
5
50K-100K
$ 129
2

467
West
Own
3
10K-25K
$ 99
4

468
North
Rent
2
50K-100K
$ 119
3

469
North
Own
6
10K-25K
$ 185
6

470
East
Own
3
100K+
$ 119
9

471
West
Own
1
25K-50K
$ 99
10

472
South
Own
4
50K-100K
$ 60
11

473
East
Rent
3
10K-25K
$ 50
4

474
West
Rent
5
50K-100K
$ 49
2

475
South
Own
6
25K-50K
$ 56
1

476
East
Own
3
25K-50K
$ 60
5

477
North
Own
2
25K-50K
$ 59
4

478
East
Own
4
50K-100K
$ 59
7

479
North
Rent
5
100K+
$ 60
8

480
West
Rent
7
50K-100K
$ 68
9

481
East
Rent
2
25K-50K
$ 84
1

482
West
Own
1
50K-100K
$ 69
7

483
South
Rent
2
50K-100K
$ 97
4

484
North
Own
1
25K-50K
$ 61
6

485
East
Rent
3
50K-100K
$ 75
5

486
East
Own
6
50K-100K
$ 76
9

487
West
Own
4
50K-100K
$ 98
2

Confirming Pages

EXTENDED LEARNING MODULE D

Student Learning Outcomes
1. Define a list and a list definition table within the context of spreadsheet software

and describe the importance of each.

2. Compare and contrast the Filter function and Custom Filter function in spreadsheet

software.

3. Describe the purpose of using conditional formatting.

4. Define a pivot table and describe how you can use it to view summarized

information by dimension.

D E C I S I O N A N A LY S I S W I T H
S P R E A D S H E E T S O F T WA R E

haa7685x_modD_D.1-D.20.indd 1haa7685x_modD_D.1-D.20.indd 1 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

Introduction D.2

Introduction
As you read in Chapter 4, technology can and does play a vitally important role in both
supporting decision making and, in some instances, actually making decisions or recom-
mendations. In this module, we’ll focus on decision-making support by exploring many
of the advanced and productive features of Microsoft Excel.

Microsoft Excel is spreadsheet software that allows you to work with any kind of
information, with each individual piece of information located in a cell. A cell is the
intersection of a row and column and is uniquely identified by its column character
and row number. In Figure D.1 you can see two workbooks. The first (the one in the
background) shows all the detailed information for a group of customers. The second
shows the number of customers by region (North, South, East, and West) and by rent
versus own.

There are a total of 487 customers (cell D9 in the workbook in the foreground), of
which 262 own a home (cell B9) and 225 rent (cell C9). Within this workbook, you can
easily see some interesting information. For example, there are 148 customers in the East
region while only 98 live in the South region. By region and ownership status, 82 own a
home in the East region while only 47 rent in the South region.

Figure D.1
Number of Customers
by Region and by Rent
versus Own

Customers
by region

Total number of customersCustomers by rent versus own

haa7685x_modD_D.1-D.20.indd 2haa7685x_modD_D.1-D.20.indd 2 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

D.3 Extended Learning Module D

Of course, now the question becomes, How is the information in Figure D.1 helpful?
Well, it depends on the nature of your decision-making task. If you believe that home
owners spend more money than those who rent and want to target advertising to the
largest region, the information might be helpful. Then again, it might not be. It could
very well be that home owners actually spend less than customers who rent. And per-
haps you generate more sales in regions with a lower number of customers.

Let’s see how spreadsheet software can help you make better decisions. As we do,
we’ll introduce you to some spreadsheet features including Filter, conditional format-
ting, and pivot tables. Our goal here is not to provide in great detail how each of these
work, but rather what’s most important about each one of them in supporting your
decision-making tasks. After completing this module, you’ll definitely be able to use
all features in their basic forms. We recommend that you continue to explore them in
detail.

Lists
What we showed in Figure D.1 was a pivot table. A pivot table is a spreadsheet func-
tion that summarizes information by category. In our case, it summarized information
by region (the rows) and rent versus own (the column). To create a pivot table (and
use many of the other features we’ll discuss in this module), you have to first build a
list. You should work along with us on this. Connect to the Web site that supports this
text ( www.mhhe.com/haag and select XLM/D). There, you can download the file called
XLMD_Customer.xls.

A list is a collection of information arranged in columns and rows in which each col-
umn displays one particular type of information. In spreadsheet software, a list possesses
the following characteristics:

1. Each column has only one type of information.
2. The first row in the list contains the labels or column headings.
3. The list does not contain any blank rows.
4. The list is bordered on all four sides by blank rows and blank columns (it may

not have a blank line above it, if it starts in the first row).

Take a look at the workbook in Figure D.2 . It contains detailed information about our
customers. In fact, we used this very list to generate the pivot table in Figure D.1 .

First, notice that each column contains only one type of information: column A con-
tains CUST ID, column B contains REGION, and so on. Second, notice that the first row
(row 1) contains the labels or column headings. Third, if you scroll down completely
through the list, you’ll notice that there are 487 customers and there are no blank rows.
Finally, notice that the list is bordered on all sides (except the top) by blank rows and
columns. So, this is a list according to the four characteristics we listed.

We’re going to be working extensively with this list throughout this module, so let’s
take a little time to explore the information in it. The columns of information include

A. CUST ID —A unique ID for each customer
B. REGION —The region in which the customer lives (North, South, East, or

West)
C. RENT VS. OWN —Whether the customer rents or owns a home
D. NUM HOUSEHOLD —Number of family members in the household
E. ANNUAL INCOME —Total combined annual income of all family members

LEARNING OUTCOME 1

haa7685x_modD_D.1-D.20.indd 3haa7685x_modD_D.1-D.20.indd 3 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

Lists D.4

F. TOTAL PURCHASES —Dollar total of all purchases made by the customer
within the last six months

G. NUM PURCHASES —Count of all purchases made by the customer within the
last six months

What we listed above is called a list definition table, a description of a list by column.
List definition tables are important. If you can create one just as we did, then you can cre-
ate a list in a workbook with the appropriate characteristics. If you can’t, then you may
not be able to use many of the features we’re about to show you.

With the good solid list in place, you’re now ready to start exploring many of the
decision support features in Excel. Let’s assume that you work for our hypothetical
retail company and have been asked to perform the following tasks to aid in various
decisions:

1. Show all information for only customers who live in the North region.
2. Show all information for only customers who (a) live in the North region, (b) own

their homes, and (c) have only one household member.
3. Show all information for customers who have at least 4 household members.
4. Show all information for customers who (a) have spent less than $20 or (b) more

than $100.
5. Show all information for all customers highlighting those customers who have

spent more than $100.
6. Provide a two-dimensional table that counts the number of customers by the

categories of REGION and RENT VS. OWN.
7. Provide a two-dimensional table that both (a) counts the number of customers

and (b) sums the TOTAL PURCHASES of customers by the categories of
REGION and RENT VS. OWN.

8. Provide a three-dimensional table that counts the number of customers by the
categories of REGION, RENT VS. OWN, and NUM HOUSEHOLD.

We will use Excel to perform all of these tasks throughout the remainder of this module.

Figure D.2
The Complete List
of Customers

Labels or
column
headings

Each column has only one type of information

haa7685x_modD_D.1-D.20.indd 4haa7685x_modD_D.1-D.20.indd 4 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

D.5 Extended Learning Module D

Basic Filter
Working with small lists that can be displayed in their entirety on a screen is seldom a prob-
lem. With a small list you can see the entire domain of information without scrolling up or
down. But our list is much larger, containing 487 customers. So, you have to scroll through
it to see all the information. If you were looking for specific information, such as all the
customers in the North region (your first task in the list on the previous page), you could
sort using the REGION column but you still get all the information (not to mention that
customers in the North would come after the customers in the East region, alphabetically).

To quickly create smaller lists out of a much larger list, you can use the Filter function.
The Filter function filters a list and allows you to hide all the rows in a list except those
that match criteria you specify. To filter a list with the Filter function, perform the follow-
ing steps (see Figure D.3 ):

1. Click in any cell within the list
2. From the menu bar, click on Data and then click on Filter

LEARNING OUTCOME 2

Figure D.3
Using Basic Filter to See
Customers in the
North Region

When you click on Data and Filter, Excel places list
arrow boxes by each column heading

The default fi ltering is all values

Deselect all regions except North and click on OK

Shows only customers in the
North REGION

haa7685x_modD_D.1-D.20.indd 5haa7685x_modD_D.1-D.20.indd 5 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

Basic Filter D.6

Once you complete those two steps, Excel will place list box arrows next to each label or
column heading. Now, all you have to do is click on the appropriate list box arrow and
select the type of filtering you want. In Figure D.3 , you can see that we clicked on the
REGION list arrow box. Excel then presented us with a number of options for filtering
within REGION. We deselected all regions except North and then clicked on the OK
button. Excel then presented us with a filtered list of only those customers in the North
region. Our list is still quite long, but it does show only customers in the North. To turn
off the Filter function, from the menu bar, click on Data, then click on Filter.

When using the Filter function, you’re not limited to working with just one column.
In Figure D.3 , we filtered using the REGION column. Now, what if you want a filtered
list of those customers in the North who own a home and have only one household
member (your second task in the list on page D.4)? That’s easy. Click in the RENT VS.
OWN list arrow box and choose only Own. Then, click in the NUM HOUSEHOLD list
arrow box and choose only 1. That will show you the complete list (4 to be exact) of
customers in the North who own a home and have only one household family member
(see Figure D.4 ).

It’s important to be clear what Excel is doing to your list when using the Filter func-
tion. No matter how you use the Filter function, Excel is simply hiding the rows you
don’t want to see. It is not eliminating or deleting them. You can see this in Figure D.4
by looking at the row numbers. Notice that they present the physical row number of each
record of information according to where it is located in the original unfiltered list. To
un-Filter a list, you can do either of the following:

1. Turn off the Filter function by clicking on Data in the menu bar and then clicking
on Filter.

2. Turn off selected column filtering by clicking on the appropriate list arrow box
and clicking on Clear Filter from “columnname” where columnname is the
name of the column.

Figure D.4
A List Generated with
Three Filters

Customers in the North REGION who own a home
with only 1 household member

haa7685x_modD_D.1-D.20.indd 6haa7685x_modD_D.1-D.20.indd 6 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

D.7 Extended Learning Module D

Custom Filter
The basic Filter function allows you to create sublists using exact match criteria: REGION
must be North, NUM HOUSEHOLD must be 1, and so forth. But what if you want to
know all those customers who have at least four people in their households (your third
task in the list on page D.4)? In that case, you can’t use the basic Filter function—you need
to use the Custom Filter function. The Custom Filter function allows you to hide all the
rows in a list except those that match criteria, besides “is equal to,” you specify. Let’s see
how to use the Custom Filter function.

Given that you want to see a list of all customers who have at least four people in their
households, perform the following steps:

1. Make sure you can see the entire list with the Filter function turned on
2. Click on the NUM HOUSEHOLD list arrow box
3. Select Number Filters
4. Click on Greater Than from the list of Boolean operations
5. Type the number 3 in the upper-right box of the Custom AutoFilter dialog box
6. Click on OK Figure D.5

Using a Custom Filter

To use Custom Filter, click on Number Filters and
then choose the appropriate Boolean operater Only customers with more than 3

people in their households

haa7685x_modD_D.1-D.20.indd 7haa7685x_modD_D.1-D.20.indd 7 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

Custom Filter D.8

Excel does the rest and shows you the appropriate list of customers with at least four
people in their households.

You should notice in Figure D.5 that the Custom Filter box allows you to enter two
criteria for creating a filtered list. So, you can easily create a Custom Filter that answers
the following question: What customers have spent less than $20 or more than $100
in the past six months (your fourth task in the list on page D.4)? In Figure D.6 , we’ve
shown you how to do that along with the result. To create this type of filtering, click on
Custom Filter within Number Filters and then Select/enter the appropriate values and
boolean operators.

Figure D.6
Using a Custom Filter
with Multiple Criteria

Only customers who have spent
less than $20 or more than $100

haa7685x_modD_D.1-D.20.indd 8haa7685x_modD_D.1-D.20.indd 8 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

D.9 Extended Learning Module D

Conditional Formatting
When you use Filter (either basic or custom), in a way you’re highlighting information
you want to see by basically hiding the other information you don’t. As an alternative,
you might want to highlight certain information while still being able to see all the other
information. If so, you can use conditional formatting. Conditional formatting high-
lights the information in a cell that meets some criteria you specify.

For example, what if you still wanted to be able to scroll through the entire list of cus-
tomers but also wanted to have all TOTAL PURCHASES greater than $100 highlighted
(your fifth task in the list on page D.4). This is a simple process in Excel. To do that,
perform the following steps (see Figure D.7 ):

1. Select the entire TOTAL PURCHASES column (move the pointer over the
F column identifier and click once)

2. From the menu bar, click on Home and then Conditional Formatting within
Styles

3. Select Highlight Cells Rules
4. Click on Greater Than
5. Type the number 100 in the left box of the Greater Than dialog box
6. Click on OK

LEARNING OUTCOME 3

Figure D.7
The Steps in Applying
Conditional Formatting
to Highlight Information

haa7685x_modD_D.1-D.20.indd 9haa7685x_modD_D.1-D.20.indd 9 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

Conditional Formatting D.10

As you can see in Figure D.8 , Excel left the list intact and highlighted all cells in the
TOTAL PURCHASES column in which the value exceeded $100. The default “high-
lighting” is dark red text with a light red fill. You can change this in the Greater Than
dialog box by clicking on the pull-down arrow for the right box.

You can remove conditional formatting in a couple of different ways:

• Option #1

1. Click anywhere in the list
2. Click on Conditional Formatting
3. Select Clear Rules
4. Click on Clear Rules from Entire Sheet

• Option #2

1. Select the entire column in which conditional formatting appears
2. Click on Conditional Formatting
3. Select Clear Rules
4. Click on Clear Rules from Selected Cells

Figure D.8
The Result of Applying
Conditional Formatting

Only customers whose TOTAL PURCHASES exceed
$100 are highlighted in red

haa7685x_modD_D.1-D.20.indd 10haa7685x_modD_D.1-D.20.indd 10 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

D.11 Extended Learning Module D

Pivot Tables
Now, let’s return to our original pivot table in Figure D.1 on page D.2. Formally defined,
a pivot table enables you to group and summarize information. That’s just what we did
in Figure D.1 . We created a two-dimensional pivot table that displayed a count of cus-
tomers by REGION and by RENT VS. OWN (your sixth task in the list on page D.4).
Of all the Excel decision-support features we demonstrate in this module, pivot tables
take the most steps to create, but they also tend to yield highly valuable information.

To create any two-dimensional pivot table, follow the two steps below (and see
Figure D.9 ):

1. From the menu bar, click on Insert and then PivotTable
2. Click on OK in the Create PivotTable dialog box

The first step above simply specifies that you want to insert a pivot table. In the
second step, we accepted the default pivot table settings by clicking on OK. While in
the PivotTable dialog box, there are other options you should consider exploring on
your own.

• Selecting the information for the pivot table —the default is the entire table. You
can select another table or choose to highlight a subset of the current table.

• Getting information from another source —you can choose to use an external data
source, such as a Word or Access table.

• Location of the pivot table —the default is to place the pivot table in a new
worksheet. You can choose to place it in the current worksheet if you wish.

After you complete the two steps above, you will then see the skeletal structure of a pivot
table as shown in Figure D.10 .

LEARNING OUTCOME 4

Figure D.9
The First Steps in
Creating a Two-
Dimensional Pivot Table

haa7685x_modD_D.1-D.20.indd 11haa7685x_modD_D.1-D.20.indd 11 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

Pivot Tables D.12

The screen in Figure D.10 has many elements to it. In the upper-left corner of the
worksheet is the actual pivot table into which we will drop fields of information. The
upper-right area contains the PivotTable Field List, the list of fields in the original
table that we can work with. The lower-right area contains a sort of summary of the
pivot table as you build and use it.

To add fields of information to the pivot table, you drag and drop field names
(i.e., column headings or labels) from the PivotTable Field List and drop them into one
of two places. First, you can drop them into the summary in the bottom-right portion of
the screen. Second, you can drop them into the appropriate locations within the pivot
table itself. It really doesn’t matter which you choose; both achieve the same result. For
our demonstration, we’ll be dropping field names into the actual pivot table.

Figure D.10
The Skeletal Structure
of a Pivot Table

Pivot table
PivotTable Field List

Summary of the
pivot table

haa7685x_modD_D.1-D.20.indd 12haa7685x_modD_D.1-D.20.indd 12 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

D.13 Extended Learning Module D

Recall that we are attempting to build a two-dimensional table that looks like the one
in Figure D.1 on page D.2. So, you know that the row information is by REGION. To
achieve this, drag the REGION field name from the PivotTable Field List to the pivot table
and drop it into the area marked “Drop Row Fields Here” (see Figure D.11 ). You also
know that the column information is by RENT VS. OWN. So, drag that field name from
the PivotTable Field List and drop it into the area marked “Drop Column Fields Here.”

Finally, you need to place something in the main area of the pivot table that will enable
you to count customers by region and rent versus own. The simplest way to achieve
this is to drag CUST ID from the PivotTable Field List and drop it into the area marked
“Drop Data Items Here.” What you will then have is a pivot table that looks like the
screen in Figure D.11 , which is not at all what we want. Why?

Figure D.11
Creating a Pivot Table by
Dragging and Dropping
Information

Drag and drop REGION
here

Drag and drop CUST ID
here

Drag and drop RENT
VS. OWN here

haa7685x_modD_D.1-D.20.indd 13haa7685x_modD_D.1-D.20.indd 13 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

Pivot Tables D.14

When you drop information into the main area of a pivot table, the default aggre-
gation or summarization is by summation. You don’t want to sum customer IDs—that
doesn’t make any sense. What you want to do is count them. To change this, perform the
following steps (see Figure D.12 ):

1. Click on any cell in the main area of the pivot table
2. Click on the Field Settings button in the menu area
3. Click on Count in the Summarize by tab of the Value Field Settings dialog box
4. Click on OK in the same dialog box

The final screen in Figure D.12 shows the correct information. Also, take a look at the
lower-right portion of the screen which contains the summary of the pivot table. It shows
the columns as RENT VS. OWN, the rows as REGION, and the values (the main area of
the pivot table) as Count of CUST ID.

We now have a pivot table that shows a count of customers by REGION and RENT
VS. OWN. But depending on what decision you’re trying to make, that may not be
enough information. What else might be helpful? Again, depending on the decision, it
might be helpful to also know the total of all purchases by REGION and RENT VS.

Figure D.12
The Pivot Table with the
Information You Want

Now, the pivot table counts the number of
customers.

haa7685x_modD_D.1-D.20.indd 14haa7685x_modD_D.1-D.20.indd 14 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

D.15 Extended Learning Module D

OWN (your seventh task in the list on page D.4). If so, you don’t need to create another
pivot table. You can simply add the field TOTAL PURCHASES to the main area of the
pivot table. To do so, drag that label from the PivotTable Field List and drop it into the
main area of the pivot table. Figure D.13 shows the result.

Is the information helpful? Again, it depends on the decision you’re trying to make.
But adding another piece of information to the main area of a pivot table is easy, and it
does illustrate the true productivity of spreadsheet software.

Your final task in the list on page D.4 is to create a three-dimensional pivot table that
counts the number of customers by the categories of REGION, RENT VS. OWN, and
NUM HOUSEHOLD. The result will look similar to the two-dimensional pivot table
in Figure D.13 with two exceptions. First, you will not include the sum of TOTAL

Figure D.13
An Added Field of
Information to a
Pivot Table

Drag and drop TOTAL PURCHASES here to obtain
a summary of another dimension of information

haa7685x_modD_D.1-D.20.indd 15haa7685x_modD_D.1-D.20.indd 15 12/15/11 8:10 PM12/15/11 8:10 PM

Confirming Pages

Pivot Tables D.16

PURCHASES in the main area of the pivot table. Second, you will add depth to the pivot
table, making it a three-dimensional pivot table. In short, you do this by dragging the
NUM HOUSEHOLD label from the PivotTable Field List to the pivot table and drop-
ping it into the area marked “Drop Page Fields Here.”

In Figure D.14 , you can see in the upper-left screen that we created a two-dimensional
pivot table showing a count of customers by REGION and RENT VS. OWN. This is the
same two-dimensional pivot table we created in Figure D.12 on page D.14. To add depth
to the pivot table, we dragged the NUM HOUSEHOLD label from the PivotTable Field
List to the pivot table and dropped it into the area marked “Drop Page Fields Here.”
Notice that the new pivot table (the lower right screen in Figure D.14 ) still looks like a
two-dimensional pivot table and provides the same information in the main area of the
pivot table. That’s because the default display for a three-dimensional pivot table is to show
all summarized information for the depth. You can tell this because to the right of NUM
HOUSEHOLD in cell A1 is the word “All.”

The current depth dimension is for “all”
customers, regardless of how many members are
in a household.

Figure D.14
Creating a Three-
Dimensional Pivot Table

haa7685x_modD_D.1-D.20.indd 16haa7685x_modD_D.1-D.20.indd 16 12/15/11 8:11 PM12/15/11 8:11 PM

Confirming Pages

D.17 Extended Learning Module D

To view the count of your customers by specific values for NUM HOUSEHOLD, sim-
ply click on the list box arrow immediately to the right of the word “All” as we did in the
top screen in Figure D.15 . You then click on the value you want in NUM HOUSEHOLD
for displaying the count of customers for that value by REGION and RENT VS. OWN.
We clicked on 4 and then OK. The bottom screen in Figure D.15 shows the result.
It shows some interesting information that might help you make a decision. For exam-
ple, in the West region there are 20 customers who own their homes and only 11 who
rent their homes. Furthermore, across all regions there are 66 customers who own their
homes and only 40 who rent. Again, is this helpful information? That depends on the
decision you’re trying to make.

The three-dimensional pivot table feature in Excel is a powerful one. If you recall our
discussions of data warehouses in Chapter 3, you can actually build a data warehouse
with rows, columns, and layers by simply creating a three-dimensional pivot table in
Excel. By selecting different values for the page (depth) field, you are actually bringing
layers of information to the front.

Click on the NUM
HOUSEHOLD pulldown
arrow to see your depth
options.

By selecting 4 in the NUM HOUSEHOLD depth
dimension, you see a summary of customers for
only that criteria.

Figure D.15
Viewing Different Depths
in a Three-Dimensional
Pivot Table

haa7685x_modD_D.1-D.20.indd 17haa7685x_modD_D.1-D.20.indd 17 12/15/11 8:11 PM12/15/11 8:11 PM

Confirming Pages

Back to Decision Support D.18

Back to Decision Support
Let’s take a break from the computer for a moment and discuss what we’ve just demon-
strated within the context of decision support. After all, you don’t need to learn the vari-
ous tools of spreadsheet software just because “they are there.” You should learn them
because they will be beneficial to you.

In general, the spreadsheet features we’ve just shown you give you the ability to look
at vast amounts of information quickly. Indeed, our customer workbook contained
information on 487 customers. Can you imagine trying to summarize or aggregate infor-
mation on 48,700 customers without the use of spreadsheet software? Even creating
simple totals and subtotals would be a daunting task.

FILTER

The Filter function (either basic or custom) helps you quickly create a view of a partial
list of information. The basic Filter function creates a partial list based on exact match
criteria, while the custom Filter function allows you to specify ranges (e.g., greater than,
less than, and so on).

The purpose of the Filter function is really to help you quickly focus on only the
information that’s important to you by “hiding” the information that isn’t. It’s rather like
having a very good search engine that gives you only a list of useful articles to help you
write a term paper.

CONDITIONAL FORMATTING

Conditional formatting maintains the view of the entire list of information but highlights
key pieces of information that you may be looking for. This gives you the ability to see
the entire list of information but quickly draws your attention to specific information.

PIVOT TABLE

A pivot table (either two- or three-dimensional) helps you quickly aggregate or summa-
rize information by dimension. This gives you a nice overview of the information without
bogging you down in any of the details.

Further, a pivot table can help you see relationships among the information. If you
look back at the pivot table in Figure D.13 on page D.15, you can see the relationship
between the number of customers and their total purchases within REGION and RENT
VS. OWN. These types of relationships can certainly be insightful.

Can any of these tools or functions make a decision for you? Definitely not. But they can
help you make that decision. That’s why spreadsheet software is often called decision
support s oftware.

haa7685x_modD_D.1-D.20.indd 18haa7685x_modD_D.1-D.20.indd 18 12/15/11 8:11 PM12/15/11 8:11 PM

Confirming Pages

D.19 Extended Learning Module D

SUMMARY: STUDENT LEARNING OUTCOMES REVISITED

1. Define a list and a list definition table within the
context of spreadsheet software and describe
the importance of each. A list is a collection
of information arranged in columns and rows
in which each column displays one particular
type of information. A list definition table is a
description of a list by column. Lists are important
within the context of spreadsheet software because
they enable you to use such spreadsheet features
as AutoFilter, conditional formatting, and pivot
tables. Creating a list definition table is important
because it requires you to adhere to the necessary
rules for creating a list.

2. Compare and contrast the Filter function and
Custom Filter function in spreadsheet software.
The Filter function filters a list and allows you
to hide all the rows in a list except those that
match specific criteria you specify. The Custom

Filter function allows you to hide all the rows in
a list except those that match criteria, besides “is

equal to,” you specify. So, the basic Filter function
makes use of “is equal to” as the criteria, while the
Custom Filter function allows you to use other
criteria such as greater than, less than, and so on.

3. Describe the purpose of using conditional
formatting. Conditional formatting highlights
the information in a cell that meets some criteria
you specify. So, conditional formatting allows
you to view the entire list while having certain
information called to your attention.

4. Defi ne a pivot table and describe how you
can use it to view summarized information
by dimension. A pivot table enables you to
group and summarize information. When
creating a pivot table, you create dimensions
of information by specifying how information
is to be summarized by dimension. You defi ne
the dimensions by dragging and dropping
information labels or column headings into the
row, column, and page areas of a pivot table.

KEY TERMS AND CONCEPTS

Conditional formatting, D.9
Custom Filter function, D.7
Filter function, D.5

List, D.3
List definition table, D.4
Pivot table, D.11

ASSIGNMENTS AND EXERCISES

1. WHAT PRODUCTION PROBLEMS DO YOU
HAVE? For this assignment use XLMD_
Production.xls. Its list definition table is as
follows:

A. BATCH —A unique number that identifies
each batch or group of products produced

B. PRODUCT —A unique number that identifies
each product

C. MACHINE —A unique number that identifies
each machine on which products are
produced

D. EMPLOYEE —A unique number that identifies
each employee producing products

E. BATCH SIZE —The number of products
produced in a given batch

F. NUM DEFECTIVE —The number of defective
products produced in a given batch

It seems you have some real problems. There
are an unacceptable number of defective
products being produced. Your task is to
use some combination of Filter, conditional
formatting, and pivot tables to illustrate
where the problems seem to be concentrated,
perhaps by product, by employee, by
machine, or even by batch size. Based on
your analysis, recommend how to correct the
problems.

haa7685x_modD_D.1-D.20.indd 19haa7685x_modD_D.1-D.20.indd 19 12/15/11 8:11 PM12/15/11 8:11 PM

Confirming Pages

Assignments and Exercises D.20

2. EVALUATING TOTAL PURCHASES AND ANNUAL
INCOME Using XLMD_Customer.xls,
create a pivot table that illustrates the
relationship between TOTAL PURCHASES and
ANNUAL INCOME. What trends do you see
in the information? Suppose your task is to
concentrate marketing efforts and resources.
On which annual income level would you
concentrate? Why? If you were the marketing
manager, what additional information would
be helpful as you make your decision? Where
would you be able to obtain such information?

3. FINDING OUT INFORMATION ABOUT YOUR
EMPLOYEES Suppose you own a small business
and have a workbook with the following list:

A. ID —Unique employee’s identification number

B. First Name —Employee’s first name

C. Last Name —Employee’s last name

D. Department —Employee’s department

E. Title —Employee’s job title

F. Salary —Employee’s annual salary

G. Hire Date —Date employee was hired

H. Birth Date —Employee’s birthday

I. Gender —Female (F) or Male (M)

J. Clearance —N (none), C (confidential),
S (secret), or TS (top secret)

You can obtain this workbook from the Web
site that supports this text ( www.mhhe.com/
haag and select XLM/D). Its filename is XLMD_
Employee.xls. Perform the following tasks:

a. Create a pivot table that shows average
salary by gender within department.

b. Create a pivot table that shows the number
of employees by clearance.

c. Use conditional formatting to highlight
those employees in the Engineering
department.

d. Use conditional formatting to highlight
those employees who have no clearance
(none).

e. Use basic Filter to show only those employees
who have top secret clearance (TS).

f. Use Custom Filter to show only those
employees who earn more than $50,000.

4. EXPLORING INFORMATION AT B&B TRAVEL
Benjamin Travis and Brady Austin are

co-owners of B&B Travel Consultants, a
medium-size business in Seattle with several
branch offices. B&B specializes in selling
cruise packages. Ben and Brady maintain a
workbook that contains the following list for
each cruise package sale:

A. LOCATION # —A unique number that
identifies which office location recorded the
sale

B. TRAVEL AGENT # —A unique number that
identifies which travel consultant recorded
the sale

C. CRUISE LINE —The name of the cruise line
for which the package was sold

D. TOTAL PACKAGE PRICE —The price charged
to the customer for the package

E. COMMISSION —The amount of money B&B
made from the sale of the package

Ben and Brady have decided to scale back their
operations. So, they’re looking to you for help.
The workbook name is XLMD_Travel.xls and
you can find it on the Web site that supports
this text at www.mhhe.com/haag (select
XLM/D). Using Filter, conditional formatting,
and pivot tables, prepare a short report that
answers each of the following questions and
illustrates the justification for your answers.

a. Which, if any, location should be closed?

b. Which, if any, travel consultants should be
downsized?

c. On which cruise lines should B&B focus its
sales efforts?

5. CREATE A LIST FOR A BOOKSTORE Suppose
that you’re the manager for your school’s
bookstore. Your task is to create a list in a
workbook that contains information about the
textbooks it sells. In addition to tracking price,
first author name, and publisher, identify five
other pieces of information for each textbook.
For this list, first provide a list definition
table. Second, enter some information for 20
textbooks. Third, illustrate the use of the basic
Filter function, the Custom Filter function,
conditional formatting, and pivot tables.
Finally, address how your bookstore might
be able to use this information to support its
decision-making tasks.

haa7685x_modD_D.1-D.20.indd 20haa7685x_modD_D.1-D.20.indd 20 12/15/11 8:11 PM12/15/11 8:11 PM