The data file has the data for this question. The variables in that file arePrice  Average selling price of housesLocation A code to indicate the location of the houseCondition A code to indicate the physical condition of the houseBedrooms Number of bedrooms in the house Bathrooms Number of bathrooms in the houseOther Rooms Number of other rooms in the house

(a) Run a regression of Price on Location, Condition, Bedrooms, Bathrooms and Other Rooms.

(b) What variables seem to be important for buyers of houses?

(c) Based on your regression results, if you wanted a low selling price on a house you wanted to purchase, what would you look for?

(d) Run a regression of Price on Bedroom, Bathrooms and Other Rooms.

(e) Compare your regression results in (a) to the regression results in (d). Which would you consider to be a better model and why?

Price Location Condition Bedrooms Bathrooms Other Rooms 67000 2 2 2 1 2 68000 2 2 3 1 3 68000 2 2 3 1 3 69000 2 3 2 1 3 72000 2 2 4 2 5 75000 3 4 2 1 3 76000 2 3 2 1 2 76900 2 3 3 1 3 77000 2 3 2 3 5 78000 3 2 2 1 2 79000 2 3 3 2 3 80000 2 3 3 1.5 2 80000 2 3 3 1 2 81000 3 3 2 1 3 82000 2 3 3 1.5 3 83000 2 3 3 1 3 84000 2 2 3 1 3 84000 2 3 3 1.5 3 86250 1 4 4 2 3 87000 3 3 3 2 2 89500 3 2 3 2 2 90400 2 4 4 2 4 90500 3 3 3 1.5 3 91000 3 3 3 2 3 91500 3 1 4 2 3 91500 3 1 4 2 3 92500 3 3 3 1.5 4 93500 2 3 3 2 3 93500 2 3 4 2 2 94000 1 2 3 1.5 3 95500 3 3 3 2 2 96000 2 4 3 2 3 96000 2 3 3 2 3 97900 3 4 3 2 3 98000 3 4 3 2 3 98000 2 4 3 2 4 98000 3 4 3 2 3 99000 2 3 4 2 4 99000 3 2 4 2 4 99000 3 3 3 2 3 102000 3 3 4 2 3 102000 2 3 3 1.5 3 102000 3 3 4 2 3 102000 3 4 3 1.5 3 103000 3 3 3 2 3 103000 3 2 3 1.5 2 103500 3 2 3 2 5 103500 3 3 3 2 5 105000 3 3 3 2 5 105000 108000 112000 112500 114900 115500 120500 122000 125500 127000 128000 129900 130350 132350 133000 134500 135500 135500 136500 136500 137400 137400 137500 139500 144000 145000 149000 155000 154000 155500 156500 163000 165000 167000 168700 169900 169900 169900 176000 179000 179000 179500 179500 187500 203000 220000 222000 250000 250000 255000 3 2 3 3 2 3 4 2 3 2 4 3 3 3 3 4 3 4 4 4 3 4 4 3 4 4 4 4 4 3 4 4 5 5 3 4 4 4 4 4 4 4 5 4 4 5 5 5 5 5 4 4 2 4 2 4 5 2 3 4 4 4 3 4 3 3 3 3 4 3 3 3 4 4 3 3 4 4 2 5 5 3 4 4 5 5 5 5 5 5 5 4 4 3 5 5 4 4 5 5 3 3 4 3 5 4 3 3 4 3 3 4 3 3 3 3 3 3 3 3 4 4 3 4 4 3 3 4 3 3 3 4 4 4 3 4 3 3 4 4 4 3 3 4 4 4 3 4 4 4 1.5 2 2 2 2 2 2 3 2.5 2.5 2 2.5 2 2 2 2 3 3 2 2 2.5 2.5 2 2.5 2.5 2 2 2 2 2.5 2 2 2 2 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 3 3.5 3.5 2.5 2.5 2.5 3 3 4 4 3 3 4 4 3 4 4 3 4 4 4 3 3 3 4 4 4 4 4 4 5 3 2 5 4 3 3 4 2 2 5 4 5 5 4 5 5 3 3 4 6 5 6 4 4 4 255000 5 5 3 2.5 4