Question 2: The file P02_35.xlsx contains data from a survey of 500 randomly selected households. Use Excel filters to answer the following questions.

a) Compute the following for all homeowners residing in the southeast part of the city: 1. the average monthly home mortgage payment, 2. the average utility bill, 3. the average total debt excluding the mortgage. [ 3 points]

b) Compute the following for all homeowners residing in the northwest part of the city. 1. the average monthly home mortgage payment, 2. the average utility bill, 3. the average total debt excluding the mortgage [ 3 points]

c) Compare the two parts of the city, namely, southeast and northwest based on the summaries you have made in parts a and b of this question. [ 7 points]

d) Suppose the summaries in parts a and b of this question were very similar will you decide to treat the two parts of the city together in your later studies? Give reasons for your answer. [ 6 points]

e) What percentage of the households are owned by a single person? [ 3 points]

• Did Question A and B but not write about graphs. The rest of word document is a template

P02 35 (2) Q Search Sheet '+ Share Home Insert Page Layout Formulas Data Review View 2 AutoSum X Cut Calibri 11 . A- A = =1 Wrap Text General Fill Copy Sort & Paste Merge & Center $ % 2 00 $.0 Conditional Format Cell Insert Delete Format Clear Format Formatting as Table Styles Filter J1 X v fx Q R S T U B C H M N 0 P 1 |Household Family Size Location Ownership First Income Second Income Monthly Payment Utilities Debt 2 Northeast $58,206 $38,503 $1,585 $252 $5,692 6 Northeast $48,27 $29,197 $1,314 $216 $4,267 Southwest $37,587 $28,16 $383 $207 $2,90 Northwest $56,610 $1,002 $249 $3,896 Southeast 37,731 $21,454 $74 $217 $3,011 Northwest $30,43 $26,00 $991 $208 $3,718 1 Northwest $47,96 $849 $243 $5,907 Northwest $55,487 $752 $242 $2,78 3 Northeas $59,947 $1,49 $256 $6,275 6 Northwest 36,970 $31,838 $991 $222 $4,845 Northwest $53,11 1,16: $251 $5,267 $27,35 $20,969 $619 $209 $2,25 Northwest $48,064 $1,43- $250 $3,918 2 Southwest $29,692 $20,617 $997 $190 $879 4 Southwest $25,853 $948 $254 $4,606 3 Northwest $49,72 $1,378 $272 $5,427 $49,88 $29,240 $902 $201 $3,48 4 Northwest $46,26 $1,62 $256 $6,658 2 Northwest $49,809 $834 $253 $4,234 4 Southwest $43,640 $729 $259 $5,393 Northwest $57,39 $1,473 $248 $4,456 Southeast $52,847 $1,038 $245 $3,99 Northeast $59,486 $933 $251 $2,598 4 Northeast $57,577 $52,088 $903 $255 $6,261 $63,825 $1,346 $250 $5,402 3 Northwest $66,86 $57,97 $574 $202 $3,911 $48,376 $39,894 $1,407 $257 $5,88 4 Southwest $33,646 $606 $264 $4,27 3 Northeas $65,241 $47,205 $699 $254 $5,737 Northwest $34,531 $21,536 $988 $264 $5,538 Southwest $18,84 $12,196 $746 $214 $1,852 3 Northwest $49,181 $35,091 $1,510 $264 $7,02 4 Northeast $65,276 $61,140 $1,091 $261 $7,212 2 Southwest $23,597 $20,798 $402 $211 $1,796 Southeast $28,851 $22,682 $696 $225 $3,452 Northeast $62,27 $31,231 $1,54 $249 $6,428 Northwest $42,639 $32,912 $919 $258 $4,46 2Northeast $35,592 $23,074 $1,66 $245 $5,516 Northwest $49,777 $27,773 $1,049 $256 $5,239 Southwest $21,451 $13,309 $493 $259 $3,731 Southeast $37,808 $28,022 $722 $286 $7,228 Northwest $56,375 $881 $261 $3,441 5 Northeast $67,798 $33,945 $1,424 $264 $6,067 Source Data + + 100% ReadyP02 35 (2) Q Search Sheet '+ Share Insert Page Layout Formulas Data Review View Home 2 AutoSum Cut Calibri 11 A- A = Wrap Text General Fill Copy Insert Delete Format Sort & BI UTYM A. Merge & Center $ ~ % 2 00 $.0 Conditional Format Cell Clear Filter Paste Formatting as Table Styles Format J1 v fx E F G H K L M N P Q R S T U v A B D $35,289 $457 $192 $1,73 45 Southwest $277 $6,153 46 5 Northeast $63,354 $52,656 $1,45 47 2 Southeast $30,693 $23,046 $977 $199 $3,76 $68,806 $1,453 $251 $4,930 2Northeast $1,658 $257 $6,025 Northeast $66,770 1 Northeast $59,321 $1,664 $247 $5,314 4 Northeast $49,954 $30,758 $1,062 $260 $5,179 2 Northeast 55,752 $37,404 $1,660 $253 $5,768 Southeast $43,436 $21,855 $699 $215 $2,767 Southeast $36,78 $21,609 $573 $279 $5,311 Northwest $64,489 $43,448 $748 $207 $3,934 Northwest $30,433 $23,92 $1,318 $244 $4,648 5 Southwest $20,234 $17,507 $572 $223 DEO'ES Southeast 32,848 $720 $254 $4,113 2 Southwest $16,25 $11,539 $669 $206 $1,428 Northeast $75,225 $71,930 $1,272 $260 $6,434 2 Southeast $38,838 $36,513 $1,084 $247 $4,42 3 Northeast $60,993 $44,220 $1,476 $257 $6,67 Northwest 31,051 $26,520 $1,033 $195 $1,821 Northwest 43,847 $847 $244 54,264 1 Sou $39,862 $1,472 $250 $4,809 2 Southwest $27,222 $17,215 $520 $201 $3,705 2 Southwest $27,651 $18,644 $501 $195 $3,66 3 Northeast 53,650 $50,636 $1,292 $259 $7,043 Northwest $42,168 $39,108 $490 $221 $1,739 4 Southeast $36,472 $33,837 $1,435 $260 $5,895 2 Northeast $66,346 $1,914 $247 $6,584 4 Northwest $63,572 $54,048 $1,123 $249 $6,16 Southeast $50,233 $39,539 $1,293 $259 $7,177 Southwest $35,46 $28,368 $776 $212 $3,949 2 Northeast $77,89 $74,072 $875 $246 $6,309 4 Northeast $53,117 $48,393 $1,534 $254 $6,956 4 Northeast $56,310 $41,558 $1,283 $261 $7,363 $58,563 $1,138 $4,848 Northwest $43,579 $277 2 Southeast $33,10 $976 $249 $3,634 4 Northwest $34,259 $28,438 $1,302 $251 $5,235 $26,910 $1,028 $244 $3,752 1 Northeast 5 Southeast $36,065 $28,020 $640 $278 $5,430 Northeast $56,330 $54,315 $989 $254 $5,429 2Northwest $54,86: $41,329 $1,751 $245 $6,172 $48,30 $752 $265 $5,131 Southeast $36,37 $207 $3,187 Southwest $32,341 $428 5 Northwest $60,940 $57,432 $888 $218 $2,615 $254 $7,415 Northwest $53,249 $39,777 $1,469 -1.. Source Data + + 100% ReadyQ Search Sheet P02 35 (2) '+ Share View Insert Page Layout Data Review Home Formulas 2 AutoSum Cut Calibri 11 A- A = =1 Wrap Text General Fill Sort & Copy Conditional Format Cell Insert Delete Format Clear Filter Formatting as Table Styles Paste BI UTYM A. Merge & Center $ ~ % ) 60 $.0 Format J1 v fx U V G H J K L M N 0 P Q R S T D E A B C $943 $259 $4,752 90 89 2 Northeast $59,064 $53,54 3 Southwest $32,061 $27,840 $577 $202 $983 91 90 $815 $254 $3,233 91 Southwest $27,377 $1,13 $199 $3,285 92 Northeast $48,232 $30,728 $52,654 $1,278 $259 $4,497 93 Northeast $62,280 $37,18 $27,569 $1,014 $265 $5,736 94 Southeast 2 Northeast $64,154 $1,088 $259 $5,048 95 $86,39 $43,989 $1,137 $241 $6,145 96 2 Northeast $41,335 $959 $278 $6,188 97 Southwest $62,52 $831 $265 98 Northeast $55,85 $7,345 99 Southeast $41,49 $35,158 $578 $205 $3,144 $1,040 $275 $5,991 101 100 6 Northeast $45,391 $30,121 $1,233 $245 $3,895 102 101 Northeast $39,36 103 102 Northwest $75,86 $1,078 $239 $5,288 $202 $1,800 104 103 2 Southwest $36,588 $30,278 $602 $203 $3,120 105 104 Southeast $48,72 $48,694 $622 $1,503 $254 $6,411 106 105 3 Northwest $75,208 106 4 Northeast $38,740 $24,806 $568 $208 $2,584 107 26,219 $3,309 108 107 Southwest $16,165 $530 $211 $771 $242 $4,410 109 108 Southwest $32,806 109 Northwest $46,66 $29,334 $1,250 $255 $5,73 110 $1,300 $259 $5,481 111 110 4 Northeast $65,115 $53,755 $214 $2,916 112 Southeast $31,725 $576 111 $40,397 $65,60 $54,278 $992 $201 $2,671 113 112 Northwest 114 $43,657 $848 $191 $4,311 11 1 Northwest $37,52 $1,829 $250 $5,117 115 114 Southeast $73,734 $73,481 $1,731 $264 $4,112 116 115 3 Northeast $51,488 $670 $261 $3,671 117 116 Southeast $58,580 $55,806 $37,384 $1,676 $257 $6,247 118 117 Northwest $1,030 $246 $4,726 119 11 1 Southeast $31,40 $635 $270 $5,719 120 115 Southeas $48,45 $31,33 $40,858 $34,114 $1,049 $247 $5,212 121 120 2 Northwest $59,510 $1,58 $254 $5,924 122 121 2 Northeast $59,737 $24,478 $989 $196 $2,871 123 122 Southwest $655 $215 $3,067 124 123 Southwest $36,39 $27,650 125 124 Northeast $42,84 $36,96 1,50 $261 $4,963 $21,557 $14,32 $658 $217 $2,606 126 125 5 Southwest $689 $204 $2,759 127 126 Southeast $37,186 $24,577 128 34,806 $68 $20 $2,592 127 Southeast $964 $259 $3,933 129 128 Southeast $35,47 $21,271 $30,58 $17,372 $586 $223 $4,229 130 129 Southwest $248 $5,412 131 130 Northwest $52,44 $1,121 $39,096 $37,336 $1,203 $263 $6,631 132 131 Northwest $2,812 133 5 Southwest $24,128 $13,88 $762 $216 132 Source Data + + 100% ReadyQ Search Sheet P02 35 (2) '+ Share Home Insert Page Layout Formulas Data Review View 2 AutoSum X Cut = =1 Wrap Text General Calibri 11 A- A Fill $ ~ % 2 00 $.0 Conditional Format Cell Insert Delete Format Sort & Merge & Center Clear Filter Paste Formatting as Table Styles Format J1 v fx U V G H J K L M N P Q R S T A B D E $560 $201 134 133 Southwest $46,342 $2,792 $626 $223 $2,961 135 134 3 Southwest $23,30 $20,987 $953 $239 $3,86: 136 135 1 Southwest $39,578 Northeast $49,132 $2,171 $250 $6,796 137 136 $36,00 $810 $252 $5,963 138 137 Northeast 56,838 $32,021 138 4 Northeast $61,955 $57,44 $1,460 $253 $6,727 139 $1,514 140 139 Northwest $71,21 $253 $5,135 141 140 Southwest $28,83 $569 $202 $1,552 $228 $5,593 142 141 5 Southeast $34,354 $22,543 $778 $24,44 $12,940 $558 $205 $2,013 143 142 4 Southwest $680 $223 $2,408 144 143 Southwest $22,25 $19,683 144 Northwest $48,91 $40,063 1,00 $268 $6,81 145 $814 $2,163 146 145 Southwest $25,71 $191 147 146 Southwest $22,991 $14,38 $1,252 $257 $4,661 $84,820 $70,096 $1,467 $245 $6,661 148 147 Northeast $27,721 $723 $198 $2,082 149 148 Southwest $237 $5,906 150 149 Northwest $39,602 $32,198 $848 $210 $2,072 151 150 3 Northwest $31,100 $28,489 $1,08 $1,47 $257 $6,623 152 151 Northeast $58,451 $29,753 $215 153 152 Southwest $20,27 $14,502 $50o $2,794 154 153 Southeast $33,96 $33,168 $991 $243 $4,006 Northwest $45,86 $246 $6,206 155 154 $1,37 $62,071 $1,326 $255 $6,18 156 155 1 Northeast $601 $211 $1,185 157 156 Southwest $30,557 158 $30,48 $18,68 $588 $208 $4,557 157 Southwest $262 $7,904 159 158 3 Northwest $90,48 $68,619 $1,537 $4,504 160 159 $1,601 3 Northwest $61,17 $35,481 $261 $28,378 $644 $256 $4,375 161 160 3 Southwest $39,847 $32,802 $1,573 $253 $5,097 162 161 Northeast $37,154 $657 $201 $1,348 163 162 Southwest Northwest $42,84 $33,96 $892 $213 $2,551 164 163 $1,248 $271 $6,969 165 164 5 Northeast $56,072 $55,593 $770 $201 $2,584 166 165 3 Southeast $33,447 $21,920 $257 $8,190 167 166 4 Northwest $28,822 $22,936 $959 $871 $249 $4,591 168 167 Northwest $33,018 $1,117 $260 $4,560 169 168 3Northeast $30,22 $6,285 170 169 5 Southeast $42,17 $40,211 $1,269 $278 $627 $198 $1,854 171 170 2 Southeast $28,340 $18,53 2 Southeast $43,027 $38,600 $1,235 $251 $4,694 172 171 $926 $252 $7,161 173 172 Northeast $76,547 $53,513 174 173 Southwest $41,275 $35,920 $1,120 $206 $3,826 $3,274 175 174 Northeast $59,70 $1,070 $255 176 $68,115 $1,159 $205 $6,910 175 3 Northwest $65,099 $847 $209 $2,171 177 176 Southeast $25,755 $20,267 Source Data + + 100% ReadyQ Search Sheet P02 35 (2) '+ Share Page Layout Formulas Data Review View Home Insert 2 AutoSum X Cut A- A Wrap Text General Calibri 11 = = 1 Fill Sort & Copy Merge & Center $ ~ % 2 60 $.0 Conditional Format Cell Insert Delete Format Clear Filter BI UTY M. A. Formatting as Table Styles Paste Format J1 v fx S T U v E G H J K L M N 0 P Q R B D $25,75 $20,267 $847 $209 $2,171 177 176 Southeast $33,699 $797 $208 $227 178 177 1 Southwest $60: $202 $2,39 179 178 Northwest $36,38 180 179 4 Southwest $25,816 $20,90: $562 $209 $3,20 $17,213 $728 $207 $2,781 181 180 Northwest $30,415 $643 $205 $1,763 182 181 1 Northwest $34,150 $31,484 $24,850 $644 $233 $3,688 183 182 Southwest 183 Northeast $68,108 $57,895 $1,52: $275 $7,025 184 185 184 Southwest $26,78 $26,101 $1,059 $203 $3,864 $1,27 $246 $6,579 186 185 Northwest $68,299 $36,015 $1,150 $252 $3,073 187 186 Southeast $1,984 $255 56,440 188 187 Northwest $46,561 $26,631 $1,093 $271 $5,594 189 188 Southwest $52,43 $534 $201 $2,158 190 189 Southwest $37,650 $32,230 $34,308 $25,24 $963 $254 $5,121 191 190 Southeast $53,576 $48,666 $1,108 $257 $4,263 192 191 Northwest $46,249 $1,133 $254 53,931 193 192 Northwest $1,027 $247 $4,923 194 193 Southwest $33,94 Southwest $37,92 $653 $248 $4,017 195 194 196 195 4 Southwest $26,167 $16,259 $553 $212 $2,353 $40 $226 $4,354 197 196 10 Southwest $33,45 $22,267 198 197 4 Southwest $20,18 $16,653 $603 $218 $2,989 O O O O O P P P O O P O O O H O O P O P P P O O O P P P P P O P P P P O P o o o o o O O $263 $4,977 199 198 Northeast $65,69 $50,207 $1,065 199 $59,015 $34,549 $1,262 $254 $7,340 200 4 Northeast 201 200 6 Northeast $81,366 $45,44 $1,80 $267 $7,85 $31,198 $20,115 $497 $213 $2,092 202 201 4 Southwest $40 383 $31,270 $1,086 $256 $5,275 203 202 Northeast 203 Southeast $24,57 $23,26 $1,28 $207 $3,154 204 204 $18,637 $349 $212 $2,808 205 Southwest $30,002 206 205 1 Southwest $42,05 $884 $254 $4,607 $797 $209 207 206 $25,835 $15,362 $3,136 Southeast $478 $196 $1,657 208 207 Southwest $18,276 $746 $194 $854 209 208 Southwest $22,38 $676 $254 $5,112 210 209 Northwest $48,89 4 Northwest $60,953 $58,573 $1,186 $205 $3,374 211 210 $17,787 $674 $212 $1,587 212 211 *Southeast $29,322 Northwest $36,170 51,185 $253 $5,467 213 212 $70,692 $69,115 $1,088 $252 $6,915 214 213 Northeast $1,304 $262 $5,697 215 214 Northwest $36,742 $19,478 $36,23 $949 $207 $3,848 216 215 4 Southeast $39,255 $37,196 216 $43,737 $797 $206 $3,273 217 Northwest $33,059 $724 $205 $2,554 218 217 Northeast $41,401 $207 $2,954 219 21 $23,77 $17,567 $784 Southwest 220 219 4 Northeast $53,165 $33,644 $1,740 $199 $6,727 Source Data + + 100% ReadyQ Search Sheet *P02 35 (2) '+ Share Page Layout View Home Insert Formulas Data Review 2 AutoSum X Cut Calibri 11 A- A = =1 Wrap Text Custom Fill $ ~ % 2 60 $.0 Conditional Format Cell Insert Delete Format Sort & Merge & Center Clear Filter Paste Formatting as Table Styles Format J1 v fx N 0 P Q R S T U V E G H K L M A B C D J -207 $199 220 219 4 Northeast $53,16 $33,644 1,74 $6,727 220 2 Southeast $34,756 $21,101 $801 $205 $3,163 221 $49,479 $201 2 Southeast $48,20 $64 53,054 222 221 Northeast $72,949 $1,522 $200 53,729 223 222 $39,987 $538 $204 $1,570 224 223 1 Southwest 225 $34,204 $838 $197 $1,855 224 Northwest $38,975 $32,867 $369 $192 $2,494 226 225 Southwest $39,99 $796 $246 $3,657 227 226 1 Northwest $690 $214 227 $9,549 $2,672 228 Southwest $18,70 229 228 Southeast $52,965 $37,370 $766 $214 $5,498 $3,48 230 229 Northeas $65,31 $58,628 $1,687 $219 $287 $7,930 231 230 Northwest $32,630 $25,291 2 Northwest $56,645 $47,472 $797 $197 $2,910 232 231 $854 $276 $6,545 233 232 Northwest $40,270 $31,77 $33,538 $26,083 $617 $215 $2,375 234 233 Southwest $37,59 $1,05 $255 $5,605 235 234 Southwest $1,161 $254 $5,364 236 235 1 Northwest $59,579 237 $32,271 $17,847 $818 $211 $3,191 236 4 Southeast $1,377 $249 $4,882 238 237 Northwest $41,427 $745 $206 $2,100 239 238 3 Southeast $37,23 $20,488 $4,669 239 $31,519 $1,218 $245 240 Southeast $823 $244 $3,831 241 240 1 Northeast $73,980 $20,514 $18,732 $629 $256 54,441 242 241 4 Southwest 56,863 Northeast $1,787 $254 243 242 $81,612 $65,71 $1,251 $263 $6,689 244 243 4 Northwest $1,068 $254 $4,262 245 244 Northwest $50,15 246 245 2 Southwest $35,502 $829 $253 $3,371 247 Southeast $40,874 $33,446 $1,217 $260 $6,199 246 248 247 5 Southwest $38,42 $35,376 $398 $224 $3,822 $271 $6,338 249 248 Southeast $30,045 $25,054 $924 249 $31,64 $19,893 $821 $266 $5,859 250 Northwest $200 $2,03 251 2 Southwest $34,052 $17,805 $585 250 $47,336 $30,437 $1,044 $261 $4,896 252 251 4 Northwest $840 252 Northeast $38,007 $21,14 $259 $4,505 253 254 253 5 Southwest $21,40 $13,964 $788 $222 $2,503 $247 $4,631 255 254 Southwest $39,35 $495 $64,179 $1,432 $199 $4,287 256 255 1 Northeast $67,18 $756 $242 $4,742 257 256 1 Northeast $43,163 $22,622 $941 $208 $2,491 258 257 Southwest $51,37 $887 $191 $1,789 259 258 Northeast $953 $226 $3,829 260 259 Southwest $23,76 $21,36 $20,987 $214 $3,635 261 260 4 Southwest $14,189 $355 $49,819 $36,911 $960 $211 $2,853 262 261 3 Southeast $4,910 2 Northwest $1,266 $256 263 262 EDE'85$ Source Data + + 100% ReadyQ Search Sheet *P02 35 (2) '+ Share Home Insert Page Layout Formulas Data Review View 2 AutoSum X Cut Calibri 11 A- A = =1 Wrap Text Custom Fill Conditional Format Cell Insert Delete Format Sort & Merge & Center $ % 2 00 $.0 Clear Filter Formatting as Table Styles Paste Format J1 v fx U G H K L N 0 P Q R S T M A B D E F $71,130 $39,826 $1,262 $216 $5,036 264 263 4 Northeast $37,375 $985 $255 $3,616 265 264 3 Southeast $21,701 $20,331 $799 $206 $2,49 266 265 4 Southwest $27,70 $728 $203 $555 267 266 Southwest $203 $1,352 267 $32,420 $1,07 268 1 Northwest $65,740 $33,583 $1,04 $244 $4,646 269 268 2 Northeast $22,103 $893 $260 $4,997 270 269 Southwest 37,552 $58,18 $37,835 $1,576 $248 $8,318 271 270 Northeast $34,66 $724 $245 $4,596 272 271 Southwest $22,798 3 Southwest $38,63 $27,213 $549 $207 $2,706 273 272 $27,085 $965 $268 $5,298 274 273 3 Southeast $60,59 $1,16 $264 $6,004 275 274 3 Northeast 2 Northeast $98,88 $74,825 $1,295 $249 $6,60 276 275 $261 $7,12 277 276 5 Northwest $46,47 $37,134 $1,489 277 $54,374 $804 $252 $5,410 278 Southeas $62,321 $1,585 $249 $7,559 279 278 Northwest $64,630 $1,25 $254 $4,220 280 279 2 Southeast $39,320 $31,461 $20,94 $888 $207 $2,62 281 280 Southeast $21,55 $712 $222 $3,712 282 281 4 Southeast $38,38 $43,179 $909 $257 $5,218 283 282 Northwest $25,940 $525 $210 $1,619 284 283 Southwest $31,721 $28,83 $793 $205 $1,003 285 284 1 Southeast 285 2Northwest $65,85 $44,595 $908 $246 $6,546 286 $49,156 $838 $258 $5,598 287 286 4 Southeast $57,772 $48,72 $1,070 $269 $6,650 288 287 5 Northeas $45,455 $37,997 $732 $217 $2,263 289 288 Southeast $577 $5,140 290 289 1 Southeast $46,89 $244 $48,33 $37,13 $616 $230 $4,681 291 290 0 Southeast $653 $201 292 291 3 Southeast $38,092 $5,330 $50,72 292 Northeast $48,586 $679 $258 $4,678 293 $833 $206 $1,413 294 293 Southeast $29,289 $36,838 $621 $192 $2,365 295 294 1 Northwest Northwest $1,10 $4,371 296 295 $39,08 $259 $21,382 $16,970 $557 $215 $2,265 297 296 5 Southwest Northwest $42,39 $26,173 $1,008 $247 $3,516 298 297 $48,120 $41,952 $1,31 $246 $5,620 299 298 Northeast $35,34 $556 $239 $4,899 300 299 2Southwest $1,380 $272 $5,384 301 300 Northeast $75,049 $55,657 $790 302 301 Southeast $32,31 $260 $3,138 $46,289 $42,42: $778 $208 $2,39 303 302 3 Southeas $19,692 $895 $203 $2,350 304 303 Southwest $35,88 $6,846 305 304 Southeast $37,904 $23,890 $1,614 $267 $54,901 $28,768 $266 $5,224 306 305 Southeast $1,306 306 4 Southeast $32,649 $24,742 $1,103 $212 $4,999 307 Source Data + + 100% Ready*P02 35 (2) Q Search Sheet '+ Share Home Insert Page Layout Formulas Data Review View 2 AutoSum X Cut Calibri 11 A- A = =1 Wrap Text Custom Fill $ ~ % 2 60 $.0 Conditional Format Cell Insert Delete Format Sort & Merge & Center Clear Filter Paste Formatting as Table Styles Format J1 v fx N P Q R S T U V H K L M B D E F G J $32,649 $24,742 $1,10 $212 $4,999 307 306 4 Southeast $807 $241 308 307 2 Southwest $16,971 $3,459 $805 $258 $5,426 309 308 3 Southwest $34,43 $213 $2,962 310 309 Southwest $30,539 $22,543 $334 $623 $202 $1,340 311 310 1 Southwest $32,697 Northeast $84,886 $1,14: $260 $6,490 312 311 $205 $2,334 313 312 Northwest $29,38 $17,430 $875 $389 $2,560 313 4 Southwest $24,10 $20,31 $211 314 $36,493 $32,221 $1,43 $248 $5,504 315 314 2 Northwest $264 315 4 Northwest $55,50 $53,412 $5,924 316 $933 $264 $5,137 317 316 Southeast $39,627 $21,83 $28,910 $14,855 $490 $203 $1,12 318 317 2Southwest 4 Southeast $24,49 $1,136 $268 $4,678 319 318 320 319 Northwest $41,965 $36,33 $1,242 $256 $6,195 $205 $4,300 Northwest $1,038 321 320 $69,615 $63,710 $41,069 $1,493 $259 $3,374 322 321 Northeast $208 323 322 $613 $2,562 Southwest $22,09 $1,039 $266 $5,677 324 323 6 Northwest $40,81 $21,383 $1,40 $258 $4,857 325 324 Southeast $40,74 $21,699 $13,70 $418 $212 $3,074 326 325 Southeast $24,430 $20,987 $610 $214 $2,269 327 326 Southeast $254 $5,868 328 327 2 Southeast $49,74 $1,734 $760 $212 $3,45 329 328 4 Southwes $19,316 $10,680 $52,862 $42,294 $1,042 $279 $8,323 330 329 Northwest 331 330 Northeast $83,859 $65,582 $1,166 $209 $5,906 331 2 Northeast $46,023 $30,39 $1,589 $245 $5,452 332 $201 332 $26,35 $623 $2,097 333 Southwest 334 333 4 Northwest 50,383 $35,749 $614 $266 $6,669 Northwest $36,630 $22,871 $1,295 $268 $7,437 335 334 $853 $272 $5,070 336 335 Northwest $39,77 2 Southeast $38,89 $23,808 $1,06 $202 $1,664 337 336 338 337 Southeast $42,32 $28,42 $866 $279 $5,509 $43,891 $43,745 $1,707 $257 $6,445 339 338 3 Northeast 340 339 Northeast $71,659 $70,436 $1,138 $267 $5,896 $553 $221 $3,903 341 340 Southeast $35,24 $18,677 $558 $217 $2,818 342 341 5 Southwest $17,88 $10,50 342 $35,310 $675 $203 $2,738 343 Southwest $25,405 344 343 3 Southwest $25,16 $19,673 $519 $210 $2,46 345 $24,859 $509 $201 $2,119 344 1 Southwest $38,99 $26,86 $921 $208 $3,089 346 345 Northwest $24,58 $1,432 $264 $6,805 347 346 Southeast $30,38 $1,050 $268 $7,739 348 347 Northeast $56,967 $37,901 $974 $3,745 349 348 1 Southwest $53,283 $248 $1,217 $264 $6,412 350 349 Northwest $44,436 $32,162 Source Data + + 100% ReadyQ Search Sheet *P02 35 (2) '+ Share Home Insert Page Layout Formulas Data Review View 2 AutoSum X Cut Calibri 11 A- A = =1 Wrap Text Currency Fill Conditional Format Cell Insert Delete Format Sort & Merge & Center $ ~ % 2 60 .0 Clear Filter Paste Formatting as Table Styles Format H350 fx 264 N 0 P Q R S T U D E G B H K L M 4 Southwest $30,527 $27,055 $765 $209 $2,204 351 350 351 5 Northeast $95,58 $71,59 $1,25 $262 $9,104 352 $218 $3,87 353 352 Southeast $24,06 $18,095 $755 $28,950 $18,542 $427 $205 $2,06 354 353 2 Southwest $201 $3,032 355 354 2 Southeas 33,176 $23,89 $711 $37,297 $28,010 $1,830 $212 $5,425 356 355 4 Northeast Northwest $33,653 $26,704 $1,055 $256 $3,773 357 356 2 Southeast $33,72 $192 $1,58 358 357 $27,480 $622 $931 $202 $4,32 359 358 2 Northwest $45,572 $23,21 $46,67 $28,87 7 $1,054 $215 $2,258 360 359 Northwest 361 360 $37,093 $18,561 $1,287 $248 $3,511 Northeast 362 361 2Southeast $36,58 $32,728 $729 $199 $3,123 363 362 2 Northeast $43,93 $41,731 $1,80 $252 $5,914 $28,068 $17,927 $603 $206 $3,203 364 363 Southwest $249 $5,542 365 364 Northeas $75,737 $1,596 Northwest 37,107 $30,047 $1,331 $271 $7,349 366 365 $1,355 $256 $4,343 367 366 Northeast $62,63 $59,352 367 Northeast $63,946 $1,321 $251 $6,548 368 $62,523 369 368 Southeast $35,94 $20,49 $568 $214 $3,001 $24,992 $579 $242 $3,225 370 369 Southwes $48,64 $36,65: $1,439 $264 $6,628 371 370 Northeast 371 Southeast $26,619 $707 $201 $2,765 372 $27,160 $250 373 372 4 Northeast $49,69 $1,516 $5,072 $47,65 $26,82 $1,051 $257 $5,891 374 373 Northeast $212 $2,326 375 374 3 Southeas $39,778 $33,336 $812 $21,586 $231 $4,468 376 375 7Northwest $31,090 $694 $753 $253 $6,474 377 37 2 Southeast $42,708 $41,601 378 377 Southeast $31,238 $29,402 $827 $216 $3,57 $252 $4,16 379 378 Northeast $60,24 $989 380 379 4 Northwest $37,117 $34,071 $523 $206 $4,268 381 380 4 Northeast $43,832 $32,996 $760 $200 $3,188 $35,10 $960 $201 $2,372 382 381 Southeast $45,60 $991 $209 $3,848 383 382 Northeast $29,60 $41,914 $38,478 51,22: $270 $5,346 384 383 4 Northwest 385 384 Northwest $51,202 $29,289 $1,619 $267 $6,031 385 $22,39: $11,802 $549 $213 $3,051 386 Southwest 3Northwest $49,44 $36,562 $854 $208 $4,042 387 386 388 387 5 Northeast $83,36 $72,930 $1,799 $267 $6,072 $566 $209 $1,817 389 388 2 Southwest $25,997 $13,29 4 Southwest $46,656 $31,044 $671 $210 $2,493 390 389 $247 $7,728 391 390 Northeast 56,857 $49,696 $1,533 Northwest $49,943 $34,731 $873 $267 $6,309 392 391 $6,34 392 Northwest $72,515 $1,085 $250 393 $53,248 $44,398 $490 $192 $1,827 394 393 2 Northwest Source Data + + 100% ReadyQ Search Sheet *P02 35 (2) '+ Share Page Layout Formulas Data Review View Home Insert 2 AutoSum X Cut Calibri 11 A- A = =1 Wrap Text Currency Fill Insert Delete Sort & Merge & Center $ % 2 60 .0 Conditional Format Cell Format Clear Filter Styles Paste Formatting as Table Format H350 fx 264 K L M N 0 P Q R S T U v G H A B D E $35,572 $31,43 $914 $249 $3,566 395 394 2Northeast $31,348 $1,176 $5,659 396 395 4 Southeast $32,425 $253 396 2 Southeast $46,27 $40,282 $941 $208 $1,49 397 398 397 Northwest $85,621 $81,979 $1,82 $260 $6,289 $1,081 $252 $3,388 399 398 2 Northwest $25,076 $21,758 $38,697 $24,277 $765 $203 $4,138 400 399 2 Southwest $405 $216 53,187 401 400 Southwest $32,794 $32,70 $538 $2,049 402 401 2 Southwest $26,10 $13,983 $204 $234 $3,826 403 402 Southwest $25,65 $23,464 $493 $719 $225 $2,609 404 403 3 Southeast $44,158 $32,61 $925 $265 $4,894 405 404 6 Southeas $24,114 $13,57 $453 $218 $1,974 406 405 Southwest 24,503 $16,321 1,15 407 406 1 Northeast $48,914 $249 $5,167 408 407 Southwest $23,69 $16,558 $510 $211 $2,722 409 408 5 Southwest $30,372 $799 $279 $4,205 410 Southeast $24,30 $15,46 $540 $199 $3,30 409 $961 $257 55,067 411 410 2 Northwest 35,079 $29,542 $820 $205 $1,551 412 411 Northwest $25,886 $199 $3,250 413 412 2 Northwest $45,62 $40,58 $887 $773 $270 56,248 414 413 3 Southeast $39,341 $34,520 $32,43 $22,666 $780 $248 $3,482 415 414 Southwest 416 415 2 Northwest 64,570 $62,590 $931 $202 $3,311 $55,66 $1,048 $252 $6,545 417 41 Northeast $530 $213 $2,780 418 417 Southwest $31,65 $31,596 419 418 4 Northeast $85,374 $53,417 $1,103 $255 $6,845 $4,260 420 419 Northeast $76,80 $258 $956 $251 $5,524 421 420 Southeast $38,681 $33,853 421 Southwest $26,380 $22,382 $648 $232 $4,229 422 $71,206 $56,268 $1,009 $276 $6,647 423 422 Northwest $69,863 $57,019 $1,70 $245 $5,764 424 423 2 Northeast $37,435 $21,724 $996 $201 $4,289 425 424 2 Southeas Northeast $42,419 $40,654 $1,187 $206 $2,911 426 425 $735 $200 427 426 Southeast $43,48 $1,783 $48,43 $44,434 $1,147 $262 $5,940 428 427 Northwest 45,038 $984 $201 $2,030 429 428 Northeast $633 $211 $818 430 429 1 Southwest $33,08 $45,993 $1,689 $248 $4,652 431 430 1 Northeast $994 $257 $5,226 432 431 Southeast $45,220 $25,914 433 432 Southeast $29,40 $857 $203 $2,68 434 433 3 Southeast $34,933 $21,84 $1,705 $256 $6,158 $37,614 $980 $259 $5,56 435 434 4 Northeast $49,206 436 435 4 Southeast $61,764 $1,066 $250 $6,303 $1,70 437 436 Northeast $64,98 $34,370 $261 $5,562 Southeast $20,844 $11,948 $861 $216 $1,656 438 137 Source Data + + 100% ReadyQ Search Sheet *P02 35 (2) '+ Share Page Layout Formulas Review View Home Insert Data 2 AutoSum X Cut Currency Calibri 11 A- A = =1 Wrap Text Fill $ ~ % 2 60 $.0 Insert Delete Format Sort & Merge & Center Conditional Format Cell Clear Filter Formatting as Table Styles Paste Format H350 fx 264 L M N 0 P Q R S T U K B D E G H $2,489 438 $33,620 $831 $194 439 2 Northwest $53,607 $38,48 $31,892 $475 $210 $2,301 440 439 Southeast $1,128 $252 $3,816 441 440 1 Northeast $56,15 $595 $204 $3,482 442 441 2 Southwest $31,11 $30,70 $274 $5,44 443 442 5 Northeas $53,338 $793 6 Southeast $25,246 $15,707 $954 $222 $4,001 444 443 4 Northeast $32,70 $25,029 $1,14 $252 $4,802 445 444 $79,69 $42,497 $814 $273 $7,04 446 445 Northeast 447 446 2 Southwest $24,327 $24,25 $628 $194 $1,67 Northwest $84,098 $60,045 $1,21 $267 $5,861 448 447 449 448 Southwest $23,653 $15,052 $474 $216 $1,623 450 $58,30 $1,171 $247 $5,803 449 2 Northeast $918 $200 $2,68 451 450 1 Northwest $47,57 $547 $215 $2,538 452 451 Southwest $20,435 $18,013 $1,068 $249 453 452 $84,675 $4,130 2 Northeas $42,60 $30,072 $931 $220 $2,958 454 453 Northwest $930 $207 $2,340 455 454 Northwest $35,04 $18,189 $206 455 Southeast $18,787 $13,096 $719 $3,330 456 $597 $196 $1,59 457 456 Northwest $32,125 38,157 $27,643 $727 $264 $5,260 458 457 3Northeas 458 Southeast $29,101 $15,967 $500 $206 $3,447 459 $37,86 $30,059 $941 $262 $5,642 460 459 Northwest $17,435 $934 461 $26,10 $215 $2,932 460 Southeast $265 $6,725 462 461 Northwest $55,264 $46,778 $1,42 29,718 $17,955 $1,240 $206 $2,851 463 462 2 Southeas $783 $251 $3,871 464 463 4 Southeast $34,884 $214 $3,210 465 464 Southeast $33,46 $30,032 $1,286 $18,11 $1,45 $211 $3,523 466 465 Southeast $46,10 $44,847 $820 $286 $6,840 467 466 8 Northeast $259 $5,107 468 467 Northwest $48,369 $1,222 $45,275 $29,055 $1,076 $197 $1,686 469 468 2Northeast $1,029 $259 $3,978 470 469 1 Southeast $35,430 $615 $208 $2,658 471 470 Southwest $42,24 $32,38 472 471 3 Northwest $84,823 $44,388 $1,13 $254 $5,801 $249 473 472 $60,06 $3,578 Northeast $1,434 28,534 $760 $255 $3,281 474 473 2 Southwest $30,43 $28,204 $584 $260 $4,823 475 474 Southwest $1,033 $5,88 475 Northwest $53,18 $41,624 $254 476 $562 $205 $2,962 477 476 Southeast $49,358 $1,732 $253 $5,370 478 477 1 Southeast $41,628 $1,780 $6,341 479 478 3Southeast $46,389 $258 $1,307 $246 $5,460 480 479 2 Northwest $85,051 $1,078 $3,606 481 Southeast $46,703 $40,502 $205 480 $17,587 $680 $208 $1,909 482 481 3 Southwest $33,268 and Source Data + + 100% ReadyQ Search Sheet *P02 35 (2) '+ Share View Home Insert Page Layout Formulas Data Review 2 AutoSum Currency X Cut Calibri 11 A- A = =1 Wrap Text Fill $ ~ % 2 60 $.0 Conditional Format Cell Insert Delete Format Sort & Clear Filter Merge & Center Formatting as Table Styles Paste Format fx 264 N 0 P Q R S T U V H350 G H K L M A B C D E 340,703 zocinet 31,070 401 ispaininne c $17,58 $208 482 Southwest $33,26 $680 $1,90 481 $6,806 482 3 Northeast $76,435 $40,136 $1,009 $259 483 2Southwest $21,464 $248 483 $37,450 $618 53,098 484 $638 $196 $2,896 485 484 Southeast $47,244 $29,51 $1,001 $213 $3,43 486 485 Southeast $57,525 $4,619 3 Southwest $33,91 $31,371 $713 $259 487 486 $37,465 $1,436 $261 $5,744 488 487 3 Northwest $50,64 $999 $197 $1,629 $26,610 489 488 Southeast $52,656 $30,42 $747 $256 $6,447 490 489 Northeast Southeast $35,49 $253 $4,684 491 490 $49,255 $1,280 $31,142 $18,969 $400 $218 $3,409 492 491 3 Southwest 5 Northwest $39,18 $24,834 $1,067 $275 $6,570 493 492 $26,25 $484 $215 $1,458 $46,379 494 493 Southwest $88: $248 $3,137 495 494 1 Southeast $42,313 $1,032 $246 $6,001 496 495 2Northwest $46,828 $39,596 $34,067 $1,18 $197 $3,194 497 496 Northwest $42,758 $54,716 $990 $274 $8,400 $66,397 498 497 5 Northeast $43,599 $33,36 $1,603 $253 $5,675 499 498 2 Northeast $831 $266 $4,879 499 $25,71 500 4 Southwest $948 $251 $3,278 501 500 Southwest $39,187 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 + 100% Source Data + ReadyW BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q . Search in Document Home Insert Design Layout References Mailings Review View '+ Share Line Numbers Indent Spacing *E Left: 2.08 cm Before: 4.5 pt Margins Orientation Size Columns Breaks bc Hyphenation Position Wrap Bring Send Selection Align Group Rotate Right: 2.08 cm After: 0 pt Text Forward Backward Pane Question 2 c) Given first household wage earners who rent their home (Ownership = House or apartment) a) Given all homeowners residing in the southeast part of the city (Location = SE sector Location Southwest and Ownership = own home) Sum of Sum of First Location Southeast Row Labels Debt Income 60417 835557 Row Labels Average of Monthly Payment Average of Utilities Average of Debt 73885 304716 $984.70 $226.90 $3,383.85 95164 965524 86655 IN $949.46 $224.43 $3,784.36 717849 $927.42 $230.66 $3,823.26 41201 360896 $229.33 10417 71919 $898.39 $4,179.61 7514 57139 $828.08 $251.75 $5,033.25 4229 26380 $939.50 $243.50 $4,447.50 10 4354 33456 7 $722.00 $286.00 $7,228.00 Grand Total 383836 3873436 10 $616.00 $230.00 $4,681.00 Grand Total $923.72 $231.16 $3,961.33 Given first household wage earners who own their home (Ownership = own home) b) Given all homeowners residing in the northwest part of the city (Location = NW sector and Ownership = own home) The average annual income of the first household who rent their home is Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard Location Northwest dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic Row Labels Average of Monthly Payment Average of Utilities Average of Debt typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of $1,001.80 $230.12 $3,992.68 Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. $1,073.80 $231.00 $4,341.00 WN $1,165.75 $243.44 $4,914.36 $1,103.89 $248.21 $5,436.63 d) Given the surveyed households who owns his or her home, the proportion contains a $1,066.00 $249.75 $5,119.08 single person $988.13 $264.63 $6,100.25 $771.00 $234.00 $5,187.00 Proportion = Number of homeowner contains a single person $1,042.00 $279.00 $8,323.00 $1,391.00 $287.00 $7,930.00 Households who owns a home Grand Total $1,081.42 $241.52 $4,848.16 00 The average monthly payment is comparatively Lorem Ipsum is simply dummy text of the 00 printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text = 000 (000%) ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic ypesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop The proportion of the surveyed households contains a single person who owns his or her publishing software like Aldus PageMaker including versions of Lorem Ipsum. home is 0000%. (EXAMPLE OF WRITING) Page 5 of 10 1376 Words English E Focus 116%