Household Family Size Location Ownership Income Monthly Payment 1 4 2 1 $93,564 $1,262 2 4 3 0 $60,640 $827 3 4 4 1 $39,246 $629 4 4 1 1 $102,242 $1,108 5 3 4 0 $60,715 $675 6 1 3 1 $46,890 $577 7 3 3 0 $72,122 $576 8 2 3 0 $53,739 $977 9 2 2 1 $76,416 $1,589 10 1 4 0 $22,091 $613 11 1 1 0 $36,384 $601 12 1 3 0 $34,806 $681 13 6 1 1 $127,474 $1,009 14 4 4 0 $52,889 $1,059 15 1 1 0 $43,657 $848 16 2 4 0 $46,295 $501 17 3 2 1 $72,649 $1,573 18 3 2 1 $106,553 $1,533 19 5 4 0 $63,253 $530 20 3 1 1 $48,369 $1,222 21 3 3 0 $61,763 $689 22 3 1 1 $78,300 $1,242 23 3 2 1 $71,653 $1,086 24 3 2 1 $79,808 $1,500 25 6 1 0 $68,808 $991 26 7 1 0 $71,800 $848 27 4 1 1 $80,392 $1,223 28 4 4 0 $36,835 $603 29 1 1 1 $71,211 $1,514 30 4 4 1 $59,655 $893 31 4 4 0 $46,719 $562 32 5 4 0 $41,942 $680 33 2 2 1 $154,916 $1,467 34 5 4 0 $45,123 $953 35 2 3 1 $56,750 $964 36 2 3 1 $67,131 $991 37 4 4 1 $43,640 $729 38 1 1 0 $34,150 $643 39 2 3 0 $97,682 $647 40 3 4 0 $48,634 $349 41 6 2 1 $75,512 $1,040 42 2 3 0 $47,673 $1,240 43 6 2 0 $77,470 $1,314 44 1 1 1 $39,991 $796 45 5 3 0 $51,533 $696 46 5 2 1 $53,338 $793 47 2 2 1 $76,963 $1,603 48 5 1 1 $56,220 $1,304 49 2 2 1 $173,706 $1,295 50 2 1 1 $96,192 $1,751 51 4 4 0 $59,621 $617 52 2 4 0 $44,437 $520 53 2 2 1 $55,665 $1,048 54 4 3 1 $59,555 $963 55 4 1 0 $56,441 $991 56 2 2 1 $110,645 $989 57 1 3 0 $43,482 $735 58 3 2 1 $112,446 $699 59 3 4 0 $48,319 $619 60 3 2 1 $139,807 $1,088 61 4 2 0 $74,460 $724 62 4 1 1 $51,758 $959 63 3 1 1 $48,893 $676 64 1 1 1 $45,869 $1,377 65 3 3 0 $55,362 $770 66 3 2 1 $114,934 $1,278 67 3 4 0 $74,636 $615 68 3 4 1 $28,378 $644 69 2 3 0 $79,123 $902 70 2 2 1 $119,247 $1,588 71 4 3 1 $24,493 $1,136 72 3 2 0 $83,073 $1,187 73 1 1 1 $75,865 $1,078 74 2 3 1 $84,746 $1,280 75 2 2 1 $66,346 $1,914 76 2 3 0 $57,073 $711 77 3 1 1 $159,107 $1,537 78 4 3 0 $50,118 $818 79 1 1 1 $59,579 $1,161 80 2 1 1 $68,563 $1,008 81 2 1 1 $74,972 $1,049 82 5 3 1 $64,085 $640 83 4 1 1 $108,918 $1,112 84 1 4 0 $46,342 $560 85 9 4 0 $48,762 $648 86 5 1 1 $76,432 $1,203 87 4 1 0 $119,526 $1,186 88 2 4 0 $43,765 $490 89 2 2 1 $74,486 $1,051 90 2 4 0 $50,309 $997 91 4 4 1 $33,646 $606 92 1 2 0 $45,038 $984 93 2 4 0 $62,974 $765 94 3 3 0 $56,437 $568 95 2 2 1 $68,806 $1,453 96 3 1 1 $129,211 $1,136 97 2 2 1 $88,859 $810 98 2 1 1 $41,427 $1,377 99 1 2 1 $26,910 $1,028 100 3 2 1 $87,636 $1,707 101 3 2 1 $147,215 $1,731 102 2 1 0 $97,646 $490 103 1 4 0 $24,859 $509 104 2 1 1 $49,809 $834 105 2 3 1 $89,772 $1,293 106 4 2 1 $57,734 $1,142 107 3 3 1 $61,458 $933 108 2 2 0 $78,960 $1,134 109 2 4 0 $55,575 $895 110 2 4 1 $35,502 $829 111 3 3 1 $46,389 $1,780 112 3 3 0 $46,022 $847 113 2 3 1 $39,320 $1,259 114 3 3 0 $88,816 $653 115 3 1 1 $43,179 $909 116 3 2 1 $126,469 $1,321 117 4 2 1 $48,586 $679 118 1 4 0 $30,557 $601 119 1 2 1 $45,993 $1,689 120 2 4 0 $66,866 $602 121 4 3 1 $70,304 $1,435 122 2 2 1 $55,654 $1,287 123 3 3 1 $83,669 $1,306 124 1 3 0 $35,105 $960 125 4 2 0 $86,809 $1,740 126 2 2 1 $64,154 $1,088 127 4 4 0 $42,032 $799 128 1 1 1 $48,064 $1,434 129 1 2 0 $51,372 $887 130 4 2 1 $109,665 $903 131 4 2 1 $118,377 $831 132 2 1 1 $85,051 $1,307 133 4 2 1 $121,986 $1,355 134 4 2 1 $118,870 $1,300 135 4 1 1 $102,042 $1,420 136 2 3 0 $59,159 $996 137 5 4 0 $53,082 $334 138 4 2 0 $65,307 $1,830 139 4 2 1 $138,791 $1,103 140 4 2 0 $63,546 $568 141 3 3 1 $73,861 $773 142 5 1 0 $76,802 $892 143 2 3 1 $72,534 $956 144 1 4 0 $27,700 $728 145 6 1 1 $67,154 $1,331 146 3 1 0 $80,933 $797 147 3 4 1 $37,599 $1,058 148 3 3 1 $74,320 $1,217 149 1 4 1 $27,377 $815 150 3 3 1 $110,068 $670 151 1 4 1 $24,992 $579 152 3 2 1 $116,571 $1,009 153 3 3 0 $35,403 $418 154 4 3 0 $31,878 $719 155 5 3 1 $58,389 $573 156 3 3 0 $45,417 $610 157 8 2 1 $90,947 $820 158 2 1 0 $68,785 $931 159 2 3 1 $31,519 $1,218 160 3 1 0 $76,825 $1,184 161 1 2 1 $60,069 $1,434 162 2 4 0 $61,823 $595 163 2 3 1 $49,744 $1,734 164 3 3 1 $40,742 $1,403 165 4 2 1 $101,510 $1,534 166 10 4 0 $55,723 $405 167 3 2 1 $93,507 $1,548 168 5 4 1 $30,372 $799 169 1 4 1 $39,578 $953 170 8 1 1 $95,156 $1,042 171 3 1 1 $84,272 $1,510 172 5 4 0 $65,498 $405 173 3 1 1 $93,190 $1,676 174 4 1 1 $117,620 $1,123 175 6 3 0 $40,953 $954 176 1 3 0 $26,610 $999 177 2 1 1 $46,249 $1,133 178 1 2 1 $60,240 $989 179 1 3 1 $31,400 $1,030 180 2 4 0 $39,292 $566 181 4 3 0 $47,109 $674 182 1 2 1 $67,184 $756 183 2 3 0 $39,773 $540 184 3 3 1 $71,134 $994 185 2 2 1 $130,387 $1,137 186 4 1 1 $36,170 $1,185 187 1 1 1 $52,448 $1,121 188 1 3 1 $52,847 $1,038 189 3 3 0 $87,039 $1,001 190 6 1 1 $72,043 $854 191 3 4 1 $52,434 $1,093 192 2 4 1 $32,806 $771 193 2 1 0 $127,160 $931 194 1 1 1 $29,805 $1,161 195 5 1 1 $59,501 $1,295 196 2 4 1 $55,099 $780 197 2 1 0 $119,879 $992 198 1 3 0 $49,358 $562 199 4 4 0 $41,346 $784 200 4 1 1 $46,265 $1,626 201 1 4 0 $28,837 $569 202 3 2 1 $96,017 $1,576 203 3 4 0 $68,714 $428 204 3 4 0 $44,840 $519 205 3 1 1 $80,491 $1,619 206 5 1 0 $118,372 $888 207 4 4 0 $28,255 $690 208 6 1 1 $62,196 $1,039 209 2 2 1 $96,709 $1,585 210 3 3 0 $87,205 $1,078 211 1 2 1 $48,914 $1,153 212 2 1 1 $33,018 $871 213 2 2 0 $74,330 $1,076 214 4 4 0 $64,045 $655 215 3 1 1 $75,208 $1,503 216 3 2 1 $94,868 $1,050 217 4 4 0 $77,700 $671 218 4 4 0 $51,313 $497 219 2 2 1 $126,882 $1,705 220 3 1 0 $46,816 $875 221 3 4 0 $38,705 $474 222 2 2 1 $58,666 $1,669 223 3 3 0 $32,792 $861 224 1 1 1 $43,847 $847 225 5 3 0 $53,918 $553 226 2 2 1 $85,665 $1,802 227 5 2 1 $130,706 $1,380 228 4 2 0 $110,956 $1,262 229 3 1 1 $73,192 $1,984 230 1 3 0 $28,835 $793 231 2 2 1 $67,005 $914 232 2 4 0 $69,880 $534 233 2 4 1 $57,460 $724 234 1 4 1 $37,924 $653 235 3 2 1 $65,800 $727 236 3 3 1 $79,786 $635 237 4 2 1 $49,699 $1,516 238 5 2 1 $122,193 $814 239 1 2 1 $76,800 $1,237 240 4 4 1 $25,853 $948 241 3 2 1 $30,225 $1,117 242 2 2 1 $84,675 $1,068 243 1 2 0 $64,179 $1,432 244 2 3 0 $53,779 $707 245 3 3 0 $76,774 $719 246 1 4 0 $37,154 $657 247 1 1 0 $32,125 $597 248 1 4 0 $18,276 $478 249 2 1 1 $58,303 $1,266 250 2 3 0 $97,420 $622 251 6 1 1 $88,973 $1,007 252 5 2 1 $167,182 $1,253 253 4 4 0 $35,176 $355 254 1 1 0 $34,204 $838 255 5 1 1 $144,147 $1,213 256 4 4 0 $57,582 $765 257 1 3 1 $41,628 $1,732 258 2 2 1 $39,367 $1,233 259 1 1 0 $36,838 $621 260 3 1 0 $133,214 $1,159 261 3 2 1 $41,069 $1,493 262 3 2 0 $149,441 $1,166 263 3 4 0 $63,834 $776 264 2 2 1 $59,486 $933 265 2 2 1 $58,305 $1,171 266 3 1 1 $102,142 $1,138 267 3 3 0 $76,648 $578 268 1 3 0 $29,407 $857 269 4 3 0 $43,538 $934 270 4 4 0 $40,253 $510 271 1 4 0 $39,987 $538 272 3 1 1 $88,108 $1,436 273 3 1 1 $60,357 $1,055 274 4 3 0 $70,373 $475 275 2 4 1 $35,343 $556 276 1 2 1 $75,737 $1,596 277 2 1 1 $86,424 $1,032 278 5 4 0 $37,741 $572 279 4 2 1 $86,820 $980 280 1 2 1 $63,825 $1,346 281 3 2 1 $105,213 $1,476 282 3 4 0 $77,195 $1,120 283 2 1 1 $110,447 $908 284 1 1 0 $25,886 $820 285 4 3 1 $34,884 $783 286 3 3 1 $36,015 $1,150 287 6 3 1 $37,691 $925 288 10 3 0 $85,465 $616 289 4 3 0 $90,335 $766 290 4 4 1 $58,637 $584 291 4 2 1 $84,886 $1,141 292 2 4 0 $51,857 $585 293 4 3 0 $41,197 $797 294 1 1 1 $72,515 $1,085 295 3 2 1 $104,286 $1,292 296 3 4 0 $72,632 $484 297 2 2 1 $99,352 $1,700 298 2 2 1 $130,060 $926 299 1 1 1 $56,610 $1,002 300 1 2 1 $59,321 $1,664 301 1 3 1 $35,430 $1,029 302 4 1 1 $76,598 $1,217 303 4 2 1 $80,712 $1,062 304 2 3 1 $84,309 $753 305 4 4 0 $44,423 $389 306 2 1 0 $86,208 $887 307 2 3 0 $46,873 $627 308 3 1 0 $86,009 $854 309 3 1 1 $93,026 $1,469 310 1 2 1 $59,708 $1,070 311 3 1 1 $96,655 $1,601 312 3 3 0 $45,068 $500 313 1 2 1 $66,770 $1,658 314 2 3 0 $62,699 $1,060 315 1 4 1 $53,283 $974 316 2 3 1 $81,627 $1,235 317 2 3 0 $69,316 $729 318 1 4 1 $33,940 $1,027 319 1 3 1 $37,523 $1,829 320 3 4 0 $50,111 $400 321 3 4 0 $34,195 $549 322 3 1 1 $49,728 $1,378 323 4 1 0 $71,188 $523 324 3 2 1 $88,204 $1,470 325 7 1 0 $52,676 $694 326 5 2 1 $142,095 $1,138 327 1 3 0 $18,119 $1,452 328 3 2 0 $123,946 $1,687 329 1 4 0 $27,721 $723 330 1 2 0 $72,949 $1,522 331 3 2 1 $81,612 $1,787 332 5 3 1 $48,304 $752 333 6 4 0 $47,956 $586 334 5 2 1 $126,003 $1,521 335 4 1 1 $65,717 $1,251 336 2 4 0 $27,791 $669 337 4 1 1 $75,551 $919 338 4 3 1 $49,156 $838 339 2 4 0 $48,577 $628 340 3 3 1 $61,794 $1,614 341 4 3 1 $61,764 $1,066 342 3 3 0 $63,499 $1,286 343 3 4 1 $37,378 $1,252 344 3 1 0 $107,937 $748 345 5 2 1 $121,113 $990 346 3 4 1 $34,760 $493 347 2 2 1 $93,156 $1,660 348 3 3 0 $47,847 $1,286 349 6 1 1 $39,773 $853 350 3 4 0 $45,995 $603 351 2 4 0 $71,842 $369 352 2 2 1 $99,323 $1,044 353 3 1 0 $124,842 $574 354 2 4 0 $44,395 $402 355 1 4 0 $32,697 $623 356 1 4 1 $42,058 $884 357 2 1 0 $87,227 $831 358 2 3 0 $86,553 $941 359 4 1 1 $76,001 $1,250 360 5 3 1 $82,389 $1,269 361 3 3 1 $27,085 $965 362 1 3 0 $29,289 $833 363 6 2 1 $126,809 $1,800 364 3 3 0 $83,452 $732 365 8 4 0 $56,334 $644 366 5 4 0 $35,366 $788 367 7 3 1 $65,830 $722 368 1 4 0 $33,087 $633 369 3 4 0 $59,901 $577 370 5 4 0 $73,801 $398 371 5 3 0 $56,897 $778 372 3 3 1 $37,375 $985 373 3 4 0 $50,855 $680 374 6 1 1 $51,537 $821 375 3 4 0 $65,746 $383 376 2 3 1 $32,848 $720 377 1 4 0 $35,289 $457 378 3 1 1 $50,155 $1,068 379 2 1 0 $104,117 $797 380 2 1 1 $68,714 $1,434 381 3 1 0 $53,232 $930 382 5 1 1 $84,674 $873 383 1 4 1 $39,187 $948 384 5 2 1 $101,743 $1,424 385 4 1 1 $86,132 $614 386 4 4 0 $37,382 $558 387 2 1 0 $133,325 $1,038 388 1 4 0 $26,351 $623 389 3 4 0 $65,847 $549 390 3 1 1 $94,808 $1,033 391 1 1 0 $32,420 $1,075 392 3 2 1 $147,155 $1,272 393 9 1 1 $57,921 $1,391 394 3 2 1 $59,947 $1,498 395 5 2 1 $106,495 $1,070 396 4 3 0 $59,943 $712 397 1 3 1 $39,862 $1,472 398 2 2 1 $151,964 $875 399 3 4 1 $65,290 $713 400 3 2 1 $115,901 $1,065 401 3 1 1 $167,600 $1,827 402 2 2 1 $112,609 $943 403 1 1 1 $47,969 $849 404 5 1 1 $83,607 $1,489 405 8 4 0 $49,119 $493 406 3 1 1 $67,928 $941 407 3 4 0 $38,448 $547 408 2 1 1 $64,621 $961 409 3 4 0 $49,166 $588 410 1 1 1 $68,299 $1,271 411 2 4 1 $39,353 $495 412 5 4 0 $38,017 $762 413 3 1 0 $75,549 $1,054 414 3 2 1 $60,590 $1,167 415 3 4 0 $57,661 $525 416 3 1 1 $39,080 $1,103 417 3 4 1 $34,431 $805 418 5 3 1 $70,750 $866 419 4 1 0 $65,859 $921 420 3 1 0 $59,589 $1,083 421 1 2 1 $56,151 $1,128 422 5 2 1 $111,665 $1,248 423 1 4 0 $22,380 $746 424 2 4 1 $28,534 $760 425 5 4 0 $35,879 $658 426 5 4 0 $38,352 $557 427 6 4 1 $41,335 $959 428 4 1 1 $77,773 $1,044 429 5 1 0 $81,276 $490 430 1 4 0 $24,478 $989 431 1 1 1 $57,395 $1,473 432 4 2 1 $119,400 $1,460 433 1 3 1 $42,313 $883 434 2 2 1 $85,139 $2,171 435 4 4 0 $29,996 $760 436 3 2 0 $75,211 $991 437 5 2 1 $83,078 $747 438 4 3 0 $75,489 $949 439 2 3 1 $33,105 $976 440 5 3 0 $42,159 $755 441 4 1 1 $62,697 $1,302 442 2 1 1 $54,362 $1,318 443 5 2 1 $85,294 $1,439 444 4 4 0 $34,779 $500 445 1 3 1 $54,374 $804 446 4 3 1 $63,773 $1,176 447 1 1 0 $47,570 $918 448 2 2 1 $59,151 $840 449 2 4 1 $58,914 $618 450 4 2 1 $126,416 $1,091 451 2 4 1 $16,971 $807 452 1 3 0 $47,244 $638 453 2 2 1 $90,072 $1,317 454 1 1 1 $55,487 $752 455 3 1 1 $56,067 $988 456 1 4 0 $25,713 $814 457 3 3 0 $73,114 $812 458 3 4 0 $65,785 $941 459 3 3 0 $59,185 $743 460 4 4 0 $42,384 $530 461 2 1 1 $126,951 $1,585 462 4 4 1 $25,713 $831 463 5 1 1 $64,023 $1,067 464 1 1 1 $53,113 $1,163 465 5 3 1 $55,099 $924 466 3 1 0 $47,628 $728 467 2 1 0 $57,571 $1,033 468 5 4 0 $28,390 $558 469 2 1 1 $46,834 $1,081 470 3 3 0 $86,730 $960 471 5 2 1 $156,293 $1,799 472 5 1 1 $92,873 $1,147 473 1 2 1 $62,071 $1,326 474 5 4 0 $40,824 $453 475 4 4 0 $42,426 $553 476 1 3 1 $32,316 $790 477 1 4 0 $33,699 $797 478 3 3 1 $56,777 $1,705 479 5 2 1 $116,010 $1,458 480 3 4 0 $44,289 $626 481 3 1 1 $56,375 $881 482 3 3 1 $64,753 $1,014 483 5 3 1 $54,966 $1,432 484 3 3 0 $52,410 $888 485 2 2 1 $88,270 $1,407 486 2 3 0 $61,203 $622 487 3 1 1 $77,550 $1,049 488 2 3 1 $75,351 $1,084 489 4 2 0 $76,828 $760 490 3 3 0 $88,710 $778 491 1 2 1 $73,980 $823 492 3 3 0 $57,723 $745 493 4 2 1 $97,868 $1,283 494 5 3 0 $65,291 $699 495 4 3 0 $57,391 $1,103 496 5 1 0 $72,675 $931 497 2 3 0 $55,857 $801 498 2 4 0 $40,084 $538 499 2 4 0 $47,492 $427 500 3 4 0 $31,042 $746 1 State the data type for each of the variables below, i e , categorical (nominal or ordinal), numerical (continuous or discrete) Explain your reasoning in each case a) Family Size b) Location c) Ownership d) Income e) Monthly Payment2 To start your analysis, rst, you conduct some descriptive statistics on the monthly home payment for both households who pay rent and those who own homes pay mortgage) To do that, sort the data by the home owner Shari To achieve this o In the Results (Output) worksheet, in cell A1 type the heading 'Rent' and in cell Cl, 'Mortgage' 0 Copyt'paste the values for monthly rent payment in column A (i e under 'Rent') and for monthly mortgagr payments in column C (i e under 'Mortgage' o Use Excel's Pivot Table tnction to create a perocntagc frequency (count) distribution table of these variables Hint use Count and NOT Sam o For Rent Payment variable use class intervals (groups) should start at $300 and have a width of $200 and for the Mortgage Payment variable a class interval starting at $400 and a width of $200 o Show percentages correct to 2 decimal places o Use the Tabular Format report layout and label your table accurately and informatively Name 1' t Table 2a Table 2b and unload to Moodle as recoil ed 3 Use the table from Question 2 to construct a percentage frequency histogram of Monthly Payment for all households Make sure you Hide remove all field buttons from the graph and ensure that the histogram is appropriately labelled Name them Graph 3a and Graph 3b and upload to Moodle as required (Marks will be deducted for the poor presentation of your graph) 8 ma4 Obtain the indicated summary measures in the following table (Table 4), for the Monthly Rent Payment and Monthly Mortgage Payments Report values to 2 decimal places Name it Table 4 and upload to Moodle as required Table 4 Table of Summary Measure for monthly home payment ($) Monthly rent Monthly mortgage Excel Function Used for mortgage payment Statistics payment payment (including cell references) Mean Median Standard Deviation Minimum Maximum Range Count First Quartile Third Quartile Interquartile Range (IQR) Coefficient of Variation (CV)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 21, 2024

Household Family Size Location Ownership Income Monthly Payment 1 4 2 1 $93,564 $1,262 2 4 3 0 $60,640 $827 3 4 4 1 $39,246

Household	Family Size	Location	Ownership	Income	Monthly Payment
1	4	2	1	$93,564	$1,262
2	4	3	0	$60,640	$827
3	4	4	1	$39,246	$629
4	4	1	1	$102,242	$1,108
5	3	4	0	$60,715	$675
6	1	3	1	$46,890	$577
7	3	3	0	$72,122	$576
8	2	3	0	$53,739	$977
9	2	2	1	$76,416	$1,589
10	1	4	0	$22,091	$613
11	1	1	0	$36,384	$601
12	1	3	0	$34,806	$681
13	6	1	1	$127,474	$1,009
14	4	4	0	$52,889	$1,059
15	1	1	0	$43,657	$848
16	2	4	0	$46,295	$501
17	3	2	1	$72,649	$1,573
18	3	2	1	$106,553	$1,533
19	5	4	0	$63,253	$530
20	3	1	1	$48,369	$1,222
21	3	3	0	$61,763	$689
22	3	1	1	$78,300	$1,242
23	3	2	1	$71,653	$1,086
24	3	2	1	$79,808	$1,500
25	6	1	0	$68,808	$991
26	7	1	0	$71,800	$848
27	4	1	1	$80,392	$1,223
28	4	4	0	$36,835	$603
29	1	1	1	$71,211	$1,514
30	4	4	1	$59,655	$893
31	4	4	0	$46,719	$562
32	5	4	0	$41,942	$680
33	2	2	1	$154,916	$1,467
34	5	4	0	$45,123	$953
35	2	3	1	$56,750	$964
36	2	3	1	$67,131	$991
37	4	4	1	$43,640	$729
38	1	1	0	$34,150	$643
39	2	3	0	$97,682	$647
40	3	4	0	$48,634	$349
41	6	2	1	$75,512	$1,040
42	2	3	0	$47,673	$1,240
43	6	2	0	$77,470	$1,314
44	1	1	1	$39,991	$796
45	5	3	0	$51,533	$696
46	5	2	1	$53,338	$793
47	2	2	1	$76,963	$1,603
48	5	1	1	$56,220	$1,304
49	2	2	1	$173,706	$1,295
50	2	1	1	$96,192	$1,751
51	4	4	0	$59,621	$617
52	2	4	0	$44,437	$520
53	2	2	1	$55,665	$1,048
54	4	3	1	$59,555	$963
55	4	1	0	$56,441	$991
56	2	2	1	$110,645	$989
57	1	3	0	$43,482	$735
58	3	2	1	$112,446	$699
59	3	4	0	$48,319	$619
60	3	2	1	$139,807	$1,088
61	4	2	0	$74,460	$724
62	4	1	1	$51,758	$959
63	3	1	1	$48,893	$676
64	1	1	1	$45,869	$1,377
65	3	3	0	$55,362	$770
66	3	2	1	$114,934	$1,278
67	3	4	0	$74,636	$615
68	3	4	1	$28,378	$644
69	2	3	0	$79,123	$902
70	2	2	1	$119,247	$1,588
71	4	3	1	$24,493	$1,136
72	3	2	0	$83,073	$1,187
73	1	1	1	$75,865	$1,078
74	2	3	1	$84,746	$1,280
75	2	2	1	$66,346	$1,914
76	2	3	0	$57,073	$711
77	3	1	1	$159,107	$1,537
78	4	3	0	$50,118	$818
79	1	1	1	$59,579	$1,161
80	2	1	1	$68,563	$1,008
81	2	1	1	$74,972	$1,049
82	5	3	1	$64,085	$640
83	4	1	1	$108,918	$1,112
84	1	4	0	$46,342	$560
85	9	4	0	$48,762	$648
86	5	1	1	$76,432	$1,203
87	4	1	0	$119,526	$1,186
88	2	4	0	$43,765	$490
89	2	2	1	$74,486	$1,051
90	2	4	0	$50,309	$997
91	4	4	1	$33,646	$606
92	1	2	0	$45,038	$984
93	2	4	0	$62,974	$765
94	3	3	0	$56,437	$568
95	2	2	1	$68,806	$1,453
96	3	1	1	$129,211	$1,136
97	2	2	1	$88,859	$810
98	2	1	1	$41,427	$1,377
99	1	2	1	$26,910	$1,028
100	3	2	1	$87,636	$1,707
101	3	2	1	$147,215	$1,731
102	2	1	0	$97,646	$490
103	1	4	0	$24,859	$509
104	2	1	1	$49,809	$834
105	2	3	1	$89,772	$1,293
106	4	2	1	$57,734	$1,142
107	3	3	1	$61,458	$933
108	2	2	0	$78,960	$1,134
109	2	4	0	$55,575	$895
110	2	4	1	$35,502	$829
111	3	3	1	$46,389	$1,780
112	3	3	0	$46,022	$847
113	2	3	1	$39,320	$1,259
114	3	3	0	$88,816	$653
115	3	1	1	$43,179	$909
116	3	2	1	$126,469	$1,321
117	4	2	1	$48,586	$679
118	1	4	0	$30,557	$601
119	1	2	1	$45,993	$1,689
120	2	4	0	$66,866	$602
121	4	3	1	$70,304	$1,435
122	2	2	1	$55,654	$1,287
123	3	3	1	$83,669	$1,306
124	1	3	0	$35,105	$960
125	4	2	0	$86,809	$1,740
126	2	2	1	$64,154	$1,088
127	4	4	0	$42,032	$799
128	1	1	1	$48,064	$1,434
129	1	2	0	$51,372	$887
130	4	2	1	$109,665	$903
131	4	2	1	$118,377	$831
132	2	1	1	$85,051	$1,307
133	4	2	1	$121,986	$1,355
134	4	2	1	$118,870	$1,300
135	4	1	1	$102,042	$1,420
136	2	3	0	$59,159	$996
137	5	4	0	$53,082	$334
138	4	2	0	$65,307	$1,830
139	4	2	1	$138,791	$1,103
140	4	2	0	$63,546	$568
141	3	3	1	$73,861	$773
142	5	1	0	$76,802	$892
143	2	3	1	$72,534	$956
144	1	4	0	$27,700	$728
145	6	1	1	$67,154	$1,331
146	3	1	0	$80,933	$797
147	3	4	1	$37,599	$1,058
148	3	3	1	$74,320	$1,217
149	1	4	1	$27,377	$815
150	3	3	1	$110,068	$670
151	1	4	1	$24,992	$579
152	3	2	1	$116,571	$1,009
153	3	3	0	$35,403	$418
154	4	3	0	$31,878	$719
155	5	3	1	$58,389	$573
156	3	3	0	$45,417	$610
157	8	2	1	$90,947	$820
158	2	1	0	$68,785	$931
159	2	3	1	$31,519	$1,218
160	3	1	0	$76,825	$1,184
161	1	2	1	$60,069	$1,434
162	2	4	0	$61,823	$595
163	2	3	1	$49,744	$1,734
164	3	3	1	$40,742	$1,403
165	4	2	1	$101,510	$1,534
166	10	4	0	$55,723	$405
167	3	2	1	$93,507	$1,548
168	5	4	1	$30,372	$799
169	1	4	1	$39,578	$953
170	8	1	1	$95,156	$1,042
171	3	1	1	$84,272	$1,510
172	5	4	0	$65,498	$405
173	3	1	1	$93,190	$1,676
174	4	1	1	$117,620	$1,123
175	6	3	0	$40,953	$954
176	1	3	0	$26,610	$999
177	2	1	1	$46,249	$1,133
178	1	2	1	$60,240	$989
179	1	3	1	$31,400	$1,030
180	2	4	0	$39,292	$566
181	4	3	0	$47,109	$674
182	1	2	1	$67,184	$756
183	2	3	0	$39,773	$540
184	3	3	1	$71,134	$994
185	2	2	1	$130,387	$1,137
186	4	1	1	$36,170	$1,185
187	1	1	1	$52,448	$1,121
188	1	3	1	$52,847	$1,038
189	3	3	0	$87,039	$1,001
190	6	1	1	$72,043	$854
191	3	4	1	$52,434	$1,093
192	2	4	1	$32,806	$771
193	2	1	0	$127,160	$931
194	1	1	1	$29,805	$1,161
195	5	1	1	$59,501	$1,295
196	2	4	1	$55,099	$780
197	2	1	0	$119,879	$992
198	1	3	0	$49,358	$562
199	4	4	0	$41,346	$784
200	4	1	1	$46,265	$1,626
201	1	4	0	$28,837	$569
202	3	2	1	$96,017	$1,576
203	3	4	0	$68,714	$428
204	3	4	0	$44,840	$519
205	3	1	1	$80,491	$1,619
206	5	1	0	$118,372	$888
207	4	4	0	$28,255	$690
208	6	1	1	$62,196	$1,039
209	2	2	1	$96,709	$1,585
210	3	3	0	$87,205	$1,078
211	1	2	1	$48,914	$1,153
212	2	1	1	$33,018	$871
213	2	2	0	$74,330	$1,076
214	4	4	0	$64,045	$655
215	3	1	1	$75,208	$1,503
216	3	2	1	$94,868	$1,050
217	4	4	0	$77,700	$671
218	4	4	0	$51,313	$497
219	2	2	1	$126,882	$1,705
220	3	1	0	$46,816	$875
221	3	4	0	$38,705	$474
222	2	2	1	$58,666	$1,669
223	3	3	0	$32,792	$861
224	1	1	1	$43,847	$847
225	5	3	0	$53,918	$553
226	2	2	1	$85,665	$1,802
227	5	2	1	$130,706	$1,380
228	4	2	0	$110,956	$1,262
229	3	1	1	$73,192	$1,984
230	1	3	0	$28,835	$793
231	2	2	1	$67,005	$914
232	2	4	0	$69,880	$534
233	2	4	1	$57,460	$724
234	1	4	1	$37,924	$653
235	3	2	1	$65,800	$727
236	3	3	1	$79,786	$635
237	4	2	1	$49,699	$1,516
238	5	2	1	$122,193	$814
239	1	2	1	$76,800	$1,237
240	4	4	1	$25,853	$948
241	3	2	1	$30,225	$1,117
242	2	2	1	$84,675	$1,068
243	1	2	0	$64,179	$1,432
244	2	3	0	$53,779	$707
245	3	3	0	$76,774	$719
246	1	4	0	$37,154	$657
247	1	1	0	$32,125	$597
248	1	4	0	$18,276	$478
249	2	1	1	$58,303	$1,266
250	2	3	0	$97,420	$622
251	6	1	1	$88,973	$1,007
252	5	2	1	$167,182	$1,253
253	4	4	0	$35,176	$355
254	1	1	0	$34,204	$838
255	5	1	1	$144,147	$1,213
256	4	4	0	$57,582	$765
257	1	3	1	$41,628	$1,732
258	2	2	1	$39,367	$1,233
259	1	1	0	$36,838	$621
260	3	1	0	$133,214	$1,159
261	3	2	1	$41,069	$1,493
262	3	2	0	$149,441	$1,166
263	3	4	0	$63,834	$776
264	2	2	1	$59,486	$933
265	2	2	1	$58,305	$1,171
266	3	1	1	$102,142	$1,138
267	3	3	0	$76,648	$578
268	1	3	0	$29,407	$857
269	4	3	0	$43,538	$934
270	4	4	0	$40,253	$510
271	1	4	0	$39,987	$538
272	3	1	1	$88,108	$1,436
273	3	1	1	$60,357	$1,055
274	4	3	0	$70,373	$475
275	2	4	1	$35,343	$556
276	1	2	1	$75,737	$1,596
277	2	1	1	$86,424	$1,032
278	5	4	0	$37,741	$572
279	4	2	1	$86,820	$980
280	1	2	1	$63,825	$1,346
281	3	2	1	$105,213	$1,476
282	3	4	0	$77,195	$1,120
283	2	1	1	$110,447	$908
284	1	1	0	$25,886	$820
285	4	3	1	$34,884	$783
286	3	3	1	$36,015	$1,150
287	6	3	1	$37,691	$925
288	10	3	0	$85,465	$616
289	4	3	0	$90,335	$766
290	4	4	1	$58,637	$584
291	4	2	1	$84,886	$1,141
292	2	4	0	$51,857	$585
293	4	3	0	$41,197	$797
294	1	1	1	$72,515	$1,085
295	3	2	1	$104,286	$1,292
296	3	4	0	$72,632	$484
297	2	2	1	$99,352	$1,700
298	2	2	1	$130,060	$926
299	1	1	1	$56,610	$1,002
300	1	2	1	$59,321	$1,664
301	1	3	1	$35,430	$1,029
302	4	1	1	$76,598	$1,217
303	4	2	1	$80,712	$1,062
304	2	3	1	$84,309	$753
305	4	4	0	$44,423	$389
306	2	1	0	$86,208	$887
307	2	3	0	$46,873	$627
308	3	1	0	$86,009	$854
309	3	1	1	$93,026	$1,469
310	1	2	1	$59,708	$1,070
311	3	1	1	$96,655	$1,601
312	3	3	0	$45,068	$500
313	1	2	1	$66,770	$1,658
314	2	3	0	$62,699	$1,060
315	1	4	1	$53,283	$974
316	2	3	1	$81,627	$1,235
317	2	3	0	$69,316	$729
318	1	4	1	$33,940	$1,027
319	1	3	1	$37,523	$1,829
320	3	4	0	$50,111	$400
321	3	4	0	$34,195	$549
322	3	1	1	$49,728	$1,378
323	4	1	0	$71,188	$523
324	3	2	1	$88,204	$1,470
325	7	1	0	$52,676	$694
326	5	2	1	$142,095	$1,138
327	1	3	0	$18,119	$1,452
328	3	2	0	$123,946	$1,687
329	1	4	0	$27,721	$723
330	1	2	0	$72,949	$1,522
331	3	2	1	$81,612	$1,787
332	5	3	1	$48,304	$752
333	6	4	0	$47,956	$586
334	5	2	1	$126,003	$1,521
335	4	1	1	$65,717	$1,251
336	2	4	0	$27,791	$669
337	4	1	1	$75,551	$919
338	4	3	1	$49,156	$838
339	2	4	0	$48,577	$628
340	3	3	1	$61,794	$1,614
341	4	3	1	$61,764	$1,066
342	3	3	0	$63,499	$1,286
343	3	4	1	$37,378	$1,252
344	3	1	0	$107,937	$748
345	5	2	1	$121,113	$990
346	3	4	1	$34,760	$493
347	2	2	1	$93,156	$1,660
348	3	3	0	$47,847	$1,286
349	6	1	1	$39,773	$853
350	3	4	0	$45,995	$603
351	2	4	0	$71,842	$369
352	2	2	1	$99,323	$1,044
353	3	1	0	$124,842	$574
354	2	4	0	$44,395	$402
355	1	4	0	$32,697	$623
356	1	4	1	$42,058	$884
357	2	1	0	$87,227	$831
358	2	3	0	$86,553	$941
359	4	1	1	$76,001	$1,250
360	5	3	1	$82,389	$1,269
361	3	3	1	$27,085	$965
362	1	3	0	$29,289	$833
363	6	2	1	$126,809	$1,800
364	3	3	0	$83,452	$732
365	8	4	0	$56,334	$644
366	5	4	0	$35,366	$788
367	7	3	1	$65,830	$722
368	1	4	0	$33,087	$633
369	3	4	0	$59,901	$577
370	5	4	0	$73,801	$398
371	5	3	0	$56,897	$778
372	3	3	1	$37,375	$985
373	3	4	0	$50,855	$680
374	6	1	1	$51,537	$821
375	3	4	0	$65,746	$383
376	2	3	1	$32,848	$720
377	1	4	0	$35,289	$457
378	3	1	1	$50,155	$1,068
379	2	1	0	$104,117	$797
380	2	1	1	$68,714	$1,434
381	3	1	0	$53,232	$930
382	5	1	1	$84,674	$873
383	1	4	1	$39,187	$948
384	5	2	1	$101,743	$1,424
385	4	1	1	$86,132	$614
386	4	4	0	$37,382	$558
387	2	1	0	$133,325	$1,038
388	1	4	0	$26,351	$623
389	3	4	0	$65,847	$549
390	3	1	1	$94,808	$1,033
391	1	1	0	$32,420	$1,075
392	3	2	1	$147,155	$1,272
393	9	1	1	$57,921	$1,391
394	3	2	1	$59,947	$1,498
395	5	2	1	$106,495	$1,070
396	4	3	0	$59,943	$712
397	1	3	1	$39,862	$1,472
398	2	2	1	$151,964	$875
399	3	4	1	$65,290	$713
400	3	2	1	$115,901	$1,065
401	3	1	1	$167,600	$1,827
402	2	2	1	$112,609	$943
403	1	1	1	$47,969	$849
404	5	1	1	$83,607	$1,489
405	8	4	0	$49,119	$493
406	3	1	1	$67,928	$941
407	3	4	0	$38,448	$547
408	2	1	1	$64,621	$961
409	3	4	0	$49,166	$588
410	1	1	1	$68,299	$1,271
411	2	4	1	$39,353	$495
412	5	4	0	$38,017	$762
413	3	1	0	$75,549	$1,054
414	3	2	1	$60,590	$1,167
415	3	4	0	$57,661	$525
416	3	1	1	$39,080	$1,103
417	3	4	1	$34,431	$805
418	5	3	1	$70,750	$866
419	4	1	0	$65,859	$921
420	3	1	0	$59,589	$1,083
421	1	2	1	$56,151	$1,128
422	5	2	1	$111,665	$1,248
423	1	4	0	$22,380	$746
424	2	4	1	$28,534	$760
425	5	4	0	$35,879	$658
426	5	4	0	$38,352	$557
427	6	4	1	$41,335	$959
428	4	1	1	$77,773	$1,044
429	5	1	0	$81,276	$490
430	1	4	0	$24,478	$989
431	1	1	1	$57,395	$1,473
432	4	2	1	$119,400	$1,460
433	1	3	1	$42,313	$883
434	2	2	1	$85,139	$2,171
435	4	4	0	$29,996	$760
436	3	2	0	$75,211	$991
437	5	2	1	$83,078	$747
438	4	3	0	$75,489	$949
439	2	3	1	$33,105	$976
440	5	3	0	$42,159	$755
441	4	1	1	$62,697	$1,302
442	2	1	1	$54,362	$1,318
443	5	2	1	$85,294	$1,439
444	4	4	0	$34,779	$500
445	1	3	1	$54,374	$804
446	4	3	1	$63,773	$1,176
447	1	1	0	$47,570	$918
448	2	2	1	$59,151	$840
449	2	4	1	$58,914	$618
450	4	2	1	$126,416	$1,091
451	2	4	1	$16,971	$807
452	1	3	0	$47,244	$638
453	2	2	1	$90,072	$1,317
454	1	1	1	$55,487	$752
455	3	1	1	$56,067	$988
456	1	4	0	$25,713	$814
457	3	3	0	$73,114	$812
458	3	4	0	$65,785	$941
459	3	3	0	$59,185	$743
460	4	4	0	$42,384	$530
461	2	1	1	$126,951	$1,585
462	4	4	1	$25,713	$831
463	5	1	1	$64,023	$1,067
464	1	1	1	$53,113	$1,163
465	5	3	1	$55,099	$924
466	3	1	0	$47,628	$728
467	2	1	0	$57,571	$1,033
468	5	4	0	$28,390	$558
469	2	1	1	$46,834	$1,081
470	3	3	0	$86,730	$960
471	5	2	1	$156,293	$1,799
472	5	1	1	$92,873	$1,147
473	1	2	1	$62,071	$1,326
474	5	4	0	$40,824	$453
475	4	4	0	$42,426	$553
476	1	3	1	$32,316	$790
477	1	4	0	$33,699	$797
478	3	3	1	$56,777	$1,705
479	5	2	1	$116,010	$1,458
480	3	4	0	$44,289	$626
481	3	1	1	$56,375	$881
482	3	3	1	$64,753	$1,014
483	5	3	1	$54,966	$1,432
484	3	3	0	$52,410	$888
485	2	2	1	$88,270	$1,407
486	2	3	0	$61,203	$622
487	3	1	1	$77,550	$1,049
488	2	3	1	$75,351	$1,084
489	4	2	0	$76,828	$760
490	3	3	0	$88,710	$778
491	1	2	1	$73,980	$823
492	3	3	0	$57,723	$745
493	4	2	1	$97,868	$1,283
494	5	3	0	$65,291	$699
495	4	3	0	$57,391	$1,103
496	5	1	0	$72,675	$931
497	2	3	0	$55,857	$801
498	2	4	0	$40,084	$538
499	2	4	0	$47,492	$427
500	3	4	0	$31,042	$746

1. State the data type for each of the variables below, i.e., categorical (nominal or ordinal), numerical (continuous or discrete). Explain your reasoning in each case. a) Family Size b) Location c) Ownership d) Income e) Monthly Payment2. To start your analysis, rst, you conduct some descriptive statistics on the monthly home payment for both households who pay rent and those who own homes {pay mortgage). To do that, sort the data by the \"home owner-Shari To achieve this: o In the Results (Output) worksheet, in cell A1 type the heading 'Rent' and in cell Cl, 'Mortgage'. 0 Copyt'paste the values for monthly rent payment in column A (i.e. under 'Rent') and for monthly mortgagr payments in column C (i.e. under 'Mortgage'}. o Use Excel's Pivot Table tnction to create a perocntagc frequency (count) distribution table of these variables. [Hint use Count and NOT Sam] o For Rent Payment variable use class intervals (groups) should start at $300 and have a width of $200 and for the Mortgage Payment variable a class interval starting at $400 and a width of $200. o Show percentages correct to 2 decimal places. o Use the Tabular Format report layout and label your table accurately and informatively. Name 1' t Table 2a Table 2b and unload to Moodle as recoil-ed 3. Use the table from Question 2 to construct a percentage frequency histogram of Monthly Payment for all households. Make sure you Hide/remove all field buttons from the graph and ensure that the histogram is appropriately labelled. Name them Graph 3a and Graph 3b and upload to Moodle as required. (Marks will be deducted for the poor presentation of your graph) [8 ma4. Obtain the indicated summary measures in the following table (Table 4), for the Monthly Rent Payment and Monthly Mortgage Payments. Report values to 2 decimal places Name it Table 4 and upload to Moodle as required. Table 4: Table of Summary Measure for monthly home payment ($) Monthly rent Monthly mortgage Excel Function Used for mortgage payment Statistics payment payment (including cell references) Mean Median Standard Deviation Minimum Maximum Range Count First Quartile Third Quartile Interquartile Range (IQR) Coefficient of Variation (CV)