5 6 points eBook Exercise 7-15 Algo A Realtor, is analyzing the relationship between the sale price of a home (Price in $). Its square footage (Sqft), the number of bedrooms (Beds), the number of bathrooms (Baths), and a Colonial dummy variable (Colonial equals 1 if a colonial-style home, 0 otherwise). The accompanying data file shows Information on 36 recent home sales. Click here for the Excel Data File a. Estimate the model: Price = 6 + 6Sqft -62Beds -6,Baths - Colonial - . Note: Negative values should be indicated by a minus sign. Round Coefficients to 2 decimal places. Coefficients Hint Intercept Sqft References Beds Baths Colonial b-1. Interpret the coefficient of beds. O For each additional bedroom in a house, the average price of a house is expected to decreases by $17,976, all else constant. O For each additional bedroom in a house, the average price of a house is expected to increases by $17,976, all else constant. As the price of a house decreases by $17,976, the house is expected to have one more bedroom, all else constant. O As the price of a house decreases by $17,976, the house is expected to have one less bedroom, all else constant. b-2. Interpret the coefficient of colonial. O All else constant, the price of a colonial-style house is, on average, $3,157 more than a non-Colonial style. All else constant, the price of a colonial-style house is, on average, $3,157 less than a non-Colonial style. All else constant, the price of a colonial-style house is, on average, $157,259 more than a non-Colonial style. All else constant, the price of a colonial-style house is, on average, $157,259 less than a non-Colonial style house. c. Construct the 95% confidence interval for expected price for a 2,500-square-foot, colonial-style home with three bedrooms and two bathrooms. Note: Round final answers to the nearest whole number. If you are using R, do not use a comma when entering the value for Sqft: that is, use 2500 Instead of 2,500. Confidence Interval to d. Construct the 95% prediction Interval for price for a 2,500-square-foot, colonial-style home with three bedrooms and two bathrooms. Note: Round final answers to the nearest whole number. If you are using R, do not use a comma when entering the value for Sqft: that is, use 2500 Instead of 2,500. Prediction Interval to