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 Exam Ill - Saved to this PC Search X AutoSave O Off) Issac, Amira IA File Home Insert Draw Design Layout References Mailings Review View Help Share Comments (c) Create bar charts to illustrate your results from Table 1 [Q1 (a)] and Table 2 [Q1(b)] above. (16 points) (d) Write down a paragraph explaining and interpret the results from Table 1 [Q1 (a)] and Table 2 [Q1(b)] above. (16 points) Q2. Run an analysis of the relationship between price of the house and total floors (levels) in house. (a) What is the Pearson correlation between the two variables? (16 points) - (b) Write down a paragraph explaining and interpret the results of your analysis in Q2(a). (16 points) Page 3 of 3 472 words DX Focus + 110% 10:40 AM Type here to search O n W X 4/30/2021