a) Which of the variables are qualitative and which are quantitative?

b) How is each variable measured? Determine the level of measurement for each of the variables.

For the variable price, select an appropriate class interval and organize the selling prices into a frequency distribution. Write a brief report summarizing your findings. Be sure to answer the following questions in your report.

c) Around what values of price do the data tend to cluster?

d) Based on the frequency distribution, what is the typical selling price in the first class? What is the typical selling price in the last class?

e) Draw a cumulative relative frequency distribution. Using this distribution, 50 percent of the homes sold for what price or less? Estimate the lower price of the top 10% of homes sold. About what percent of the homes sold for less than $300,000?

f) Refer to the variable bedrooms. Draw a bar chart showing the number of homes sold with 2, 3, 4 or more bedrooms. Write a description of the distribution.

Consider the sales prices of home, answer the following:

g) Around what values of price do the data tend to cluster? What is the mean sales price? What is the median sales price? Is one measure more representative of the typical sales prices than the others?

h) What is the range of sales prices? What is the standard deviation? About 95% of thesales prices are between what two values? Is the standard deviation a useful statistic for describing the dispersion of sales price?

i) Repeat (g) and (h) using FICO score.

j) Compute the minimum, maximum, median, and the first and the third quartiles of price. Create a box plot. Comment on the distribution of home prices

7:05 AM Tue 28 Sep 63% ... 4 Feed record en I Marty 2 Rose 3 Carter 4 Per s Carter 6. Peter 7 Care Putere 10 Isaac 11 Row 12 Peter 13 May 14 Row 13 Rose 16 sacs 17 Carter IN N 19 Rose 20 R 21 Marty 22 Rose 23 Carter 34 Isaac 25 C 36 I 27 Carter 25 Marty 29 Isaac 30 Marty 31 sacs 32 sacs 33 Carter 34 Cart 35 Marty 36 las 37 35 Row 39 Cartier 40 Pierce 41 R 43 43 Peter 44 R 45 Marty Real_Estate.xlsx Price Sure Bedroom Baths Pool (yes is 1) Garage (Ya i Duys Townshop Mortgage type Yours FODefault Yes ist) 206424 18:30 2 18 ! 33 2 Fixed 2 894 346150 10 2 0 036 9820 372360 3210 4 3 0 ! 21 2 Fred 18 819 0 310622 30 $ 35 1 0 26 Fixed 19 817 0 496100 4510 6 45 0 1 13 4 Fixed 17 816 0 294056 3400 4 1 1 1 31 4 Fixed 1981) 0 22610 260 4 2.5 0 1 39 4 Adjustable 10813 0 184420 4470 5 35 0 ! 26 2 Fixed 6812 416120 000 S 15 0 1 26 4 Fixed 31 810 0 487494 5380 1 1 32 3 Fixed sos 0 440 6 4 0 1 35 4 Fixed 3806 1 38890 4430 4 3 0 1 50 2 Adjustable 9305 1 335610 2970 325 0 ! 3 Adjustable 9 801 1 21000 2300 2 15 0 0 34 I Fixed 20 795 0 346421 2970 . 3 1 1 Adjustable 1005 0 451913 3660 6 4 1 1 12 3 Fixed 18792 0 376146 3290 $ 35 1 1 28 2 Adjustable 9792 1 0944100 55 1 ! Adjustable 10 780 0 25120 2050 2 1 ! 38 3 Fixed 16 786 0 54759 1920 6 45 1 1 5 Fred 2785 0 214910 1950 2 1.5 1 0 20 4 Fixed 6784 0 188799 1950 2 1.3 1 0 Fixed 10 72 0 4999500 4 3 1 1 31 4 Fixed 3781 0 264160 2500 2.3 0 1 40 1 Fixed 18 70 O 191557 BINO 4 3 1 ! 54 1 Faxed 20 776 0 478675 16 5 3.5 1 1 26 5 Adjustable 773 0 384020 1020 S 35 0 1 23 4 Adjustable 9772 313200 3600 4 3 0 ! 31 3 Fixed 19 772 274482 2990 3 2 1 0 17 3 Faxed 5 76 O 167962 1920 2 15 1 1 31 S Fixed 6 769 0 175623 1970 2 15 1 0 28 5 Adjustable 9 h 1 226498 2520 3 1 1 28 3 Fixed $763 1 316327 3150 4 3 1 12 4 Fixed 2799 1 189954 1550 2 15 1 0 2 Faxed 17758 0 366350 000 3 2 1 1 23 3 Fixed 3 754 1 416160 WORD 4 1 0 ! 25 4 Fred 12753 0 WOOOO 1500 4 3 0 1 2 Fixed 1872 0 29-4357 230 4 1 1 4 Fixed 10 751 O 337144 2790 4 3 1 1 19 3 Fed 15 749 299730 2910 0 0 31 2 Fixed 1378 0 465740 370 4 0 1 19 3 Fixed 5746 0 410592 4200 4 3 1 ! 29 Adjustable 141 1 667732 5970 535 1 1 29 sed 4 700 0 521584 00 6 4 1 1 19 5 Adjustable 10 739 33000 3360 3 2 0 0 12 Fixed 6737 7:05 AM Tue 28 Sep .63% Real_Estate.xlsx ... 0 28 30 23 0 0 0 o 0 45 Marty 46 Marty 47 Marty 4 R 49 50 sans 51 las 52 Isaac 53 Peters 54 Pro 35 Rose 56 Carter 57 ans 58 Carter 50 C Row 61 Peterson 62 Peter 1 1 0 0 1 1 1 1 0 1 ! 3000 3360 20359 2270 35 2850 3213202770 246520 870 S4 9010 793054 00 174528 1600 392554 1970 263160 000 237120 1900 225750 2150 848420 7190 371956 3110 404518 1290 2S000 2010 39978 0 209292 1630 190012 1850 216720 2520 323417 3930 316210 1070 22054 2090 1819202000 248400 2300 466560 570 667212 6110 362710 370 265440 3160 706596 293700 3300 19944% 231 309533 4230 20121 2010 16/9000 1000 190291 2000 193554 363792 2160 BO 15.00 310577 1 919) 7670 392904 3400 200928 18.00 537900 1890 258120 2390 S58342 6160 3 2 3 2 325 3 2 4 3 6 4 X 55 2 15 4 3 3 2 2 13 215 6 4 3 13 $ 35 4 3 4 25 2 1.5 2 15 3 225 4 3 3 2 2 IS 3 2 $ 35 5 35 4 4 25 $$ 2 5 3 2 2 1.5 4 3 21.5 25 2 1.5 3 3 25 6 43 3 2 3.5 3 2 2 15 4 3 2.5 4 1 1 0 1 1 1 0 1 0 1 0 1 0 1 0 1 1 0 64 Isanes 65 Muty 66 Isaacs 67 Piero 68 Marty 69 Rose 70 71 Rowe 72. Peterson 73 R 14 R 75 Marty 6 Marty 77 Carter 78 Marty 79 Marty 80 Pro 81 Rose 82 Marty %3Cmeter 84 C X5 Peterson 6 Carter 87 Carter 88 Carter 89 H 90 Curler 0 0 0 ! 1 1 1 0 1 ! 0 1 ! 1 1 1 1 0 1 0 1 0 1 0 1 ! 1 1 1 1 0 35 27 39 30 26 14 27 49 29 24 18 27 18 30 2 22 30 28 30 50 42 21 24 22 40 14 25 32 21 20 31 34 48 33 40 30 40 16 3 Fixed Ied 4 Fixed Fored 5 Fixed 5 Adjustable 4 Feed 2 Fixed 4 Feed 3 Fed 3 Fixed 2 Fixed I Fixed 5 Fixed 2 Fixed 5 Fixed 4 Fixed 3 Fixed 4 Adjustable 4 Adjustable 4 Adjustable 1 Adjustable 1 Alle 2 Adjustable 2 Adjustable 4 Adjustable Adjustable Adjustable 5 Adjustable 3 Adjustable 4 Male Adjustable 2 Adjustable 2 Mjustable 1 Adjustable 4 Adjustable 3 Adjustable 5 Adjustable 2 Adjustable Adjustable 4 Adjustable 2 Adjustable 4. Adjustable 1 Adjustable 1 Male Ale 6737 10 737 8736 6 TM 13 735 10 731 6729 15 720 171 726 10 726 18 729 15 715 5 710 8710 14 707 11 704 1070) 10 701 2675 5 674 2673 1673 6670 8 69 4661 3665 5662 2.656 3 651 7682 7 647 5644 2 642 3639 7699 6 631 7630 3626 $636 6634 1623 8613 3 618 7.614 6614 7.613 O 0 0 0 0 0 o 0 0 0 0 0 1 O 0 0 1 0 0 1 0 0 1 1 1 0 1 1 1 0 1 1 1 0 1 1 1 1 0 0 1 1 1 0 0 1 ! 1 1 ! 1 0 ! 1 ! 1 1 1 1 0 1 1 o 1 1 23 24 1 0 7:05 AM Tue 28 Sep 63% Real_Estate.xlsx ... 0 3665 8662 2.656 3 651 1652 w 70 Isaac 71 Rose 72 Peters 71 Rose 74 R 25 Marty 76 Marty 77 Carter 78 Marty 79 Marty 80 Pro 1 Rose 82 Marty 83 Care 84 Carter 85 Piece 56 Cartier 87 Carter 88 Cler x9 Rose 90 C 91 Marty 92 Isaac Carter 94 Pierce 95 Peterson 6 Marty 97 Peterson 95 Marty 99 Isaacs 100 Carter 101 Peter 102 103 May 104 Petersom 105 Person 7641 $ 644 2 642 3619 7.639 6631 7630 36.36 5636 2 466560 5700 667212 6110 362710 4370 265.440 11 206596600 291700 3300 199448 2330 369511 4330 20121 2010 16/9000 1690 190291 300 393584 363792 2560 0 1 310877 3180 91940 7670 392904 100 200928 1540 $37900 890 258120 2390 558342 6160 302720 10 240115 2230 793656 6530 2182 1930 3R1051 3510 351320 3180 841491 7030 326300 2350 3128633750 275033 00 219900 2110 195257 2130 194238 1650 348528 2540 241920 220 $ 35 6 4 25 $ 35 7 5 2 2 1.5 4 3 2 15 2 15 2 15 4 3 3 25 6 45 3 2 X 5.5 3 2 25 6 4 325 6 4 1 0 1 1 0 1 1 1 0 1 1 1 0 1 1 1 1 0 0 1 0 1 1 1 1 0 1 0 1 1 0 1 1 1 0 T 50 ! 42 ! 21 1 24 ! 22 1 40 0 14 1 25 1 32 0 21 0 20 1 31 1 34 ! 48 1 12 1 40 30 0 10 1 16 1 23 1 23 ! 24 38 0 39 1 53 0 58 1 27 ! 35 1 50 0 28 1 12 1 27 0 37 0 11 1 30 ! 27 1 14 JUNG 4 Adjustable 3 Adjustable 1 Adjustable 5 Male Adjustable Adjustable 3 Adjustable 2 Adjustable 2 Adjustable 1 Adjustable 4 Adjustable 3 Mjustable 5 Able 2. Adjustable 1 Male 4 Adjuvable 2 Adjustable 4 Adul 1 Adjustable Adjustable Adjustable Adjustable 5 Adjustable 4 Adjustable 4 Adjustable 2 Adjustable 2 Adjustable 4 Mjustable 1 Ajate 4 Adjustable 3 Adjustable Adjustable 5 Adjustable 2 Adjustable 5 Adjustable 5 Adjustable 1 0 0 1 1 1 0 0 1 1 1 0 1 1 0 1 1 0 1 0 2 1.3 7 $ 2 1.5 3 2 3 2 6 4 325 6 4 3 2 2 1.5 2 1.5 2 1.5 4 2 23 1623 5618 3618 7 614 6614 7613 09 10 3 605 1604 6 601 3590 8596 6 595 2 595 3593 6991 59 7590 1984 85 0 1 0 1 1 1 1 0 0 1 1 1 1 1