please answer part a and b

LOX PRICE FINAREA 214190 28 1510 1215 SITE 21400 SON 1 1 1 BUILT TOTRMS 7 4 4 4 4 7 4 7 4 1 7 1 1 1 3153 1729 4 19 417 381465 584111 46150 472750 11 1 1 1 1 E 1 1 SIT 21775 1071 2059 20111 28533 10 27251 2293 4110 17250 S100 1 5 . 1960 SO 13HIN 1356 195 1255 193 5 . 0 1 1 3 5 11 1 O 1 9119 . . 11 51450 20130 1945 125 1317 10 . . 15000 2149 4341 547 1 1979 1997 6 SWEE CHCI 7 1 . . 1TSA 15 IS . 1 7 6 6534 6534 1939 18123 17415 17695 2017 1 131565 135240 152145 10 106 110 123311 1 1913 1913 1901 0 o ID 10 10 DOSE TI 19 19 192 1M 121 6 7 D 0 0 0 D 0 1200 131 58653 35800 00 235200 13:34 201 1 9 1878 10 18 10 11 11 3312 1657 305 130 SIZE 1 0 0 IL 44 0295 SIIS NE 09 1981 1 0 1 1 11 11 11 11 55713 72165 3450 235.00 1255 1257385 1024 13700 138913 11157 13210 157290 12500 5 13:40 1674 1074 161) 10 1663 6 6 6 $ 5 $ 5 7 134 11 1 1 19100 30 13 5 5 1945 TOLS 2018 14 1 1 1 . 0 D W 30300 4100 12350 35110 1971 25400 28 19230 1935 16 2160 13210 1351 2017 1 12 14 14 14 14 14 14 14 14 15 6 1 BE 1 1 1 5 154130 154150 TIISTA 152145 1990 1900 2000 IS 15 15 $ 4 1 22:50 2653 3103 1704 1954 1541 2009 1900 220 14 17350 2011 2440 1977% 1240 14100 19900 1600 17250 21531 O 0 0 1 30 21 $ 6 30 1 0 1 D 0 URY PE 101430 1900 105910 141130 16.3575 11030 11170 TO 1037 102753 1070725 105540 Tin 30 . 9 1 4 1755 1629 1625 1995 19 TE SE 0 9100 104 104 11040 8214 . 35 15 0 . 3 1 1 1712 0 Using the data on the sheet 'Home', solve the following question on sheet P1. a. Using the tools menu and the data analysis, find the correlation matrix for the given data and place the correlations between the PRICE and the explanatory variables on the sheet b. Regress the price with the given independent variables and determine what price would you expect for a home with 2055 sq ft of finished area, on a 23,500 sq ft lot, of good location (=1), built 5 years ago, 7 total rooms and fire place(=1). c. Regress the price with the given independent variables and determine what price would you expect for a home with 3335 sq ft of finished area, on a 35,975 sq ft lot, of bad location (=0), built 15 years ago, 9 total rooms and no fire place(=O). Problem 1 FINAREA SITE LOC BUILT TOTRM$ FIRE Correlation Matrix PRICE PRICE FINAREA SITE LOC BUILT TOTRMS FIRE b. Coefficients values Intercept FINAREA SITE LOC BUILT TOTRMS FIRE Home Price 0 Coefficients values Intercept FINAREA SITE LOC BUILT TOTRMS FIRE home price 0 LOX PRICE FINAREA 214190 28 1510 1215 SITE 21400 SON 1 1 1 BUILT TOTRMS 7 4 4 4 4 7 4 7 4 1 7 1 1 1 3153 1729 4 19 417 381465 584111 46150 472750 11 1 1 1 1 E 1 1 SIT 21775 1071 2059 20111 28533 10 27251 2293 4110 17250 S100 1 5 . 1960 SO 13HIN 1356 195 1255 193 5 . 0 1 1 3 5 11 1 O 1 9119 . . 11 51450 20130 1945 125 1317 10 . . 15000 2149 4341 547 1 1979 1997 6 SWEE CHCI 7 1 . . 1TSA 15 IS . 1 7 6 6534 6534 1939 18123 17415 17695 2017 1 131565 135240 152145 10 106 110 123311 1 1913 1913 1901 0 o ID 10 10 DOSE TI 19 19 192 1M 121 6 7 D 0 0 0 D 0 1200 131 58653 35800 00 235200 13:34 201 1 9 1878 10 18 10 11 11 3312 1657 305 130 SIZE 1 0 0 IL 44 0295 SIIS NE 09 1981 1 0 1 1 11 11 11 11 55713 72165 3450 235.00 1255 1257385 1024 13700 138913 11157 13210 157290 12500 5 13:40 1674 1074 161) 10 1663 6 6 6 $ 5 $ 5 7 134 11 1 1 19100 30 13 5 5 1945 TOLS 2018 14 1 1 1 . 0 D W 30300 4100 12350 35110 1971 25400 28 19230 1935 16 2160 13210 1351 2017 1 12 14 14 14 14 14 14 14 14 15 6 1 BE 1 1 1 5 154130 154150 TIISTA 152145 1990 1900 2000 IS 15 15 $ 4 1 22:50 2653 3103 1704 1954 1541 2009 1900 220 14 17350 2011 2440 1977% 1240 14100 19900 1600 17250 21531 O 0 0 1 30 21 $ 6 30 1 0 1 D 0 URY PE 101430 1900 105910 141130 16.3575 11030 11170 TO 1037 102753 1070725 105540 Tin 30 . 9 1 4 1755 1629 1625 1995 19 TE SE 0 9100 104 104 11040 8214 . 35 15 0 . 3 1 1 1712 0 Using the data on the sheet 'Home', solve the following question on sheet P1. a. Using the tools menu and the data analysis, find the correlation matrix for the given data and place the correlations between the PRICE and the explanatory variables on the sheet b. Regress the price with the given independent variables and determine what price would you expect for a home with 2055 sq ft of finished area, on a 23,500 sq ft lot, of good location (=1), built 5 years ago, 7 total rooms and fire place(=1). c. Regress the price with the given independent variables and determine what price would you expect for a home with 3335 sq ft of finished area, on a 35,975 sq ft lot, of bad location (=0), built 15 years ago, 9 total rooms and no fire place(=O). Problem 1 FINAREA SITE LOC BUILT TOTRM$ FIRE Correlation Matrix PRICE PRICE FINAREA SITE LOC BUILT TOTRMS FIRE b. Coefficients values Intercept FINAREA SITE LOC BUILT TOTRMS FIRE Home Price 0 Coefficients values Intercept FINAREA SITE LOC BUILT TOTRMS FIRE home price 0