Call:
lm(formula = Sale_Price ~ Lot_Area + Street + Lot_Shape + Land_Contour +
Lot_Config + Land_Slope + Neighborhood + Condition_1 + Condition_2 +
Bldg_Type + Overall_Qual + Overall_Cond + Year_Built + Year_Remod_Add +
Roof_Matl + Exterior_1st + Mas_Vnr_Type + Mas_Vnr_Area +
Exter_Qual + Bsmt_Qual + Bsmt_Exposure + BsmtFin_Type_1 +
BsmtFin_Type_2 + Bsmt_Unf_SF + Total_Bsmt_SF + Heating_QC +
First_Flr_SF + Second_Flr_SF + Low_Qual_Fin_SF + Bsmt_Full_Bath +
Full_Bath + Bedroom_AbvGr + Kitchen_AbvGr + Kitchen_Qual +
Functional + Fireplaces + Fireplace_Qu + Garage_Finish +
Garage_Cars + Garage_Area + Wood_Deck_SF + Enclosed_Porch +
Screen_Porch + Pool_QC + Misc_Feature + Year_Sold + Sale_Condition +
Latitude, data = clean_df)
Residuals:
Min 1Q Median 3Q Max
-303379 -9424 152 9032 147539
Coefficients: (1 not defined because of singularities)
Estimate Std. Error
(Intercept) -1.447e+07 5.133e+06
Lot_Area 5.413e-01 7.338e-02
StreetPave 2.059e+04 6.839e+03
Lot_ShapeSlightly_Irregular -1.746e+03 9.963e+02
Lot_ShapeModerately_Irregular 4.281e+03 2.695e+03
Lot_ShapeIrregular 3.688e+03 5.731e+03
Land_ContourHLS 7.172e+03 3.069e+03
Land_ContourLow -6.194e+03 3.987e+03
Land_ContourLvl 3.745e+03 2.251e+03
Lot_ConfigCulDSac 3.846e+03 1.995e+03
Lot_ConfigFR2 -6.576e+03 2.607e+03
Lot_ConfigFR3 -4.060e+03 5.786e+03
Lot_ConfigInside -2.569e+02 1.088e+03
Land_SlopeMod 5.598e+03 2.433e+03
Land_SlopeSev -2.027e+04 7.094e+03
NeighborhoodCollege_Creek 1.117e+04 3.731e+03
NeighborhoodOld_Town -2.465e+03 2.623e+03
NeighborhoodEdwards 2.256e+03 3.161e+03
NeighborhoodSomerset 1.680e+04 2.895e+03
NeighborhoodNorthridge_Heights 2.043e+04 3.624e+03
NeighborhoodGilbert -2.224e+03 3.464e+03
NeighborhoodSawyer 7.086e+03 2.470e+03
NeighborhoodNorthwest_Ames -3.311e+03 2.597e+03
NeighborhoodSawyer_West 6.351e+03 2.879e+03
NeighborhoodMitchell 1.361e+04 6.693e+03
NeighborhoodBrookside 8.850e+03 2.875e+03
NeighborhoodCrawford 2.855e+04 4.180e+03
NeighborhoodIowa_DOT_and_Rail_Road 3.770e+03 3.736e+03
NeighborhoodTimberland 1.967e+04 6.541e+03
NeighborhoodNorthridge 3.159e+04 3.756e+03
NeighborhoodStone_Brook 3.866e+04 4.530e+03
NeighborhoodSouth_and_West_of_Iowa_State_University 8.574e+03 4.419e+03
NeighborhoodClear_Creek 9.740e+03 4.326e+03
NeighborhoodMeadow_Village 1.779e+04 7.847e+03
NeighborhoodBriardale 1.024e+04 5.284e+03
NeighborhoodBloomington_Heights 8.845e+03 5.606e+03
NeighborhoodVeenker 2.715e+03 4.864e+03
NeighborhoodNorthpark_Villa 2.016e+04 5.581e+03
NeighborhoodBlueste 2.078e+04 8.253e+03
NeighborhoodGreens 1.485e+04 8.433e+03
NeighborhoodGreen_Hills 1.325e+05 1.583e+04
NeighborhoodLandmark 1.889e+04 2.135e+04
Condition_1Feedr 2.989e+03 2.966e+03
Condition_1Norm 1.135e+04 2.439e+03
Condition_1PosA 1.272e+04 5.708e+03
Condition_1PosN 1.477e+04 4.386e+03
Condition_1RRAe -2.233e+03 4.954e+03
Condition_1RRAn 8.130e+03 4.119e+03
Condition_1RRNe 3.694e+03 9.171e+03
Condition_1RRNn -2.183e+03 7.639e+03
Condition_2Feedr -4.396e+03 1.143e+04
Condition_2Norm 3.855e+03 9.887e+03
Condition_2PosA 3.154e+04 1.571e+04
Condition_2PosN -1.262e+05 1.510e+04
Condition_2RRAe -1.838e+04 2.585e+04
Condition_2RRAn 2.912e+03 2.350e+04
Condition_2RRNn 1.311e+04 1.808e+04
Bldg_TypeTwoFmCon -1.013e+04 3.310e+03
Bldg_TypeDuplex -1.678e+04 3.929e+03
Bldg_TypeTwnhs -2.784e+04 3.260e+03
Bldg_TypeTwnhsE -2.070e+04 2.102e+03
Overall_QualPoor -1.523e+03 1.447e+04
Overall_QualFair -2.787e+03 1.372e+04
Overall_QualBelow_Average -4.540e+03 1.345e+04
Overall_QualAverage -1.233e+03 1.356e+04
Overall_QualAbove_Average 1.339e+03 1.364e+04
Overall_QualGood 8.052e+03 1.369e+04
Overall_QualVery_Good 2.181e+04 1.377e+04
Overall_QualExcellent 5.578e+04 1.414e+04
Overall_QualVery_Excellent 8.729e+04 1.496e+04
Overall_CondPoor -1.383e+04 1.163e+04
Overall_CondFair -1.232e+04 9.900e+03
Overall_CondBelow_Average 1.727e+03 9.717e+03
Overall_CondAverage 9.378e+03 9.620e+03
Overall_CondAbove_Average 1.520e+04 9.649e+03
Overall_CondGood 2.259e+04 9.679e+03
Overall_CondVery_Good 2.526e+04 9.772e+03
Overall_CondExcellent 3.230e+04 1.028e+04
Year_Built 3.648e+02 4.011e+01
Year_Remod_Add 8.087e+01 3.299e+01
Roof_MatlCompShg 6.896e+05 2.802e+04
Roof_MatlMembran 7.365e+05 3.649e+04
Roof_MatlMetal 7.179e+05 3.617e+04
Roof_MatlRoll 6.943e+05 3.523e+04
Roof_MatlTar&Grv 6.824e+05 2.829e+04
Roof_MatlWdShake 6.847e+05 2.907e+04
Roof_MatlWdShngl 7.425e+05 2.902e+04
Exterior_1stAsphShn 8.245e+03 1.555e+04
Exterior_1stBrkComm 9.870e+03 9.564e+03
Exterior_1stBrkFace 1.694e+04 4.290e+03
Exterior_1stCBlock -2.457e+03 1.704e+04
Exterior_1stCemntBd 1.365e+03 4.428e+03
Exterior_1stHdBoard 1.410e+02 3.778e+03
Exterior_1stImStucc -1.659e+04 2.162e+04
Exterior_1stMetalSd 3.695e+03 3.645e+03
Exterior_1stPlywood -1.161e+02 4.001e+03
Exterior_1stPreCast 6.326e+04 2.222e+04
Exterior_1stStone -1.621e+03 1.625e+04
Exterior_1stStucco 6.787e+03 4.790e+03
Exterior_1stVinylSd 2.823e+03 3.723e+03
Exterior_1stWd Sdng 2.408e+03 3.639e+03
Exterior_1stWdShing 3.226e+02 4.534e+03
Mas_Vnr_TypeBrkFace 2.562e+03 4.456e+03
Mas_Vnr_TypeCBlock -5.091e+04 2.186e+04
Mas_Vnr_TypeNone 6.314e+03 4.468e+03
Mas_Vnr_TypeStone 7.555e+03 4.673e+03
Mas_Vnr_Area 1.941e+01 3.643e+00
Exter_QualFair -6.865e+03 5.559e+03
Exter_QualGood -1.045e+04 3.277e+03
Exter_QualTypical -1.165e+04 3.592e+03
Bsmt_QualFair -1.005e+04 3.577e+03
Bsmt_QualGood -1.393e+04 2.055e+03
Bsmt_QualNo_Basement 3.458e+04 2.552e+04
Bsmt_QualPoor -1.268e+04 1.547e+04
Bsmt_QualTypical -1.261e+04 2.534e+03
Bsmt_ExposureGd 9.540e+03 1.831e+03
Bsmt_ExposureMn -5.737e+03 1.782e+03
Bsmt_ExposureNo -4.672e+03 1.292e+03
Bsmt_ExposureNo_Basement -1.211e+04 1.217e+04
BsmtFin_Type_1BLQ -2.653e+02 1.741e+03
BsmtFin_Type_1GLQ 3.663e+03 1.548e+03
BsmtFin_Type_1LwQ -3.997e+03 2.174e+03
BsmtFin_Type_1No_Basement NA NA
BsmtFin_Type_1Rec -2.706e+03 1.774e+03
BsmtFin_Type_1Unf 3.497e+03 1.755e+03
BsmtFin_Type_2BLQ -5.724e+03 3.973e+03
BsmtFin_Type_2GLQ 5.882e+03 4.886e+03
BsmtFin_Type_2LwQ -7.123e+03 3.843e+03
BsmtFin_Type_2No_Basement -2.690e+04 2.154e+04
BsmtFin_Type_2Rec -5.988e+03 3.722e+03
BsmtFin_Type_2Unf 1.841e+02 3.115e+03
Bsmt_Unf_SF -1.951e+01 1.795e+00
Total_Bsmt_SF 3.942e+01 2.721e+00
Heating_QCFair -4.846e+03 2.554e+03
Heating_QCGood -1.996e+03 1.265e+03
Heating_QCPoor -1.332e+04 1.414e+04
Heating_QCTypical -3.021e+03 1.224e+03
First_Flr_SF 5.105e+01 2.740e+00
Second_Flr_SF 5.590e+01 1.834e+00
Low_Qual_Fin_SF 2.279e+01 8.930e+00
Bsmt_Full_Bath 1.767e+03 1.111e+03
Full_Bath 3.433e+03 1.198e+03
Bedroom_AbvGr -3.135e+03 7.500e+02
Kitchen_AbvGr -9.448e+03 3.453e+03
Kitchen_QualFair -1.551e+04 3.770e+03
Kitchen_QualGood -1.267e+04 2.316e+03
Kitchen_QualPoor 2.648e+04 2.205e+04
Kitchen_QualTypical -1.439e+04 2.543e+03
FunctionalMaj2 3.025e+03 8.918e+03
FunctionalMin1 1.580e+04 5.962e+03
FunctionalMin2 1.355e+04 5.938e+03
FunctionalMod 8.760e+03 6.526e+03
FunctionalSal -1.988e+04 1.843e+04
FunctionalSev -2.345e+04 1.663e+04
FunctionalTyp 2.400e+04 5.354e+03
Fireplaces 8.286e+03 1.540e+03
Fireplace_QuFair -4.204e+03 4.331e+03
Fireplace_QuGood 2.542e+01 3.467e+03
Fireplace_QuNo_Fireplace 5.522e+03 3.941e+03
Fireplace_QuPoor 1.463e+03 4.774e+03
Fireplace_QuTypical -8.876e+02 3.563e+03
Garage_FinishNo_Garage 6.273e+03 2.787e+03
Garage_FinishRFn -1.748e+03 1.211e+03
Garage_FinishUnf 2.115e+02 1.385e+03
Garage_Cars 3.311e+03 1.373e+03
Garage_Area 1.514e+01 4.562e+00
Wood_Deck_SF 7.006e+00 3.563e+00
Enclosed_Porch 1.145e+01 7.123e+00
Screen_Porch 4.402e+01 7.433e+00
Pool_QCFair -4.782e+04 2.410e+04
Pool_QCGood -4.804e+04 1.691e+04
Pool_QCNo_Pool -7.529e+04 1.126e+04
Pool_QCTypical -7.380e+04 1.677e+04
Misc_FeatureGar2 5.498e+05 2.510e+04
Misc_FeatureNone 5.413e+05 2.292e+04
Misc_FeatureOthr 5.607e+05 2.542e+04
Misc_FeatureShed 5.419e+05 2.304e+04
Misc_FeatureTenC 4.849e+05 3.800e+04
Year_Sold -4.466e+02 3.092e+02
Sale_ConditionAdjLand 2.404e+04 6.747e+03
Sale_ConditionAlloca 1.358e+04 5.024e+03
Sale_ConditionFamily 3.466e+03 3.519e+03
Sale_ConditionNormal 9.474e+03 1.679e+03
Sale_ConditionPartial 1.965e+04 2.364e+03
Latitude 3.170e+05 1.209e+05
t value Pr(>|t|)
(Intercept) -2.820 0.004843 **
Lot_Area 7.378 2.13e-13 ***
StreetPave 3.011 0.002626 **
Lot_ShapeSlightly_Irregular -1.753 0.079753 .
Lot_ShapeModerately_Irregular 1.589 0.112253
Lot_ShapeIrregular 0.643 0.520031
Land_ContourHLS 2.337 0.019526 *
Land_ContourLow -1.553 0.120458
Land_ContourLvl 1.663 0.096348 .
Lot_ConfigCulDSac 1.928 0.053933 .
Lot_ConfigFR2 -2.522 0.011726 *
Lot_ConfigFR3 -0.702 0.482969
Lot_ConfigInside -0.236 0.813251
Land_SlopeMod 2.301 0.021461 *
Land_SlopeSev -2.858 0.004301 **
NeighborhoodCollege_Creek 2.994 0.002774 **
NeighborhoodOld_Town -0.940 0.347259
NeighborhoodEdwards 0.714 0.475487
NeighborhoodSomerset 5.804 7.23e-09 ***
NeighborhoodNorthridge_Heights 5.638 1.89e-08 ***
NeighborhoodGilbert -0.642 0.520860
NeighborhoodSawyer 2.869 0.004149 **
NeighborhoodNorthwest_Ames -1.275 0.202433
NeighborhoodSawyer_West 2.206 0.027489 *
NeighborhoodMitchell 2.034 0.042080 *
NeighborhoodBrookside 3.078 0.002104 **
NeighborhoodCrawford 6.831 1.04e-11 ***
NeighborhoodIowa_DOT_and_Rail_Road 1.009 0.313032
NeighborhoodTimberland 3.007 0.002666 **
NeighborhoodNorthridge 8.409 < 2e-16 ***
NeighborhoodStone_Brook 8.535 < 2e-16 ***
NeighborhoodSouth_and_West_of_Iowa_State_University 1.940 0.052430 .
NeighborhoodClear_Creek 2.251 0.024433 *
NeighborhoodMeadow_Village 2.267 0.023459 *
NeighborhoodBriardale 1.938 0.052731 .
NeighborhoodBloomington_Heights 1.578 0.114682
NeighborhoodVeenker 0.558 0.576712
NeighborhoodNorthpark_Villa 3.613 0.000308 ***
NeighborhoodBlueste 2.518 0.011846 *
NeighborhoodGreens 1.761 0.078371 .
NeighborhoodGreen_Hills 8.373 < 2e-16 ***
NeighborhoodLandmark 0.885 0.376208
Condition_1Feedr 1.008 0.313652
Condition_1Norm 4.651 3.46e-06 ***
Condition_1PosA 2.229 0.025867 *
Condition_1PosN 3.367 0.000771 ***
Condition_1RRAe -0.451 0.652173
Condition_1RRAn 1.974 0.048489 *
Condition_1RRNe 0.403 0.687105
Condition_1RRNn -0.286 0.775103
Condition_2Feedr -0.384 0.700646
Condition_2Norm 0.390 0.696674
Condition_2PosA 2.008 0.044741 *
Condition_2PosN -8.356 < 2e-16 ***
Condition_2RRAe -0.711 0.477150
Condition_2RRAn 0.124 0.901405
Condition_2RRNn 0.725 0.468380
Bldg_TypeTwoFmCon -3.061 0.002226 **
Bldg_TypeDuplex -4.271 2.01e-05 ***
Bldg_TypeTwnhs -8.538 < 2e-16 ***
Bldg_TypeTwnhsE -9.851 < 2e-16 ***
Overall_QualPoor -0.105 0.916213
Overall_QualFair -0.203 0.838996
Overall_QualBelow_Average -0.338 0.735743
Overall_QualAverage -0.091 0.927559
Overall_QualAbove_Average 0.098 0.921831
Overall_QualGood 0.588 0.556493
Overall_QualVery_Good 1.583 0.113454
Overall_QualExcellent 3.944 8.22e-05 ***
Overall_QualVery_Excellent 5.835 6.00e-09 ***
Overall_CondPoor -1.190 0.234187
Overall_CondFair -1.245 0.213352
Overall_CondBelow_Average 0.178 0.858934
Overall_CondAverage 0.975 0.329708
Overall_CondAbove_Average 1.575 0.115384
Overall_CondGood 2.334 0.019676 *
Overall_CondVery_Good 2.585 0.009788 **
Overall_CondExcellent 3.142 0.001695 **
Year_Built 9.096 < 2e-16 ***
Year_Remod_Add 2.452 0.014287 *
Roof_MatlCompShg 24.611 < 2e-16 ***
Roof_MatlMembran 20.184 < 2e-16 ***
Roof_MatlMetal 19.850 < 2e-16 ***
Roof_MatlRoll 19.708 < 2e-16 ***
Roof_MatlTar&Grv 24.123 < 2e-16 ***
Roof_MatlWdShake 23.551 < 2e-16 ***
Roof_MatlWdShngl 25.581 < 2e-16 ***
Exterior_1stAsphShn 0.530 0.595920
Exterior_1stBrkComm 1.032 0.302168
Exterior_1stBrkFace 3.949 8.05e-05 ***
Exterior_1stCBlock -0.144 0.885349
Exterior_1stCemntBd 0.308 0.757962
Exterior_1stHdBoard 0.037 0.970242
Exterior_1stImStucc -0.767 0.443039
Exterior_1stMetalSd 1.014 0.310867
Exterior_1stPlywood -0.029 0.976851
Exterior_1stPreCast 2.847 0.004449 **
Exterior_1stStone -0.100 0.920556
Exterior_1stStucco 1.417 0.156635
Exterior_1stVinylSd 0.758 0.448322
Exterior_1stWd Sdng 0.662 0.508176
Exterior_1stWdShing 0.071 0.943283
Mas_Vnr_TypeBrkFace 0.575 0.565394
Mas_Vnr_TypeCBlock -2.329 0.019913 *
Mas_Vnr_TypeNone 1.413 0.157714
Mas_Vnr_TypeStone 1.617 0.106014
Mas_Vnr_Area 5.329 1.07e-07 ***
Exter_QualFair -1.235 0.216978
Exter_QualGood -3.190 0.001440 **
Exter_QualTypical -3.244 0.001195 **
Bsmt_QualFair -2.811 0.004973 **
Bsmt_QualGood -6.778 1.48e-11 ***
Bsmt_QualNo_Basement 1.355 0.175467
Bsmt_QualPoor -0.820 0.412518
Bsmt_QualTypical -4.975 6.93e-07 ***
Bsmt_ExposureGd 5.209 2.04e-07 ***
Bsmt_ExposureMn -3.220 0.001298 **
Bsmt_ExposureNo -3.616 0.000305 ***
Bsmt_ExposureNo_Basement -0.995 0.319861
BsmtFin_Type_1BLQ -0.152 0.878914
BsmtFin_Type_1GLQ 2.366 0.018050 *
BsmtFin_Type_1LwQ -1.839 0.066088 .
BsmtFin_Type_1No_Basement NA NA
BsmtFin_Type_1Rec -1.525 0.127423
BsmtFin_Type_1Unf 1.993 0.046356 *
BsmtFin_Type_2BLQ -1.441 0.149779
BsmtFin_Type_2GLQ 1.204 0.228734
BsmtFin_Type_2LwQ -1.853 0.063952 .
BsmtFin_Type_2No_Basement -1.249 0.211795
BsmtFin_Type_2Rec -1.609 0.107761
BsmtFin_Type_2Unf 0.059 0.952858
Bsmt_Unf_SF -10.869 < 2e-16 ***
Total_Bsmt_SF 14.489 < 2e-16 ***
Heating_QCFair -1.897 0.057895 .
Heating_QCGood -1.577 0.114915
Heating_QCPoor -0.942 0.346365
Heating_QCTypical -2.467 0.013687 *
First_Flr_SF 18.631 < 2e-16 ***
Second_Flr_SF 30.490 < 2e-16 ***
Low_Qual_Fin_SF 2.552 0.010750 *
Bsmt_Full_Bath 1.591 0.111812
Full_Bath 2.866 0.004185 **
Bedroom_AbvGr -4.180 3.00e-05 ***
Kitchen_AbvGr -2.736 0.006251 **
Kitchen_QualFair -4.114 4.00e-05 ***
Kitchen_QualGood -5.472 4.84e-08 ***
Kitchen_QualPoor 1.201 0.229966
Kitchen_QualTypical -5.659 1.68e-08 ***
FunctionalMaj2 0.339 0.734464
FunctionalMin1 2.650 0.008089 **
FunctionalMin2 2.282 0.022572 *
FunctionalMod 1.342 0.179596
FunctionalSal -1.079 0.280698
FunctionalSev -1.410 0.158598
FunctionalTyp 4.482 7.70e-06 ***
Fireplaces 5.379 8.13e-08 ***
Fireplace_QuFair -0.971 0.331789
Fireplace_QuGood 0.007 0.994151
Fireplace_QuNo_Fireplace 1.401 0.161316
Fireplace_QuPoor 0.307 0.759246
Fireplace_QuTypical -0.249 0.803316
Garage_FinishNo_Garage 2.251 0.024476 *
Garage_FinishRFn -1.444 0.148986
Garage_FinishUnf 0.153 0.878600
Garage_Cars 2.412 0.015938 *
Garage_Area 3.320 0.000913 ***
Wood_Deck_SF 1.966 0.049393 *
Enclosed_Porch 1.607 0.108200
Screen_Porch 5.922 3.57e-09 ***
Pool_QCFair -1.984 0.047357 *
Pool_QCGood -2.841 0.004530 **
Pool_QCNo_Pool -6.688 2.73e-11 ***
Pool_QCTypical -4.401 1.12e-05 ***
Misc_FeatureGar2 21.904 < 2e-16 ***
Misc_FeatureNone 23.618 < 2e-16 ***
Misc_FeatureOthr 22.056 < 2e-16 ***
Misc_FeatureShed 23.523 < 2e-16 ***
Misc_FeatureTenC 12.761 < 2e-16 ***
Year_Sold -1.444 0.148835
Sale_ConditionAdjLand 3.563 0.000373 ***
Sale_ConditionAlloca 2.702 0.006930 **
Sale_ConditionFamily 0.985 0.324753
Sale_ConditionNormal 5.643 1.84e-08 ***
Sale_ConditionPartial 8.312 < 2e-16 ***
Latitude 2.622 0.008779 **
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 20780 on 2746 degrees of freedom
Multiple R-squared: 0.9366, Adjusted R-squared: 0.9323
F-statistic: 221.5 on 183 and 2746 DF, p-value: < 2.2e-16