Business Finance
PUP 424 ASU Excel Statistical Analyses of US Census Website Data Worksheet

pup 424

Arizona State University

PUP

Question Description

I’m working on a Excel question and need guidance to help me study.

In addition to giving you more practice accessing data from the US Census website, this assignment provides you the opportunity to work with Excel to perform various statistical analyses of your data, as well as to visualize your data as information ready to be presented. Create a Word document on which you will answer the questions listed below. Submit your answers via the link on Canvas found under the “Assignments” tab.

Unformatted Attachment Preview

ZIP CODE ZCTA5 85003 ZCTA5 85004 ZCTA5 85006 ZCTA5 85007 ZCTA5 85008 ZCTA5 85009 ZCTA5 85012 ZCTA5 85013 ZCTA5 85014 ZCTA5 85015 ZCTA5 85016 ZCTA5 85017 ZCTA5 85018 ZCTA5 85019 ZCTA5 85020 ZCTA5 85021 ZCTA5 85022 ZCTA5 85023 ZCTA5 85024 ZCTA5 85027 ZCTA5 85028 ZCTA5 85029 ZCTA5 85031 ZCTA5 85032 ZCTA5 85033 ZCTA5 85034 ZCTA5 85035 ZCTA5 85037 ZCTA5 85040 ZCTA5 85041 ZCTA5 85042 ZCTA5 85043 ZCTA5 85044 ZCTA5 85045 ZCTA5 85048 ZCTA5 85050 ZCTA5 85051 ZCTA5 85053 ZCTA5 85054 ZCTA5 85083 ZCTA5 85085 ZCTA5 85086 ZCTA5 85087 ZCTA5 85118 ZCTA5 85119 ZCTA5 85120 ZCTA5 85121 ZCTA5 85122 ZCTA5 85123 ZCTA5 85128 ZCTA5 85131 ZCTA5 85132 ZCTA5 85137 HOUSING OCCUPANCY UNITS IN STRUCTURE Total housing units Occupied housing Vacant units housing units Total housing units 1-unit, detached 4,612 3,968 644 4,612 1,483 2,520 1,974 546 2,520 560 10,003 8,236 1,767 10,003 5,641 5,858 4,783 1,075 5,858 3,359 23,212 18,592 4,620 23,212 7,655 14,456 12,305 2,151 14,456 8,635 4,234 3,259 975 4,234 1,521 11,436 9,617 1,819 11,436 4,749 14,413 11,431 2,982 14,413 4,719 17,012 14,114 2,898 17,012 6,471 19,262 15,074 4,188 19,262 7,531 14,120 11,933 2,187 14,120 6,672 19,790 16,830 2,960 19,790 10,216 8,568 7,286 1,282 8,568 5,843 18,024 14,780 3,244 18,024 8,131 18,124 14,940 3,184 18,124 6,920 23,566 20,688 2,878 23,566 10,604 13,981 12,318 1,663 13,981 8,339 10,252 9,308 944 10,252 7,397 17,128 14,781 2,347 17,128 8,731 8,844 8,003 841 8,844 7,256 18,834 16,796 2,038 18,834 10,529 8,909 7,565 1,344 8,909 6,146 30,267 26,812 3,455 30,267 16,817 16,547 14,342 2,205 16,547 11,520 2,020 1,615 405 2,020 878 15,232 13,080 2,152 15,232 8,564 14,890 12,881 2,009 14,890 12,565 10,584 8,707 1,877 10,584 6,422 17,354 15,858 1,496 17,354 14,780 14,734 12,647 2,087 14,734 9,937 9,908 8,652 1,256 9,908 7,844 18,678 16,921 1,757 18,678 11,510 2,875 2,758 117 2,875 2,771 13,911 12,838 1,073 13,911 11,198 11,494 10,199 1,295 11,494 8,301 16,831 14,605 2,226 16,831 10,238 12,084 10,739 1,345 12,084 8,326 3,622 2,890 732 3,622 883 6,248 5,702 546 6,248 6,053 6,964 5,654 1,310 6,964 5,257 15,712 13,341 2,371 15,712 14,294 2,988 2,392 596 2,988 2,716 8,504 5,886 2,618 8,504 6,684 12,660 9,280 3,380 12,660 5,349 16,632 11,778 4,854 16,632 5,781 791 692 99 791 602 22,249 18,060 4,189 22,249 13,704 4,327 3,208 1,119 4,327 3,252 6,159 4,836 1,323 6,159 4,677 4,862 3,803 1,059 4,862 2,968 9,858 6,932 2,926 9,858 6,306 1,253 1,000 253 1,253 1,057 ZCTA5 85138 ZCTA5 85139 ZCTA5 85140 ZCTA5 85141 ZCTA5 85142 ZCTA5 85143 ZCTA5 85145 ZCTA5 85147 ZCTA5 85172 ZCTA5 85173 ZCTA5 85192 ZCTA5 85193 ZCTA5 85194 ZCTA5 85201 ZCTA5 85202 ZCTA5 85203 ZCTA5 85204 ZCTA5 85205 ZCTA5 85206 ZCTA5 85207 ZCTA5 85208 ZCTA5 85209 ZCTA5 85210 ZCTA5 85212 ZCTA5 85213 ZCTA5 85215 ZCTA5 85224 ZCTA5 85225 ZCTA5 85226 ZCTA5 85233 ZCTA5 85234 ZCTA5 85248 ZCTA5 85249 ZCTA5 85250 ZCTA5 85251 ZCTA5 85253 ZCTA5 85254 ZCTA5 85255 ZCTA5 85256 ZCTA5 85257 ZCTA5 85258 ZCTA5 85259 ZCTA5 85260 ZCTA5 85262 ZCTA5 85263 ZCTA5 85264 ZCTA5 85266 ZCTA5 85268 ZCTA5 85281 ZCTA5 85282 ZCTA5 85283 ZCTA5 85284 ZCTA5 85286 ZCTA5 85295 ZCTA5 85296 14,192 7,180 12,197 158 16,441 14,300 557 1,327 452 1,457 907 1,797 3,253 21,578 17,753 13,278 23,068 22,812 17,997 19,876 17,771 19,131 15,178 7,756 14,161 8,793 19,099 27,956 15,642 14,537 17,659 16,932 13,792 10,136 21,857 8,291 20,689 19,071 1,994 14,263 15,665 10,298 19,795 7,173 1,795 370 6,264 12,926 25,022 23,285 19,242 6,429 14,186 12,888 13,251 10,720 5,712 10,076 93 14,248 11,067 486 1,125 348 1,068 660 1,325 2,469 18,113 15,314 11,726 20,044 18,197 14,825 16,681 14,119 15,830 12,880 7,191 12,256 6,939 17,679 25,050 14,824 13,648 16,722 14,025 12,011 8,206 17,379 7,011 18,474 15,006 1,574 12,501 11,235 9,126 16,779 4,676 1,046 348 4,755 10,173 21,128 20,646 17,822 6,216 13,143 11,904 12,434 3,472 1,468 2,121 65 2,193 3,233 71 202 104 389 247 472 784 3,465 2,439 1,552 3,024 4,615 3,172 3,195 3,652 3,301 2,298 565 1,905 1,854 1,420 2,906 818 889 937 2,907 1,781 1,930 4,478 1,280 2,215 4,065 420 1,762 4,430 1,172 3,016 2,497 749 22 1,509 2,753 3,894 2,639 1,420 213 1,043 984 817 14,192 7,180 12,197 158 16,441 14,300 557 1,327 452 1,457 907 1,797 3,253 21,578 17,753 13,278 23,068 22,812 17,997 19,876 17,771 19,131 15,178 7,756 14,161 8,793 19,099 27,956 15,642 14,537 17,659 16,932 13,792 10,136 21,857 8,291 20,689 19,071 1,994 14,263 15,665 10,298 19,795 7,173 1,795 370 6,264 12,926 25,022 23,285 19,242 6,429 14,186 12,888 13,251 13,542 5,336 10,843 45 14,890 13,809 523 901 165 1,237 510 659 2,121 6,715 7,005 7,755 12,406 11,790 9,367 13,497 8,351 11,388 6,001 7,285 7,964 5,209 11,625 16,354 10,927 11,654 14,549 13,324 13,590 4,316 6,778 6,740 14,740 14,926 1,102 7,714 7,640 7,687 9,442 6,730 1,500 343 5,725 8,346 6,351 10,311 9,840 6,070 11,834 10,291 12,667 ZCTA5 85297 ZCTA5 85298 ZCTA5 85301 ZCTA5 85302 ZCTA5 85303 ZCTA5 85304 ZCTA5 85305 ZCTA5 85306 ZCTA5 85307 ZCTA5 85308 ZCTA5 85310 ZCTA5 85320 ZCTA5 85321 ZCTA5 85322 ZCTA5 85323 ZCTA5 85326 ZCTA5 85331 ZCTA5 85333 ZCTA5 85335 ZCTA5 85337 ZCTA5 85338 ZCTA5 85339 ZCTA5 85340 ZCTA5 85342 ZCTA5 85343 ZCTA5 85345 ZCTA5 85351 ZCTA5 85353 ZCTA5 85354 ZCTA5 85355 ZCTA5 85361 ZCTA5 85363 ZCTA5 85373 ZCTA5 85374 ZCTA5 85375 ZCTA5 85377 ZCTA5 85379 ZCTA5 85381 ZCTA5 85382 ZCTA5 85383 ZCTA5 85387 ZCTA5 85388 ZCTA5 85390 ZCTA5 85392 ZCTA5 85395 ZCTA5 85396 ZCTA5 85539 ZCTA5 85545 ZCTA5 85618 ZCTA5 85623 ZCTA5 85631 ZCTA5 85634 ZCTA5 85653 ZCTA5 85658 ZCTA5 85739 8,355 8,214 24,402 16,082 10,063 9,859 4,727 9,925 3,458 26,692 7,057 470 2,664 323 12,593 16,226 11,677 336 10,615 984 15,528 11,874 9,869 921 43 22,219 21,750 9,704 2,365 3,360 2,348 2,424 10,416 24,625 20,289 2,429 13,449 10,141 18,353 13,383 5,043 7,704 5,713 12,909 9,908 5,384 2,434 723 751 2,131 1,597 2,376 5,356 3,910 9,344 7,717 7,042 20,089 14,130 8,833 9,206 4,242 9,096 2,940 24,275 6,689 285 1,787 267 10,747 13,563 9,880 202 9,311 804 13,655 10,250 9,095 643 34 20,229 17,462 8,583 1,666 2,918 1,759 2,155 8,771 19,103 16,646 1,574 11,766 9,283 15,740 11,648 4,243 6,758 4,379 11,347 7,877 3,892 1,913 375 526 1,972 1,419 1,569 4,447 3,227 7,821 638 1,172 4,313 1,952 1,230 653 485 829 518 2,417 368 185 877 56 1,846 2,663 1,797 134 1,304 180 1,873 1,624 774 278 9 1,990 4,288 1,121 699 442 589 269 1,645 5,522 3,643 855 1,683 858 2,613 1,735 800 946 1,334 1,562 2,031 1,492 521 348 225 159 178 807 909 683 1,523 8,355 8,214 24,402 16,082 10,063 9,859 4,727 9,925 3,458 26,692 7,057 470 2,664 323 12,593 16,226 11,677 336 10,615 984 15,528 11,874 9,869 921 43 22,219 21,750 9,704 2,365 3,360 2,348 2,424 10,416 24,625 20,289 2,429 13,449 10,141 18,353 13,383 5,043 7,704 5,713 12,909 9,908 5,384 2,434 723 751 2,131 1,597 2,376 5,356 3,910 9,344 7,535 7,896 8,366 9,188 7,787 8,200 2,745 6,550 2,089 20,402 7,037 298 2,217 182 9,073 13,915 10,489 127 9,324 550 13,661 11,522 8,091 598 30 15,110 12,830 8,841 1,083 3,281 1,724 1,741 7,204 19,146 16,215 1,787 12,554 6,887 12,318 12,974 4,783 7,397 3,858 10,188 8,461 4,992 1,745 258 437 1,422 1,319 1,929 2,525 3,486 7,243 1-unit, attached 142 160 326 226 617 374 224 595 1,468 1,355 1,716 670 1,093 180 2,256 785 1,601 432 393 1,344 448 955 242 1,397 691 135 282 427 645 252 426 199 1,276 42 321 199 907 716 34 114 303 130 44 325 123 274 8 502 129 53 77 14 0 2 units 363 227 913 527 1,232 843 23 222 526 448 416 161 613 213 562 758 180 101 37 55 0 324 52 243 70 130 55 8 471 184 220 9 111 0 14 16 557 0 11 0 0 11 0 56 60 37 0 50 358 40 370 210 8 3 or 4 units 501 127 1,367 718 2,217 836 126 592 1,405 1,618 838 871 815 535 1,597 1,200 1,362 788 377 874 90 780 359 1,683 303 185 547 205 998 195 536 198 817 14 288 185 577 280 151 35 106 148 0 216 412 367 9 592 65 173 200 284 5 5 to 9 units 221 166 592 215 1,892 680 171 1,108 1,449 1,569 1,228 1,001 1,539 268 1,588 1,837 2,185 1,407 122 1,266 144 1,473 613 1,597 1,013 205 1,828 557 412 124 869 415 1,904 48 739 596 1,150 883 443 19 189 84 0 0 247 196 0 672 30 189 121 249 18 10 to 19 units 349 167 203 347 4,867 774 509 1,648 1,755 2,380 2,679 2,264 1,832 694 1,375 3,323 3,418 1,294 471 1,844 195 1,671 403 3,179 720 187 1,965 471 454 169 1,160 231 1,947 0 586 381 1,737 1,126 643 0 539 405 0 0 181 126 0 990 0 17 69 120 5 20 or more units Mobile home 1,494 59 1,041 72 773 153 434 32 3,964 726 695 1,615 1,660 0 2,381 127 2,929 162 2,936 219 4,660 194 1,895 579 3,551 111 725 110 2,100 415 2,762 534 2,123 2,093 823 797 790 665 1,443 1,422 693 18 2,845 247 824 270 3,738 1,606 2,163 67 262 38 1,859 132 543 114 775 398 400 1,250 723 863 129 883 1,048 65 0 0 744 21 408 1,408 1,419 246 660 93 1,457 0 27 0 519 51 105 535 0 222 0 1,173 232 5,692 174 9,384 0 172 1,036 4,452 0 473 50 940 128 924 24 2,516 0 149 199 24 31 0 27 162 18 45 0 18 15 0 75 1,556 1,255 398 1,394 1,266 1,500 345 881 1,499 767 73 495 952 750 2,091 527 421 743 822 55 3,087 3,648 597 509 1,195 0 1,344 3,111 440 1,837 214 227 0 385 1,723 1,859 1,738 1,294 338 112 524 287 16 62 0 0 0 0 0 100 0 0 16 28 53 546 188 394 558 382 40 26 122 123 210 0 38 45 225 296 213 53 103 53 0 105 198 15 109 41 0 173 157 14 345 102 0 0 33 313 779 281 235 0 37 62 19 0 0 39 0 111 0 0 0 0 5 0 9 0 1,951 1,152 1,335 1,778 1,170 660 388 243 512 1,066 0 667 177 735 1,391 371 174 181 163 0 310 1,480 213 788 525 0 780 1,555 388 1,882 110 15 5 0 1,023 2,815 1,285 1,177 11 249 37 13 0 96 0 0 120 24 0 0 0 84 0 0 0 2,050 2,540 796 1,516 1,127 1,464 479 159 596 1,564 34 431 0 2,166 2,529 1,608 708 1,024 445 15 1,185 2,041 312 1,957 1,166 34 739 1,700 502 2,292 17 0 3 63 753 2,922 1,959 1,761 7 590 318 89 0 29 0 4 127 0 0 0 0 0 0 0 97 3,472 2,827 1,496 1,388 621 1,141 353 414 437 2,633 139 351 68 1,561 2,398 971 704 548 461 0 580 2,630 157 1,594 513 0 758 750 626 2,012 0 0 0 0 552 3,890 3,507 2,680 0 643 445 68 0 0 0 0 85 14 0 0 0 0 0 0 0 3,501 2,240 677 1,243 945 1,470 633 414 294 2,038 73 554 58 1,989 1,473 870 761 425 824 4 501 4,818 219 980 531 0 1,473 728 603 1,929 0 8 0 14 195 5,732 2,996 1,956 0 277 1,203 91 435 1,580 1,284 109 1,081 291 16 281 287 76 361 1,026 888 1,740 539 412 2,785 5,135 2,306 4,026 6,994 4,093 891 152 3,417 2,284 48 1,339 151 62 86 840 128 52 234 38 12 146 831 1,230 24 38 56 0 45 19 44 21 648 1,196 294 3 444 8 17 8 112 1,710 1,092 308 389 116 603 506 589 12 0 30 0 205 71 334 0 144 7 144 65 356 13 0 1,414 6,533 117 27 10 14 63 1,439 417 2,383 348 208 837 1,708 122 12 83 173 83 63 29 15 0 8 33 11 64 10 129 215 0 13 342 67 128 10 8 0 47 19 0 0 39 0 260 161 115 0 8 63 91 59 0 25 0 164 351 24 10 0 0 67 51 59 106 62 0 8 79 0 0 0 71 0 0 9 26 0 17 31 0 0 30 14 0 109 0 1,713 654 480 30 79 178 42 290 0 0 25 0 618 103 107 0 149 61 326 19 86 0 0 512 436 109 0 0 0 157 52 474 148 47 34 37 368 34 0 0 287 43 62 0 14 0 10 0 0 44 3 0 41 91 13 1,833 1,015 359 146 160 685 223 1,601 0 5 18 0 710 114 177 0 169 43 142 0 529 0 0 980 305 262 0 0 0 104 128 672 28 32 32 208 909 36 0 13 196 1,387 439 26 37 0 8 65 0 8 139 0 0 368 49 2,597 1,698 498 538 650 958 352 1,945 0 10 0 0 174 144 103 0 64 9 95 0 70 14 0 415 239 167 0 0 0 85 30 749 136 86 250 758 985 47 0 63 137 357 131 7 18 0 33 0 9 0 6 0 0 159 13 4,364 1,941 247 499 673 749 70 1,187 8 0 50 0 404 261 47 0 57 0 619 0 396 3 0 1,206 900 71 0 0 0 190 556 1,257 1,202 35 213 1,387 1,367 122 4 24 114 509 498 18 11 0 0 0 12 0 43 0 0 85 118 3,395 419 256 47 285 202 129 659 0 157 285 137 1,149 1,431 305 206 618 243 436 209 341 227 13 2,393 156 109 1,245 69 610 17 894 1,659 71 32 158 19 619 33 244 124 731 335 254 303 558 443 238 580 246 331 2,591 281 1,793 HOUSING TENURE VEHICLES AVAILABLE Boat, RV, van,Occupied etc. housing Owner-occupied units Renter-occupied Occupied housing No vehicles units available 1 vehicle available 0 3,968 1,174 2,794 3,968 1,064 1,790 0 1,974 615 1,359 1,974 578 854 35 8,236 3,373 4,863 8,236 2,050 3,433 0 4,783 2,027 2,756 4,783 1,135 1,716 42 18,592 5,877 12,715 18,592 2,294 9,743 4 12,305 5,357 6,948 12,305 2,777 4,576 0 3,259 1,518 1,741 3,259 368 1,544 14 9,617 4,423 5,194 9,617 1,725 4,340 0 11,431 4,588 6,843 11,431 1,527 6,162 16 14,114 5,079 9,035 14,114 3,794 5,314 0 15,074 7,004 8,070 15,074 2,061 7,255 7 11,933 4,750 7,183 11,933 2,065 4,934 20 16,830 9,679 7,151 16,830 1,866 7,066 0 7,286 4,041 3,245 7,286 833 2,604 0 14,780 8,392 6,388 14,780 1,401 7,160 5 14,940 6,402 8,538 14,940 2,424 6,144 0 20,688 11,532 9,156 20,688 1,289 9,241 0 12,318 7,481 4,837 12,318 823 5,141 0 9,308 6,484 2,824 9,308 226 3,687 149 14,781 8,434 6,347 14,781 669 6,589 0 8,003 6,597 1,406 8,003 263 2,239 10 16,796 8,886 7,910 16,796 1,715 6,869 0 7,565 3,734 3,831 7,565 746 3,150 7 26,812 15,484 11,328 26,812 1,708 11,286 0 14,342 7,467 6,875 14,342 1,011 5,650 0 1,615 376 1,239 1,615 497 658 0 13,080 5,744 7,336 13,080 1,049 5,272 0 12,881 8,109 4,772 12,881 301 4,328 9 8,707 4,437 4,270 8,707 1,564 3,510 0 15,858 10,532 5,326 15,858 1,382 5,732 0 12,647 7,858 4,789 12,647 1,114 4,458 0 8,652 5,701 2,951 8,652 301 2,887 0 16,921 9,996 6,925 16,921 357 7,543 0 2,758 2,351 407 2,758 14 606 0 12,838 9,639 3,199 12,838 265 3,554 0 10,199 7,700 2,499 10,199 138 3,367 0 14,605 8,065 6,540 14,605 1,378 5,681 0 10,739 6,730 4,009 10,739 591 4,316 0 2,890 1,069 1,821 2,890 75 1,653 0 5,702 5,042 660 5,702 0 742 0 5,654 3,621 2,033 5,654 66 1,790 0 13,341 10,361 2,980 13,341 286 3,880 6 2,392 2,050 342 2,392 25 408 50 5,886 5,252 634 5,886 205 2,057 364 9,280 7,864 1,416 9,280 531 4,219 293 11,778 9,397 2,381 11,778 981 6,333 0 692 372 320 692 90 290 251 18,060 12,631 5,429 18,060 1,140 7,389 20 3,208 2,246 962 3,208 54 1,336 20 4,836 3,062 1,774 4,836 397 1,808 5 3,803 2,594 1,209 3,803 458 1,521 135 6,932 5,079 1,853 6,932 318 3,223 11 1,000 859 141 1,000 87 404 0 53 0 0 0 0 0 0 0 37 5 75 19 47 7 15 0 376 49 129 193 189 8 0 244 0 0 85 4 0 0 0 0 0 30 0 0 28 27 52 0 0 0 0 0 0 0 0 26 12 5 0 0 0 0 10,720 5,712 10,076 93 14,248 11,067 486 1,125 348 1,068 660 1,325 2,469 18,113 15,314 11,726 20,044 18,197 14,825 16,681 14,119 15,830 12,880 7,191 12,256 6,939 17,679 25,050 14,824 13,648 16,722 14,025 12,011 8,206 17,379 7,011 18,474 15,006 1,574 12,501 11,235 9,126 16,779 4,676 1,046 348 4,755 10,173 21,128 20,646 17,822 6,216 13,143 11,904 12,434 8,667 4,142 8,070 71 11,456 7,939 439 673 135 823 609 811 1,775 6,887 7,426 7,055 11,436 12,252 9,600 13,628 11,160 11,644 5,938 5,641 9,465 6,030 9,911 14,257 9,504 9,381 12,401 11,432 10,640 6,201 9,082 6,136 13,426 12,628 1,074 8,048 8,358 6,699 10,139 4,389 972 249 4,478 8,502 5,594 9,656 9,289 5,737 9,530 8,060 9,045 2,053 1,570 2,006 22 2,792 3,128 47 452 213 245 51 514 694 11,226 7,888 4,671 8,608 5,945 5,225 3,053 2,959 4,186 6,942 1,550 2,791 909 7,768 10,793 5,320 4,267 4,321 2,593 1,371 2,005 8,297 875 5,048 2,378 500 4,453 2,877 2,427 6,640 287 74 99 277 1,671 15,534 10,990 8,533 479 3,613 3,844 3,389 10,720 5,712 10,076 93 14,248 11,067 486 1,125 348 1,068 660 1,325 2,469 18,113 15,314 11,726 20,044 18,197 14,825 16,681 14,119 15,830 12,880 7,191 12,256 6,939 17,679 25,050 14,824 13,648 16,722 14,025 12,011 8,206 17,379 7,011 18,474 15,006 1,574 12,501 11,235 9,126 16,779 4,676 1,046 348 4,755 10,173 21,128 20,646 17,822 6,216 13,143 11,904 12,434 91 313 282 0 192 144 6 301 0 133 5 34 131 2,230 1,610 552 1,391 1,487 1,013 1,006 697 318 1,326 34 725 203 908 1,299 420 348 317 585 194 148 1,929 124 539 408 204 807 275 273 613 32 43 40 85 212 2,854 1,610 1,472 80 119 220 225 3,281 1,577 2,856 29 2,966 3,621 128 506 169 398 140 460 713 8,834 7,000 4,842 8,020 8,802 7,450 5,401 6,806 7,896 5,676 1,562 4,864 3,143 6,702 9,591 5,588 3,714 4,293 6,403 3,235 4,060 8,833 1,598 5,451 4,037 771 5,480 5,122 2,708 7,070 730 486 114 1,007 3,375 10,676 9,041 7,081 1,232 3,560 3,174 2,737 0 0 82 8 0 0 11 0 0 0 0 0 0 4 0 26 0 3 82 8 14 0 0 41 0 25 0 4 0 0 0 0 62 192 0 0 0 0 0 15 0 0 146 7 0 0 10 22 0 0 0 0 9 0 52 7,717 7,042 20,089 14,130 8,833 9,206 4,242 9,096 2,940 24,275 6,689 285 1,787 267 10,747 13,563 9,880 202 9,311 804 13,655 10,250 9,095 643 34 20,229 17,462 8,583 1,666 2,918 1,759 2,155 8,771 19,103 16,646 1,574 11,766 9,283 15,740 11,648 4,243 6,758 4,379 11,347 7,877 3,892 1,913 375 526 1,972 1,419 1,569 4,447 3,227 7,821 5,721 5,874 8,404 8,432 5,640 7,020 2,327 5,756 1,291 17,833 5,778 216 1,214 203 6,297 9,473 8,388 170 6,296 472 9,717 7,915 6,485 506 27 13,930 14,545 5,795 1,407 2,477 1,556 1,217 7,609 14,536 14,632 1,296 8,309 6,589 11,014 9,846 3,912 5,246 3,033 6,958 5,942 3,050 1,462 264 400 1,655 1,066 991 3,430 2,805 7,001 1,996 1,168 11,685 5,698 3,193 2,186 1,915 3,340 1,649 6,442 911 69 573 64 4,450 4,090 1,492 32 3,015 332 3,938 2,335 2,610 137 7 6,299 2,917 2,788 259 441 203 938 1,162 4,567 2,014 278 3,457 2,694 4,726 1,802 331 1,512 1,346 4,389 1,935 842 451 111 126 317 353 578 1,017 422 820 7,717 7,042 20,089 14,130 8,833 9,206 4,242 9,096 2,940 24,275 6,689 285 1,787 267 10,747 13,563 9,880 202 9,311 804 13,655 10,250 9,095 643 34 20,229 17,462 8,583 1,666 2,918 1,759 2,155 8,771 19,103 16,646 1,574 11,766 9,283 15,740 11,648 4,243 6,758 4,379 11,347 7,877 3,892 1,913 375 526 1,972 1,419 1,569 4,447 3,227 7,821 138 110 3,199 1,467 519 338 152 602 122 675 117 24 173 15 721 441 134 29 227 77 439 375 83 65 0 1,281 1,255 233 75 24 0 229 499 647 984 18 224 757 739 208 69 80 337 62 202 48 244 23 52 171 114 370 166 36 101 1,782 1,825 9,742 5,601 2,673 2,686 1,500 3,078 1,163 6,995 1,091 101 723 128 4,250 4,178 1,961 36 3,556 319 3,551 2,734 2,307 214 0 7,623 11,685 2,629 321 449 506 837 4,519 9,298 10,606 665 2,999 2,673 5,314 1,908 1,636 2,110 1,730 3,524 2,993 1,288 800 170 119 543 510 650 1,327 978 3,075 TRAVEL TIME TO WORK 2 vehicles available 3 or more vehicles Lessavailable than 55minutes to 9 minutes 10 to 14 minutes 15 to 19 minutes 20 to 24 minutes 25 to 29 minutes 30 to 34 minutes 923 191 205 520 651 562 521 275 487 431 111 48 379 369 351 106 99 118 1,783 970 76 673 1,204 1,407 1,232 318 1,503 1,501 431 59 697 881 684 731 187 742 4,885 1,670 473 1,351 3,573 4,776 3,033 906 5,123 3,291 1,661 213 1,014 1,882 2,229 1,816 696 2,158 1,016 331 109 446 506 548 452 431 361 2,696 856 193 1,223 1,718 1,981 1,855 518 1,291 3,195 547 256 1,608 1,927 2,216 1,893 822 1,933 3,741 1,265 291 974 2,109 2,507 2,679 801 2,753 4,396 1,362 401 1,958 2,614 2,887 2,603 1,100 2,274 3,412 1,522 121 989 1,582 2,000 2,776 414 3,093 5,783 2,115 660 1,869 3,184 3,649 3,335 962 1,911 2,596 1,253 38 549 1,010 1,373 1,576 580 2,021 4,802 1,417 215 1,198 1,648 2,931 3,390 1,163 2,782 4,392 1,980 296 1,482 1,533 2,552 2,842 1,556 2,560 7,651 2,507 258 1,540 2,546 3,911 4,841 2,195 4,860 4,414 1,940 359 1,053 1,706 2,351 2,792 1,097 2,867 3,974 1,421 104 668 1,164 2,475 2,147 986 2,213 5,729 1,794 400 1,867 2,749 2,752 3,033 802 2,939 3,961 1,540 305 728 1,088 1,948 2,217 550 1,067 5,758 2,454 325 1,332 2,971 3,077 3,184 1,118 4,053 2,321 1,348 21 299 1,477 1,814 1,403 321 1,955 10,070 3,748 631 2,569 4,386 4,989 6,413 3,037 6,215 5,083 2,598 141 1,075 1,911 2,443 3,462 1,452 4,431 345 115 35 109 256 249 143 4 155 4,777 1,982 103 951 2,291 2,842 3,063 1,064 3,458 5,533 2,719 128 1,287 1,906 2,407 3,497 1,316 3,867 2,404 1,229 264 976 1,580 2,003 1,597 598 1,458 5,881 2,863 258 1,136 1,627 3,500 3,820 1,560 5,345 4,818 2,257 127 1,027 2,669 3,373 2,693 978 2,471 3,867 1,597 101 748 1,528 1,231 1,921 1,243 2,946 6,956 2,065 500 1,666 2,864 3,771 3,504 1,382 2,636 1,554 584 26 138 285 412 451 316 694 6,388 2,631 233 1,534 2,088 2,524 2,575 1,162 2,688 5,214 1,480 94 625 1,541 2,249 2,288 1,169 2,166 5,263 2,283 188 998 1,783 2,621 2,724 1,159 3,533 3,927 1,905 237 1,300 1,899 1,762 2,206 1,190 2,254 989 173 113 300 529 237 560 263 411 3,605 1,355 64 563 1,325 1,006 1,098 831 1,747 3,079 719 71 343 622 1,008 1,254 777 1,159 6,264 2,911 531 1,071 1,267 1,376 1,772 1,081 2,230 1,224 735 84 46 227 196 288 295 525 2,924 700 123 203 221 249 328 394 796 2,681 1,849 214 688 573 565 805 368 1,999 3,388 1,076 303 980 922 629 697 447 1,855 214 98 21 16 203 88 189 34 132 6,972 2,559 642 3,651 3,879 3,038 1,834 539 1,598 1,178 640 38 0 228 310 1,208 25 ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer

