5 6 points eBook Hint 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, O otherwise). The accompanying data file shows Information on 36 recent home sales. Click here for the Excel Data File a. Estimate the model: Price = + SqftBeds -6,Baths - Colonial -. Note: Negative values should be indicated by a minus sign. Round Coefficients to 2 decimal places. Intercept Sqft References Beds Baths Colonial Coefficients 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,798, all else constant. O For each additional bedroom in a house, the average price of a house is expected to increases by $17,798, all else constant. O As the price of a house decreases by $17,798, the house is expected to have one more bedroom, all else constant. O As the price of a house decreases by $17,798, the house is expected to have one less bedroom, all else constant. b-2. Interpret the coefficient of colonial. All else constant, the price of a colonial-style house is, on average, $57,109 more than a non-Colonial style. All else constant, the price of a colonial-style house is, on average, $57,109 less than a non-Colonial style. All else constant, the price of a colonial-style house is, on average, $183,859 more than a non-Colonial style. All else constant, the price of a colonial-style house is, on average, $183,859 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