Autosave Off GBS221_Data for_Lesson_6_Essay File Home Insert Page Layout Formulas Data Review View Au X Cut Calibri 11 A A E Paste LB Copy BIU. v A E Format Painter Undo Clipboard Font D17 XV fx A B C D E F G H Lake View Homes No Lake View Homes 2 List Price Sale Price Days to Sell List Price Sale Price Days to Sell 3 $ 675.00 $ 669.00 142 $ 217.00 $ 217.00 182 4 $ 409.00 $ 400.00 28 $ 148.00 $ 135.50 338 5 $ 649.00 $ 649.00 29 $ 186.50 $ 179.00 122 6 $ 319.00 $ 305.00 140 $ 239.00 $ 230.00 150 7 $ 425.00 $ 410.00 85 $ 279.00 $ 267.50 169 8 $ 359.00 $ 340.00 107 $ 215.00 $ 214.00 58 9 $ 469.00 $ 449.00 72 $ 279.00 $ 259.00 110 10 $ 895.00 $ 875.00 129 $ 179.90 $ 176.50 130 11 $ 439.00 $ 430.00 160 $ 149.90 $ 144.90 149 12 $ 435.00 $ 400.00 206 $ 235.00 $ 230.00 114 13 $ 235.00 $ 227.00 91 $ 199.80 $ 192.00 120 14 $ 638.00 $ 618.00 100 $ 210.00 $ 195.00 61 15 $ 629.00 $ 600.00 97 $ 226.00 $ 212.00 146 16 $ 329.00 $ 309.00 114 $ 149.90 $ 146.50 137 17 $ 595.00 $ 555.00 45 $ 160.00 $ 160.00 281 18 $ 339.00 $ 315.00 150 $ 322.00 $ 292.50 63 19 $ 215.00 $ 200.00 48 $ 187.50 $ 179.00 48 20 $ 395.00 $ 375.00 135 $ 247.00 $ 227.00 52 21 22 23 24 25Essay 1. Use the Case Study Scenario (background information) below to create the essay. 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 in 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. 2. Answer the questions below in essay format. Your essay must include an introduction, a body, and a conclusion. It must address all relevant parts of each question. 3. Your response should be a minimum of 500 words in length, and it should include your analysis of all calculations. Make sure to cite any source you use. 4. All references must be created in APA format as described in Lesson 0. Essay Qu Using the Lesson 6 Essay data file, provide a summary report for management including the following information in an essay with a minimum of 500 words: ons: Probability 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 ofa 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? 9. 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