Based on common sense; the number of bedrooms is an important predictor for value of a house. But it was not included in the linear prediction equation. In its relationship with other predictors, discuss possible reason(s) of not including the number of bedrooms in the model.

ID List Price Baths - Total Square Age of Acreage Number of Dunes West Park West Subdivision Footage House Fireplaces $769,900 3.5 2767 4 0.35 0 O Carolina Park Source: Mount Pleasant Real Estate Data $699,990 35 240 0.29 Carolina Park 62 $436,625 3 2072 0.19 Carolina Park SUMMARY OUTPUT 61 $446,900 2.5 .895 IN 0.11 Carolina Park 25 $575,000 3.5 3237 0.2 Carolina Park Regression Statistics 27 $575,000 3 045 0.19 Carolina Park Multiple R 0.848084079 60 $464,900 2.5 .895 0.13 Carolina Park R Square 0.719246606 32 $569,900 3 545 0.16 Carolina Park Adjusted R Square 0.705107946 40 $530,000 3.5 761 4 0.19 Carolina Park Standard Error 118724.8838 57 $478,900 2.5 199 0.14 Carolina Park Observations 147 58 $478,900 2.5 199 0.12 Carolina Park 56 $489,900 3 2072 0.15 Carolina Park ANOVA 54 $505,000 3 2457 0.15 Carolina Park of SS MS F Significance F 52 $505,900 2.5 1990 0.17 Carolina Park Regression 7 5.01939E+12 7.17056E+11 50.87091695 2.61301E-35 55 $499,900 2.5 814 0.15 Carolina Park Residual 139 1.95929E+12 14095598036 50 $509,000 3.5 2445 0.17 Carolina Park Total 146 6.97868E+12 46 $519,000 3.5 0.16 Carolina Park 45 $522,000 3.5 2761 0.23 Carolina Park Coefficients Standard Error t Stat P-value Lower 95% Upper 95%ower 95.09 pper 95.0% 42 $529,900 3.5 2612 0.16 Carolina Park Intercept 109470.9765 50708.61879 -2.158823866 0.032580687 -209730.928 -9211.02 -209731 -9211.02 38 $534,000 2445 NN 2.5 0.21 39849.36014 19258.32772 2.069201476 0.040379369 77926.5 1772.224 77926.5 HHOHO Carolina Park Baths - Total 1772.223569 37 $534,900 3.5 2357 0.17 Carolina Park Square Footage 170.6130372 21.05439013 8.103442378 2.46658E-13 128.9847661 212.2413 128.9848 212.2413 36 $549,900 3 255 0.17 Carolina Park Age of House -2361.20616 1631.144312 -1.447576492 0.149987202 -5586.268359 863.856 -5586.27 863.856 35 $561,900 3.5 559 0.16 Carolina Park Acreage 164333.8402 27255.55231 6.029371129 1.40529E-08 110444.7693 218222.9 110444.8 218222.9 33 $564,900 3.5 010 0.17 Carolina Park Number of Fireplaces 73852.62598 24533.6621 3.010256915 0.003100844 25345.21578 122360 25345.22 122360 34 $564,900 3.5 433 0.2 Carolina Park Dunes West 41092.94146 33346.33123 -1.232307722 0.219914544 -107024.5648 24838.68 -107025 24838.68 31 $569,900 3.5 065 0.19 Carolina Park Park West -28405.97849 27105.45356 -1.047980194 0.296466544 -81998.27749 25186.32 -81998.3 25186.32 30 $571,900 3.5 593 0.17 Carolina Park PPPPPPNET 28 $574,900 3.5 180 0.2 Carolina Park 29 $574,900 3.5 433 0.22 Carolina Park 22 $589,900 3.5 086 0.22 Carolina Park 23 $589,900 3.5 2593 0.2 Carolina Park 19 $599,900 3.5 3021 0.23 Carolina Park