6g00%24LUYou have attached in the MS-Excel file data on residential houses, their prices, facilities, locations, etc.The variables are PRICE (Price of each House),POOL (Whether the house has a swimming pool or not. Pool has a value of 1 if the house has a swimmingpool and "0" if the house does not have a swimming pool)DISTANCE (Distance from the City in miles)SIZE (The amount of living space in the house in Square Feet)YOUR ASSIGNMENTSort the data according to and separate houses that have a swimming pool from houses that do not have a1. Calculate the mean and standard deviations for (Prices, Living Space, and Distance from the City) ofthe two categories of houses (Swimming pool vs. no swimming pool)2. Calculate the Coefficients of Variations comparing the two categories of houses and present yourresults in tables and charts. Which category of houses has a wider variation in the values of thevariables that you analyzed?3. Construct a 97% Confidence Interval Estimate for each of the three variables and use your ConfidenceIntervals to compare the two categories of housesREAL ESTATE.xlsREAL ESTATE.xlsASSIGNMENT SUBMISSIONnere to searcha48 F Mostly cloudydy93Olyf12%233.9.6R.}7 N|2QN FNmN5551t%2412/2N 6 t N3 4 5 m64t23/343业不45 O23S.caps lock&tab%3.#fs米f4f3f2esca.#五1.9 Type here to search2.01.54.4.1.ReadyREAL ESTATE212261.1.006257.20187.00173.10326.30345.30209.30192.90152520.22002121009.4.11281.010091.4.4.148.5.41201006251.1.151009244.4.2.50.01252.3022006234.3.2.93.20.(0६ 60८198.90207.50172.702123005.4.211.202.01.1.1.1.20.1118.281.30173.2.01.1.219-194.407.8.4.21009.1.51.4.1.1.1.246.10270.8013152.03.21142.01414.13.18.9.41292.4009 99671.1.51.2400412.52.02.3.3.221.106.111.2100000271.808.1.1.2.01.9.1.52.52.01228.2.2.2.3.1.327.201.2.06 699.3.20121.00004.213.601.2.05.1.4.DISTANCE TOWNSHI GARAGE BATHSD.182.40263.101 PRICE0004.100dROOMS SIZEB.C.

Question

6g00%24LUYou have attached in the MS-Excel file data on residential houses, their prices, facilities, locations, etc.The variables are PRICE (Price of each House),POOL (Whether the house has a swimming pool or not. Pool has a value of 1 if the house has a swimmingpool and &#34;0&#34; if the house does not have a swimming pool)DISTANCE (Distance from the City in miles)SIZE (The amount of living space in the house in Square Feet)YOUR ASSIGNMENTSort the data according to and separate houses that have a swimming pool from houses that do not have a1. Calculate the mean and standard deviations for (Prices, Living Space, and Distance from the City) ofthe two categories of houses (Swimming pool vs. no swimming pool)2. Calculate the Coefficients of Variations comparing the two categories of houses and present yourresults in tables and charts. Which category of houses has a wider variation in the values of thevariables that you analyzed?3. Construct a 97% Confidence Interval Estimate for each of the three variables and use your ConfidenceIntervals to compare the two categories of housesREAL ESTATE.xlsREAL ESTATE.xlsASSIGNMENT SUBMISSIONnere to searcha48 F Mostly cloudydy93Olyf12%233.9.6R.}7 N|2QN FNmN5551t%2412/2N 6 t N3 4 5 m64t23/343业不45 O23S.caps lock&tab%3.#fs米f4f3f2esca.#五1.9 Type here to search2.01.54.4.1.ReadyREAL ESTATE212261.1.006257.20187.00173.10326.30345.30209.30192.90152520.22002121009.4.11281.010091.4.4.148.5.41201006251.1.151009244.4.2.50.01252.3022006234.3.2.93.20.(0६ 60८198.90207.50172.702123005.4.211.202.01.1.1.1.20.1118.281.30173.2.01.1.219-194.407.8.4.21009.1.51.4.1.1.1.246.10270.8013152.03.21142.01414.13.18.9.41292.4009 99671.1.51.2400412.52.02.3.3.221.106.111.2100000271.808.1.1.2.01.9.1.52.52.01228.2.2.2.3.1.327.201.2.06 699.3.20121.00004.213.601.2.05.1.4.DISTANCE TOWNSHI GARAGE BATHSD.182.40263.101 PRICE0004.100dROOMS SIZEB.C.

Accepted Answer

Hello! As you have posted more than 3 sub parts, we are answering the first 3 sub-parts(means,…