Lecture21.xlsx - Selling Price vs House Size 400 350 300...

Info icon This preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
10.0 12.0 14.0 16.0 18.0 20.0 22.0 24.0 26.0 0 50 100 150 200 250 300 350 400 Selling Price vs House Size House size (squares) Selling price ($'000)
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Size Price Size (squares) ($'000) (m^2) 20.0 219 185.81 14.8 190 137.50 20.5 199 190.45 12.5 121 116.13 18.0 150 167.23 14.3 198 132.85 24.9 334 231.33 16.5 188 153.29 24.3 310 225.75 20.2 213 187.66 22.0 288 204.39 19.0 312 176.52 12.3 186 114.27 14.0 173 130.06 16.7 174 155.15
Image of page 2
Size Price Fitted Values Residuals (squares) ($'000) (Price.hat) (U.hat) U.hat^2 1 20.0 219 242.303 -23.303 543.014 2 14.8 190 176.516 13.484 181.825 3 20.5 199 248.628 -49.628 2462.970 4 12.5 121 147.418 -26.418 697.895 5 18.0 150 217.000 -67.000 4489.000 6 14.3 198 170.190 27.810 773.391 7 24.9 334 304.294 29.706 882.437 8 16.5 188 198.023 -10.023 100.461 9 24.3 310 296.703 13.297 176.801 10 20.2 213 244.833 -31.833 1013.335 11 22.0 288 267.605 20.395 415.943 12 19.0 312 229.651 82.349 6781.304 13 12.3 186 144.887 41.113 1690.243 14 14.0 173 166.395 6.605 43.630 15 16.7 174 200.553 -26.553 705.076 SSE= 20957.325 Mean 18 217 Variance 16.143 4080.714 2583.763 1496.952 1612.101892 40.151 Covariance 204.229 SumSq/n 18.414 E(Price | Size) = beta.0 + beta.1 Size Coefficient S.E. t-stat p-value ci.L ci.U betahat.1 12.651 2.671 4.737 0.0004 6.882 18.420 betahat.0 -10.724 49.180 -0.218 0.8308 R^2 0.633 Size = 21 254.95398 13.102 226.653 283.255
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
12.0 14.0 16.0 18.0 20.0 22.0 24.0 26.0 0 50 100 150 200 250 300 350 400 Selling Price vs House Size House Size (sq.) Selling price ($'000)
Image of page 4
10.0 12.0 14.0 16.0 18.0 20.0 22.0 24.0 26.0 28.0 30.0 0 50 100 150 200 250 300 350 400 Selling Price vs House Size
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
Image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

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