Question

"Are there any of the independent variables (not including the constant) that are statistically not significant at the 0.10 level or lower? If yes, drop them from the list of independent variables.... . Continue the process until all of the independent variables are significant at least at the 0.10 level or lower. "

Coefficients a Standardized Coefficients Unstandardized Coefficients Collinearity Statistics Tolerance VIF Model B Std. Error Beta t Sig. 1 4790324.307 348934.230 13.728 .000 (Constant) Number of bedrooms -6950.604 5589.815 -.034 -1.243 .214 .643 1.554 59148.992 9658.720 .223 6.124 .000 .367 2.726 -1.025 .775 -.031 -1.323 .186 .900 1.111 Number of bathrooms (fractions) Lot size 2015 (square feet) Square feet of living space in 2015 23.177 11.823 .056 1.960 .050 .596 1.677 Number of floors 30704.524 11727.929 .075 2.618 .009 .589 1.698 2424.024 7038.555 .008 .344 .731 .892 1.121 Building Condition Building Grade 105935.245 6729.560 .509 15.742 .000 .467 2.143 Year built -2733.079 183.777 - 462 - 14.872 .000 .506 1.977 69321.276 .236 9.854 .000 .851 1.176 Waterfront property 683080.507 View property 51117.932 a. Dependent Variable: Selling price 7404.664 .180 6.903 .000 .713 1.403

Answer 1

Yes following variables are not significant (insignificant) as their significance values are more than 0.10

Number of bedrooms ( sig. = .214),

Lot size (sig. = .186),

Building conditions (sig. = .731).

You can remove these three independent variables from your model and re run the model with remaining significant variables.