A1 fx MPG A B C D E MPG _ Horsepower Weight N 43.1 48 1985 19.9 1 10 3365 19.2 105 3535 17.7 165 3445 18.1 139 3205 20.3 103 2830 8 21.5 115 3245 9 16.9 155 4360 10 15.5 142 4054 11 18.5 150 3940 12 27.2 71 3190 13 41.5 76 2144 14 46.6 65 2110 15 23.7 100 2420 16 27.2 84 2490 17 39.1 58 1755 18 28.0 88 2605 19 24.0 92 2865 20 20.2 139 3570 21 20.5 95 3155 22 28.0 90 2678 23 34.7 63 2215 24 36.1 66 1800 25 35.7 80 1915 26 20.2 85 2965 27 23.9 90 3420 28 29.9 65 2380 29 30.4 67 3250 30 36.0 74 1980 31 22.6 110 2800 32 36.4 67 2950 33 27.5 95 2560\fQUESTION 9 A US consumer lobby wishes to develop a model to predict gasoline mileage, as measured by miles per gallon, based on the horsepower of the car's engine. The Excel data file AUTO.xls (contained in a folder under the (ML Quizzes tab) contains data on this for fifty recent models. Use Excel Data Analysis to estimate a linear model for the relationship, the 94% confidence interval and the residual plot. State all numerical answers correct to four decimal places using the excel output results: 'i . the intercept , 2. the slope coefficient , and 3. the coefficient of determination, 4. Using this model, predict the gasoline mileage for the car with 85 horsepower. Use all decimal places in your calculation by selecting and using the values of be and b1 in the output generated by Excel. 5. Does the prediction involve extrapolating the relationship? Type yes or no. Use Excel to determine a 94% confidence interval for the slope coefficient, reporting the 6. lower bound 7. upper bound for the interval, correct to 4 decimal places. 7 points Save An