Spring is a peak time for selling houses. The file Spring Houses contains the selling price, number of bathrooms, square footage, and number of bedrooms of 26 homes sold in Ft. Thomas, Kentucky, in spring 2018 (realtor.com website) Click on the datafile logo to reference the data. DATA file a. The Excel output for the estimated regression equation that can be used to predict the selling price given the number of bathrooms, square footage, and number of bedrooms in the house: SUMMARY OUTPUT Regression statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total 0.7429 0.5519 0.4907 61948.6931 Intercept Baths df 26 SS MS 3 1.0397E+11 3.4656E+10 22 8.4428E+10 3.8376E+09 25 1.8840E+11 Coefficients Standard Error -5531.0144 67312.9506 -1386.2100 23143.8052 23.5813 60.2793 54797.0778 24019.7592 t Stat F 9.0306E+00 Lower 95% Upper 95% -0.0822 0.9353 -145129.5298 134067.5011 -0.0599 0.9528 -49383.5243 46611.1044 Sq Ft 2.5562 0.0180 11.3748 109.1838 Beds 2.2813 0.0326 4983.1461 104611.0095 Does the estimated regression equation provide a good fit to the data? Explain. Hint: If R is greater than 45%, the estimated regression equation provides a good fit. The estimated regression equation does (to 2 decimals). provide a reasonable fit because the adjusted R² is 0.4907 b. The Excel output for the estimated regression equation that can be used to predict selling price given square footage and the number of bedrooms: SUMMARY OUTPUT P-value Significance F 4.3455E-04