You’re asked to do further research on the housing market in Albuquerque, New Mexico, during the...

You’re asked to do further research on the housing market in Albuquerque, New Mexico, during the early 1990s. In this analysis you’ll examine the size of the homes sold on the market and the price per square foot of each home. a. Open the Housing workbook from the Chapter04 folder and save it as Home Sizes. b. Create a table of univariate statistics for the size of the homes in square feet, including all distribution, variability, and summary statistics except the mode. Place the table on a worksheet named Sq Ft. Stats. c. What are the smallest and largest houses in the sample? d. If you were interested only in houses that were 2,200 square feet or higher, what percentage of the houses in the sample would meet the requirement? (Hint: Use the PERCENTRANK function.) e. Create a boxplot of the size of the homes in square feet. Place the boxplot in a chart sheet named Sq Ft. Boxplot. f. What value appears to be an extreme outlier in the boxplot? g. Create a second boxplot of house size, this time breaking the boxplot down by whether the home is a corner lot. Place the plot in a chart sheet named Sq Ft. Boxplot by Corner Lot. h. Interpret your boxplot in terms of the relationship between size of a house and whether it lies on a corner lot. i. What happened to the extreme outlier you identifi ed earlier? Discuss this in terms of the defi nition of outlier given in the text. Is this value an outlier or not? j. Recreate the table of univariate statistics for house size, and this time break the table down by the Corner Lot variable. Place the table in a worksheet named Sq Ft. Stats by Corner Lot. k. Create a new column containing the price per square foot of each house. Assign the values in the new column a range name. What type of variable is this? l. Create a histogram with 20 evenly spaced bins of the price per square foot on a chart sheet named PPSqFt Histogram. Count the bins totals to the right of the cutoff points. m. What is the shape of the distribution of price per square foot? n. Create a boxplot of the price per square foot saved to the chart sheet PPSqFt. Boxplot. Are there any severe outliers? How does the median value compare to the mean value? o. Save your workbook and then write a report summarizing your observations.