A B C MPG Horsepower Weight 43.1 48 1985 19.9 110 3365 19.2 105 3535 17.7 165 3445 18.1 139 3205 20.3 103 2830 21.5 115 3245 16.9 155 4360 0 15.5 142 4054 18.5 150 3940 27.2 71 3190 41.5 76 2144 46.6 65 2110 5 23.7 100 2420 6 27.2 84 2490 39.1 58 1755 8 28.0 88 2605 9 24.0 92 2865 0 20.2 139 3570 1 20.5 95 3155 .2 28.0 90 2678 34.7 63 2215 36.1 66 1800 5 35.7 80 1915 6 20.2 85 2965 23.9 90 3420 8 29.9 65 2380 9 30.4 67 3250 0 36.0 74 1980 1 22.6 110 2800 2 36.4 67 2950 3 27.5 95 2560 4 33.7 75 2210 5 44.6 67 1850 6 32.9 100 2615 38.0 67 1965 8 24.2 120 2930 9 38.1 60 1968 0 39.4 70 2070 25.4 116 2900 2 31.3 75 2542 34.1 68 1985 4 34.0 88 2395 .5 31.0 82 2720 6 27.4 80 2670 7 22.3 88 2890 8 28.0 79 2625 CO 17.6 85 3465 0 34.4 65 3465 1 20.6 105 3380A US consumer lobby wishes to develop a model to predict gasoline usage, as measured by miles per gallon, based on the weight of the car in pounds. The Excel data file AUTO.x|s (contained in a folder under the CML Quizzes tab) contains these data (and also HP) for fifty recent models. Use Excel Data Analysis to estimate a linear model for the relationship, as well as a 94% confidence interval for the slope and a residual plot. State all numerical answers below correct to four decimal places using the Excel output results. 1. the intercept 2. the slope coefficient , and 3. the standard error of the estimate :l 4. Using this model, predict the gasoline usage for a car weighing 1900 pounds. Use all decimal places in your calculation by selecting and using the values of b0 and b1 in the output generated by Excel. 5. Does the prediction involve extrapolating the relationship? Type yes or no. From the output for 94% confidence interval for the slope coefficient report 6. the lower bound and 7. the upper bound