OK - all done!!

Phoenix metro housing and transportation data were collected from the US Census
website for analysis of the area. The first analysis conducted was to understand the difference
in occupied and vacant housing in the 85003 and 85251 zip codes. The following charts show
us that vacancies are a higher percentage of housing in the 85251 zip code.

Figure 1: Comparison of Occupancy Between Zip Code 85003 and 85251

The average number of mobile homes in the Phoenix metro area was found by averaging the
data in Excel using Excel’s built in AVERAGE function. The average number of mobile homes
was found to be 757.8. However, it’s more interesting to compare a variety of statistics, so the
following were computed using Excel functions:

Mean number of mobile homes
Median number of mobile homes
Minimum number of mobile homes
Maximum number of mobile homes

757.8
270
0
9,384

Figure 2: Statistical Summary of Mobile Homes Across Zip Codes

There was also a desire to understand the impact of low-density, single-family
“sprawled” development on commuting travel time. 42% of the total housing units in the
85013 zip code are single-family, detached homes. The average is 67% across all zip codes, with
a median of 68%.
Studying zip code 85258, we find that 28% of the commuters have a commute time that
is 30 minutes or more. To see the general relationship, a scatterplot was created:

% Commute time > 30 min by Zip Code

% Single Family Detached Homes vs. % Commute
Time of 30 minutes or more
90%
80%
70%
60%
50%
40%
30%
20%
10%
0%
0%

