Brookline_condo_data Multiple Regressions.xlsx

Brookline_condo_data Multiple Regressions.xlsx - SUMMARY...

This preview shows page 1 - 8 out of 52 pages.

SUMMARY OUTPUT Regression Statistics Multiple R 0.0552385448 R Square 0.31% Ranges from 0% to 100% Tells us how much the X variables explain Adjusted R Square 0.0021307533 Tells us the percentage of Y is explained by the X variable Standard Error 262584.41157 Absolute value of r square is not important Observations 1085 ANOVA df SS MS F Significance F Regression 1 2.2855E+011 2.2855E+011 3.314668512 0.068940033 Residual 1083 7.4673E+013 68950573199 Total 1084 7.4902E+013 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept $ 520,728.88 8435.426622 61.73118463 0 504177.248 537280.5084 Beacon St $ (46,969.18) 25798.40916 -1.820623111 0.068940033 -97589.7054 3651.345461
Image of page 1

Subscribe to view the full document.

n of the Y vaiable Lower 95.0% Upper 95.0% 504177.248 537280.5084 -97589.7054 3651.345461
Image of page 2
SUMMARY OUTPUT Regression Statistics Multiple R 0.8730429 R Square 76.2% Adjusted R S 0.76176436 Standard Erro 128302.609 Observations 1085 ANOVA df SS MS F Significance F Regression 2 5.709E+013 2.855E+013 1734.05841 0 Residual 1082 1.781E+013 1.646E+010 Total 1084 7.490E+013 CoefficientsStandard Error t Stat P-value Lower 95% Upper 95% Intercept -24139.3101 10596.166 -2.27811739 0.02291389 -44930.6713 -3347.94882 Size 354.126203 9.80652278 36.1112915 5.1325E-188 334.884247 373.368158 Full bathroom68645.7979 8868.12582 7.74073342 2.2598E-014 51245.1261 86046.4698 SUMMARY OUTPUT Regression Statistics Multiple R 0.86546822 R Square 0.74903524 Adjusted R S 0.74880351 Standard Erro 131746.444 Observations 1085 ANOVA df SS MS F Significance F Regression 1 5.610E+013 5.610E+013 3232.34699 0 Residual 1083 1.880E+013 1.736E+010 Total 1084 7.490E+013 Coefficients Standard Errot Stat P-value Lower 95% Upper 95% Lower 95.0% Intercept 12934.124 9705.71239 1.33263005 0.18293354 -6110.00607 31978.2541 -6110.00607 Size 407.451333 7.16665925 56.8537333 0 393.389224 421.513443 393.389224
Image of page 3

Subscribe to view the full document.

SUMMARY OUTPUT Regression Statistics Multiple R 0.68964649 R Square 47.6% Adjusted R S 0.47512808 Standard Erro 190440.27 Observations 1085 ANOVA df SS MS F Significance F Regression 1 3.562E+013 3.562E+013 982.265766 5.4613E-154 Residual 1083 3.928E+013 3.627E+010 Total 1084 7.490E+013 CoefficientsStandard Error t Stat P-value Lower 95% Upper 95% Intercept 75701.13 15183.1194 4.98587463 7.1785E-007 45909.4681 105492.792 Full bathroom293608.045 9368.14163 31.3411194 5.4613E-154 275226.282 311989.809 Upper 95.0% 31978.2541 421.513443
Image of page 4
SUMMARY OUTPUT Regression Statistics Multiple R 0.8739672102 R Square 0.7638186844 Adjusted R S 0.7631632321 Standard Erro127925.370683 Observations 1085 ANOVA df SS MS F Significance F Regression 3 5.7212E+013 1.9071E+013 1165.330678 0 Residual 1081 1.7690E+013 16364900464 Total 1084 7.4902E+013 Coefficients Prediction Standard Error t Stat P-value Lower 95% Intercept -30541.111789 1 10824.25911 -2.821542933 0.004866839 -51780.05 Beacon St 34373.4852265 1 12643.78891 2.718606381 0.006660682 9564.336771 Size 355.910587873 1200 9.799694827 36.31853789 1.9483E-189 336.6820097 Full bathroom68996.1290419 3 8842.990509 7.802352493 1.4265E-014 51644.75867 Prediction Pri $ 637,913 High $ 893,764.21 Low $ 382,062.72
Image of page 5

