Lecture22.xlsx - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Size...

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

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 R 0.796 Size = 21 254.95398 13.102 226.653 283.255
Image of page 1

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

12.0 14.0 16.0 18.0 20.0 22.0 0 50 100 150 200 250 300 350 400 House Price vs House Size Size (squares) Price ($'000)
Image of page 2
24.0 26.0
Image of page 3

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

Size Price Fitted Values Residuals (squares) ($'000) (Price.hat) (U.hat) U.hat^2 1 20.0 219 209.221 9.779 95.630 2 14.8 190 184.553 5.447 29.668 3 20.5 199 211.593 -12.593 158.580 4 12.5 121 173.642 -52.642 2771.223 5 18.0 150 199.733 -49.733 2473.404 6 14.3 198 182.181 15.819 250.233 7 24.9 75 232.466 -157.466 24795.412 8 16.5 188 192.618 -4.618 21.322 9 24.3 310 229.619 80.381 6461.056 10 20.2 213 210.170 2.830 8.011 11 22.0 288 218.709 69.291 4801.304 12 19.0 312 204.477 107.523 11561.166 13 12.3 186 172.694 13.306 177.059 14 14.0 173 180.758 -7.758 60.188 15 16.7 174 193.566 -19.566 382.843 SSE= 54047.100 Mean 18.0 199.73 Variance 16.143 4223.781 2583.763 1496.952 4157.4692 64.478 Covariance 76.579 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 4.744 4.289 1.106 0.2888 3.387 21.916 betahat.0 114.345 78.977 1.448 0.1714 R^2 0.612
Image of page 4
12.0 14.0 16.0 18.0 20.0 22. 0 50 100 150 200 250 300 350 House Price vs House Size Size (squares) Price ($'000)
Image of page 5

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

.0 24.0 26.0
Image of page 6
Size Price Fitted Values Residuals (squares) ($'000) (Price.hat) (U.hat) U.hat^2 1 20.0 219 224.405 -5.405 29.217 2 14.8 190 164.072 25.928 672.287 3 20.5 199 230.207 -31.207 973.854 4 12.5 121 137.385 -16.385 268.481 5 18.0 150 201.200 -51.200 2621.440 6 14.3 198 158.270 39.730 1578.459 7 24.9 334 281.258 52.742 2781.685 8 16.5 188 183.796 4.204 17.673 9 24.3 310 274.297 35.703 1274.724 10 20.2 213 226.726 -13.726 188.399 11 22.0 288 247.611 40.389 1631.302 12 19.0 75 212.803 -137.803 18989.572 13 12.3 186 135.065 50.935 2594.388 14 14.0 173 154.789 18.211 331.627 15 16.7 174 186.117 -12.117 146.811 SSE= 34099.918 Mean 18.0 201.2 Variance 16.143 4608.886 2583.763 1496.952 2623.07065 51.216 Covariance 187.300 SumSq/n 18.414 E(Price | Size) = beta.0 + beta.1 Size Coefficient S.E. t-stat p-value ci.L
Image of page 7

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

Image of page 8
This is the end of the preview. Sign up to access the rest of the document.
  • Three '13
  • House Price vs, Price vs House, vs House Size

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