he file MidCity contains data on 128 recent sales in Mid City. For each sale, the file shows the neighborhood (1, 2, or 3) in which the house is located, the number of offers made on the house, the square footage, whether the house is made primarily of brick, the number of bathrooms, the number of bedrooms, and the selling price. Neighborhoods 1 and 2 are more traditional neighborhoods, whereas neighborhood 3 is a newer, more prestigious neighborhood.
Include steps for below.
Sort and filter the data from the MidCity file so that you only consider the data from neighborhood 2. Construct an 99% confidence interval for the population square feet of all homes in neighborhood 2. Make sure you list the specific equations you are using, ALL variables, show ALL work etc. You can use Excel to compute your variables (ie the mean, variance, standard deviation, proportions etc). However, the rest of the steps should be done manually (similar to our notes). Go back to our notes and follow the same steps. Remember to interpret these confidence intervals in the context of this problem. Use one Excel spreadsheet labeled P1PartB to show your work for this problem.