issac, .r'nira File Home Insert Draw Design Layout References Mailings Review View Heip 6 Share Fl Comments I The data set contains sale prices of house sold between May 2014 and May 2015 that are located at King County, Seate. id Id number for each house gear sold Year the house was sold price Sold price of the house bedrooms Number of bedrooms in the house bathrooms Number of bathrooms in the house satt Living square footage of the house sgtt lot square footage of the lot oors Total oors (levels) in house waterfront Whether the house has a View to a waterfront; 1= Yes; 0=No. condition How good the condition is (Overall) 2. 1= very bad; 5 = very good 1 sgtt above Square footage of house above basement sgtt basement Square footage of the basement gear built Built Year of the house .; xear renovated Year when house was renovated zigcode ZiEcode of the house Page1of3 472words B} :D: Focus g [i 7 I + 110% E: pTypeheretosearch 0 ii in e a a I g F I. a A q!\" 1"\" E 33.33% a AutoSave O Off) Exam Ill - Saved to this PC . Search Issac, Amira IA X File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Q1. Conduct descriptive analysis of the data and answer the following questions. (a) Fill the table below with the average price of the houses sold by year and number of bedrooms. (16 points) Table 1: Average Housing Price of King County Year Number of Bedrooms 2014 2015 2 3 4 5 6 (b) Fill the table below with the number of houses sold by year and number of bedrooms. (16 points) Table 2: Number of real estate transactions of King County Year Number of Bedrooms 2014 2015 2 3 4 5 6 Page 2 of 3 472 words X Focus + 110% 10:40 AM Type here to search O W X 4/30/2021