Data Set 2: Gulf Properties Gulf Real Estate Prosperities, Inc. is a real estate firm located in South Florida. The company advertises itself as \"expert in the real estate market,\" and monitors condominium sales by collecting data on location, list price, sale price, and the number of days it takes to sell each unit. Each Gulf View condominium is classied as Gulf view if it is located directly on the Gulf of Mexico. Sample data 'om the Multiple Listing Services in Florida provided sales for 40 Gulf view condominiums. mption of Variables List Price: the list price of a condominium in thousands of dollars Sale Price: the sale price of a condominium in thousands of dollars Days to Sell: the number of days it takes to sell each unit. Exercise 2. Use the Excel le Lab #3 (Exercise 2) to complete the following tasks. A. Use descriptive statistics to summarize the data. Discuss any statistical results that would help a real estate agent understand the condominium market. B. Develop 95% condence interval estimate of the population mean sale price and the population mean number of days to sell Gulf View Condominiums. Interpret the results in the context of the problem. C. Gulf view Real estate properties just sign a contract for a new listing with a list price of $589,000. What is your estimate of the nal selling price and the number of days require to sell this unit? A B C D 1 Gulf View Condominiums 2 List Price Sale Price Days to Sell 3 495.0 475.0 130 4 379.0 350.0 71 5 529.0 519.0 85 6 552.5 534.5 95 334.9 334.9 119 8 550.0 505.0 92 9 169.9 165.0 197 10 210.0 210.0 56 11 975.0 945.0 73 12 314.0 314.0 126 13 315.0 305.0 88 14 885.0 800.0 282 15 975.0 975.0 100 16 469.0 445.0 56 17 329.0 305.0 49 18 365.0 330.0 48 19 332.0 312.0 88 20 520.0 495.0 161 21 425.0 405.0 149 22 675.0 669.0 142 23 409.0 400.0 28 24 649.0 649.0 29 25 319.0 305.0 140 26 425.0 410.0 85 27 359.0 340.0 107 28 469.0 449.0 72 29 895.0 875.0 129 30 439.0 430.0 160 31 435.0 400.0 206 32 235.0 227.0 91 33 638.0 618.0 100 34 629.0 600.0 97 35 329.0 309.0 114 36 595.0 555.0 45 37 339.0 315.0 150 38 215.0 200.0 48 39 395.0 375.0 135 40 449.0 425.0 53 41 499.0 465.0 86 42 439.0 428.5 158 43