Other than question $3,$ you do not need to create copies of the pivot table like in the demo. Pay attention to the wording of each question to decide which variables to use to build your pivot table for each question.

$(1)$ Using the Data on the HousePriceData worksheet, create a pivot table to find the average house price in the "Neither" location. $($To two decimal places$)$ the average house price $($in $$K)$ is

$(2)$ Using the Data on the HousePriceData worksheet, create a pivot table to find the number of "Other" style houses in the "Ravine" location. The number of houses is

$(3)$ Using the Data on the HousePriceData worksheet, create a pivot table to find the percent of houses that are "Bungalow" style AND in the "Golf" location. $($To zero decimal places$)\%$ of all the houses are "Bungalow" style AND in the "Golf location.

Hint: Divide by the grand total in the bottom right corner.

$(4)$ Using the Data on the HousePriceData worksheet, create a pivot table to find the maximum size of an "Other" style house that's in the "Golf" location. $($To two decimal places$)$ the maximum house size is

$(5)$ Using the Data on the HousePriceData worksheet, create a pivot table to find the standard