3:20 .0 5G E C Done 17 of 17 F Significance F 136.9797998 1.62431E-17 -value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 0.618998774 -119.4014142 196.9683109 -119.4014142 196.9683109 3.59028E-10 0. 191734541 0.296347105 0.191734541 0.296347105 0.031382197 7.790001101 154.1018353 7. 790001101 154.1018353 0.0660515 6.154463598 179.3495841 -6.154463598 179.3495841 0.883528357 -3.093629748 2.677651975 -3.093629748 2.677651975 W X DELLWhich predictors are considered significant if we work with a=0.05? Which predictors can be eliminated? What is the final model if we only use FloorArea and Offices as predictors? Suppose our final model is: AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x Offices What wouldbe the assessed value of a medical office building with a floor area of 3500 sq. ft., 2 offices, that was built 15 years ago? Is this assessed value consistent with what appears in the database?3:20 .0 5G E C Done 17 of 17 A JMMARY OUTPUT Regression Statistics Multiple R 0.976236077 Square 0.953036879 Adjusted R Square 0.946079379 Standard Error 105.8107623 Observations 32 ANOVA df SS MS F Regression 4 6134458.105 1533614.526 136.9797998 Residual 27 302289.7703 11195.91742 Total 31 6436747.875 Coefficients Standard Error t Stat P-value 17 Intercept 38.78344837 77.09450721 0.503063 704 0.618998774 18 X Variable 1 0.244040823 0.025492496 9.573045389 3.59028E-10 19 X Variable 2 80.9459182 35.65397654 2.2703195 0.031382197 20 X Variable 3 86.59756024 45.20452498 1.915683447 0.0660515 21 X Variable 4 0.207988886 1.406373888 0.147890179 0.883528357 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Sheet1 Regression Modeling Data + Ready Type here to search O W