Business Statistics
Mike95DSCI_3710_Excel_Quiz_4_Data.xls
Data
Obs | Income1 | Income2 | Famlsize | Ownrent | Autodebt | Hpayrent | Groc | Loc |
1 | 36557 | 20610 | 4 | 0 | 15290 | 1339 | 278 | 0 |
2 | 27045 | 25490 | 5 | 0 | 14676 | 1175 | 220 | 0 |
3 | 38878 | 0 | 8 | 0 | 10317 | 1108 | 456 | 0 |
4 | 41448 | 0 | 2 | 1 | 9504 | 729 | 253 | 0 |
5 | 33136 | 25300 | 6 | 1 | 17802 | 875 | 344 | 0 |
6 | 44308 | 24559 | 2 | 1 | 20537 | 1282 | 326 | -1 |
7 | 31997 | 25419 | 4 | 1 | 11725 | 919 | 308 | 1 |
8 | 43437 | 0 | 6 | 1 | 12084 | 970 | 311 | 2 |
9 | 41625 | 22802 | 4 | 1 | 14863 | 945 | 305 | 0 |
10 | 40140 | 32158 | 5 | 0 | 15708 | 1470 | 432 | 2 |
11 | 31448 | 0 | 4 | 0 | 6160 | 985 | 259 | 1 |
12 | 44850 | 14878 | 6 | 1 | 16528 | 1211 | 333 | -1 |
13 | 29334 | 0 | 2 | 0 | 7979 | 300 | 114 | 0 |
14 | 36579 | 23304 | 5 | 0 | 15442 | 1234 | 342 | 0 |
15 | 26977 | 20265 | 1 | 1 | 13920 | 274 | 184 | 2 |
16 | 35050 | 0 | 2 | 0 | 10538 | 993 | 174 | 0 |
17 | 46469 | 0 | 4 | 1 | 11580 | 1055 | 234 | 2 |
18 | 38446 | 22976 | 4 | 1 | 16095 | 981 | 258 | 0 |
19 | 45135 | 24819 | 5 | 1 | 19338 | 776 | 209 | 0 |
20 | 52240 | 0 | 8 | 1 | 12967 | 1394 | 454 | 1 |
21 | 56264 | 0 | 1 | 1 | 15849 | 746 | 160 | 2 |
22 | 31536 | 0 | 7 | 0 | 6965 | 1519 | 419 | -1 |
23 | 36924 | 0 | 4 | 0 | 11799 | 690 | 184 | -1 |
24 | 45540 | 0 | 3 | 0 | 8307 | 854 | 232 | -1 |
25 | 28004 | 0 | 4 | 1 | 10336 | 1034 | 267 | 1 |
26 | 34971 | 0 | 4 | 1 | 15163 | 450 | 278 | 2 |
27 | 35327 | 0 | 6 | 0 | 6984 | 1057 | 347 | -1 |
28 | 55231 | 0 | 5 | 0 | 13523 | 1039 | 367 | 0 |
29 | 34969 | 22296 | 2 | 1 | 12752 | 593 | 254 | 1 |
30 | 35766 | 0 | 1 | 0 | 10175 | 376 | 103 | 0 |
31 | 35716 | 16419 | 5 | 1 | 10227 | 1073 | 208 | 2 |
32 | 32575 | 0 | 6 | 0 | 10550 | 1352 | 393 | 2 |
33 | 41154 | 0 | 1 | 0 | 6096 | 713 | 150 | 2 |
34 | 30909 | 0 | 2 | 1 | 12811 | 515 | 191 | -1 |
35 | 40450 | 0 | 4 | 0 | 9177 | 479 | 259 | -1 |
36 | 42236 | 15492 | 3 | 0 | 15556 | 1719 | 313 | 2 |
37 | 39602 | 22935 | 1 | 0 | 15197 | 639 | 140 | -1 |
38 | 24029 | 0 | 2 | 0 | 3651 | 834 | 265 | -1 |
39 | 28913 | 0 | 3 | 1 | 6628 | 674 | 273 | 2 |
40 | 32005 | 0 | 2 | 1 | 10740 | 770 | 196 | 1 |
41 | 31342 | 0 | 4 | 0 | 6040 | 502 | 212 | 0 |
42 | 38429 | 22218 | 2 | 1 | 17750 | 907 | 257 | 2 |
43 | 50319 | 0 | 4 | 1 | 13279 | 934 | 187 | 2 |
44 | 31862 | 13799 | 3 | 1 | 9958 | 790 | 243 | 1 |
45 | 29308 | 13975 | 6 | 1 | 11597 | 1414 | 356 | 2 |
46 | 38392 | 18192 | 2 | 1 | 10501 | 870 | 155 | -1 |
47 | 37146 | 0 | 6 | 1 | 8017 | 1145 | 284 | -1 |
48 | 40817 | 23313 | 4 | 1 | 15722 | 1129 | 246 | 2 |
49 | 41019 | 0 | 4 | 0 | 11958 | 958 | 200 | 2 |
50 | 40040 | 25261 | 1 | 0 | 16238 | 875 | 112 | 1 |
51 | 36804 | 20519 | 4 | 0 | 15693 | 1340 | 290 | -1 |
52 | 27033 | 25809 | 4 | 0 | 14649 | 1245 | 261 | 2 |
53 | 38861 | 0 | 10 | 0 | 9907 | 1180 | 596 | 0 |
54 | 41124 | 0 | 4 | 1 | 9711 | 675 | 341 | -1 |
55 | 32837 | 25304 | 5 | 0 | 18210 | 913 | 236 | -1 |
56 | 44243 | 24931 | 5 | 1 | 20602 | 1277 | 334 | 1 |
57 | 32116 | 25189 | 2 | 0 | 11973 | 963 | 390 | 2 |
58 | 43416 | 0 | 7 | 0 | 11882 | 899 | 223 | -1 |
59 | 41669 | 22817 | 3 | 1 | 15011 | 827 | 155 | -1 |
60 | 40407 | 32077 | 6 | 0 | 15329 | 1388 | 386 | 0 |
61 | 31147 | 0 | 4 | 0 | 5550 | 1011 | 165 | 0 |
62 | 44675 | 0 | 7 | 0 | 16936 | 1226 | 398 | 0 |
63 | 29445 | 0 | 3 | 1 | 8597 | 201 | 50 | -1 |
64 | 36841 | 23274 | 3 | 1 | 15391 | 1420 | 341 | 2 |
65 | 26867 | 0 | 1 | 0 | 13564 | 225 | 144 | 0 |
66 | 34782 | 0 | 3 | 0 | 10345 | 972 | 168 | 0 |
67 | 46381 | 0 | 3 | 0 | 11409 | 1224 | 210 | 0 |
68 | 38261 | 22711 | 7 | 0 | 16434 | 1009 | 307 | 2 |
69 | 45194 | 24467 | 7 | 0 | 19378 | 957 | 677 | 1 |
70 | 52465 | 0 | 8 | 0 | 12420 | 1504 | 482 | -1 |
71 | 55837 | 0 | 2 | 0 | 15990 | 665 | 193 | -1 |
72 | 30990 | 0 | 7 | 0 | 6698 | 1416 | 366 | 1 |
73 | 36748 | 0 | 4 | 0 | 12120 | 853 | 202 | 0 |
74 | 45582 | 0 | 2 | 0 | 8575 | 1008 | 217 | 2 |
75 | 28123 | 17998 | 5 | 0 | 9960 | 1027 | 294 | -1 |
76 | 34742 | 19100 | 5 | 0 | 14953 | 516 | 437 | -1 |
77 | 35370 | 0 | 6 | 0 | 6786 | 1028 | 326 | 0 |
78 | 55270 | 0 | 6 | 0 | 13284 | 1115 | 346 | 1 |
79 | 35389 | 22421 | 2 | 1 | 12638 | 660 | 237 | 1 |
80 | 35821 | 0 | 2 | 0 | 10068 | 284 | 179 | -1 |
81 | 35786 | 16557 | 5 | 0 | 10675 | 1072 | 356 | 1 |
82 | 32597 | 0 | 7 | 0 | 10432 | 1421 | 455 | 0 |
83 | 41172 | 0 | 1 | 0 | 6459 | 823 | 154 | 0 |
84 | 30620 | 0 | 3 | 1 | 12685 | 437 | 196 | 2 |
85 | 40369 | 0 | 4 | 0 | 9165 | 559 | 162 | 1 |
86 | 42289 | 15832 | 6 | 0 | 15152 | 1718 | 344 | 1 |
87 | 39343 | 23292 | 1 | 0 | 15137 | 687 | 87 | -1 |
88 | 23937 | 0 | 4 | 0 | 3444 | 1003 | 278 | 2 |
89 | 29025 | 0 | 3 | 1 | 7263 | 655 | 234 | 2 |
90 | 31807 | 0 | 4 | 1 | 10267 | 693 | 400 | 1 |
91 | 31540 | 0 | 4 | 1 | 5846 | 564 | 266 | 1 |
92 | 38302 | 22313 | 4 | 1 | 17748 | 904 | 295 | 1 |
93 | 50375 | 0 | 6 | 1 | 13274 | 954 | 456 | 1 |
94 | 31925 | 13705 | 3 | 0 | 8818 | 745 | 256 | -1 |
95 | 29371 | 14038 | 6 | 0 | 12020 | 1478 | 487 | -1 |
96 | 38463 | 17978 | 4 | 0 | 10496 | 901 | 118 | 1 |
97 | 37039 | 0 | 8 | 0 | 8203 | 1086 | 566 | 0 |
98 | 40895 | 23136 | 3 | 1 | 15598 | 1038 | 262 | 2 |
99 | 41161 | 0 | 4 | 0 | 12087 | 1133 | 225 | -1 |
100 | 39976 | 25391 | 3 | 0 | 16616 | 1072 | 235 | 2 |