Overview This assignment involves using Microsoft Excel to explore real estate data. You will need to import the data, create several pivot tables, and use those pivot tables to analyze the data and provide answers to several questions posed below. The Problem The data provided for this assignment consists of home sales data for 1,460 properties in the Ames, Iowa region collected between 2006 and 2010. For each property there are 79 explanatory variables (79 variables or pieces of data about each property that may influence the sale price), as well as the property sale price. The problem posed is this: what variables most directly impact the sale price of a property? Deliverables Please download the data and its associated description. Import the data into Excel and save it as an Excel workbook in the form LastNameHW1.xlsx, where LastName is replaced with your last name. Review the data, the data description, and the questions posed below, and construct one pivot table for each of the following questions: 1) How many homes were sold each year? 2) Which year had the lowest average sale price? 3) Which neighborhood has the highest average sale price? 4) Which neighborhood had the single lowest sale price property? 5) What is the average sale price by number of above ground bedrooms? Extra Credit 6) What is the average price per above grade living area square foot in each neighborhood? Make sure that you place each pivot table on a new worksheet. Rename the worksheet appropriately. Edit column headings and categories to make the tables meaningful to the reader. Arrange the worksheet tabs such that the left