Management and information system EXCEL homework

profilefanche7788
customerpurchasehistory.xlsx
Home>Business & Finance homework help>Management homework help>Management and information system EXCEL homework

Documentation

MGMT 4013 MIS
Fall 2014
Pivot Table Example
Dr. Troboy
Retail Marketing Campaign
Objective: Create business intelligence to inform marketing decisions.
What types of products should we promote in what parts of the city?
Method: Perform analysis and visualization of customer data via Pivot Tables.
Data: The Raw Data worksheet contains
* Limited data for a general retailer (think Walmart, Kmart, Sam's Club, Costco, etc.)
* A unique identifier.
* The part of the city in which the customer lives (text field).
* Whether the customer owns or rents their home (text field).
* How many people live in the customer's household (integer numeric field).
* The customer's annual income range (text field).
* The total amount the customer has spent with us for the time period covered (currency field).
* The number of purchases the customer has made with us for the time period covered (integer numeric field).
Hints: The Raw Data worksheet does not contain
* Data allowing us to estimate profit. We cannot tell how profitable each customer is to us.
We can only tell how much they represent to us in terms of total revenue and frequency of purchases.
* Geographic data. We don't know much about what is going on in each quadrant of the city.
Parts of the city may be industrial, rural, or contain a university.
Keep in mind that many renting college students rent and have low incomes now but may have a higher income later.
General background knowledge
* Always consider that you might have some bad data or outliers that might unduly influence statistics.
Think about how you can discover bad data and what you can do about any bad data that you find.
* Renters generally cannot make structural changes to their home.
* Household size may indicate the customer's life cycle position (single, married, living with roommates, has a family, is retired, etc.).
(Be thoughtful about your assumptions.)
* The income data is a categorical range. You cannot do arithmetic with this column. Sorting on it prove misleading if you are not careful.
* Consider what you can derive from the data. For example, you can calculate an average amount spent per perchase.
Results: Not complete. See notes in Pivot Table/Chart worksheets.

Raw Data

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

Calculated Data

CUST ID REGION RENT VS. OWN NUM HOUSEHOLD ANNUAL INCOME TOTAL PURCHASES NUM PURCHASES AVG/PURCHASE
1 North Rent 1 10K-25K $ 38 1 $ 38
2 South Own 4 100K+ $ 30 4 $ 8
3 North Rent 3 25K-50K $ 19 3 $ 6
4 West Own 5 25K-50K $ 21 6 $ 4
5 East Own 6 50K-100K $ 35 7 $ 5
6 South Own 2 10K-25K $ 27 5 $ 5
7 East Own 3 100K+ $ 26 3 $ 9
8 West Rent 4 25K-50K $ 25 6 $ 4
9 North Own 5 50K-100K $ 30 8 $ 4
10 West Rent 7 25K-50K $ 26 2 $ 13
11 North Own 1 50K-100K $ 21 4 $ 5
12 East Own 2 100K+ $ 29 9 $ 3
13 South Own 5 10K-25K $ 20 7 $ 3
14 South Own 4 25K-50K $ 27 10 $ 3
15 South Rent 3 50K-100K $ 19 2 $ 10
16 West Own 5 25K-50K $ 19 6 $ 3
17 North Own 6 50K-100K $ 129 5 $ 26
18 East Rent 2 10K-25K $ 99 7 $ 14
19 West Own 3 25K-50K $ 99 4 $ 25
20 North Rent 1 50K-100K $ 119 3 $ 40
21 East Own 4 50K-100K $ 149 2 $ 75
22 South Own 3 50K-100K $ 165 8 $ 21
23 West Rent 5 25K-50K $ 119 6 $ 20
24 North Rent 6 10K-25K $ 129 7 $ 18
25 East Rent 7 100K+ $ 165 5 $ 33
26 South Own 3 10K-25K $ 99 3 $ 33
27 West Rent 2 25K-50K $ 155 6 $ 26
28 North Own 4 50K-100K $ 115 8 $ 14
29 East Own 5 50K-100K $ 129 1 $ 129
30 South Rent 4 50K-100K $ 99 8 $ 12
31 West Own 2 25K-50K $ 169 6 $ 28
32 East Rent 3 25K-50K $ 40 4 $ 10
33 East Own 1 50K-100K $ 36 7 $ 5
34 North Own 6 100K+ $ 45 3 $ 15
35 North Own 5 10K-25K $ 29 1 $ 29
36 West Rent 4 100K+ $ 28 4 $ 7
37 East Rent 1 25K-50K $ 46 1 $ 46
38 South Rent 5 50K-100K $ 50 4 $ 13
39 East Rent 3 50K-100K $ 22 6 $ 4
40 West Own 6 50K-100K $ 20 9 $ 2
41 North Own 7 25K-50K $ 19 3 $ 6
42 East Own 3 50K-100K $ 31 1 $ 31
43 South Rent 2 50K-100K $ 30 10 $ 3
44 West Rent 4 25K-50K $ 18 3 $ 6
45 East Own 5 25K-50K $ 31 7 $ 4
46 South Own 3 10K-25K $ 35 6 $ 6
47 West Own 7 25K-50K $ 28 5 $ 6
48 East Rent 3 100K+ $ 29 8 $ 4
49 South Rent 2 10K-25K $ 35 6 $ 6
50 North Own 6 25K-50K $ 30 4 $ 8
51 South Own 5 50K-100K $ 38 7 $ 5
52 West Own 3 50K-100K $ 20 3 $ 7
53 North Rent 1 25K-50K $ 40 5 $ 8
54 East Rent 5 25K-50K $ 30 4 $ 8
55 South Own 6 25K-50K $ 40 8 $ 5
56 West Rent 3 10K-25K $ 62 7 $ 9
57 North Rent 4 100K+ $ 22 9 $ 2
58 East Rent 5 100K+ $ 25 1 $ 25
59 West Rent 7 10K-25K $ 27 4 $ 7
60 East Rent 2 25K-50K $ 22 7 $ 3
61 South Own 3 25K-50K $ 30 4 $ 8
62 East Own 1 25K-50K $ 31 3 $ 10
63 East Own 4 50K-100K $ 22 8 $ 3
64 South Rent 2 50K-100K $ 25 9 $ 3
65 West Own 3 25K-50K $ 24 3 $ 8
66 East Own 5 50K-100K $ 36 2 $ 18
67 North Rent 4 50K-100K $ 123 11 $ 11
68 North Rent 6 100K+ $ 19 2 $ 10
69 North Own 5 100K+ $ 23 6 $ 4
70 South Rent 7 100K+ $ 19 8 $ 2
71 West Rent 4 25K-50K $ 25 6 $ 4
72 West Rent 5 50K-100K $ 129 8 $ 16
73 North Own 3 50K-100K $ 119 9 $ 13
74 East Own 6 100K+ $ 109 3 $ 36
75 North Own 5 10K-25K $ 179 6 $ 30
76 East Rent 4 100K+ $ 145 5 $ 29
77 South Own 2 25K-50K $ 119 7 $ 17
78 North Rent 3 50K-100K $ 129 2 $ 65
79 East Own 4 10K-25K $ 189 4 $ 47
80 West Own 6 50K-100K $ 155 6 $ 26
81 North Rent 5 25K-50K $ 78 4 $ 20
82 East Own 4 25K-50K $ 61 5 $ 12
83 South Rent 3 25K-50K $ 97 7 $ 14
84 North Rent 2 50K-100K $ 63 2 $ 32
85 West Own 4 100K+ $ 39 3 $ 13
86 East Rent 6 50K-100K $ 95 1 $ 95
87 South Rent 4 25K-50K $ 86 7 $ 12
88 West Own 1 50K-100K $ 85 5 $ 17
89 East Own 2 50K-100K $ 59 7 $ 8
90 North Rent 3 100K+ $ 84 9 $ 9
91 North Own 2 100K+ $ 144 10 $ 14
92 West Rent 3 100K+ $ 26 1 $ 26
93 South Rent 7 25K-50K $ 31 1 $ 31
94 East Own 6 50K-100K $ 19 1 $ 19
95 South Rent 5 50K-100K $ 30 1 $ 30
96 West Rent 4 100K+ $ 29 11 $ 3
97 West Rent 5 10K-25K $ 25 2 $ 13
98 West Rent 6 100K+ $ 24 6 $ 4
99 East Rent 3 25K-50K $ 36 5 $ 7
100 North Own 4 50K-100K $ 29 7 $ 4
101 South Own 2 10K-25K $ 99 9 $ 11
102 West Rent 1 50K-100K $ 169 3 $ 56
103 East Own 3 10K-25K $ 179 1 $ 179
104 North Rent 4 100K+ $ 119 7 $ 17
105 South Own 5 25K-50K $ 99 4 $ 25
106 West Rent 4 50K-100K $ 179 7 $ 26
107 East Own 6 10K-25K $ 185 6 $ 31
108 North Rent 3 50K-100K $ 179 8 $ 22
109 South Rent 4 25K-50K $ 145 9 $ 16
110 West Rent 5 25K-50K $ 119 3 $ 40
111 North Own 7 25K-50K $ 99 2 $ 50
112 North Own 2 50K-100K $ 155 5 $ 31
113 East Own 3 100K+ $ 119 4 $ 30
114 North Rent 5 50K-100K $ 149 7 $ 21
115 East Rent 3 25K-50K $ 56 5 $ 11
116 North Rent 2 50K-100K $ 50 6 $ 8
117 West Own 4 50K-100K $ 86 3 $ 29
118 South Rent 2 100K+ $ 45 2 $ 23
119 East Rent 1 100K+ $ 95 6 $ 16
120 West Rent 3 100K+ $ 86 8 $ 11
121 South Rent 2 25K-50K $ 97 11 $ 9
122 East Rent 4 50K-100K $ 40 8 $ 5
123 North Rent 5 50K-100K $ 50 5 $ 10
124 East Own 6 100K+ $ 59 3 $ 20
125 North Rent 3 10K-25K $ 75 4 $ 19
126 South Rent 4 50K-100K $ 68 3 $ 23
127 West Rent 6 50K-100K $ 63 1 $ 63
128 North Own 2 25K-50K $ 56 10 $ 6
129 East Own 4 25K-50K $ 86 2 $ 43
130 North Rent 6 50K-100K $ 45 6 $ 8
131 West Own 3 100K+ $ 78 8 $ 10
132 South Own 4 10K-25K $ 68 7 $ 10
133 East Rent 7 100K+ $ 95 6 $ 16
134 North Own 4 25K-50K $ 95 4 $ 24
135 East Rent 5 50K-100K $ 39 7 $ 6
136 East Own 6 50K-100K $ 56 8 $ 7
137 North Own 2 50K-100K $ 31 9 $ 3
138 South Rent 3 25K-50K $ 29 6 $ 5
139 West Rent 4 50K-100K $ 41 7 $ 6
140 East Rent 5 50K-100K $ 62 4 $ 16
141 North Rent 1 25K-50K $ 51 3 $ 17
142 South Own 2 25K-50K $ 37 2 $ 19
143 West Own 3 10K-25K $ 19 6 $ 3
144 East Rent 4 25K-50K $ 38 5 $ 8
145 North Rent 5 100K+ $ 56 7 $ 8
146 East Own 4 100K+ $ 41 5 $ 8
147 West Own 3 25K-50K $ 51 8 $ 6
148 North Rent 6 50K-100K $ 19 4 $ 5
149 East Rent 2 10K-25K $ 29 3 $ 10
150 North Own 4 50K-100K $ 41 5 $ 8
151 East Own 3 25K-50K $ 19 6 $ 3
152 West Own 3 25K-50K $ 30 7 $ 4
153 North Own 5 25K-50K $ 19 8 $ 2
154 South Rent 4 50K-100K $ 21 3 $ 7
155 East Own 6 100K+ $ 23 2 $ 12
156 North Own 7 50K-100K $ 29 5 $ 6
157 West Own 2 25K-50K $ 18 2 $ 9
158 East Own 3 50K-100K $ 26 5 $ 5
159 South Own 1 50K-100K $ 20 1 $ 20
160 West Rent 2 100K+ $ 76 11 $ 7
161 East Own 4 100K+ $ 40 4 $ 10
162 South Own 2 100K+ $ 41 3 $ 14
163 North Own 4 25K-50K $ 24 7 $ 3
164 East Rent 5 50K-100K $ 26 5 $ 5
165 West Rent 6 50K-100K $ 25 8 $ 3
166 South Own 4 100K+ $ 26 6 $ 4
167 East Own 2 10K-25K $ 23 8 $ 3
168 North Own 4 50K-100K $ 27 5 $ 5
169 East Own 3 50K-100K $ 25 8 $ 3
170 South Rent 5 25K-50K $ 34 10 $ 3
171 West Rent 4 25K-50K $ 24 7 $ 3
172 West Rent 6 50K-100K $ 21 9 $ 2
173 East Own 4 100K+ $ 40 8 $ 5
174 South Rent 3 50K-100K $ 19 1 $ 19
175 West Own 1 100K+ $ 30 11 $ 3
176 East Rent 2 100K+ $ 35 10 $ 4
177 North Own 4 100K+ $ 24 1 $ 24
178 East Own 7 25K-50K $ 26 4 $ 7
179 South Own 4 50K-100K $ 15 1 $ 15
180 East Rent 6 50K-100K $ 18 3 $ 6
181 North Rent 3 100K+ $ 28 1 $ 28
182 South Own 7 10K-25K $ 24 4 $ 6
183 West Rent 2 100K+ $ 30 5 $ 6
184 East Own 1 25K-50K $ 30 4 $ 8
185 West Own 4 50K-100K $ 23 7 $ 3
186 North Own 5 10K-25K $ 28 5 $ 6
187 East Rent 3 50K-100K $ 21 6 $ 4
188 North Own 2 25K-50K $ 28 4 $ 7
189 East Rent 4 25K-50K $ 22 2 $ 11
190 West Own 5 25K-50K $ 28 6 $ 5
191 North Own 2 50K-100K $ 30 8 $ 4
192 South Own 1 100K+ $ 28 9 $ 3
193 East Own 4 50K-100K $ 25 10 $ 3
194 North Rent 2 25K-50K $ 29 3 $ 10
195 West Own 5 50K-100K $ 28 6 $ 5
196 East Own 3 50K-100K $ 30 5 $ 6
197 South Rent 6 100K+ $ 19 4 $ 5
198 West Own 5 100K+ $ 30 6 $ 5
199 East Rent 7 100K+ $ 149 8 $ 19
200 South Own 4 25K-50K $ 155 7 $ 22
201 North Own 5 50K-100K $ 115 4 $ 29
202 East Rent 6 50K-100K $ 119 5 $ 24
203 West Rent 3 100K+ $ 99 7 $ 14
204 South Rent 2 10K-25K $ 119 8 $ 15
205 East Own 4 100K+ $ 149 9 $ 17
206 North Rent 5 25K-50K $ 145 11 $ 13
207 East Own 3 25K-50K $ 119 8 $ 15
208 South Own 5 50K-100K $ 129 5 $ 26
209 North Rent 4 50K-100K $ 99 7 $ 14
210 East Own 6 50K-100K $ 119 8 $ 15
211 South Rent 4 100K+ $ 185 9 $ 21
212 West Own 5 10K-25K $ 119 5 $ 24
213 West Own 6 50K-100K $ 99 2 $ 50
214 East Own 7 50K-100K $ 109 6 $ 18
215 South Rent 1 25K-50K $ 179 8 $ 22
216 West Rent 3 25K-50K $ 169 6 $ 28
217 East Rent 2 50K-100K $ 179 9 $ 20
218 North Rent 5 10K-25K $ 145 7 $ 21
219 East Own 4 100K+ $ 119 6 $ 20
220 South Own 6 100K+ $ 165 3 $ 55
221 East Own 7 10K-25K $ 129 2 $ 65
222 North Rent 3 100K+ $ 159 11 $ 14
223 South Rent 2 50K-100K $ 37 7 $ 5
224 West Own 4 50K-100K $ 55 5 $ 11
225 East Own 5 25K-50K $ 63 7 $ 9
226 West Own 4 25K-50K $ 56 8 $ 7
227 North Rent 3 10K-25K $ 67 6 $ 11
228 East Rent 4 50K-100K $ 60 8 $ 8
229 North Own 6 25K-50K $ 50 9 $ 6
230 East Own 5 50K-100K $ 49 3 $ 16
231 West Own 4 100K+ $ 56 4 $ 14
232 North Rent 2 50K-100K $ 60 7 $ 9
233 South Rent 3 50K-100K $ 59 2 $ 30
234 East Own 1 50K-100K $ 59 8 $ 7
235 North Rent 7 50K-100K $ 60 5 $ 12
236 West Rent 3 50K-100K $ 68 7 $ 10
237 South Rent 4 25K-50K $ 84 9 $ 9
238 South Rent 2 25K-50K $ 69 2 $ 35
239 West Rent 5 100K+ $ 97 5 $ 19
240 North Own 3 10K-25K $ 61 4 $ 15
241 East Own 4 100K+ $ 75 6 $ 13
242 West Own 5 100K+ $ 76 11 $ 7
243 North Rent 6 100K+ $ 98 8 $ 12
244 East Own 4 25K-50K $ 95 5 $ 19
245 South Own 5 25K-50K $ 59 7 $ 8
246 West Rent 6 50K-100K $ 44 4 $ 11
247 North Rent 7 50K-100K $ 97 3 $ 32
248 East Own 4 100K+ $ 68 6 $ 11
249 South Rent 3 25K-50K $ 145 10 $ 15
250 West Rent 2 50K-100K $ 119 3 $ 40
251 North Rent 1 10K-25K $ 129 6 $ 22
252 East Own 5 50K-100K $ 99 8 $ 12
253 South Own 4 25K-50K $ 119 6 $ 20
254 West Own 6 25K-50K $ 185 8 $ 23
255 East Rent 3 25K-50K $ 119 10 $ 12
256 East Own 2 50K-100K $ 99 3 $ 33
257 North Rent 1 100K+ $ 60 6 $ 10
258 North Own 5 50K-100K $ 50 5 $ 10
259 West Own 4 25K-50K $ 49 8 $ 6
260 West Rent 6 50K-100K $ 56 4 $ 14
261 East Own 7 50K-100K $ 60 7 $ 9
262 North Rent 3 100K+ $ 59 3 $ 20
263 East Rent 2 100K+ $ 59 2 $ 30
264 South Own 4 100K+ $ 60 6 $ 10
265 East Rent 5 25K-50K $ 68 5 $ 14
266 North Rent 3 50K-100K $ 84 8 $ 11
267 South Own 2 50K-100K $ 69 9 $ 8
268 West Own 4 100K+ $ 97 3 $ 32
269 East Rent 3 10K-25K $ 61 2 $ 31
270 West Own 4 50K-100K $ 75 6 $ 13
271 North Rent 3 50K-100K $ 76 5 $ 15
272 East Rent 4 25K-50K $ 98 7 $ 14
273 North Own 5 25K-50K $ 95 9 $ 11
274 East Rent 4 50K-100K $ 59 4 $ 15
275 West Rent 6 100K+ $ 44 6 $ 7
276 North Rent 5 50K-100K $ 97 8 $ 12
277 South Rent 7 100K+ $ 68 7 $ 10
278 East Rent 1 100K+ $ 145 1 $ 145
279 North Own 2 100K+ $ 85 10 $ 9
280 West Own 3 25K-50K $ 59 3 $ 20
281 South Rent 4 50K-100K $ 84 7 $ 12
282 South Own 3 50K-100K $ 28 5 $ 6
283 South Rent 5 100K+ $ 26 8 $ 3
284 East Own 3 10K-25K $ 31 9 $ 3
285 North Rent 3 100K+ $ 19 3 $ 6
286 West Own 2 25K-50K $ 30 2 $ 15
287 East Rent 4 50K-100K $ 29 11 $ 3
288 South Rent 5 10K-25K $ 25 6 $ 4
289 West Rent 6 50K-100K $ 24 3 $ 8
290 East Own 5 25K-50K $ 36 6 $ 6
291 South Own 4 25K-50K $ 29 7 $ 4
292 North Own 3 25K-50K $ 99 9 $ 11
293 East Rent 5 50K-100K $ 169 8 $ 21
294 West Rent 4 100K+ $ 179 3 $ 60
295 South Rent 6 50K-100K $ 119 5 $ 24
296 East Own 4 25K-50K $ 99 4 $ 25
297 North Rent 6 50K-100K $ 56 6 $ 9
298 East Rent 1 50K-100K $ 50 11 $ 5
299 South Rent 2 100K+ $ 86 10 $ 9
300 North Rent 3 100K+ $ 45 3 $ 15
301 East Rent 4 100K+ $ 95 2 $ 48
302 South Rent 7 25K-50K $ 86 10 $ 9
303 West Own 4 50K-100K $ 97 11 $ 9
304 West Rent 3 50K-100K $ 40 7 $ 6
305 East Rent 1 100K+ $ 50 5 $ 10
306 South Rent 4 10K-25K $ 59 9 $ 7
307 West Own 2 100K+ $ 75 4 $ 19
308 East Own 5 25K-50K $ 68 3 $ 23
309 North Rent 3 25K-50K $ 26 2 $ 13
310 East Own 6 50K-100K $ 15 6 $ 3
311 South Own 4 50K-100K $ 18 8 $ 2
312 East Rent 7 50K-100K $ 28 6 $ 5
313 North Own 3 100K+ $ 24 8 $ 3
314 South Rent 2 10K-25K $ 30 9 $ 3
315 West Own 4 50K-100K $ 30 10 $ 3
316 East Own 5 50K-100K $ 23 3 $ 8
317 West Rent 3 25K-50K $ 28 2 $ 14
318 North Rent 1 25K-50K $ 21 6 $ 4
319 East Rent 4 50K-100K $ 28 5 $ 6
320 North Rent 3 10K-25K $ 22 8 $ 3
321 East Own 5 100K+ $ 28 7 $ 4
322 West Own 6 100K+ $ 30 9 $ 3
323 North Rent 4 10K-25K $ 28 4 $ 7
324 South Rent 2 100K+ $ 25 6 $ 4
325 East Own 5 50K-100K $ 29 3 $ 10
326 North Own 3 50K-100K $ 28 5 $ 6
327 West Rent 5 25K-50K $ 30 3 $ 10
328 South Rent 6 25K-50K $ 19 6 $ 3
329 South Own 4 10K-25K $ 30 5 $ 6
330 West Own 3 50K-100K $ 149 7 $ 21
331 North Own 5 25K-50K $ 155 9 $ 17
332 East Own 6 50K-100K $ 115 4 $ 29
333 West Rent 4 100K+ $ 39 6 $ 7
334 North Own 6 50K-100K $ 95 8 $ 12
335 East Own 4 50K-100K $ 86 7 $ 12
336 South Own 7 50K-100K $ 85 1 $ 85
337 West Own 4 50K-100K $ 59 10 $ 6
338 North Own 3 50K-100K $ 84 3 $ 28
339 East Rent 1 25K-50K $ 28 7 $ 4
340 South Own 2 25K-50K $ 26 5 $ 5
341 West Own 5 100K+ $ 31 8 $ 4
342 North Own 3 10K-25K $ 19 9 $ 2
343 East Rent 4 100K+ $ 30 3 $ 10
344 South Rent 6 100K+ $ 29 2 $ 15
345 West Own 5 100K+ $ 25 11 $ 2
346 East Own 3 25K-50K $ 24 6 $ 4
347 East Own 2 25K-50K $ 36 3 $ 12
348 North Own 1 50K-100K $ 29 6 $ 5
349 North Rent 6 50K-100K $ 99 7 $ 14
350 West Rent 7 50K-100K $ 169 9 $ 19
351 West Rent 2 50K-100K $ 179 8 $ 22
352 East Own 1 10K-25K $ 119 3 $ 40
353 North Rent 2 100K+ $ 99 5 $ 20
354 East Own 3 10K-25K $ 179 4 $ 45
355 South Own 2 100K+ $ 185 6 $ 31
356 East Rent 1 50K-100K $ 179 11 $ 16
357 North Own 3 50K-100K $ 145 10 $ 15
358 South Own 4 25K-50K $ 119 3 $ 40
359 West Own 6 25K-50K $ 99 2 $ 50
360 East Rent 5 10K-25K $ 155 10 $ 16
361 West Rent 4 50K-100K $ 119 11 $ 11
362 North Own 3 25K-50K $ 149 7 $ 21
363 East Own 5 50K-100K $ 56 5 $ 11
364 North Own 6 100K+ $ 50 9 $ 6
365 East Own 7 50K-100K $ 86 4 $ 22
366 North Rent 5 50K-100K $ 45 3 $ 15
367 South Rent 6 50K-100K $ 95 2 $ 48
368 North Rent 3 50K-100K $ 86 6 $ 14
369 West Own 4 50K-100K $ 97 8 $ 12
370 East Rent 5 25K-50K $ 23 6 $ 4
371 South Own 2 25K-50K $ 29 8 $ 4
372 East Rent 3 100K+ $ 18 9 $ 2
373 West Own 6 10K-25K $ 26 10 $ 3
374 North Own 2 100K+ $ 20 3 $ 7
375 West Own 5 100K+ $ 15 2 $ 8
376 North Rent 4 100K+ $ 40 6 $ 7
377 East Rent 1 25K-50K $ 41 5 $ 8
378 South Own 4 25K-50K $ 24 8 $ 3
379 South Rent 3 50K-100K $ 26 7 $ 4
380 South Own 5 10K-25K $ 25 9 $ 3
381 West Own 6 25K-50K $ 26 4 $ 7
382 North Own 4 50K-100K $ 23 6 $ 4
383 East Rent 2 50K-100K $ 27 7 $ 4
384 West Own 5 25K-50K $ 25 5 $ 5
385 North Rent 3 25K-50K $ 18 3 $ 6
386 East Own 5 25K-50K $ 24 6 $ 4
387 South Own 6 10K-25K $ 21 8 $ 3
388 West Own 4 100K+ $ 40 2 $ 20
389 North Own 3 100K+ $ 19 4 $ 5
390 South Rent 5 10K-25K $ 30 9 $ 3
391 West Own 6 25K-50K $ 35 7 $ 5
392 East Own 4 25K-50K $ 24 10 $ 2
393 East Rent 6 25K-50K $ 26 2 $ 13
394 North Own 4 50K-100K $ 15 6 $ 3
395 North Rent 7 50K-100K $ 18 5 $ 4
396 West Own 4 25K-50K $ 28 7 $ 4
397 West Own 3 50K-100K $ 24 4 $ 6
398 East Rent 1 50K-100K $ 30 3 $ 10
399 North Rent 2 100K+ $ 30 2 $ 15
400 East Rent 5 25K-50K $ 23 8 $ 3
401 South Own 3 25K-50K $ 28 6 $ 5
402 East Rent 4 10K-25K $ 21 7 $ 3
403 North Own 6 25K-50K $ 28 5 $ 6
404 South Own 5 100K+ $ 22 3 $ 7
405 West Rent 3 50K-100K $ 28 6 $ 5
406 East Own 2 50K-100K $ 30 8 $ 4
407 West Rent 1 25K-50K $ 28 1 $ 28
408 North Own 6 25K-50K $ 25 8 $ 3
409 East Own 7 50K-100K $ 29 6 $ 5
410 North Rent 2 50K-100K $ 28 4 $ 7
411 East Rent 1 25K-50K $ 30 7 $ 4
412 North Own 2 50K-100K $ 19 3 $ 6
413 South Own 3 50K-100K $ 30 1 $ 30
414 North Own 2 25K-50K $ 149 4 $ 37
415 West Own 1 50K-100K $ 155 1 $ 155
416 East Rent 3 10K-25K $ 115 4 $ 29
417 South Own 4 100K+ $ 119 6 $ 20
418 East Own 6 50K-100K $ 99 5 $ 20
419 West Own 5 50K-100K $ 119 3 $ 40
420 North Own 4 25K-50K $ 149 7 $ 21
421 West Own 3 25K-50K $ 145 6 $ 24
422 North Rent 5 25K-50K $ 119 8 $ 15
423 East Own 6 10K-25K $ 129 9 $ 14
424 West Own 7 100K+ $ 99 10 $ 10
425 North Own 5 100K+ $ 119 2 $ 60
426 East Rent 6 10K-25K $ 185 6 $ 31
427 South Rent 3 25K-50K $ 119 4 $ 30
428 West Own 4 25K-50K $ 99 7 $ 14
429 North Own 5 25K-50K $ 109 5 $ 22
430 East Own 2 50K-100K $ 179 8 $ 22
431 South Own 3 50K-100K $ 169 9 $ 19
432 West Rent 5 25K-50K $ 179 2 $ 90
433 North Rent 4 50K-100K $ 145 5 $ 29
434 East Rent 6 50K-100K $ 119 4 $ 30
435 South Own 7 100K+ $ 165 3 $ 55
436 West Rent 2 25K-50K $ 129 11 $ 12
437 East Own 3 25K-50K $ 159 7 $ 23
438 East Own 1 10K-25K $ 37 4 $ 9
439 North Rent 3 25K-50K $ 55 6 $ 9
440 North Own 5 25K-50K $ 63 5 $ 13
441 West Own 4 25K-50K $ 56 9 $ 6
442 West Own 6 50K-100K $ 67 2 $ 34
443 East Rent 7 50K-100K $ 60 5 $ 12
444 North Rent 2 50K-100K $ 50 3 $ 17
445 East Own 3 25K-50K $ 49 6 $ 8
446 South Own 4 10K-25K $ 56 8 $ 7
447 East Own 5 25K-50K $ 60 4 $ 15
448 North Own 3 100K+ $ 59 7 $ 8
449 South Rent 4 10K-25K $ 59 5 $ 12
450 West Rent 1 25K-50K $ 60 1 $ 60
451 East Rent 3 50K-100K $ 68 10 $ 7
452 South Own 4 50K-100K $ 84 11 $ 8
453 North Rent 5 25K-50K $ 69 11 $ 6
454 West Own 6 25K-50K $ 97 11 $ 9
455 East Rent 7 50K-100K $ 61 3 $ 20
456 South Own 6 10K-25K $ 75 6 $ 13
457 East Own 7 100K+ $ 76 4 $ 19
458 West Own 4 100K+ $ 98 7 $ 14
459 North Rent 3 100K+ $ 95 9 $ 11
460 West Rent 5 50K-100K $ 59 3 $ 20
461 North Own 2 50K-100K $ 44 2 $ 22
462 East Rent 3 100K+ $ 97 6 $ 16
463 West Own 4 10K-25K $ 68 5 $ 14
464 North Own 6 100K+ $ 145 8 $ 18
465 East Own 4 25K-50K $ 119 7 $ 17
466 South Rent 5 50K-100K $ 129 2 $ 65
467 West Own 3 10K-25K $ 99 4 $ 25
468 North Rent 2 50K-100K $ 119 3 $ 40
469 North Own 6 10K-25K $ 185 6 $ 31
470 East Own 3 100K+ $ 119 9 $ 13
471 West Own 1 25K-50K $ 99 10 $ 10
472 South Own 4 50K-100K $ 60 11 $ 5
473 East Rent 3 10K-25K $ 50 4 $ 13
474 West Rent 5 50K-100K $ 49 2 $ 25
475 South Own 6 25K-50K $ 56 1 $ 56
476 East Own 3 25K-50K $ 60 5 $ 12
477 North Own 2 25K-50K $ 59 4 $ 15
478 East Own 4 50K-100K $ 59 7 $ 8
479 North Rent 5 100K+ $ 60 8 $ 8
480 West Rent 7 50K-100K $ 68 9 $ 8
481 East Rent 2 25K-50K $ 84 1 $ 84
482 West Own 1 50K-100K $ 69 7 $ 10
483 South Rent 2 50K-100K $ 97 4 $ 24
484 North Own 1 25K-50K $ 61 6 $ 10
485 East Rent 3 50K-100K $ 75 5 $ 15
486 East Own 6 50K-100K $ 76 9 $ 8
487 West Own 4 50K-100K $ 98 2 $ 49

PurchasesByRegionPivotTable

Average of TOTAL PURCHASES The average purchase analysis shows that the North region has the highest average purchase.
REGION Total We might get more bang for our buck by advertising in this region.
South $65 The south region remained the lowest area in terms of potential revenue.
West $69
East $69
North $70
Grand Total $69
Copy and paste as graphic image the Total Purchases by Region chart.
(The graphic image is not interactive and thereby freezes that analysis chart.)

Average Purchases by Region

Total South West East North 65.428571428571431 68.870689655172413 69.141891891891888 70.096000000000004

PurchaseByRentVsOwn

Count of TOTAL PURCHASES Our overall total purchases (sum) shows we had more revenue from those who own their own home.
RENT VS. OWN Total But the average purchase amount was higher for renters.
Own $261 So, we need to check on how many are in each category (do a count).
Rent $226 That chart (on the right) shows that although the highest average purchase comes fom renters,
Grand Total $487 we actually get a lot more revenue from home-owners.
Maybe we need to focus our marketing on home-owners to increase revenue.
Or maybe we want to expand our market share and target the renters.
That strategy might also expand our revenue significantly.
Pasted graphic image.
Pasted graphic image.

Count of Total Purchases

Total Own Rent 261 226

PurchasesByIncome

Count of TOTAL PURCHASES Most of our customers are from the 50K-100K group, followed by the 25K-50K group.
ANNUAL INCOME Total We generate most of our income from these two groups.
10K-25K 59 The highest average purchase, however, comes from the 10K-25K group.
100K+ 106 We just don't have very many of them making purchases in general.
25K-50K 143 Maybe we should expand our target market in this direction.
50K-100K 179 We need to see where each group generally lives (see next Pivot Table/Chart).
Grand Total 487
Pasted graphic image
Pasted graphic image

Count of Customers by Income Group

Total 10K-25K 100K+ 25K-50K 50K-100K 59 106 143 179

CountIncomeByRegion

Count of TOTAL PURCHASES REGION
ANNUAL INCOME East North South West Grand Total
100K+ 31 29 19 27 106
10K-25K 18 14 19 8 59
25K-50K 40 33 30 40 143
50K-100K 59 49 30 41 179
Grand Total 148 125 98 116 487
The 10K-25K group lives mostly in the East and South region.
Very few of them live in the west
The 50K-100K group lives mostly in the East and North regions.
The 25K-50K group lives mostly in the East and West regions.
Looks like we have a lot of customers in the East region.
We could advertise here to consolidate and build customer relationships.
Or we could advertise elsewhere to expand our target market.
East 100K+ 10K-25K 25K-50K 50K-100K 31 18 40 59 North 100K+ 10K-25K 25K-50K 50K-100K 29 14 33 49 South 100K+ 10K-25K 25K-50K 50K-100K 19 19 30 30 West 100K+ 10K-25K 25K-50K 50K-100K 27 8 40 41