Brookline_condo_data Mult. categories.xlsx

Brookline_condo_data Mult. categories.xlsx - SUMMARY OUTPUT...

This preview shows page 1 - 10 out of 54 pages.

SUMMARY OUTPUT Regression Statistics Multiple R 0.88631679 R Square 79% We have information for 79% of the price of Brookline Condos Adjusted R S 0.78376211 We are missing 21% of the variation in price. Standard Erro 122235.687 Observations 1085 ANOVA df SS MS F Significance F Regression 9 5.884E+013 6.538E+012 437.555284 0 Residual 1075 1.606E+013 1.494E+010 Total 1084 7.490E+013 CoefficientsStandard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Intercept -2270.53825 15401.1666 -0.14742638 0.88282313 -32490.2945 27949.218 -32490.2945 Beacon 35836.042 12296.4207 2.91434742 0.00363819 11708.3349 59963.749 11708.3349 Size 313.522732 13.730515 22.8340111 2.1030E-094 286.581083 340.46438 286.581083 Base floor -2511.60742 2035.38196 -1.23397351 0.21748248 -6505.37934 1482.1645 -6505.37934 Elevators -3857.39635 2403.0047 -1.60523879 0.10873497 -8572.50777 857.71506 -8572.50777 Rooms 433.727203 5111.90026 0.08484657 0.93239917 -9596.70644 10464.1608 -9596.70644 Bedrooms 721.956382 8344.29397 0.08652097 0.9310684 -15650.9936 17094.9063 -15650.9936 Full bathroom69365.0193 8977.7144 7.7263562 2.5282E-014 51749.1887 86980.8498 51749.1887 Half Bathroo 69852.3316 10794.8014 6.47092324 1.4771E-010 48671.0615 91033.6016 48671.0615 Garage parki 34787.2313 4900.59119 7.09857851 2.2861E-012 25171.4226 44403.04 25171.4226
Image of page 1

Subscribe to view the full document.

Upper 95.0% 27949.218 59963.749 340.46438 1482.1645 857.71506 10464.1608 17094.9063 86980.8498 91033.6016 44403.04
Image of page 2
Low-Rise Sum - Low-Rise Low-Rise High-Rise Decker Row 0 0 1 406 Total Result 406
Image of page 3

Subscribe to view the full document.

Mid-Rise Other
Image of page 4
SUMMARY OUTPUT Regression Statistics Multiple R 0.89407057 R Square 0.79936218 Adjusted R S 0.79580243 Standard Erro 118511.713 Observations 1085 ANOVA df SS MS F Significance F Regression 15 5.987E+013 3.992E+012 304.499466 0 Residual 1070 1.503E+013 1.405E+010 Total 1085 7.490E+013 CoefficientsStandard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Intercept -162411.227 28527.584 -5.6931294 1.6102E-008 -218387.583 -106434.872 -218387.583 Beacon 62193.3714 13019.796 4.77683147 2.0287E-006 36646.1421 87740.6007 36646.1421 Size 316.511487 13.5683802 23.3271386 1.2360E-097 289.887834 343.135139 289.887834 Base floor 1815.96979 2126.78762 0.85385573 0.39337604 -2357.17784 5989.11742 -2357.17784 Elevators 21398.3301 4811.23166 4.44757841 9.5910E-006 11957.8106 30838.8496 11957.8106 Rooms 2142.23362 5035.70625 0.42540877 0.67062425 -7738.74623 12023.2135 -7738.74623 Bedrooms -4468.33834 8156.50062 -0.54782542 0.58392604 -20472.8895 11536.2128 -20472.8895 Full bathroom 69193.127 8846.29338 7.82170837 1.2440E-014 51835.0758 86551.1781 51835.0758 Half Bathroo 82069.5509 10798.4519 7.60012189 6.4453E-014 60881.0064 103258.095 60881.0064 Garage parki 36782.5563 4800.43253 7.66234211 4.0778E-014 27363.2267 46201.8859 27363.2267 Low-Rise 156988.909 23819.7473 6.5907042 6.8581E-011 110250.193 203727.625 110250.193 High-Rise 0 0 65535 #NUM! 0 0 0 Decker 152012.49 27984.0307 5.43211563 #NUM! 97102.6862 206922.294 97102.6862 Row 153770.43 26146.3888 5.88113454 5.4419E-009 102466.417 205074.444 102466.417 Mid-Rise 81229.8331 22227.4964 3.65447514 0.00027021 37615.4058 124844.26 37615.4058 Other 92003.5961 30151.1656 3.05141093 0.00233383 32841.4757 151165.716 32841.4757
Image of page 5

Subscribe to view the full document.

