General Conditional format asce Formatting Table Styles Sort & Find & Filter - Select - Editing 21 : x MN OPO 100 Calculate the mean standard deviation for each of the variables: a. LV List The list price of a lake view home b. LV Sale The sale price of a lakeview home C.LV Days The number of days to sell alake view home d. NLV List The list price of a no lake view home e. NIV Sale The sale price of a no lakeview home F.NLV Days The number of days to sell alake view home 10 1 Lake View Homes 2 List Price Sale Price Days to Sell 3 $675.00 $ 669.00 142) 4 $409.00 $ 400,00 5 $649.00 $ 649.00 6 $319.00 $ 305.00 7 $425.00 $ 410.00 8 $ 359,00 $ 300.00 9 $469.00 $ 449.00 10 $895.00 $ 875.00 129 11 $439.00 $ 430.00 12 $435.00 $ 400.00 13 $235.00 $ 227.00 14 $618.00 S 615.00 15 $629.00 $ 600.00 16 $329.00 $ 309.00 114 17 $55.00 $ 555.00 18 $339.00 $ 315.00 150 19 $215.00 $ 200.00 20 $395.00 $ 375.00 135 No Lake View Homes List Price Sale Price Days to Sell $217.00 217.00 $143.00 $ 135.50 $ 186.50 $ 179.00 $ 239.00 $ 230,00 $ 279.00 $267.50 $215,00 $ 214.00 $ 279,00 S 9.00 $129,90 S 125.50 $149.90S 140 $235.00 $ 230,00 $ 199.00 $ 192,00 $ 210.00 $ 195,00 $ 226.00 $ 212.00 $19. 0 145 SO $160.00 $ 150.00 $322.00 22.50 $187.50 $ 179.00 $247.00 $ 227.00 Develop a 95% confidence interval estimate of the mean ales price and the mean number of days to sell a lake view home andano lakeview home interpret the results. 91 100 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 lakeview 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? 22 $430,00 S 40500 1033 $212.50 S 203.50 $ 126.00 Median 24 5680.00 S 675.00 178 $174.00 $ 157.00 $ 230.00 Range