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:Model for predicting the average mpg based on the data provided below and interpretation.Explain the final model.

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

Case Trip MPG Weight Displace No Cyl HP Trans Gears For/Dom 1 32 2365 1.6 113 0 5 W N 33 2430 1.6 108 0 42 1895 1.3 60 36 2320 1.6 74 32 2330 1.6 82 6 34 2255 1.5 68 7 36 2350 1.6 74 LD CO 41 1635 1.3 58 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 48 14 37 2185 1.5 68 15 36 2115 1.8 81 16 28 3040 2.2 145 17 34 2620 2 108 18 25 3230 3 142 19 29 2745 2 102 20 28 2573 1.9 110 21 27 2802 2.3 100 22 31 2699 2 90 23 36 2695 2.2 110 24 31 2885 2.5 100 25 23 3310 5 8 225 26 23 3430 5 8 170 27 29 2670 2.2 97 28 35 2925 2 115 29 28 2735 2.5 98 30 29 3155 3 140 31 30 2995 3 150 32 27 3150 3 6 136 33 29 2950 2.8 125 PPPPP 34 26 3295 3.8 140 P 35 28 2915 2.5 100 36 29 3220 2.8 125 37 26 2900 2.2 146 PPP 38 27 3205 2.5 153 39 26 2930 2.2 103 40 25 3320 3 157 41 26 3080 2.3 114 42 24 3625 3 6 136 ON H O I O O O OOO OOO OOO OOO OPP 43 23 3665 3 145 44 22 3625 2.4 106 23 3415 2.4 107