Case Study Scenario Lake View Homes, a real estate company that specializes in residential real estate, is located in Havasu City, Arizona. Management wants to know if its marketing efforts should focus on selling lake view homes primarily and has asked you, the statistics expert, to provide relevant statistics to make an informed decision with its marketing dollars. a. Calculate the mean, median, standard deviation, and the range for each of the variables: a. LV List The list price of a lake view home b. LV Sale The sale price of a lake view home c. LV Days The number of days to sell a lake view home d. NLV List The list price of a no lake view home e. NLV Sale The sale price of a no lake view home f. NLV Days The number of days to sell a lake view home b. Compare your results for the statistics in Question 1. Explain how the results would help a real estate agent understand the local market. C. Develop a 95% confidence interval estimate of the mean sales price and the mean number of days to sell a lake view home and a no lake view home. Interpret the results. d. Assume the company just signed contracts on two new listings: A lake view home with an asking price of selling price of $600,000 and no lake view home with an asking price of $300,000. What is your estimate of the final selling price and the number of days required to sell each of these homes? e. Based on your total analysis, provide management with your suggestions on how the company's marketing dollars should be spent. Should the company market primarily lake view homes? Explain. D E F . . B Lake View Homes List Price Sale Price Days to Sell $ 675.00 $ 669.00 142 $ 409.00 $ 400.00 28 $ 649.00 $ 649.00 29 $ 319.00 $ 305.00 140 $ 425.00 $ 410.00 85 $ 359.00 $ 340.00 107 $ 469.00 $ 449.00 72 $ 895.00 $ 875.00 129 $ 439.00 $ 430.00 160 $ 435.00 $ 400.00 206 $ 235.00 $ 227.00 91 $ 638.00 $ 618.00 100 $ 629.00 $ 600.00 97 $ 329.00 $ 309.00 114 $ 595.00 $ 555.00 45 $ $ 339.00 $ 315.00 150 $ 215.00 $ 200.00 48 $ 395.00 $ 375.00 135 E F G No Lake View Homes List Price Sale Price Days to Sell $ 217.00 $ 217.00 182 $ 148.00 $ 135.50 338 $ 186.50 $ 179.00 122 $ 239.00 $ 230.00 150 $ 279.00 $ 267.50 169 $ 215.00 $ 214.00 58 $ 279.00 $ 259.00 110 $ 179.90 $ 176.50 130 $ 149.90 $ 144.90 149 $ 235.00 $ 230.00 114 $ 199.80 $ 192.00 120 $ 210.00 $ 195.00 61 $ 226.00 $ 212.00 146 $ 149.90 $ 146.50 137 $ 160.00 $ 160.00 281 $ 322.00 $ 292.50 63 $ 187.50 $ 179.00 48 $ 247.00 $ 227.00 52