lab6

profileKOPUO
DigitalMappingLab6ExcelData.xls
Home>Computer Science homework help>lab6

Data

LON LAT COMMUTE GROWUP WEALTH PHILLIES MINUTES MILES
-75.147479 39.9725 1 1 2 4 10 15
-75.049661 40.0216 3 3 3 4 60 26
-75.161181 39.9699 1 2 2 2 20 7
-75.168795 39.9705 1 3 3 5 10 10
-75.172126 39.9628 1 2 3 3 10 30
-75.172426 39.9485 1 2 3 3 10 30
-75.149347 40.0008 3 2 4 5 8 15
-75.166688 39.9149 1 2 3 5 8 15
-75.150309 39.9384 1 3 3 1 4 600
-75.159009 40.0442 1 3 2 1 12 45
-75.162933 39.9696 1 3 4 1 8 135
-75.222919 39.9544 1 3 5 5 15 37
-75.152072 40.0000 1 3 3 3 5 50
-75.183398 39.9119 1 2 4 2 7 27
-75.188429 39.9381 1 2 3 3 5 24
-75.185377 39.9879 1 3 3 1 5 275
-75.232999 40.0455 1 3 3 4 1 85
-75.199253 39.9584 1 2 4 3 10 12
-75.009211 40.1000 2 3 5 1 10 90
-75.156383 40.0503 2 1 5 5 32 13
-75.15144 40.0610 1 3 2 1 5 35
-75.155166 40.0051 1 3 3 1 3 36
-75.173486 39.9330 1 2 3 4 8 60
-75.164579 39.9456 1 3 3 3 7 100
-75.159318 39.9608 1 2 3 3 10 60
-75.209011 40.0647 1 3 4 1 10 350
-75.186544 39.9852 1 3 3 3 7 2
-75.159175 39.9514 1 2 3 2 5 30
-75.209042 39.9642 1 3 3 1 30 100
-75.179603 39.9151 2 3 3 4 90 50
-75.232458 39.9465 1 2 2 1 7 20
-75.129351 39.9810 1 3 3 3 5 70
-75.180881 39.9311 3 1 4 4 30 10
-75.131947 40.0285 3 2 4 1 60 30
-75.159691 39.9569 1 3 2 2 10 180
-75.226308 39.9518 2 2 2 5 5 25
-75.12638 39.9834 1 2 3 4 5 50
-75.133215 39.9695 1 2 2 1 15 37
-75.03066 40.0414 1 3 3 1 5 94
-75.137571 39.9774 3 1 3 2 30 8
-75.12468 40.0005 1 1 4 3 7 4
-75.143725 39.9516 3 3 1 1 25 4
-75.218767 40.0278 1 3 3 1 7 90
-75.159002 39.9200 2 2 2 4 40 12
-75.139278 40.0062 1 2 3 5 10 25
-75.084643 40.0666 1 3 3 5 5 30
-75.073254 40.0442 1 1 3 2 8 20
-75.137786 39.9638 1 3 3 3 7 100
-75.253563 39.9798 1 2 4 4 8 25
-75.167782 39.9396 1 3 4 2 5 120
-75.186185 40.0629 1 2 2 3 5 20
-75.205684 39.9603 1 3 4 3 5 60
-75.127004 39.9792 1 3 2 4 5 100
-75.162854 39.9849 1 3 4 1 5 50
-75.172839 39.9419 1 2 1 3 10 20
-75.011648 40.1330 1 3 3 1 15 80
-75.031322 40.1136 1 3 3 2 6 100
-75.155829 39.9214 2 3 3 1 8 395
-75.157793 39.9845 1 2 4 5 10 29
-75.158536 39.9293 1 2 4 3 4 29
-75.152478 40.0602 1 3 4 1 3 81
-75.145258 39.9509 1 1 3 2 10 20
-75.014757 40.0570 1 3 3 1 15 60
-75.140534 39.9829 1 3 5 3 10 75
-75.125097 40.0205 1 2 3 5 5 30
-75.165968 39.9648 2 2 3 2 5 100
-75.158671 39.9335 1 3 3 5 5 30
-75.126212 39.9892 1 3 3 2 7 55
-75.137056 39.9774 3 1 4 2 60 15
-75.092196 39.9901 1 2 2 1 10 35
-75.182351 40.0391 1 2 4 3 8 60
(-75.14569 39.9482 3 3 1 1 15 200
-75.153909 39.9623 1 3 3 1 8 75
-75.147912 40.0176 1 2 3 5 7 20
-75.166055 39.9646 3 2 1 1 50 30
-75.150979 39.9301 1 2 3 4 4 30
-75.228739 40.0413 1 1 5 5 10 20
-75.035832 40.0281 1 3 3 5 5 50
-75.174856 39.9493 1 2 3 4 10 30
-75.137648 39.9824 1 3 3 1 10 70
-75.165571 40.0282 2 3 2 1 5 60
-75.166798 39.9268 1 2 2 2 10 75
-75.167192 39.9797 3 2 4 2 40 50
-75.166679 39.9482 3 2 5 5 1 50
-75.230216 39.9218 1 3 4 4 5 150
-75.168529 39.9179 1 3 4 5 15 100
-75.182491 39.9802 1 3 3 3 11 30
-75.110322 40.0180 1 2 4 5 10 30
-75.181342 39.9776 1 2 3 4 12 33
-75.100802 40.0431 1 2 4 5 10 40
-75.158821 39.9632 1 3 3 3 5 100
-75.024463 40.0398 3 1 3 5 40 35
-75.164034 40.0000 1 3 1 5 5 15
-75.160347 39.9780 1 2 2 5 15 45
-74.963661 40.1006 2 1 5 3 30 15
-75.155939 39.9559 1 2 2 2 8 50
-75.095917 40.0514 1 3 3 2 3 28
-75.049491 40.0420 1 2 5 5 12 60
-75.114092 39.9782 1 2 2 2 20 30
-75.17361 39.9333 3 2 2 5 15 30
-75.046744 40.0261 3 2 4 5 10 33
-75.130494 39.9790 3 3 5 5 5 40
-75.175115 39.9394 3 3 4 5 5 100
-75.194533 39.9566 3 3 2 5 5 35
-75.234642 39.9614 3 1 3 5 7 15
-75.181151 40.0304 2 1 2 5 60 45
-75.159449 39.9473 1 3 1 5 10 15
-75.21577 39.9489 1 3 2 5 8 50
-75.174696 39.9715 2 3 3 5 15 28
-75.133893 40.0196 1 3 4 5 5 60
-75.171889 39.9699 2 1 1 5 30 50
-75.178452 39.9350 1 1 3 5 7 50
-75.176006 39.9395 2 2 2 5 25 150
-75.171797 39.9343 1 1 3 5 7 100
-75.168014 39.9504 1 2 4 5 40 30
-75.166589 39.9202 2 3 5 5 10 30
-74.972546 40.0796 3 1 1 5 5 33
-75.173958 39.9407 3 2 2 5 8 40
-75.145106 39.9581 3 2 3 5 7 100
-75.052769 40.0588 3 3 4 5 8 35
-75.176232 40.0413 3 1 5 5 5 15
-75.178103 39.9418 3 2 4 5 5 45
-75.156383 39.9995 3 3 3 5 5 24.5
-75.172826 39.9514 3 1 2 5 5 17
-75.192527 39.9475 3 1 1 5 7 9.5
-75.202481 40.0710 3 1 2 5 60 60
-75.145291 39.9416 3 1 3 5 10 75
-75.161567 39.9230 1 1 2 5 8 50
-75.148125 39.9344 1 1 1 5 60 50
-75.130131 40.0397 1 2 2 5 20 150
-75.142725 39.9649 1 2 3 5 10 100
-75.069542 39.9996 1 2 4 3 10 30
-75.150517 39.9374 1 2 3 3 10 30
-75.162598 39.9083 1 2 2 3 8 33
-75.144122 39.9772 1 2 3 3 8 40
-75.236298 40.0563 1 2 4 3 4 100
-75.145988 40.0281 1 2 5 3 12 57
-75.140748 39.9668 1 2 3 3 8 56
-75.178929 39.9398 1 3 2 3 15 54
-75.16853 39.9686 1 3 2 3 5 52
-75.067281 40.0515 1 3 1 3 7 51
-75.180904 40.0286 1 3 2 3 5 7
-75.170618 40.0658 1 3 5 3 5 10
-75.239929 40.0695 2 3 5 3 8 30
-75.157782 39.9359 2 3 4 3 15 30
-75.127718 40.0041 2 3 4 3 5 15
-75.163479 39.9690 2 1 4 3 30 15
-75.144494 39.9431 2 1 4 3 7 600
-75.184119 40.0422 2 1 4 3 25 45
-75.174648 39.9533 2 1 4 3 7 135
-75.164352 39.9443 2 1 4 3 40 205
-75.136644 39.9816 2 1 5 3 10 437.5
-75.164043 39.9620 2 1 5 3 5 670
-75.042346 40.0325 2 1 4 3 8 902.5
-75.214488 40.0057 2 1 3 3 7 1135
-75.189256 40.0648 2 1 4 3 8 1367.5
-75.118161 40.0399 2 1 5 3 5 342
-75.181656 39.9325 2 1 2 3 5 32
-75.148625 40.0053 2 1 3 3 5 344
-75.162061 40.0226 2 1 4 3 5 566
-75.161539 39.9231 2 1 4 3 7 432
-75.192996 39.9360 2 1 5 3 60 23
-75.186497 39.9947 2 1 5 3 10 21
-75.160838 39.9245 2 1 4 3 8 15
-75.220631 39.9479 2 1 3 3 60 4
-75.052038 40.1039 2 1 4 3 20 2
-75.16007 39.9854 2 1 5 3 10 33
-75.173922 39.9651 2 1 6 3 10 21
-74.992689 40.0476 2 1 3 3 8 23
-75.237826 39.9097 2 1 4 3 8 45
-75.185204 40.0364 2 1 4 3 4 332
-75.180579 39.9753 2 1 5 3 12 11
-75.18444 40.0506 2 1 4 3 8 23
-75.159655 39.9580 2 1 5 3 15 34
-75.173329 39.9415 2 1 6 3 5 21
-75.220807 39.9553 2 1 2 3 7 55
-74.970514 40.0874 2 1 3 3 5 56
-75.137407 39.9757 2 1 2 3 60 76
-75.025382 40.1230 2 1 1 3 10 54
-75.008292 40.0585 2 1 2 3 8 32
-75.110591 39.9948 2 1 3 3 60 45
-75.142417 39.9743 2 1 5 3 34 43
-75.147666 40.0236 2 1 2 3 33.8 21
-75.170603 39.9835 2 1 1 3 33.6 34
-75.192643 39.9661 2 1 2 3 33.4 21
-75.161434 39.9712 2 1 2 3 33.2 21
-75.155512 40.0297 2 1 3 3 33 45
-75.139105 39.9952 2 1 4 3 32.8 33
-75.112421 39.9967 2 1 4 3 60 67
-75.180069 39.9459 2 1 5 3 10 64
-75.074719 39.9955 2 1 5 3 8 879
-75.157521 39.9268 2 1 4 3 60 643
-75.242207 39.9906 2 1 3 3 20 45
-75.177834 39.9449 2 2 3 3 10 32
-75.178306 39.9406 3 2 4 3 10 21
-75.16774 40.0614 3 2 5 3 10 12
-75.128751 39.9998 3 2 4 3 55 5
-75.16814 39.9507 3 2 3 3 64 6
-75.107254 39.9941 3 2 2 3 54 8
-75.076505 40.0718 3 2 5 3 32 5
-75.171308 39.9670 3 2 5 3 23 3
-75.204124 39.9618 3 2 5 3 23 3
-75.166586 39.9320 3 2 5 3 12 4
-75.171028 39.9623 3 2 5 3 10 5
-75.164736 39.9361 3 2 5 3 8 6
-75.158014 39.9246 3 2 5 3 15 7
-75.178417 39.9914 3 2 5 3 5 23
-74.961471 40.0954 3 2 5 3 30 34
-75.184226 40.0067 3 2 5 3 7 21
-75.154131 39.9183 3 2 5 3 25 55
-75.149905 39.9645 3 2 5 3 7 56
-75.170426 39.8954 3 2 5 3 40 76
-75.050449 40.1093 3 2 5 3 10 54
-75.129251 39.9801 1 2 5 3 5 32
-75.080112 40.0374 2 2 5 3 8 45
-75.177505 39.9694 3 2 5 3 7 43
-75.232811 39.9910 2 2 5 3 8 21
-75.165512 39.9654 2 2 5 3 34 34
-75.106918 39.9884 1 2 5 3 32 21
-75.133929 40.0345 2 2 5 3 12 21
-75.248007 39.9474 1 2 5 3 45 45
-75.227929 39.9416 3 2 5 3 54 33
-75.108149 39.9833 2 2 5 3 33 5
-75.13096 40.0402 1 2 5 3 33 3
-75.159481 40.0381 2 2 4 3 21 3
-75.22306 39.9544 3 2 4 3 13 4
-75.157745 39.9258 3 2 4 3 15 5
-75.206139 40.0753 3 2 4 3 43 6
-75.159764 39.9761 3 2 4 3 32 7
-75.203733 39.9592 1 2 4 3 22 23
-75.044878 40.0350 2 2 4 3 23 34
-75.154468 40.0011 2 2 4 3 24 21
-75.139847 40.0117 3 2 4 3 25 55
-75.167553 39.9261 2 2 4 3 23 56
-75.221515 39.9758 1 3 4 3 34 76
-75.14081 39.9689 3 3 4 3 32 62
-75.134772 39.9696 1 3 4 3 12 67
-75.120251 40.0278 2 3 4 3 45 73
-75.17538 39.9394 2 3 4 3 54 79
-75.202715 39.9631 2 3 4 3 33 85
-75.08983 40.0064 1 3 4 3 33 91
-75.241958 39.9167 3 3 4 3 21 96
-75.149173 39.9260 3 3 2 3 13 102
-75.116591 39.9971 1 3 2 3 15 107
-75.181567 39.9800 2 3 2 3 10 113
-75.15947 39.9639 2 3 2 3 8 119
-75.175997 39.9668 1 3 2 3 8 124
-75.15549 39.9270 2 3 2 3 4 32
-75.083593 40.0012 2 3 2 3 12 5
-75.155028 39.9705 2 3 2 3 8 6
-75.177172 39.9343 1 3 2 3 15 7
-75.017828 40.1347 1 3 2 3 5 8
-75.175987 39.9355 1 3 2 3 7 45
-75.139721 40.0633 1 3 2 3 5 33
-75.171806 39.9018 1 3 2 3 5 456
-75.119848 39.9806 1 3 2 3 8 21
-75.174158 40.0118 3 3 2 3 12 45
-75.15676 39.9391 3 3 2 3 8 342
-75.17601 39.9964 3 3 2 3 15 32
-75.177514 39.9343 3 3 2 3 5 344
-75.140032 39.9852 3 3 2 3 7 566
-75.142912 40.0432 3 3 2 3 5 432
-75.221434 40.0242 3 3 2 3 5 23
-75.081011 40.0435 3 3 2 3 8 21
-75.182556 39.9315 3 3 2 3 12 15
-75.22467 39.9624 3 3 2 3 8 4
-75.154735 39.9379 3 3 2 3 15 2
-75.137611 39.9744 3 3 2 3 5 50
-75.185362 40.0311 3 3 2 3 7 50
-75.153142 39.9379 3 3 2 3 5 150
-75.159238 39.9299 3 3 2 3 5 100
-75.238184 39.9243 3 3 1 3 8 30
-75.168571 39.9282 3 3 1 3 32 30
-75.235061 40.0499 3 3 1 3 22 33
-75.092385 40.0367 3 3 1 3 34 40
-75.202666 40.0777 3 3 1 3 12 100
-75.174346 40.0399 3 3 1 3 11 35
-75.173212 39.9140 3 3 1 3 54 15
-75.026764 40.0389 3 3 1 3 45 45
-75.161174 39.9701 3 3 1 3 32 24.5
-75.122398 39.9828 2 3 1 3 23 17
-75.22523 40.0405 2 3 1 3 34 34
-75.161126 39.9819 2 3 1 3 32 55
-75.000087 40.1049 2 3 1 3 56 67
-75.160579 39.9792 2 3 1 3 56 68
-75.171322 39.9479 2 3 1 3 32 53
-75.239736 39.9582 2 3 1 3 32 43
-75.224952 39.9807 1 3 1 3 34 233
-75.151156 39.9412 1 3 1 3 56 12
-75.170438 39.9334 3 3 1 3 57 44
-75.146134 40.0277 3 3 1 3 58 2
-75.172426 39.9485 1 3 2 2 45 5
-75.215704 40.0325 1 3 2 2 43 7
-75.159035 39.9531 2 2 2 2 41 98
-75.218408 40.0266 3 3 2 2 40 11
-75.154747 39.9432 1 1 2 2 33 3
-75.15398 39.9392 2 2 2 2 26 23

Dictionary

Category Question Field Value Key
Location
a. Lattitude
b. Longitude
Question 1 -  Nominal Data
a.      What is your preferred mode of transportation (other than walking) COMMUTE 1 Bike
2 Drive
3 Public Transportation (train/bus/subway/trolley)
b.       Where are you from (did you grow up)? GROWUP 1 City of Philadelphia
2 Suburbs of Philadelphia
3 Outside the Philadelphia area
Question 2 - Ordinal Data
a.       How important to you is being wealthy? WEALTH {1, 2, …5}
c.       How much of a Phillies fan are you? PHILLIES {1, 2, …5}
Question 3 - Ratio Data
a.       How many minutes does it typically take you to get from MINUTES # minutes
your current residence to work?
b.      How many miles is it, approximately, from where you grew up MILES # miles
(or consider “home”) from where you currently are?