20%

40%

60%

80%

100%

120%

% Single Family Detached Homes by Zip Code
Figure 3: Scatterplot of Single Family Homes vs. Commute Time

Finally, there was also a need to study distribution of vehicles available to households
across the dataset. The data was summed across households and plotted in a pie chart. See
Figure 4 for the results.

TOTAL VEHICLES AVAILABLE ACROSS ZIP CODES
No vehicles available

1 vehicle available

16%

2 vehicles available

3 or more vehicles available

7%

38%

39%

Figure 4: Distribution of Vehicles Available Across Zip Codes


ZIP CODE
ZCTA5 85003
ZCTA5 85004
ZCTA5 85006
ZCTA5 85007
ZCTA5 85008
ZCTA5 85009
ZCTA5 85012
ZCTA5 85013
ZCTA5 85014
ZCTA5 85015
ZCTA5 85016
ZCTA5 85017
ZCTA5 85018
ZCTA5 85019
ZCTA5 85020
ZCTA5 85021
ZCTA5 85022
ZCTA5 85023
ZCTA5 85024
ZCTA5 85027
ZCTA5 85028
ZCTA5 85029
ZCTA5 85031
ZCTA5 85032
ZCTA5 85033
ZCTA5 85034
ZCTA5 85035
ZCTA5 85037
ZCTA5 85040
ZCTA5 85041
ZCTA5 85042
ZCTA5 85043
ZCTA5 85044
ZCTA5 85045
ZCTA5 85048
ZCTA5 85050
ZCTA5 85051
ZCTA5 85053
ZCTA5 85054
ZCTA5 85083
ZCTA5 85085
ZCTA5 85086
ZCTA5 85087
ZCTA5 85118
ZCTA5 85119
ZCTA5 85120
ZCTA5 85121
ZCTA5 85122
ZCTA5 85123
ZCTA5 85128
ZCTA5 85131
ZCTA5 85132
ZCTA5 85137

