Answer following question

A 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 le AUTO.xls (contained in a folder under the (ML Quizzes tab) contains data on this for fty recent models. Use Excel Data Analysis to estimate a linear model for the relationship, a 99% confidence interval for the slope coefficient, and the residual plot. State all numerical answers below correct to four decimal places. 1. the intercept 2. the slope coefficient , and 3. the standard error of the estimate |: 4. Using this model, predict the gasoline usage for a car weighing 1500 pounds. 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. State the 7. upper bound |: for the 99% condence interval for the slope coefficient