Home Price Home Size Lot Size Rooms Bathrooms 1 $102,000 600 0.50 3 1.0 2 $146,300 1050 0.43 5 1.5 3 $182,000 1800 0.68 7 1.5 4 $110,500 922 0.30 5 1.0 5 $171,900 1950 0.75 8 2.5 6 $154,000 1783 0.22 8 1.5 7 $147,000 1008 0.50 6 1.0 8 $195,900 1840 1.16 8 2.0 9 $183,500 3700 1.10 10 3.0 10 $156,500 1092 0.26 6 1.0 11 $152,000 1950 0.50 7 1.5 12 $170,000 1403 0.50 6 2.0 13 $253,000 1680 14.37 8 2.0 14 $129,500 1000 0.49 4 1.0 15 $241,900 2310 0.46 8 2.5 16 $151,900 1300 0.78 6 1.0 17 $199,000 1930 3.00 9 3.0 18 $186,000 3000 0.50 11 2.5 19 $153,500 1362 0.40 7 2.0 20 $166,000 1750 0.50 7 2.0 21 $224,900 2080 1.00 8 2.5 22 $158,500 1344 0.94 6 2.0 23 $332,000 2130 11.91 8 1.5 24 $172,000 1500 0.41 7 1.0 25 $176,000 2400 0.40 7 2.5 26 $210,000 2272 0.41 9 2.5 27 $156,500 1050 1.00 5 1.0 28 $169,500 1610 0.45 8 1.5 29 $154,900 1248 0.22 7 1.0 30 $163,000 2000 0.50 8 2.0 31 $140,000 1450 0.30 6 2.0 32 $148,500 1248 0.25 7 1.0 33 $224,500 2544 0.28 9 2.5 34 $299,900 2500 0.92 8 3.0 35 $199,900 2858 0.79 9 3.0 36 $220,000 1745 0.58 7 2.5 37 $233,000 2653 1.80 9 3.0 38 $174,900 1450 0.30 7 1.0 39 $124,000 850 0.11 4 1.0 40 $169,900 1839 2.60 7 1.5 41 $213,000 2016 0.78 8 2.5 42 $165,000 1625 0.36 7 1.5 43 $162,000 2000 0.11 8 2.0 44 $211,500 2250 0.33 9 2.5 45 $166,000 1300 0.30 7 1.0 46 $194,000 1956 0.50 8 2.5 47 $192,000 2496 0.75 9 2.5 48 $171,000 1575 0.25 7 1.5 49 $226,800 1960 1.33 8 2.5 50 $155,000 1200 0.33 5 1.0 51 $157,500 1296 0.50 9 1.0 52 $297,000 1950 18.70 7 2.5 53 $315,000 2516 8.10 7 2.5 54 $161,000 1066 0.33 5 1.0 55 $193,500 2276 1.00 8 2.5 56 $163,000 1908 0.46 7 2.0 57 $180,000 1122 3.09 5 2.0 58 $171,000 3500 1.00 10 2.5 59 $163,000 1100 0.33 6 1.0 60 $220,000 2300 5.63 7 2.5 61 $155,900 1118 0.56 7 1.5 62 $219,900 2464 0.43 8 2.5 63 $185,000 2100 0.58 8 1.5 64 $172,500 1552 0.46 6 1.5 65 $167,900 1856 0.33 7 1.5 66 $160,000 1800 0.30 7 1.5 67 $147,000 1248 0.30 6 1.0 68 $210,500 2000 0.60 9 2.5 69 $192,500 1848 0.50 7 2.5 70 $138,000 1036 0.95 6 1.0 71 $200,000 2277 0.80 8 3.0 72 $186,000 2300 0.65 7 3.0 73 $217,000 2080 1.23 8 2.5 74 $180,000 1600 1.84 7 2.0 75 $195,000 2680 0.50 9 3.0 76 $149,000 1200 0.25 7 1.0 77 $165,500 1526 0.30 7 1.5 78 $175,900 1680 0.50 6 1.5 79 $156,000 1232 0.31 6 2.0 80 $235,406 2465 1.55 8 2.5 81 $215,500 2800 1.68 9 1.5 82 $225,000 2265 0.85 8 2.5 83 $155,000 1300 0.65 5 1.0 84 $190,000 1900 1.00 8 2.5 85 $126,000 864 0.32 4 1.0 86 $172,000 2000 0.75 9 1.5 87 $175,000 1800 0.66 8 2.5 88 $181,500 1900 0.75 7 2.0 89 $180,000 1564 0.33 6 2.0 90 $295,000 2400 2.00 7 2.0 91 $146,000 1100 1.10 6 1.0 92 $165,000 1800 1.00 8 2.5 93 $159,000 1200 0.33 6 1.0 94 $138,500 1540 0.18 7 2.0 95 $194,900 1980 0.70 8 2.5 96 $140,000 1289 0.25 6 1.0 97 $184,000 1800 0.68 7 2.0 98 $164,000 1502 0.35 7 1.5 99 $190,000 2025 1.10 7 2.0 100 $250,000 3000 1.15 10 3.5 101 $156,500 1500 0.50 7 1.5 102 $156,500 1600 0.26 8 1.5 103 $188,000 1500 0.54 5 2.5 104 $202,000 2100 1.00 8 2.5 105 $245,000 2100 0.50 8 2.5 106 $171,900 1632 3.00 6 3.0 107 $119,900 1660 0.21 7 1.0 108 $159,900 1070 1.69 5 1.0 109 $165,000 1400 0.35 6 2.0 110 $165,000 1800 0.50 7 2.0 111 $152,500 1100 0.37 7 1.0 112 $265,000 3150 0.30 11 4.0 113 $164,500 2000 0.70 8 1.0 114 $156,500 1700 0.30 8 2.0 115 $210,000 1800 1.52 8 2.5 116 $157,500 1850 0.26 9 2.0 117 $195,000 2320 0.40 8 2.5 118 $127,000 1300 0.37 5 1.0 119 $130,000 1338 0.12 6 1.0 120 $238,000 2288 1.20 8 2.5 121 $212,000 2400 0.50 8 2.5 122 $205,000 2400 0.70 8 3.0 123 $174,900 1900 0.44 6 2.0 124 $207,000 2010 0.68 8 1.5 125 $261,750 2981 1.30 10 3.5 126 $195,000 1725 1.53 8 2.5 127 $108,000 821 2.30 4 1.0 128 $209,000 3060 0.75 8 2.0 129 $115,000 875 0.26 5 1.0 130 $190,000 1760 0.05 7 2.0 131 $171,000 2000 0.65 7 1.0 132 $215,000 2600 0.75 8 2.0 133 $143,500 1624 1.80 7 1.5 134 $220,000 2473 1.25 9 2.5 135 $137,000 1100 0.17 5 1.0 136 $247,000 3100 0.54 10 3.5 137 $224,500 2300 0.91 8 2.5 138 $182,000 1450 0.30 6 1.5 139 $240,000 2100 0.50 8 2.5 140 $170,000 1650 0.50 8 2.5 141 $150,500 1600 0.40 6 2.0 142 $209,900 2790 0.75 13 2.5 143 $182,500 1786 0.30 8 2.0 144 $189,000 1728 0.50 8 1.5 145 $198,500 1900 1.06 7 2.5 146 $128,000 1165 0.12 6 1.0 147 $147,500 1300 0.29 6 1.0 148 $145,000 1080 0.31 5 1.0 149 $305,000 2820 1.00 9 2.5 150 $220,000 2100 1.30 8 1.5

_____________________________________________________________________________________________________________________________________________________________

Do the selling prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the selling price of the house is the dependent variable and the size of the house is the explanatory variable. Use the sample data given in the fileP10_10.xlsx. Round your answer for the intercept coefficient to the nearest whole number and the slope coefficient to three decimal places, if necessary.

Please solve what is bold print.

=+X

Y=[ ] + [ ] X

Interpret your estimated equation. Round your answer to the nearest whole dollar, if necessary.

The predicted increase in selling price for every extra 100 square feet is about what $ amount.

Interpret the associatedR2. Round your answer to the nearest whole number, if necessary.

Thesize of a houseexplains48.75% of the variation inselling price.

.