3. Refer to the Lincolnville School District bus data. Consider a regression
a) In addition to the engine dummy variable construct manufacturer dummy variables. (Hint: Since there are 3 manufacturers, you need 2 dummy variables. One takes a value of 1 if the manufacturer is Keiser and 0 if the
manufacturer is Thompson or Bluebird and a second takes a value of 1 if the manufacturer is Thompson and 0 if the manufacturer is Keiser or Bluebird. Note: Having 3 dummies for 3 manufacturers would create multicollinearity.) b) Suppose you are considering a regression where maintenance cost is the dependent variable and the potential independent variables are manufacturer (both dummy variables, engine type, age, odometer miles, and capacity.) Create a correlation matrix. Are there any |
variables you think cannot be in a regression together? c) Use a statistical software package to determine the multiple regression equation. (Use your conclusions from the correlation matrix to omit independent variables, if necessary.) -
d) Show that your regression equation shows a significant relationship (i.e. we can reject the null that all coefficients are 0.) -
e) Write out the regression equation and interpret its practical application. -
f) Report and interpret the R-square. -
g) Develop a histogram of the residuals from the final regression equation. Is it reasonable to conclude that the normality assumption has been met? -
h) Plot the residuals against the fitted values of Y from the final regression equation. Plot the residuals on the vertical axis and the fitted values on the horizontal axis. Use the graph to explain whether you think the linearity and homoskedasticity assumptions hold |
Engine Type (O=diesel Capacity 14 14 EE ? 59 9 42 5: 55 55 55 5. 50 5 mm en NSNN 9. Om mo 1 5 55 50 101 358 29 365 162 686 370 887 464 948 678 481 43 704 0012180198119821 291 292 293 ADE 8 Miles 11973 11969 11967 11948 11925 11922 11890 11883 11837 11814 11800 11798 11789 11782 11781 11778 11758 11757 11707 11704 11698 11691 11668 11662 11615 11610 11576 11533 11518 11462 11461 11418 11359 11358 11344 11342 11342 11336 11248 11231 11222 11168 B&B MO!||||||!!!!!||||||||| - 6 e 0 4 6 0 1 55 55 55 50 ED EE 43 74 982 321 724 100 134 800 193 1 42 59 14 09 NLD 0 0 9 7 8 61 135 833 671 692 200 754 540 660 0 1 0 0 0 8 8 10 14 1 4 6 1 353 1 482 1 4 10 14 9 8 0 0 0 7 4 A 0 0 0 0 6 6 9 10 Kelser Bluebird Thompson Thompson Bluebird Bluebird Kelser was Bluebird end Bluebird Kelser mated Bluebird Thompson Bluebird Bluebird Kelser Keiser Bluebird Kolser Kelser Blushird Bluebird Bluebird Kelser ole Bluebird Kelser Thompson . Keiser Bluebird olubic Thompson Bluebird Bluebird Bluebird Bluebird va Kelser . Keiser Thompson Bluebird Bluebird Bluebird Bluebird Bluebird Diesel Diesel Diesel Gasoline Diesel c! Diesel Diesel Gasoline Gasoline Gasoline Gasoline dsome Diesel Diesel Diesel Diesel Diesel Diesel Diesel Diesel Diesel ni... Diesel Die Diesel Corolla Gasoline Colin Gasoline Diesel Diesel Gasoline Gasoline Gasoline Diesel Diesel Gasoline Die Diesel local Diesel Gasoline Diesel . Diesel Gasoline Diesel Gasoline Diesel 0 0 0 1 . 1 55 55 14 14 55 55 14 55 55 55 55 6 55 55 42 55 3 55 42 42 CE 55 55 EE 55 14 14 55 55 14 42 42 42 55 55 55 . 14 6 55 55 55 55 55 4139 3560 3920 6733 3770 5168 7380 3656 6213 41 4279 10575 107 732 4752 3809 3809 3769 3769 2152 2152 2985 4563 4723 1000 1826 1064 1061 2527 3527 occo 9669 2116 6212 6927 100 1881 7004 5284 3173 10133 2256 2356 22 3124 FO 5976 400 5408 2000 3690 9573 2470 6863 4513 4 . 2 2 . 4 398 330 984 30 977 705 103 767 326 325 120 120 554 695 9 861 co 603 156 427 883 168 954 768 490 725 45 38 314 507 . 40 918 387 418 103536 76426 90968 89792 93248 103700 146860 45284 207 64434 45744 116534 100 95922 93322 87664 79422 19422 47596 47596 71538 107343 110320 A6 44604 23152 400 46848 con 106040 4902 44384 es 140460 73423 *** 20742 83006 101000 71778 106940 106240 57065 COL 60102 61662 128117 . 72849 118470 53620 89960 104715 11148 11127 11112 11100 11048 2010 11018 11003 10945 100 10911 10902 10202 100VA 10802 10802 10002 1070 10760 10759 10755 10726 10724 10674 10662 1003 10633 100 10591 10551 10518 10473 10355 10344 . 10315 10235 10227 10240 10210 10000 10209 10167 10120 10140 10120 10128 100 10095 10081 10075 10055 10000 10 . 4 0 0 1 1 1 12 7 2 7 10 7 10 0 0 U 1 0 0 1 0 0 1 5 . 6 6 11 7 10 5 8 9 0 1 0 Engine Type (O=diesel Capacity 14 14 EE ? 59 9 42 5: 55 55 55 5. 50 5 mm en NSNN 9. Om mo 1 5 55 50 101 358 29 365 162 686 370 887 464 948 678 481 43 704 0012180198119821 291 292 293 ADE 8 Miles 11973 11969 11967 11948 11925 11922 11890 11883 11837 11814 11800 11798 11789 11782 11781 11778 11758 11757 11707 11704 11698 11691 11668 11662 11615 11610 11576 11533 11518 11462 11461 11418 11359 11358 11344 11342 11342 11336 11248 11231 11222 11168 B&B MO!||||||!!!!!||||||||| - 6 e 0 4 6 0 1 55 55 55 50 ED EE 43 74 982 321 724 100 134 800 193 1 42 59 14 09 NLD 0 0 9 7 8 61 135 833 671 692 200 754 540 660 0 1 0 0 0 8 8 10 14 1 4 6 1 353 1 482 1 4 10 14 9 8 0 0 0 7 4 A 0 0 0 0 6 6 9 10 Kelser Bluebird Thompson Thompson Bluebird Bluebird Kelser was Bluebird end Bluebird Kelser mated Bluebird Thompson Bluebird Bluebird Kelser Keiser Bluebird Kolser Kelser Blushird Bluebird Bluebird Kelser ole Bluebird Kelser Thompson . Keiser Bluebird olubic Thompson Bluebird Bluebird Bluebird Bluebird va Kelser . Keiser Thompson Bluebird Bluebird Bluebird Bluebird Bluebird Diesel Diesel Diesel Gasoline Diesel c! Diesel Diesel Gasoline Gasoline Gasoline Gasoline dsome Diesel Diesel Diesel Diesel Diesel Diesel Diesel Diesel Diesel ni... Diesel Die Diesel Corolla Gasoline Colin Gasoline Diesel Diesel Gasoline Gasoline Gasoline Diesel Diesel Gasoline Die Diesel local Diesel Gasoline Diesel . Diesel Gasoline Diesel Gasoline Diesel 0 0 0 1 . 1 55 55 14 14 55 55 14 55 55 55 55 6 55 55 42 55 3 55 42 42 CE 55 55 EE 55 14 14 55 55 14 42 42 42 55 55 55 . 14 6 55 55 55 55 55 4139 3560 3920 6733 3770 5168 7380 3656 6213 41 4279 10575 107 732 4752 3809 3809 3769 3769 2152 2152 2985 4563 4723 1000 1826 1064 1061 2527 3527 occo 9669 2116 6212 6927 100 1881 7004 5284 3173 10133 2256 2356 22 3124 FO 5976 400 5408 2000 3690 9573 2470 6863 4513 4 . 2 2 . 4 398 330 984 30 977 705 103 767 326 325 120 120 554 695 9 861 co 603 156 427 883 168 954 768 490 725 45 38 314 507 . 40 918 387 418 103536 76426 90968 89792 93248 103700 146860 45284 207 64434 45744 116534 100 95922 93322 87664 79422 19422 47596 47596 71538 107343 110320 A6 44604 23152 400 46848 con 106040 4902 44384 es 140460 73423 *** 20742 83006 101000 71778 106940 106240 57065 COL 60102 61662 128117 . 72849 118470 53620 89960 104715 11148 11127 11112 11100 11048 2010 11018 11003 10945 100 10911 10902 10202 100VA 10802 10802 10002 1070 10760 10759 10755 10726 10724 10674 10662 1003 10633 100 10591 10551 10518 10473 10355 10344 . 10315 10235 10227 10240 10210 10000 10209 10167 10120 10140 10120 10128 100 10095 10081 10075 10055 10000 10 . 4 0 0 1 1 1 12 7 2 7 10 7 10 0 0 U 1 0 0 1 0 0 1 5 . 6 6 11 7 10 5 8 9 0 1 0