Subscribe to view the full document.

Upper 95% Lower 95.0% Upper 95.0% -9302.17361 -51780.05 -9302.17361 59182.63368 9564.336771 59182.63368 375.1391661 336.6820097 375.1391661 86347.49941 51644.75867 86347.49941
Image of page 6
Sale Price Street NumStreet Name Beacon St Size Full bathr Base floor Building St 174000 150 PLEASANT ST 0 1060 1 4 MID-RISE 337000 7 LEVERETT ST 0 831 1 1 DECKER 850000 24 EUSTON ST 0 2246 3 1 ROW-END 516000 417 WASHINGTON ST 0 1574 2 2 LOW-RISE 145000 150 PLEASANT ST 0 669 1 4 MID-RISE 962000 135 MASON TER 0 986 2 1 DECKER 676000 20 CHAPEL ST 0 1561 2 7 HIGH-RISE 265000 32 JUNIPER ST 0 822 1 3 LOW-RISE 357500 41 ACKERS AVE 0 986 1 1 CONVERTE 382000 1731 BEACON ST 1 947 1 6 HIGH-RISE 391000 70 PARK ST 0 1201 2 6 HIGH-RISE 564000 103 SEWALL AVE 0 1083 2 1 CONVERTE 310000 27 ENGLEWOOD AVE 0 792 1 2 LOW-RISE 573000 33 STANTON RD 0 1300 2 1 DECKER 548000 1600 BEACON ST 1 950 2 6 HIGH-RISE 380000 55 SEWALL AVE 0 908 1 6 MID-RISE 489900 8 HAMILTON RD 0 1286 2 1 LOW-RISE 410000 26 HOLLY LN 0 1122 2 2 LOW-RISE 288000 20 CHAPEL ST 0 876 2 0 HIGH-RISE 549000 168 WINCHESTER ST 0 1254 1 1 CONVERTE 325000 22 CHESTNUT PL 0 826 1 6 MID-RISE 348500 50 LONGWOOD AVE 0 958 1 7 HIGH-RISE 480000 131 SEWALL AVE 0 1217 2 6 MID-RISE 275000 99 POND AVE 0 870 1 3 HIGH-RISE 300000 33 POND AVE 0 870 1 12 HIGH-RISE 475000 28 STANTON RD 0 1148 1 3 LOW-RISE 390000 91 WALNUT ST 0 1052 1 3 DECKER 200000 24 JUNIPER ST 0 638 1 1 LOW-RISE 610000 2 ST PAUL ST 0 1161 2 1 MID-RISE 330000 1834 BEACON ST 1 733 1 3 LOW-RISE 730000 52 VERNON ST 0 2050 2 2 ROW-MIDD 250000 20 CHAPEL ST 0 710 1 0 HIGH-RISE 145000 150 PLEASANT ST 0 702 1 4 MID-RISE 529900 629 HAMMOND ST 0 1129 2
Image of page 7

Subscribe to view the full document.

Image of page 8
  • Spring '16
  • Agha
  • Low-rise

{[ snackBarMessage ]}

Get FREE access by uploading your study materials

Upload your study materials now and get free access to over 25 million documents.

Upload now for FREE access Or pay now for instant access
Christopher Reinemann
"Before using Course Hero my grade was at 78%. By the end of the semester my grade was at 90%. I could not have done it without all the class material I found."
— Christopher R., University of Rhode Island '15, Course Hero Intern

Ask a question for free

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern