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 CML Quizzes tab)contains these data (also weight) for fifty recent models. Use Excel Data Analysis to estimate a linear model for the relationship, as well as the 99% confidence interval for the slope coefficient and the residual plot. State all numeric answers below correct to 4 decimal places using the Excel output results.

1. the intercept,

2. the slope coefficient, and

3. the standard error of the estimate.

4. Using this model, predict the gasoline mileage for the car with 170 horsepower. Use all decimal places in your calculation by selecting and using the values ofb₀andb₁in the output generated by Excel.

5. Does the prediction involve extrapolating the relationship? Type yes or no.Use all decimal places in your calculation.

State the

6. lower bound

7. upper boundfor the 99% confidence interval for the slope coefficient

?

\f