yExamine the information in the data-table-B3.xls file that is attached. In addition to numerous other variables, the data includes observations of 32 motor vehicles with mpg (Y). More specifically, we are interested in the mpg regression on engine horsepower (X 2).
Open the data file in R and regress the horsepower mpg.
Check the regression's significance at alpha=0.05.
If significant, produce an mpg estimate with a 95% prediction interval for a car with a 150 horsepower engine.
able[[y,x1, imes 2,1 imes 3, imes 4, imes 5, imes 6, imes 7, imes 8, imes 9, imes 10, imes 11
B C U E F G H J K L ly x1 [2 Ix3 x4 x5 X6 X7 X8 x9 10 x11 18.9 350 165] 260 8 2.56 4 3 200.3 69.9 3910 1 17 350 170 275 8.5 2.56 4 3 199.6 72.9 3860 1 20 250 105 185 8.25 2.73 1 3 196.7 72.2 3510 1 18.25 351 143 255 8 E 2 3 199.9 74 3880 1 20.07 225 95 170 8.4 2.76 1 3 194.1 71.8 3365 0 11.2 440 215 300 8.2 288 4 E 184.5 69 4215 1 22.12 231 110 175 8 2.56 2 3 179.3 65.4[ 3020 1 21.47 262 110 200 8.5 2.56 2 3 179.3 65.4[ 3180 1 34.7 89.7 70 81 8.2 3.9 2 4 155.7 64 1905 0 30.4 96.9 75 88 9 4.3 2 5 165.2 65 2320 0 16.5 350 155 250 8.5 3.08 4 3 195.4 74.4 3885 1 36.5 85.3 08 8.5 3.89 2 4 160.6 62.2 2009 0 21.5 171 109 146 8.2 3.22 2 T 170.4 66.9 2655 0 19.7 258 110 195 : 308 1 3 171.5 77 3375 1 20.3 140 109 8.4 3.4 2 4 168.8 69.4 2700 0 17.8 302 129 220 8 3 2 E 199.9 74 3890 1 14.39 500 190 360 8.5 2.73 4 3 224.1 79.8 5290 1 14.89 440 215 330 8.2 2.71 4 3 231 79.7 5185 1 17.8 350 155 250 8.5 3.08 4 3 196.7 72.2 3910 1 16.41 318 145 255 8.5 2.45 2 3 197.6 71 3660 1 23.54 231 110 175 8 2.56 2 E 179.3 65.4 3050 1 21.47 360 180 290 8.4 2.45 2 3 214.2 76.3 4250 1 16.59 400 185 7.6 3.08 4 3 196 E2 3850 1 31.9 6'96 75 4.3 2 5 165.2 61.8 2275 0 29.4 140 86 8 2.92 2 4 176.4 65.4[ 2150 0 13.27 460 223 366 : 3 4 3 228 79.8[ 5430 1 23.9 133.6 96 120 8.4 3.91 2 5 171.5 63.4 2535 0 19.73 318 140 255 8.5 2.71 2 3 215.3 76.3 4370 1 13.9 351 148 243 8 3.25 2 3 215.5 4540 1 13.27 351 148 243 8 3.26 2 E 216.1 78.5 4715 1 13.77 360 195 295 8.25 3.15 4 3 209.3 77.4 4215 1 16.5 360 165 255 8.5 2.73 4 3 185.2 69 3660 1