MGTS Independent Lab $3$ Assessment QuestionsOther 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 thats 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 deviation of size of an Other style house thats in the Ravine location. $($To two decimal places$)$ the standard deviation of house size is $\_\_\_\_\_\_\_.$