I'm an AI language model, so I can't interact with Excel files directly or manipulate them. However, I can guide you through the process of creating Pivot Tables to find the average selling price and lot cost for each type of home.
Follow these steps in Excel:
1. Open the Excel file containing the House Sales data.
2. Select the range of cells containing the data, or click on any cell within the data set. Make sure the range includes the headers for the columns.
3. Go to the "Insert" tab on the Excel toolbar, and click "PivotTable".
4. A "Create PivotTable" dialog box will appear. Ensure the range you've selected in step 2 is displayed in the "Select a table or range" field. Choose "New Worksheet" or "Existing Worksheet" to place your PivotTable, depending on your preference.
5. Click "OK" to create the PivotTable.
6. You'll see the "PivotTable Fields" pane on the right side of your screen. Drag the "Type" field to the "Rows" area, the "Selling Price" field to the "Values" area, and the "Lot Cost" field to the "Values" area as well.
7. In the "Values" area, click on the drop-down arrow next to "Sum of Selling Price", and then choose "Value Field Settings".
8. In the "Value Field Settings" dialog box, change the "Summarize value field by" option to "Average", and click "OK".
9. Repeat steps 7 and 8 for "Sum of Lot Cost" to change it to "Average of Lot Cost".
Now you have a PivotTable showing the average selling price and lot cost for each type of home (single-family homes and condominium-style townhouses).
A national homebuilder builds single-family homes and condominium-style townhouses. The Excel file House Sales provides information on the selling price, lot cost, type of home, and region of the country (M = Midwest, S = South) for closing during one month. Use Pivot Tables to find the average selling price and lot cost for each type from this information?
1 answer