HOUSING OCCUPANCY
UNITS IN STRUCTURE
Total housing units
Occupied housing
Vacant
units
housing units
Total housing units
1-unit, detached
4,612
3,968
644
4,612
1,483
2,520
1,974
546
2,520
560
10,003
8,236
1,767
10,003
5,641
5,858
4,783
1,075
5,858
3,359
23,212
18,592
4,620
23,212
7,655
14,456
12,305
2,151
14,456
8,635
4,234
3,259
975
4,234
1,521
11,436
9,617
1,819
11,436
4,749
14,413
11,431
2,982
14,413
4,719
17,012
14,114
2,898
17,012
6,471
19,262
15,074
4,188
19,262
7,531
14,120
11,933
2,187
14,120
6,672
19,790
16,830
2,960
19,790
10,216
8,568
7,286
1,282
8,568
5,843
18,024
14,780
3,244
18,024
8,131
18,124
14,940
3,184
18,124
6,920
23,566
20,688
2,878
23,566
10,604
13,981
12,318
1,663
13,981
8,339
10,252
9,308
944
10,252
7,397
17,128
14,781
2,347
17,128
8,731
8,844
8,003
841
8,844
7,256
18,834
16,796
2,038
18,834
10,529
8,909
7,565
1,344
8,909
6,146
30,267
26,812
3,455
30,267
16,817
16,547
14,342
2,205
16,547
11,520
2,020
1,615
405
2,020
878
15,232
13,080
2,152
15,232
8,564
14,890
12,881
2,009
14,890
12,565
10,584
8,707
1,877
10,584
6,422
17,354
15,858
1,496
17,354
14,780
14,734
12,647
2,087
14,734
9,937
9,908
8,652
1,256
9,908
7,844
18,678
16,921
1,757
18,678
11,510
2,875
2,758
117
2,875
2,771
13,911
12,838
1,073
13,911
11,198
11,494
10,199
1,295
11,494
8,301
16,831
14,605
2,226
16,831
10,238
12,084
10,739
1,345
12,084
8,326
3,622
2,890
732
3,622
883
6,248
5,702
546
6,248
6,053
6,964
5,654
1,310
6,964
5,257
15,712
13,341
2,371
15,712
14,294
2,988
2,392
596
2,988
2,716
8,504
5,886
2,618
8,504
6,684
12,660
9,280
3,380
12,660
5,349
16,632
11,778
4,854
16,632
5,781
791
692
99
791
602
22,249
18,060
4,189
22,249
13,704
4,327
3,208
1,119
4,327
3,252
6,159
4,836
1,323
6,159
4,677
4,862
3,803
1,059
4,862
2,968
9,858
6,932
2,926
9,858
6,306
1,253
1,000
253
1,253
1,057

