The data in the attached excel file comes fromConsumer Reportsand was collected over a two-year period.It gives the average mpg over a 195-mile trip, the weight of the vehicle (pounds), engine displacement (liters), number of cylinders, horsepower, type of transmission (0 = manual, 1 = automatic), the number of gears and whether the car was foreign (1) or domestic (0).

Part a:Build a model for predicting the average mpg based on the data in the attached excel spread sheet.Show and annotate your work in the excel spread sheet.Include an interpretation of the final model.

Part b:Using your final model frompart a, construct an interval estimate of the average mpg of a vehicle which weighs 3000 pounds, with an engine displacement of 2.5 liters, 4 cylinders, 150 hp, manual transmission, 5 gears and is a domestic car. Explain what this means.

Case Trip MPG Weight Displace No Cyl HP Trans Gears For/Dom 1 UI AWNI 32 2365 1.6 113 33 2430 1.6 A 108 42 1895 1.3 60 36 2320 1.6 74 32 2330 1.6 82 6 34 2255 1.5 68 36 2350 1.6 74 8 41 1635 1.3 58 HPPOPP 9 36 2070 1.6 82 10 34 2115 1.5 68 11 35 1840 1.1 52 12 43 1970 1.5 78 13 51 1575 1.0 WADA 48 14 37 2185 1.5 68 15 36 2115 1.8 81 16 28 3040 2.2 145 17 34 2620 2.0 108 P O O O O O O O O 18 25 3230 3.0 142 19 29 2745 2.0 102 20 28 2573 1.9 A A 110 21 27 2802 2.3 -A 100 22 31 2699 2.0 90 23 36 2695 2.2 110 24 31 2885 2.5 100 25 23 3310 5.0 225 26 23 3430 5.0 8 170 27 29 2670 2.2 97 28 35 2925 2.0 115 29 28 2735 2.5 98 30 29 3155 3.0 140 A W A W D D U U W W A D A W A D D U A D ADD W WW WAVU 31 30 2995 3.0 6 150 32 27 3150 3.0 6 136 33 29 2950 2.8 125 34 26 3295 3.8 w w A 140 35 28 2915 2.5 100 36 29 3220 2.8 125 37 26 2900 2.2 146 38 27 WAWA 3205 2.5 153 39 26 2930 2.2 4 103 40 25 3320 3.0 157 41 26 3080 2.3 4 114 42 24 3625 3.0 136 43 23 3665 3.0 145 44 22 3625 2.4 106 AWAD 45 23 3415 2.4 107 H HOOP HOP OOOOOOOOOHOOOOOOOPPPPPP