Management and Information System Problem Set

Maoxiaoying
xlmd_customer.xls
Home>Business & Finance homework help>Management homework help>Management and Information System Problem Set

Sheet1

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

NPV

Interest rate NPV
0.05
0.06
0.07
0.08
0.09

Sheet3