How do I do this problem in Excel?

Gate View Condominiums

Problem 1 Gustav Real Estate Properties, Inc. is a real estate firm located in San Francisco, CA. The company monitors condominium sales by collecting data on location, list price, sale price and number of days it takes to sell each unit. Each condominium is classified as Gate View if it has a Golden Gate view or No Gate View if it doesn't have a view of the bridge. Sample data from Multiple Listings Services provided recent sales data for 40 Gate View condominium and 18 No Gate View condominiums. Prices are in thousands (000s) of dollars. The data is available in the dataset Real Estate. Perform an analysis of the Gustav Real Estate Properties data for their President and Management Team that summarizes your investigation and findings. Assume you are a consultant to Gustav Real Estate Properties, Inc. 1. Use appropriate descriptive statistics to summarize each of the three variables for the 40 Gate View condominiums and for the 18 No Gate View condominiums. 2. Compare your summary results. Discuss any specific statistical results that would help a real estate agent understand the condominium market. (Be specific. Make sure you discuss the mean, median, standard deviation, max, and min.) \begin{tabular}{ccrcrr} \multicolumn{2}{c}{ Gate View Condominiums } & \multicolumn{2}{c}{ No Gate View Condominiums } \\ \hline List PriceSale Price Days to Sell & \multicolumn{2}{c}{ List Price Sale Price Days to Sell } \\ 495.0 & 475.0 & 130 & 217.0 & 217.0 & 182 \\ 379.0 & 350.0 & 71 & 148.0 & 135.5 & 338 \\ 529.0 & 519.0 & 85 & 186.5 & 179.0 & 122 \\ 552.5 & 534.5 & 95 & 239.0 & 230.0 & 150 \\ 334.9 & 334.9 & 119 & 279.0 & 267.5 & 169 \\ 550.0 & 505.0 & 92 & 215.0 & 214.0 & 58 \\ 169.9 & 165.0 & 197 & 279.0 & 259.0 & 110 \\ 210.0 & 210.0 & 56 & 179.9 & 176.5 & 130 \\ 975.0 & 945.0 & 73 & 149.9 & 144.9 & 149 \\ 314.0 & 314.0 & 126 & 235.0 & 230.0 & 114 \\ 315.0 & 305.0 & 88 & 199.8 & 192.0 & 120 \\ 885.0 & 800.0 & 282 & 210.0 & 195.0 & 61 \\ 975.0 & 975.0 & 100 & 226.0 & 212.0 & 146 \\ 469.0 & 445.0 & 56 & 149.9 & 146.5 & 137 \\ 329.0 & 305.0 & 49 & 160.0 & 160.0 & 281 \\ 365.0 & 330.0 & 48 & 322.0 & 292.5 & 63 \\ 332.0 & 312.0 & 88 & 187.5 & 179.0 & 48 \\ 520.0 & 495.0 & 161 & 247.0 & 227.0 & 52 \\ 425.0 & 405.0 & 149 & & & \end{tabular} 675.0409.0649.0319.0425.0359.0469.0895.0439.0435.0235.0638.0629.0329.0595.0339.0215.0395.0449.0499.0439.0669.0400.0649.0305.0410.0340.0449.0875.0430.0400.0227.0618.0600.0309.0555.0315.0200.0375.0425.0465.0428.514228291408510772129160206911009711445150481355386158