Chapter Project Home Sweet Home: Using Confidence Intervals to Analyze and Compare Home Prices One of the biggest purchases we make in our lives is a home. As we buy a home if?- Data we ask ourselves many questions such as. The data can be found at How much should i spend for a home? stathawkeslearningcom Data Sets > Mount Pleasant 7 How many bathrooms are there. Real Estate Data What is the cost per square foot? Suppose you are looking for a house near Charleston in Mount Pleasant, SC, and you have narrowed your search to three subdivisions: Carolina Park, Dunes West, and Park West. a. Download the Mount Pleasant Real Estate data set. f. Construct an interval to estimate the true average List Price for each subdivision with 95% confidence. Based on these condence intervals, is it possible that Carolina Park and Dunes West have the same average List Price. Discuss. Do you think a List Price of $520,000 is a reasonable value for the Carolina Park b. Import the data into Minitab, Excel or other statistical software. c. For the variable List Price, calculate the sample mean, the sample standard deviation, and the sample size for the three different subdivisions. g. Put the calculations in a table and round to the nearest dollar for the sample standard deviation subdivision? and the mean. h. Do you think a List Price of $670,000 is d. Based on the data set and the information we a reaab'e value for the Dunes WESt subdnwsmn? have, which condence interval should we use here, a z or a t interval? Why? i. Do you think a List Price of $568,000 is a reasonable value for both the Carolina Park and Park West subdivisions? e. Find the critical value for a 95% condence level for each subdivision for the variable List Price