Upper 95.0% -106434.872 87740.6007 343.135139 5989.11742 30838.8496 12023.2135 11536.2128 86551.1781 103258.095 46201.8859 203727.625 0 206922.294 205074.444 124844.26 151165.716
Image of page 6
SUMMARY OUTPUT Regression Statistics Multiple R 0.894070567 R Square 80% Adjusted R S 0.796737011 Standard Erro 118511.7128 Observations 1085 ANOVA df SS MS F Significance F Regression 14 5.987E+013 4.277E+012 304.499466 0 Residual 1070 1.503E+013 1.405E+010 Total 1084 7.490E+013 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Intercept $ (81,181.39) 20775.2747 -3.90759665 9.9072E-005 -121946.296 -40416.4922 -121946.296 Beacon $ 62,193.37 13019.796 4.77683147 2.0287E-006 36646.1421 87740.6007 36646.1421 Size $ 316.51 13.5683802 23.3271386 1.2360E-097 289.887834 343.135139 289.887834 Base floor $ 1,815.97 2126.78762 0.85385573 0.39337604 -2357.17784 5989.11742 -2357.17784 Elevators $ 21,398.33 4811.23166 4.44757841 9.5910E-006 11957.8106 30838.8496 11957.8106 Rooms $ 2,142.23 5035.70625 0.42540877 0.67062425 -7738.74623 12023.2135 -7738.74623 Bedrooms $ (4,468.34) 8156.50062 -0.54782542 0.58392604 -20472.8895 11536.2128 -20472.8895 Full bathroom $ 69,193.13 8846.29338 7.82170837 1.2440E-014 51835.0758 86551.1781 51835.0758 Half Bathroo $ 82,069.55 10798.4519 7.60012189 6.4453E-014 60881.0064 103258.095 60881.0064 Garage parki $ 36,782.56 4800.43253 7.66234211 4.0778E-014 27363.2267 46201.8859 27363.2267 Low-Rise $ 75,759.08 15939.9781 4.75277163 2.2801E-006 44481.9132 107036.238 44481.9132 High-Rise $ (81,229.83) 22227.4964 -3.65447514 0.00027021 -124844.26 -37615.4058 -124844.26 Decker $ 70,782.66 19857.8298 3.56447093 0.00038068 31817.9506 109747.364 31817.9506 Row $ 72,540.60 18347.3731 3.95373205 8.1997E-005 36539.6838 108541.51 36539.6838 Other $ 10,773.76 21802.8219 0.49414535 0.62130496 -32007.3749 53554.9009 -32007.3749 On average for every additional bedroom the price of a condo in brookline decreases $4,468.34, holding all o Comapred to a mid-rise condo, a low-rise condo costs $75,759.08 more on average.
Image of page 7

Subscribe to view the full document.

Upper 95.0% -40416.4922 87740.6007 343.135139 5989.11742 30838.8496 12023.2135 11536.2128 86551.1781 103258.095 46201.8859 107036.238 -37615.4058 109747.364 108541.51 53554.9009 other factors constant.
Image of page 8
Sale Price Street NumStreet NamBeacon Size Base floor Elevators Rooms Bedrooms Full bathr 174000 150 PLEASANT 0 1060 4 1 4 2 1 337000 7 LEVERETT S 0 831 1 0 4 2 1 850000 24 EUSTON ST 0 2246 1 0 10 6 3 516000 417 WASHINGT 0 1574 2 0 6 3 2 145000 150 PLEASANT 0 669 4 1 3 1 1 962000 135 MASON TE 0 986 1 0 7 3 2 676000 20 CHAPEL ST 0 1561 7 6 6 2 2 265000 32 JUNIPER ST 0 822 3 0 5 2 1 357500 41 ACKERS AV 0 986 1 0 5 2 1 382000 1731 BEACON ST 1 947 6 2 4 1 1 391000 70 PARK ST 0 1201 6 4 4 2 2 564000 103 SEWALL AV 0 1083 1 0 4 2 2 310000 27 ENGLEWOO 0 792 2 0 5 2 1 573000 33 STANTON R 0 1300 1 0 7 3 2 548000 1600 BEACON ST 1 950 6 2 4 2 2 380000 55 SEWALL AV 0 908 6 1 4 2 1 489900 8 HAMILTON 0 1286 1 0 6 3 2 410000 26 HOLLY LN 0 1122 2 1 6 2 2 288000 20 CHAPEL ST 0 876 0 6 4 1 2 549000 168 WINCHEST 0 1254 1 0 5 3 1 325000 22 CHESTNUT 0 826 6 2 3 1 1 348500 50 LONGWOO 0 958 7 3 3 1 1 480000 131 SEWALL AV 0 1217 6 2 4 2 2 275000 99 POND AVE 0 870 3 5 3 1 1 300000 33 POND AVE 0 870 12 5 3 1 1 475000
Image of page 9

Subscribe to view the full document.

Image of page 10
  • Spring '16
  • Agha
  • BABCOCK S, 5.884E

{[ 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