1)Estimate the multiple regression model specified as follows: ????? = ?? + ????? + ???????? + ?????(??????) + ??
(2)Export the summary output tables to the word document, and comment on the significance of the coefficient, meaning of the coefficients, significance of the F test, and R-squared (Note: level-level; level-log)
(3)Write down the estimated regression equation and pick the observed values for all independent variables for any observation. Then, calculate and report the predicted value for rent, and compare it with the observed value for the same observation (Note: Show your work for full credit).
(4)Plot using Excel the predicted and observed (original) values for rent, and comment on the trends you observe.
(5)Plot using Excel the estimated and standardized residuals and comment on the trends you observe.
(6)Check the zero conditional mean assumption (weak version) for this regression model using the residual output table.
city year rent pop enroll avginc 197 75211 15303 11537 VARIABLE DESCRIPT 30 342 77759 18017 19568 city City label, 1 80 30 323 106743 22462 19841 year 80 80 496 141865 29769 31885 rent average rer 80 216 36608 11847 11455 log(rent) log(average 80 351 42099 10265 21202 pop city populat # college st 80 267 36640 13825 14682 enroll 80 588 46209 18173 29044 avginc per capita i 80 475 62134 8175 31300 log(pop) log of city p 6 6 0 0 V V O O UI VI A A W W N N H H 925 110330 18205 56307 log(enroll) log of colles 80 276 118550 12223 16291 log(avginc) log of per c 80 630 132605 15192 35103 80 302 76685 20724 16744 80 521 83312 24809 29407 80 257 65092 17134 15773 80 422 87758 21377 26826 80 253 126109 16009 11683 80 568 130474 19012 25811 10 80 242 81371 24528 12586 10 80 383 84770 26027 21077 30 228 81548 22735 11750 11 80 444 124773 33980 23453 12 80 187 42549 14863 10018 12 80 347 45734 18396 14286 13 80 243 58133 19532 14894 13 80 422 63502 21070 22967 14 80 336 73706 12215 21715 14 80 636 73233 14887 22346 15 80 210 52044 25719 10933 15 80 403 60633 29886 18393 16 80 195 77216 13618 13459 16 80 325 71305 15799 19353 17 80 251 45775 20465 16104 17 80 404 47198 21615 24636 18 80 234 50508 18299 14417 18 80 414 59738 23508 24565 19 80 248 52738 19308 13180 19 80 415 65608 22508 22900 20 80 224 32644 9253 13030 20 80 396 37712 12223 21531 21 80 194 40450 8551 12195 21 80 332 40641 7086 20043 22 80 239 219419 24732 15158 22 80 354 219531 29333 21898 23 80 257 95322 23403 14211 23 80 538 95802 24364 3314024 80 248 51392 32289 15000 24719 24 80 451 50677 32044 80 232 79722 17340 14620 25 80 403 80277 18351 23207 26 80 309 107966 35628 18316 26 80 568 109592 36074 33344 27 80 238 42566 8571 15367 27 80 399 48812 11889 24004 28 80 197 40829 7392 10983 28 80 304 41882 3703 21174 29 80 236 62061 22202 13651 29 80 382 69101 22166 22059 17094 30 80 231 171932 24993 30 80 379 191972 29616 28056 31 80 215 45086 5645 13593 31 80 366 62126 9002 23648 32 80 230 28732 14173 10294 32 80 493 29541 16361 25152 33 80 212 101727 14587 12511 80 456 101082 17635 7738 33 34 80 210 170105 21139 12321 34 80 409 163860 23703 21242 35 80 256 32421 14338 15744 35 80 489 38719 15359 30489 36 80 225 100831 14863 12845 36 80 440 136611 18486 24354 37 80 255 150255 16498 17022 37 80 479 207951 29138 32451 38 80 231 35740 10463 13471 38 80 374 44972 12470 12206 39 80 228 61383 3534 17065 39 80 355 74111 11938 25326 16009 40 80 216 43765 7959 40 80 367 49425 10494 25456 41 80 252 25728 13789 13521 41 80 393 28176 14394 21766 42 80 248 26164 10030 13891 42 80 401 28835 12611 21463 43 80 244 68020 16689 15555 43 80 362 80071 17751 25165 44 80 219 38268 18098 11102 44 80 354 36676 14972 18501 45 80 245 40960 16072 13621 45 30 385 44757 15872 23212 46 80 249 105624 19179 14959 46 80 425 112669 21440 25369 47 80 225 564871 58499 14834
