Price	Sqft	Beds	Baths	Colonial
795000	2744	3	2.0	0
793000	2653	4	1.5	0
692000	2429	1	3.0	1
731000	2107	2	3.5	0
635000	2676	4	4.5	0
645000	2362	1	1.0	1
637000	2613	2	1.5	0
612000	2558	2	3.5	0
593000	2267	2	1.5	1
557000	2176	2	1.5	0
629000	1986	1	3.5	1
584000	3239	4	2.0	0
521000	1862	4	3.0	0
493000	1386	2	1.5	1
512000	2677	4	2.5	0
519000	2049	3	2.0	0
551000	1720	2	2.5	1
505000	1644	4	2.0	0
540000	1723	2	2.0	0
465000	1726	4	2.0	1
479000	1811	1	3.0	0
499000	1831	1	2.0	1
447000	1474	2	1.5	0
392000	2047	3	1.5	1
373000	1339	4	1.5	0
370000	1390	1	2.0	1
419000	1423	3	2.0	1
390000	1395	3	1.0	0
402000	1468	4	2.0	1
403000	2329	1	1.0	0
354000	1226	2	1.0	0
333000	1473	4	1.0	1
377000	1620	2	2.0	0
339000	1419	4	2.0	0
365000	1639	4	2.0	1
259000	612	2	1.0	0

6 5 points Skipped 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 + 61 Sqft+862Beds +63 Baths +84 Colonial + . Note: Negative values should be Indicated by a minus sign. Round Coefficients to 2 decimal places. Coefficients eBook Intercept Sqft Beds Hint Baths References Colonial b-1. Interpret the coefficient of beds. For each additional bedroom in a house, the average price of a house is expected to decreases by $17,976, all else constant. 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. 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. 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