Business Finance
PUP 424 ASU Statistics of Housing Occupancy Worksheet

pup 424

Arizona State University

PUP

Question Description

Can you help me understand this Excel question?

I attached excel file and also the instructions follow the instructions it should be clear

Unformatted Attachment Preview

Lab: Using Excel for Statistical Analysis and Visualization PUP 424—Planning Methods Assignment Overview 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. This assignment is due Monday night 3/23 by midnight. Assignment Steps 1. Open the file titled “Lab 5 Data”. You can find it as an attachment to this assignment on Canvas. This table provides data by zip code in the Phoenix metro area for housing and transportation-related characteristics. Let’s say you want to create some graphic visuals of some of the data. You want to create two pie charts that compare the proportion of vacant vs. occupied housing units in the 85003 and 85251 zip codes. First, highlight the cells containing the number of occupied and vacant housing units for 85003 (cells C3 and D3), as well as the cells containing the column headings (cells C2 and D2). Under the “Insert” tab, select the 2-D pie chart option to create the first visual. Under the “Chart Layouts” option at the top left, select a layout that includes a chart title and shows the percentages. Change the chart title to “Housing Occupancy in 85003”and adjust the text font and color so that it can easily be seen on the chart. (Your chart might look something like Figure 3.) Question #1: Cut and paste your chart from the Excel document and into your Word document. Question #2: Now complete the same steps to create a pie chart for the 85251 zip code. Cut and paste the results in your Word document. Figure 3 4. Now let’s say you want to determine the mean (average) number of mobile home units in Phoenix zip codes. You can do this either by adding the mobile home counts (using Excel’s SUM function) and dividing the 1 total by the number of zip codes in the sample OR by using Excel’s built-in AVERAGE function. Ask a classmate or your TA if you need help! Question #3: What is the average number of mobile home units? You also want to compare the median to the mean that you just calculated. Again there are two ways to do this. One is to sort your data by the mobile home count column (M), and the value in the middle of your data will be the median (take the total number of data points + 1, and then divide by 2 to determine which record contains the median). To perform the sort, first highlight all the cells in spreadsheet that contain data (rows 3 through 165 from columns A to AH), but do not highlight the column headings (in rows 1 or 2). Under the “Data” tab select “Sort” and choose “Sort by” Column M (the column containing the mobile home counts) and choose order “Smallest to Largest.” Now that the data are ordered, find the median. Alternatively, you can use Excel’s MEDIAN function. Question #4: What is the median number of mobile home units? What is the minimum number of mobile home units in a zip code? What is the maximum number? 5. Finally, you want to conduct an analysis of the impacts of low-density single-family “sprawled” development on commuting travel time. You want to analyze the correlation between the percentage of 1unit detached housing structures and the percentage of workers commuting longer than 30 minutes. To do this, you will first need to add a few columns to your table to calculate the percentages. First, add a column to the right of the “1-unit, detached” column. (To do this, highlight the column to the right of “1-unit, detached,” right click, and select “insert” to make a new column appear.) Label the new column “Percent Single-Family” (in cell G2). Next, in cell G3 type “=F3/E3” to divide the number of 1-unit detached houses by the total number of housing units in the zip code. With cell G3 highlighted, under the “Home” tab click the “%” symbol to convert the result into a percentage. Cut and paste this formula into the remaining cells in column G (or drag cell G3 down). You should now have percentages of single-family units for each zip code. Question 5: What percentage of units in the 85013 zip code are single-family? Question 6: Calculate the mean percentage of single-family homes per zip code (see step 4 above). What is the mean percentage? Question 7: Sort the data based on the numbers in column G (see step 4 above). What is the median data value for single-family homes per zip code? Now add a column on the right side of the table and label it “Total Commuters.” Since you want to find out how many workers commute in each zip code, in cell AJ3 type “=SUM(X3:AI3)” to add across the row. Cut and paste this formula into the remaining cells down column AJ to get your totals for each zip code. Next add a column to the right labeled “30 Minutes Plus” and type “=SUM(AD3:AI3)” in cell AK3. This will add the counts for all commuters that travel 30 or more minutes to work (columns AD through AI). Cut and paste this formula into the remaining cells down column AK to get your totals for each zip code. Now, add a column to the right labeled “% Commute 30+” and type “=AK3/AJ3” in cell AL3. This will divide the number of 30+ commuters by the total number of commuters to give you a percentage. (Be sure to change 2 the value to a %, as in step 5 above). Cut and paste this formula into the remaining cells down column AL to get your percentages for each zip code. Question 8: What percentage of workers living in the 85258 zip code commute 30 minutes or longer? Now, create a scatter plot of the percentage of workers commuting 30 minutes or longer (column AL) who live in single-family homes (column G). To do this, hold down the control key and highlight the data in column G (cells G3 through G165) and the data in column AL (cells AL3 through AL165). (Make sure all the data are highlighted.) Under the “Insert” tab select the Scatter chart (with only markers) option. Change the layout so your scatter plot includes a chart title and axis titles. Change the chart title to “Long Commutes and SingleFamily Living,” the X-axis to “Percent Single-Family Homes” and the Y-axis to “Percent Commutes 30+ Minutes.” (Delete the legend from your scatter plot, since there is only one series.) To complete your scatter plot, insert a line that represents the line of best fit. Click on the scatter plot points, right click, and go to “Add Trendline”. Then choose “linear” as the type. Question 9: Cut and paste your scatter plot (with line of best fit drawn) in your Word document. Finally, you’ll create one last chart. This one will represent the distribution of vehicles available to households in the entire dataset. First, you’ll need to sum up the number of households with different numbers of vehicles available across all zip codes. Use Excel’s SUM function for this. Then, select your newly-summed cells and create a pie chart of these values (Insert -> Chart, and then choose a pie chart option). Label your chart with a title, and ideally with labels for each pie slice (you can get Excel to label them for you if you select both the newly-summed cells and the pie slice titles when you create your chart). Question 10: Cut and paste your pie chart into your Word document. Your Word document with answers to these questions, as well as your Excel table from step 2, are due via the link on Canvas found under the “Assignments” tab no later than Monday night 3/23 before midnight. 3 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, ...
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

Here is the final file containing the solutions.

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,0...

geobalies (1202)
Purdue University

Anonymous
Thanks for the help.

Anonymous
Outstanding. Studypool always delivers quality work.

Anonymous
Tutor was very helpful and took the time to explain concepts to me. Very responsive, managed to get replies within the hour.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags