Selling Price ($) Size (ft-) Location Area Population Jobless Rate Type 787,000 2301 Fairview 59000 0.03 Detached 703,000 1871 Fairview 59000 0.03 Detached 538,000 1432 Fairview 59000 0.03 Detached 661,000 1629 Fairview 59000 0.03 Detached 560,000 1410 Fairview 59000 0.03 Detached 521,000 1436 Fairview 59000 0.03 Detached 653,000 1666 Fairview 59000 0.03 Condo 750,000 1995 Fairview 59000 0.03 Condo 736,000 1710 Fairview 59000 0.03 Detached 754,000 1766 Fairview 59000 0.03 Detached 526,000 1698 Shadyside 1 1000 0.01 Condo 655,000 1794 Shadyside 11000 0.01 Condo 610,000 1727 Shadyside 11000 0.01 Condo 728,000 1648 Shadyside 1 1000 0.01 Detached 682,000 2048 Shadyside 1 1000 0.01 Detached 654,000 1655 Shadyside 11000 0.01 Condo 719,000 1908 Shadyside 11000 0.01 Condo 634,000 1870 Shadyside 1 1000 0.01 Detached 575,000 1555 Shadyside 1 1000 0.01 Detached 530,000 1422 Shadyside 1 1000 0.01 Detached 767,000 1768 Groton 81000 0.04 Detached 538,000 1357 Groton 81000 0.04 Detached 584,000 1320 Groton 81000 0.04 Detached 715,000 1782 Groton 81000 0.04 Detached 534,000 1349 Groton 81000 0.04 Detached 464,000 1377 Groton 81000 0.04 Condo 413,000 1274 Groton 81000 0.04 Condo 609,000 1404 Groton 81000 0.04 Detached 533,000 1406 Groton 81000 0.04 Detached 587,000 1607 Groton 81000 0.04 Detached 772,000 1767 Irving 65000 0.04 Detached 862,000 2153 Irving 65000 0.04 Detached 418,000 1111 Irving 65000 0.04 Detached 450,000 1162 Irving 65000 0.04 Detached 864,000 2067 Irving 65000 0.04 Detached 589,000 1326 Irving 65000 0.04 Detached 426,000 1150 Irving 65000 0.04 Detached 746,000 1684 Irving 65000 0.04 Detached 755,000 2139 Irving 65000 0.04 Condo 513,000 1173 Irving 65000 0.04 Detached 583,000 1378 Hamilton 85000 0.06 Detached 665,000 1470 Hamilton 85000 0.06 Detached 381,000 1019 Hamilton 85000 0.06 Detached 305,000 979 Hamilton 85000 0.06 Condo 340,000 903 Hamilton 85000 0.06 Condo 486,000 1023 Hamilton 85000 0.06 Detached 484,000 1040 Hamilton 85000 0.06 Detached 515,000 1188 Hamilton 85000 0.06 Detached 496,000 1166 Hamilton 85000 0.06 Detached 394,000 945 Hamilton 85000 0.06 DetachedChapter 2: Descriptive Statistics ABC Real Estate Company renovates and sells houses in different areas of Los Angeles. A sample of 50 houses was selected from their previous year's nal sales (Date File: CH2). Selling price, size, location (name, population, jobless rate), and type of the houses are included in the dataset. The company would like to use the sample data to determine the average house price in different regions, and whether or not area population and jobless rate play any role in the prices. Use the methods of descriptive statistics to learn about the ABC Real Estate Company's activities. Include the following in your report. 1. Graphical and numerical summaries to display the scope of company's activities in terms of house sizes, prices, and locations (tables and histograms). Discuss what you learn about the company in terms of its variety of operations. 2. Summarize the equency, selling price, size (z), and price per ft2 for different house types in different neighborhoods. Try to come up with valuable insights. For example, which neighborhood is more expensive; are detached houses on average larger than condominiums, any exceptions, etc. Is there any limitation in extracting insights? 3. Develop scatter diagrams to explore the relationship between the average price per ft2 and area's characteristics (e. g. population and jobless rate). Use the vertical axis for price per z. Compute the sample correlation coefcients to support your observations. 4. Is there any linear relationship observable between house sizes and per-it2 prices? Does it make sense