answer the following questions by creating pivot tables based on the real estate data set ("HousingDT.cvs available on blackboard). You can refer to the DataDescriptions file for attribute descriptions. you do not need to submit Excel spreadsheets: please just answer the following questions:

a) report the average student/teacher ratio for the four subgroups (2x2 pivot table) based on two attributes, 'Distance and median'. Group the distance criteria into two groups 1.12 to 7.12 and 7.12 to 13/12) do the areas with high median home values have higher or lower student/teacher ratios? Do the areas closer to the employment centers have higher or lowere student/teacher ratios? Based on your experience do you find the results counterintuitive?

b) Report the average crime rate for the four subgroups (2x2 pivot table) based on two attributes, Ind and Median. Group the Ind criteria into two groups (0.46 to 15.46 and 15.46 to 30.46) Do the areas with High median home values have higher or lower crime rates? Do the areas with higher industrial uses have higher or lower crime rates? Based on your experience do you find the results counterintuitive?