LAB WORK 5 (EXCEL) Lecture 8/9 From the House pricing) data file provided in the Departmental File (RUN). answer the following questions (2% of total course marks) Price Sq. Feltedroom Bathrooms Garaget $11000 1000 26 3 1 1 $133.300 1400 21 1 1 $112.00 12458 3 4 1 1 $141.750 110612 2 1 1 5199 250 211275 2 6 2 $132.250 1078 1 SI 16.00 992 13 2 2 S162.750 1100 2 1 1 $148.500 1040 17 3 1 1 S123 od 1616 27 2 1 S142.250 1150 25 2 2 $145 SOKO 17 3 2 SISS.250 146428 3 2 SIS0.750 12281 3 S150,900 11321 3 4 2 1 S14400 1132 1 3 4 1 S151.900 11321 3 4 S1650 1454 3 1 S155.750 12701 4 3 SIS7250 1362 23 3 $152.90011201 3 2 $145.250 1025 1 3 $ 2 1 $164.750 1.290 19 2 1 SI52.500 1260 3 4 1 S150,750 TOSSI 3 4 $144,750 1112 41 3 4 2 1 S1422501439 1 1 $14.500 1510 24 $213.02 2112 12 SISS.250 1351 1 4 $ 1 $367.90 13511 2 S148.500 11933 3 2 $1$2.500 1200 1 4 4 2 1 S167 200 1256 1 3 1 SI59.500 105 1 3 4 153.000 12001 3 + 2 $168.00 1901 4 1 S1010 110111 2 $165.200 1.3738 4 $174.900 1437 3 2 SI60.250 1330 1 3 $165 100 1261 1 3 4 2 1 SI70 500 159416 3 3 $155.900 1186 2 5167,200 13361 3 4 $165.400 1325 $16.500 13529 3 4 2 5178.500 11547 3 2 $164.000 13181 S172.750 141519 $149.000 1337 2 1 1 4 3 3 3 3 4 3 1 1 1 4 4 2 E t 1 1 1 4 1 1 2 1 4 5 4 4 4 4 1 3 3 3 1 3 1 1 1 1 3 3 3 3 3 3 3 4 4 4 2 1 1 1 2 4 4 5 2 2 2 1 1 1 1 1 1 0 2 1 3 3 3 4 4 4 + 4 1 1 3 4 1 1 1 2 6 4 3 1 1 I 1 1 4 4 $17.SO 1354 7 1516400 IN 1 5172.750 1415 9 15149.000 1137 2 5176000 2028 25 15205 500 1820 21 S181.100 1330 2 $16.600 1356 1 16.750 1150 2 SIX70015211 15190 600 1477 1 s16000 1165 4 $164.900 343022 SI5.00 1311 S184.750 1411 SI74.000 1412 1 ISI 3.250 1300 S169.000 1334 4 ISIS1900 1100 19 SIND 350 1900 43 5171,300 1328 1 $172.650 1350 $174.750 1601 5166,900 1405 5171.750 1619 $170,900 1450 s16.400 IRIN 5193.100 1424 1 5206,900 2240 16 $19000 1872 2 SIS SOO 1550 516 300, 1342 S157.100 1318 $177.650 1843 5207,100 1526 1 $191,900 1526 1 5164 250 1407 1 $146.100 ISIS 1 $136.750 14251 $236.600 2150 20 S1x2.250 1430 2 ISISR900 1975 10 $1730000 1433 8 5217.600 2400 34 5.201.000 216032 $149.650 1600 10 5206,150 1526 1 $162.00 1480 20 SIR20 129 1 $172.900 1493 1 S188.400 1728 4 S182.750 1828 5175 500 1689 SI57.500 1572 1 S211,900 1534 1 $307,300 1975 10 $126.750 HOS S181200 1938 22 S1815001564 3 SIS2.750 170022 S181200 13932 IsI61.400 ISO 9 5160300 1510 S $16.9 1689 1 $179,900 1407 1 S185.000 In 119 4 4 3 3 3 3 3 3 1 1 1 1 4 4 + 4 3 2 1 1 1 3 4 4 3 2 2 2 2 1 1 4 $ 4 3 1 4 4 4 5 4 4 1 1 1 1 1 1 2 3 2 5 4 3 1 $ 1 1 4 2 2 2 2 3 1 4 4 4 4 3 4 1 1 1 1 1 $ $ 4 4 4 3 + 4 3 3 2 1 1 1 4 4 3 Pihl 3 3 2 1 1 4 3 4 4 4 4 2 1 1 1 3 3 3 1 1 4 4 4 4 4 3 1 1 1 3 4 2 4 9 4 4 3 3 3 6 + 3 F 3 4 4 1 1 1 1 1 1 1 $ 2 5 4 4 3 3 2 1 4 5 3 4 1 1 1 3 4 4 1618 3 5 4 1 1 1 3 4 2 3 5 4 S160 300 1510 5 $16.900 1689 1 $179,900 1407 ISIRR 900193825 $201.750 1337 1 15.200,00 1500 8 I56.300 1488 1 $195300 1526 1 IS194350 1594 1 $199,10019 1 15207 400 1212 ! ISIS 0112 1 SIS7500 1773 9 5214300 13 20 $23.900 267220 S145.10010082 S181.750 17003 5196.9002080 22 1235 3 ST2S 200 $197.900 1800 22 $200,400 1661 1 5173,300 1680 9 IS191 1700 1 S166,100 1707 3 S182.750 1595 1 5164500 1420 1 S1900 5 5227.200 1632 5 5191.200 15581 $219.400 1720 7 $199,750 2072 29 5203.900 2012 24 $199.500 1899 1 516100 1572 1 5190 SOL 1672 5.208.800 1611 1 5228.700 1920 3 S228.900 236722 5194 200193413 $250.100271223 5224 600 2144 23 s211.250 2040 23 $161.500, 1622 1 5199 od 1665 1 $132.400 2192 26 5.229.250 2358 21 S159.700 1738 4 S211,700 1983 7 5199 250 219412 $194,750 2050 3 $147,750 7356 25 5208 900 WO 30 $24.600 1687 1 SI86S 1968 21 S194.200 1650S $126.00 1646 SI78000 18602 5.240 X 1536 21 $225.750 1566 $16.500 2000 14 5207.900 18756 $260.6501910 5245.750 2546 25 S112.00 1400 16 ST85.1002878 29 5235.500 1000 I IT 4 4 4 3 3 2 3 4 1 6 1 1 1 1 1 1 4 4 3 6 4 2 4 4 3 4 S 6 1 1 1 4 3 3 3 4 5 1 1 4 2 4 4 4 + 1 1 3 6 3 1 2 4 4 3 4 4 5 3 4 4 4 4 3 1 1 1 4 4 5 3 2 2 3 1 1 1 1 1 1 4 4 4 4 4 3 6 5 2 3 2 1 1 9 4 3 6 5 1 6 2 1 1 6 4 3 1 6 6 5 2 3 $ 4 5 5 1 1 1 1 1 1 1 2 3 R 6 6 4 $ 7 4 4 3 4 3 4 3 4 1 1 1 3 2 4 6 3 2 2 1 1 1 1 1 5 + 5 1 3 3 1 3 3 3 1 1 1 1 4 4 4 4 5 2 3 1 2 + 3 4 4 4 1 1 1 1 4 4 1 3 3 3 3 4 1 4 5 2 6 1 4 $ 4 4 COM 10 $245.750 2546 25 S112.00 1400 36 SIRS.10278 29 5235-500 3000 11 $179.00 1776 X $265.750 3024 18 5222.000 2682 20 5242.500 2037 0 ISIS 1836 152518 1711 3 5209.500 2700 19 5224 00 1651 2 520620 2200 22 5237 00 2051 12 Is26 500 000 3 $199,500 2700 42 $216.750 2182 1 S181,250 2000 37 5229.00 1930 S20750018342 52062501933 1 15265.400 2192 1 $219,250,2193 4 5272.00 2018 1 5229.600 2310 15261.000 2256 1 52745002710 $192.400 1984 15217.200 24431 201.700 2650 2 5243 350 2560 1 $287.700 2341 1 5240,750 23:50 1 5217.500 2567 1 $288.9002383 1 15265 500 2544 1 5252.750 251 s208, ISO $229,700 2400 15 5282 3002939 1 5234.750 2500 3 S170200 2854 1 5301 200 10NO 12 5305.9003659 1 $225,400 2542 6 5251.900 2208 5291 300 2939 1 5301.700 24601 $262.750 2619 1 $273.900 2718 10 $317.800 1403 5242.000 2619 5.298.500 1550 13 5229.00 2544 $ ISO 100 2567 $310.500 2938 1 5273,100 3321 12 5305.700 29751 $289,00 3063 5257 500 2754 1 $311.000 3285 8 15280,300 3300 12 $32.150 2895 1 15337-300 1277 1 126550 100 27 5231.000 2750 6 6 4 7 5 5 4 5 4 4 3 4 4 4 3 . 3 3 3 3 3 1 1 1 1 1 3 $ 4 5 1 1 1 1 S 4 5 6 3 1 4 5 1 1 1 5 4 4 6 5 $ 5 5 5 3 3 4 3 3 3 6 $ 1 1 6 4 4 4 1 1 1 4 1 4 5 5 7 1 1 5 1 1 1 4 4 3 3 5 5 4 7 6 1 1 1 1 3 $ 5 6 7 1 4 + 6 1 1 S 5 4 4 5 2 3 1 7 5 5 5 7 6 1 1 1 6 3 5 5 4 1 1 1 1 9 E 1 4 5 4 3 1 1 6 4 4 6 3 . 4 3 1 1 1 . 3 3 2 5 1 1 1 o 1 1 1 1 1 1 0 0 1 1 1 1 1 2 2 3 3 3 2 2 2 3 3 2 3 4 2 3 O 0 1 O . 1 1 1 3 0 1 0 1 2 1 2 1 1 1 2 1 0 0 PSEK 1302895 5337 300 3277 1 5265 So 2160 27 5231.000 2750 4 5274.00 2727 4 5263,500 2733 5361,1004080 14 $322.900 2900 2 151 So H0 1 Sax 3000 15309.300 2950 $298.000 3217 3 5278.000 2300 43 5331.000 2418 5 $317.000 3355 102.003114 10 SSR 100 1095 30 571,100 28 $$900 1159 SO S78.500 120023 $64.200 1430 54 557,600 121723 $54,100 911 49 572,000 954 53 590,00 950 48 $75 200 JONO 41 SSR 500 ILRO 7 5664,200 100452 S88.900 98 2x 56.550 45 SX2,250 100847 S68.600 140031 $75.900 1340 579.600 1563 44 S8800 107249 592,700 1534 19 580350 101621 583,400 1040 16 597,200 1136 29 596.300 128242 57.100 1670 47 $94.000 1530 54 $29.300 1789 33 SNR SO 1339 65 588.200 1160 21 591.600 1910 47 582.700 1100 591,100 1379 40 591 00 103215 596.450 1672 129 572,50 1407 37 $82.200 1450 $93.300 1728 61 SIT1,400 1976 37 590.250 1607 572.500 1532 41 $20.600 1288 3 S65.950 13209 $90,100 1416 41 ISE10,200 2002 36 151500 1550 42 $93,900 1568 40 584800 40 S103.00 1536 22 $121.000, 187239 SIO2.150 2200 IT 1161 TE E 1 2 4 3 3 3 1 . 2 2 2 4 o 1 1 3 4 0 + 4 1 . 3 2 3 4 1 1 4 4 o 2 2 3 2 3 . 0 . 1 1 1 2 3 0 OP 1 3 4 4 3 0 0 . 1 2 2 1 1 2 2 2 2 1 2 4 3 2 4 3 3 0 0 O 3 3 3 4 1 0 4 4 0 0 1 1 4 3 2 2 3 3 4 3 3 3 4 4 3 4 4 1 2 2 1 2 2 3 3 2 3 $110,200 2022 26 $122.500 1550 42 593,900 1568 40 584,00 1968 20 ISO 153612 $121.000 1872 39 S102.150 2200 31 $129, 1763 29 $82,950 2073 71 S111,700156352 S127.150 2002 SI39, 1968 47 $111.900 1340 9 $96.400 1730 12 $106,250 21682 $126,100292022 $121.950 1750 8 $150,990 2000 39 $142,100 2073 $173,200 2000 20 $157,850 1900 45 $164,00 2400 38 S130,100 3000 S123.000 21721 SINO SOD 2515 51 $169,900 2500 49 $213,000 2345 44 5 3 3 3 4 4 1 4 3 4 4 4 4 4 2 1 1 3 3 3 3 4 2 3 2 2 2 3 4 4 6 + 5 . 2 1 3 2 5 2 4 5 6 4 6 4 Get the excel results for 100 observations of Multiple Regression (Topic_9_Multiple Regression Data_House Prices First City-3) Write down the fitted multiple regression equation Interpret any two B's Test the Individual significance of the regression hypothesis at the 5% level of significance Test the Overall significance of the regression hypothesis at the 5% level of significance Interpret R Square Interpret Adjusted R Square LAB WORK 5 (EXCEL) Lecture 8/9 From the House pricing) data file provided in the Departmental File (RUN). answer the following questions (2% of total course marks) Price Sq. Feltedroom Bathrooms Garaget $11000 1000 26 3 1 1 $133.300 1400 21 1 1 $112.00 12458 3 4 1 1 $141.750 110612 2 1 1 5199 250 211275 2 6 2 $132.250 1078 1 SI 16.00 992 13 2 2 S162.750 1100 2 1 1 $148.500 1040 17 3 1 1 S123 od 1616 27 2 1 S142.250 1150 25 2 2 $145 SOKO 17 3 2 SISS.250 146428 3 2 SIS0.750 12281 3 S150,900 11321 3 4 2 1 S14400 1132 1 3 4 1 S151.900 11321 3 4 S1650 1454 3 1 S155.750 12701 4 3 SIS7250 1362 23 3 $152.90011201 3 2 $145.250 1025 1 3 $ 2 1 $164.750 1.290 19 2 1 SI52.500 1260 3 4 1 S150,750 TOSSI 3 4 $144,750 1112 41 3 4 2 1 S1422501439 1 1 $14.500 1510 24 $213.02 2112 12 SISS.250 1351 1 4 $ 1 $367.90 13511 2 S148.500 11933 3 2 $1$2.500 1200 1 4 4 2 1 S167 200 1256 1 3 1 SI59.500 105 1 3 4 153.000 12001 3 + 2 $168.00 1901 4 1 S1010 110111 2 $165.200 1.3738 4 $174.900 1437 3 2 SI60.250 1330 1 3 $165 100 1261 1 3 4 2 1 SI70 500 159416 3 3 $155.900 1186 2 5167,200 13361 3 4 $165.400 1325 $16.500 13529 3 4 2 5178.500 11547 3 2 $164.000 13181 S172.750 141519 $149.000 1337 2 1 1 4 3 3 3 3 4 3 1 1 1 4 4 2 E t 1 1 1 4 1 1 2 1 4 5 4 4 4 4 1 3 3 3 1 3 1 1 1 1 3 3 3 3 3 3 3 4 4 4 2 1 1 1 2 4 4 5 2 2 2 1 1 1 1 1 1 0 2 1 3 3 3 4 4 4 + 4 1 1 3 4 1 1 1 2 6 4 3 1 1 I 1 1 4 4 $17.SO 1354 7 1516400 IN 1 5172.750 1415 9 15149.000 1137 2 5176000 2028 25 15205 500 1820 21 S181.100 1330 2 $16.600 1356 1 16.750 1150 2 SIX70015211 15190 600 1477 1 s16000 1165 4 $164.900 343022 SI5.00 1311 S184.750 1411 SI74.000 1412 1 ISI 3.250 1300 S169.000 1334 4 ISIS1900 1100 19 SIND 350 1900 43 5171,300 1328 1 $172.650 1350 $174.750 1601 5166,900 1405 5171.750 1619 $170,900 1450 s16.400 IRIN 5193.100 1424 1 5206,900 2240 16 $19000 1872 2 SIS SOO 1550 516 300, 1342 S157.100 1318 $177.650 1843 5207,100 1526 1 $191,900 1526 1 5164 250 1407 1 $146.100 ISIS 1 $136.750 14251 $236.600 2150 20 S1x2.250 1430 2 ISISR900 1975 10 $1730000 1433 8 5217.600 2400 34 5.201.000 216032 $149.650 1600 10 5206,150 1526 1 $162.00 1480 20 SIR20 129 1 $172.900 1493 1 S188.400 1728 4 S182.750 1828 5175 500 1689 SI57.500 1572 1 S211,900 1534 1 $307,300 1975 10 $126.750 HOS S181200 1938 22 S1815001564 3 SIS2.750 170022 S181200 13932 IsI61.400 ISO 9 5160300 1510 S $16.9 1689 1 $179,900 1407 1 S185.000 In 119 4 4 3 3 3 3 3 3 1 1 1 1 4 4 + 4 3 2 1 1 1 3 4 4 3 2 2 2 2 1 1 4 $ 4 3 1 4 4 4 5 4 4 1 1 1 1 1 1 2 3 2 5 4 3 1 $ 1 1 4 2 2 2 2 3 1 4 4 4 4 3 4 1 1 1 1 1 $ $ 4 4 4 3 + 4 3 3 2 1 1 1 4 4 3 Pihl 3 3 2 1 1 4 3 4 4 4 4 2 1 1 1 3 3 3 1 1 4 4 4 4 4 3 1 1 1 3 4 2 4 9 4 4 3 3 3 6 + 3 F 3 4 4 1 1 1 1 1 1 1 $ 2 5 4 4 3 3 2 1 4 5 3 4 1 1 1 3 4 4 1618 3 5 4 1 1 1 3 4 2 3 5 4 S160 300 1510 5 $16.900 1689 1 $179,900 1407 ISIRR 900193825 $201.750 1337 1 15.200,00 1500 8 I56.300 1488 1 $195300 1526 1 IS194350 1594 1 $199,10019 1 15207 400 1212 ! ISIS 0112 1 SIS7500 1773 9 5214300 13 20 $23.900 267220 S145.10010082 S181.750 17003 5196.9002080 22 1235 3 ST2S 200 $197.900 1800 22 $200,400 1661 1 5173,300 1680 9 IS191 1700 1 S166,100 1707 3 S182.750 1595 1 5164500 1420 1 S1900 5 5227.200 1632 5 5191.200 15581 $219.400 1720 7 $199,750 2072 29 5203.900 2012 24 $199.500 1899 1 516100 1572 1 5190 SOL 1672 5.208.800 1611 1 5228.700 1920 3 S228.900 236722 5194 200193413 $250.100271223 5224 600 2144 23 s211.250 2040 23 $161.500, 1622 1 5199 od 1665 1 $132.400 2192 26 5.229.250 2358 21 S159.700 1738 4 S211,700 1983 7 5199 250 219412 $194,750 2050 3 $147,750 7356 25 5208 900 WO 30 $24.600 1687 1 SI86S 1968 21 S194.200 1650S $126.00 1646 SI78000 18602 5.240 X 1536 21 $225.750 1566 $16.500 2000 14 5207.900 18756 $260.6501910 5245.750 2546 25 S112.00 1400 16 ST85.1002878 29 5235.500 1000 I IT 4 4 4 3 3 2 3 4 1 6 1 1 1 1 1 1 4 4 3 6 4 2 4 4 3 4 S 6 1 1 1 4 3 3 3 4 5 1 1 4 2 4 4 4 + 1 1 3 6 3 1 2 4 4 3 4 4 5 3 4 4 4 4 3 1 1 1 4 4 5 3 2 2 3 1 1 1 1 1 1 4 4 4 4 4 3 6 5 2 3 2 1 1 9 4 3 6 5 1 6 2 1 1 6 4 3 1 6 6 5 2 3 $ 4 5 5 1 1 1 1 1 1 1 2 3 R 6 6 4 $ 7 4 4 3 4 3 4 3 4 1 1 1 3 2 4 6 3 2 2 1 1 1 1 1 5 + 5 1 3 3 1 3 3 3 1 1 1 1 4 4 4 4 5 2 3 1 2 + 3 4 4 4 1 1 1 1 4 4 1 3 3 3 3 4 1 4 5 2 6 1 4 $ 4 4 COM 10 $245.750 2546 25 S112.00 1400 36 SIRS.10278 29 5235-500 3000 11 $179.00 1776 X $265.750 3024 18 5222.000 2682 20 5242.500 2037 0 ISIS 1836 152518 1711 3 5209.500 2700 19 5224 00 1651 2 520620 2200 22 5237 00 2051 12 Is26 500 000 3 $199,500 2700 42 $216.750 2182 1 S181,250 2000 37 5229.00 1930 S20750018342 52062501933 1 15265.400 2192 1 $219,250,2193 4 5272.00 2018 1 5229.600 2310 15261.000 2256 1 52745002710 $192.400 1984 15217.200 24431 201.700 2650 2 5243 350 2560 1 $287.700 2341 1 5240,750 23:50 1 5217.500 2567 1 $288.9002383 1 15265 500 2544 1 5252.750 251 s208, ISO $229,700 2400 15 5282 3002939 1 5234.750 2500 3 S170200 2854 1 5301 200 10NO 12 5305.9003659 1 $225,400 2542 6 5251.900 2208 5291 300 2939 1 5301.700 24601 $262.750 2619 1 $273.900 2718 10 $317.800 1403 5242.000 2619 5.298.500 1550 13 5229.00 2544 $ ISO 100 2567 $310.500 2938 1 5273,100 3321 12 5305.700 29751 $289,00 3063 5257 500 2754 1 $311.000 3285 8 15280,300 3300 12 $32.150 2895 1 15337-300 1277 1 126550 100 27 5231.000 2750 6 6 4 7 5 5 4 5 4 4 3 4 4 4 3 . 3 3 3 3 3 1 1 1 1 1 3 $ 4 5 1 1 1 1 S 4 5 6 3 1 4 5 1 1 1 5 4 4 6 5 $ 5 5 5 3 3 4 3 3 3 6 $ 1 1 6 4 4 4 1 1 1 4 1 4 5 5 7 1 1 5 1 1 1 4 4 3 3 5 5 4 7 6 1 1 1 1 3 $ 5 6 7 1 4 + 6 1 1 S 5 4 4 5 2 3 1 7 5 5 5 7 6 1 1 1 6 3 5 5 4 1 1 1 1 9 E 1 4 5 4 3 1 1 6 4 4 6 3 . 4 3 1 1 1 . 3 3 2 5 1 1 1 o 1 1 1 1 1 1 0 0 1 1 1 1 1 2 2 3 3 3 2 2 2 3 3 2 3 4 2 3 O 0 1 O . 1 1 1 3 0 1 0 1 2 1 2 1 1 1 2 1 0 0 PSEK 1302895 5337 300 3277 1 5265 So 2160 27 5231.000 2750 4 5274.00 2727 4 5263,500 2733 5361,1004080 14 $322.900 2900 2 151 So H0 1 Sax 3000 15309.300 2950 $298.000 3217 3 5278.000 2300 43 5331.000 2418 5 $317.000 3355 102.003114 10 SSR 100 1095 30 571,100 28 $$900 1159 SO S78.500 120023 $64.200 1430 54 557,600 121723 $54,100 911 49 572,000 954 53 590,00 950 48 $75 200 JONO 41 SSR 500 ILRO 7 5664,200 100452 S88.900 98 2x 56.550 45 SX2,250 100847 S68.600 140031 $75.900 1340 579.600 1563 44 S8800 107249 592,700 1534 19 580350 101621 583,400 1040 16 597,200 1136 29 596.300 128242 57.100 1670 47 $94.000 1530 54 $29.300 1789 33 SNR SO 1339 65 588.200 1160 21 591.600 1910 47 582.700 1100 591,100 1379 40 591 00 103215 596.450 1672 129 572,50 1407 37 $82.200 1450 $93.300 1728 61 SIT1,400 1976 37 590.250 1607 572.500 1532 41 $20.600 1288 3 S65.950 13209 $90,100 1416 41 ISE10,200 2002 36 151500 1550 42 $93,900 1568 40 584800 40 S103.00 1536 22 $121.000, 187239 SIO2.150 2200 IT 1161 TE E 1 2 4 3 3 3 1 . 2 2 2 4 o 1 1 3 4 0 + 4 1 . 3 2 3 4 1 1 4 4 o 2 2 3 2 3 . 0 . 1 1 1 2 3 0 OP 1 3 4 4 3 0 0 . 1 2 2 1 1 2 2 2 2 1 2 4 3 2 4 3 3 0 0 O 3 3 3 4 1 0 4 4 0 0 1 1 4 3 2 2 3 3 4 3 3 3 4 4 3 4 4 1 2 2 1 2 2 3 3 2 3 $110,200 2022 26 $122.500 1550 42 593,900 1568 40 584,00 1968 20 ISO 153612 $121.000 1872 39 S102.150 2200 31 $129, 1763 29 $82,950 2073 71 S111,700156352 S127.150 2002 SI39, 1968 47 $111.900 1340 9 $96.400 1730 12 $106,250 21682 $126,100292022 $121.950 1750 8 $150,990 2000 39 $142,100 2073 $173,200 2000 20 $157,850 1900 45 $164,00 2400 38 S130,100 3000 S123.000 21721 SINO SOD 2515 51 $169,900 2500 49 $213,000 2345 44 5 3 3 3 4 4 1 4 3 4 4 4 4 4 2 1 1 3 3 3 3 4 2 3 2 2 2 3 4 4 6 + 5 . 2 1 3 2 5 2 4 5 6 4 6 4 Get the excel results for 100 observations of Multiple Regression (Topic_9_Multiple Regression Data_House Prices First City-3) Write down the fitted multiple regression equation Interpret any two B's Test the Individual significance of the regression hypothesis at the 5% level of significance Test the Overall significance of the regression hypothesis at the 5% level of significance Interpret R Square Interpret Adjusted R Square
