In cells F26-G26, choose how you would describe the shape of the distribution from the drop-down menu. In cells F27-G27, choose which measure of 'center' is best to describe the distribution from the drop- down menu. In cells F28-G28, choose how to compare the values of the mean and the median from the drop-down menu. In cells F29-G29, choose which measure of 'spread' is best to describe the distribution from the drop- down menu. In cell D34, calculate the percentage of homes rounded to one decimal place whose prices are expected to exceed $300,000 using the value(s) found in step 5. Note: Using the Histogram tool, a value is included in a particular bin if the number is greater than the lowest bound and equal to or less than the greatest bound for the data bin. In cell D36, calculate the percentage of homes rounded to one decimal place that are priced between $90,000 and $300,001, exclusive, using the value(s) found in step 5. Note: Using the Histogram tool, a value is included in a particular bin if the number is greater than the lowest bound and equal to or less than the greatest bound for the data bin. In cell D38, calculate the percentage of homes rounded to one decimal place expected to be priced less than or equal to $150,000 using the value(s) found in step 5. Note: Using the Histogram tool, a value is included in a particular bin if the number is greater than the lowest bound and equal to or less than the greatest bound for the data bin. Construct two histograms showing the distribution of prices for homes without central air and the prices for homes with central air. First, create the two columns of data. On the Data worksheet, copy the Price column to columns P and Q. In cell P1, type Price without central air. In cell Q1, type Price with central air. Then select the first row, go to the Home tab of the Ribbon, and select Sort&Filter in the Editing group. Select Filter in