Excel File Data Price Saft Beds Baths 728000 2399 4 2.5 822000 2500 2.5 831833 2800 5 2 814273 2600 2.5 685000 2716 W 3.5 838500 3281 2.5 432692 1891 1.5 620000 2436 3.5 718056 2567 2.5 w w 585000 1947 1.5 795000 3033 3.5 379333 2175 W H 764400 2509 780000 2149 2.5 732273 3964 .5 516000 1951 738111 2531 714000 2418 495000 1692 N W N N W N N 463000 1714 639800 2310 451000 1685 435000 1500 1.5 431700 1896 in 414000 1182 in 401500 1152 319200 1106 253333 896 HNWNNWWWWWWNNWWD 475000 1590 375900 2275 620000 1675 275625 954 356500 1431 412500 1703 247500 1099 307500 8504 Exercise 14-35 Algo 0 A realtor In a suburb outside of Chicago is analyzing the relationship between the sale price of a home (Price In $), Its square footage pints (Sqft). the number of bedrooms (Beds), and the number of bathrooms (Baths). She collects data on 36 recent sales. A portion of the data Is shown in the accompanying table Price Saft Baths 728,090 2,399 2.5 eBook 822,00e 2,500 2.5 307,500 850 Hint Click here for the Excel Data File Print a. Estimate the model Price = 6 + 6,Soft + 62Beds + 63Baths + z. (Round Coefficients to 2 decimal places.) Coefficients References Intercept Sqft Beds Baths b-1. Interpret the coefficient of sqft. O For every additional square foot, the predicted price of a home increases by $102.76. For every additional square foot, the predicted price of a home increases by $102.76, holding number of bedrooms and bathrooms constant. For every additional square foot, the predicted price of a home increases by $102.76, holding square foot, number of bedrooms and bathrooms constant. b-2. Interpret the coefficient of beds. For every additional bedroom, the predicted price of a home Increases by $46,793.94. For every additional bedroom, the predicted price of a home increases by $46,793,94, holding square footage and number of baths constant. For every additional bedroom, the predicted price of a home increases by $46,793.94, holding square foot, number of bedrooms and bathrooms constant. b-3. Interpret the coefficient of baths. For every additional bathroom, the predicted price of a home Increases by $89,621,92. O For every additional bathroom, the predicted price of a home increases by $89,621.92, holding square footage and number of bedrooms constant. For every additional bathroom, the predicted price of a home Increases by $89,621.92, holding square foot, number of bedrooms and bathrooms constant. c. Predict the Price of a 2,038 square-foot home with three bedrooms and two bathrooms. (Do not round intermediate calculations. Round your final answer to the nearest whole number.) Predicted Price