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 P$1,$ type Price without central air. In cell Q$1,$ 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 the drop$-$down menu. In cell E$1,$ open the drop$-$down menu and select to show only value $0.$ Delete all of the filtered values in column $Q.$ Then in cell E$1$ in the drop$-$down menu, select to show only value $1.$ Delete all of the filtered values in column P$.$ Go back to cell $E1$ and select to show all values.

Construct the histogram using Data Analysis for the Price without central air column using the Binsize column K $($starting on cell K$1).$ Choose cell R$1$ on the Data worksheet as the output range. Be sure to check the 'Labels' and 'Chart Output' boxes in the Histogram menu. Move the histogram to the Problem worksheet and place it in cells B$42-$C$42.$ Change the title of the histogram to Distribution of selling prices without central air. Right click on one of the bars and select 'Format Data Series'. Slide the 'Gap Width' to zero.

Construct the histogram using Data Analysis for the Price with central air column using the Binsize column K $($starting on cell K$1).$ Choose cell T$1$ on the Data worksheet as the output range. Be sure to check the 'Labels' and 'Chart Output' boxes in the Histogram menu. Move the histogram to the Problem worksheet and place it in cells D$42-$G$42.$ Change the title of the histogram to Distribution of selling prices with central air. Right click on one of the bars and select 'Format Data Series'. Slide the 'Gap Width' to zero.