ZCTA5 85138
ZCTA5 85139
ZCTA5 85140
ZCTA5 85141
ZCTA5 85142
ZCTA5 85143
ZCTA5 85145
ZCTA5 85147
ZCTA5 85172
ZCTA5 85173
ZCTA5 85192
ZCTA5 85193
ZCTA5 85194
ZCTA5 85201
ZCTA5 85202
ZCTA5 85203
ZCTA5 85204
ZCTA5 85205
ZCTA5 85206
ZCTA5 85207
ZCTA5 85208
ZCTA5 85209
ZCTA5 85210
ZCTA5 85212
ZCTA5 85213
ZCTA5 85215
ZCTA5 85224
ZCTA5 85225
ZCTA5 85226
ZCTA5 85233
ZCTA5 85234
ZCTA5 85248
ZCTA5 85249
ZCTA5 85250
ZCTA5 85251
ZCTA5 85253
ZCTA5 85254
ZCTA5 85255
ZCTA5 85256
ZCTA5 85257
ZCTA5 85258
ZCTA5 85259
ZCTA5 85260
ZCTA5 85262
ZCTA5 85263
ZCTA5 85264
ZCTA5 85266
ZCTA5 85268
ZCTA5 85281
ZCTA5 85282
ZCTA5 85283
ZCTA5 85284
ZCTA5 85286
ZCTA5 85295
ZCTA5 85296

