Lab 11
yyyyy10086
Lab7SummaryStatisticsLab7MeanStandardDeviationandRelationshipsbetweenVariables2.zip(Lab 7 Summary Statistics) Lab #6 Mean Standard Deviation and Relationships between Variables/Digital Mapping Lab #6 Excel Data.xls
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? |
(Lab 7 Summary Statistics) Lab #6 Mean Standard Deviation and Relationships between Variables/Digital Mapping Lab #7 Hybrid.docx
Lab 7: Working with Spatial Data, Part 2
Learning Outcomes for Lab:
1. Summarize and analyze spatial data sets
2. Calculate mean in Excel
3. Calculate standard deviation in Excel
4. organize data for analysis
5. Explore functions in Excel
6. Explore/Explain the relationship between quantitative variables
Learning Outcomes for Quantitative Literacy:
· Understand quantitative models that describe real world phenomena and recognize limitations of those models;
· Perform simple mathematical computations associated with a quantitative model and make conclusions based on the results;
· Recognize, use, and appreciate mathematical thinking for solving problems that are part of everyday life;
· Understand the various sources of uncertainty and error in empirical data;
· Retrieve, organize, and analyze data associated with a quantitative model; and
· Communicate logical arguments and their conclusions.
1. Calculate the mean and standard deviation for the MINUTES variable.
Here, we will continue from last week’s lab to work with the survey data. If you haven’t already, download the Data for Lab Digital Mapping excel from lab #5. Open the file in Microsoft Excel. Recall that this file contains survey results.
Review the data table on the aata tab and the meanings and coding for the variables on the Dictionary tab.
Calculating Mean
To calculate the mean, go to the data table, and in the row underneath the last row containing data, in the cell under the MINUTES variable type the function
=AVERAGE(G2:G298)
Note that the columns are labeled with letters, e.g. ‘G’ at the top of the table which serves as an identifier for that column/variable. The function ‘average’ indicates you are calculating the average and the text “G2:G298” indicates the range of cells for which to apply the average calculation.
Question 1: What is the mean of the MINUTES variable (to the nearest whole minute)?
To calculate the standard deviation, go to the data table, and in the row underneath the row containing the mean, under the MINUTES variable type the function
=stdev(G2:G298)
Question 2? What is the standard deviation of the MINUTES variable (to the nearest whole minute)?
Question? Standard Deviation and Mean are summary statistics – they tell us something important about this complex array of numbers. Having calculated the mean and standard deviation please analyze the data set using SD and mean. Explain what they numbers tell us about the data set. Please recall our discussion from class to answer this question.
2. Calculate the mean and standard deviation of MINUTES for each value of WEALTH.
Here you will create a table that reports the mean and standard deviation (to the nearest whole number) of MINUTES for each value of WEALTH. Select all and then under the sort & filter tab select “custom sort.” Add a level, then select first to sort by WEALTH, then MINUTES. Complete the table below:
|
Wealth Variable |
Average for each wealth category for Minutes |
Standard Deviation for each wealth category for Minutes |
|
1 |
Avg minutes for all of the 1s |
SD in minutes for all of the 1s |
|
2 |
Avg minutes for all of the 2s |
SD in minutes for all of the 2s |
|
3 |
Avg minutes for all of the 3s |
SD in minutes for all of the 3s |
|
4 |
Avg minutes for all of the 4s |
SD in minutes for all of the 4s |
|
5 |
Avg minutes for all of the 5s |
SD in minutes for all of the 5s |
Question 3: Write a paragraph or two addressing the following questions: Is there a relationship between the importance of wealth question and the amount of minutes it takes for folks to get to work? Explain/analyze the relationship you showed in this table.
3. Investigate another relationship between variables in the data set
Question 4: Investigate whether a nominal or ordinal variable of your choosing in the data set has a relationship with MILES. To do this, use the same approach you used to investigate whether the mean and standard deviation of MINUTES differed for different values of WEALTH. In your answer, be sure to include a table that expresses the mean and standard deviation of MILES for different values of the nominal or ordinal variable you choose. Then, explain in a paragraph if you think there is a relationship between MILES and the other variable, the evidence for this relationship relating to the differences in mean and/or standard deviation, and why you think the relationship exists (or doesn’t exist).
|
Wealth Variable |
Average for each wealth category for Miles |
Standard Deviation for each wealth category for Miles |
|
1 |
Avg miles for all of the 1s |
SD in miles for all of the 1s |
|
2 |
Avg miles for all of the 2s |
SD in miles for all of the 2s |
|
3 |
Avg miles for all of the 3s |
SD in miles for all of the 3s |
|
(4) Use only for ordinal |
Avg miles for all of the 4s |
SD in miles for all of the 4s |
|
(5) Use only for ordinal |
Avg miles for all of the 5s |
SD in miles for all of the 5s |
Explain the relationship between the variables here…