14,192
7,180
12,197
158
16,441
14,300
557
1,327
452
1,457
907
1,797
3,253
21,578
17,753
13,278
23,068
22,812
17,997
19,876
17,771
19,131
15,178
7,756
14,161
8,793
19,099
27,956
15,642
14,537
17,659
16,932
13,792
10,136
21,857
8,291
20,689
19,071
1,994
14,263
15,665
10,298
19,795
7,173
1,795
370
6,264
12,926
25,022
23,285
19,242
6,429
14,186
12,888
13,251

10,720
5,712
10,076
93
14,248
11,067
486
1,125
348
1,068
660
1,325
2,469
18,113
15,314
11,726
20,044
18,197
14,825
16,681
14,119
15,830
12,880
7,191
12,256
6,939
17,679
25,050
14,824
13,648
16,722
14,025
12,011
8,206
17,379
7,011
18,474
15,006
1,574
12,501
11,235
9,126
16,779
4,676
1,046
348
4,755
10,173
21,128
20,646
17,822
6,216
13,143
11,904
12,434

3,472
1,468
2,121
65
2,193
3,233
71
202
104
389
247
472
784
3,465
2,439
1,552
3,024
4,615
3,172
3,195
3,652
3,301
2,298
565
1,905
1,854
1,420
2,906
818
889
937
2,907
1,781
1,930
4,478
1,280
2,215
4,065
420
1,762
4,430
1,172
3,016
2,497
749
22
1,509
2,753
3,894
2,639
1,420
213
1,043
984
817

14,192
7,180
12,197
158
16,441
14,300
557
1,327
452
1,457
907
1,797
3,253
21,578
17,753
13,278
23,068
22,812
17,997
19,876
17,771
19,131
15,178
7,756
14,161
8,793
19,099
27,956
15,642
14,537
17,659
16,932
13,792
10,136
21,857
8,291
20,689
19,071
1,994
14,263
15,665
10,298
19,795
7,173
1,795
370
6,264
12,926
25,022
23,285
19,242
6,429
14,186
12,888
13,251

13,542
5,336
10,843
45
14,890
13,809
523
901
165
1,237
510
659
2,121
6,715
7,005
7,755
12,406
11,790
9,367
13,497
8,351
11,388
6,001
7,285
7,964
5,209
11,625
16,354
10,927
11,654
14,549
13,324
13,590
4,316
6,778
6,740
14,740
14,926
1,102
7,714
7,64...

Sara_777 (1099)
Rice University

Anonymous
I was on a very tight deadline but thanks to Studypool I was able to deliver my assignment on time.

Anonymous
The tutor was pretty knowledgeable, efficient and polite. Great service!

Anonymous
Heard about Studypool for a while and finally tried it. Glad I did caus this was really helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags